[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
openLDAP + Oracle
Hi,
Trying to get openLDAP work with Oracle 9i via back-sql
Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_get_db_conn()
Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_open_db_conn()
Mar 26 05:25:56 localhost slapd[4444]: backsql_open_db_conn:
SQLConnect() to database 'loe' as user 'loe' failed:
Mar 26 05:25:56 localhost slapd[4444]: Return code: -1
Mar 26 05:25:56 localhost slapd[4444]: Native error code: 0
Mar 26 05:25:56 localhost slapd[4444]: SQL engine state: IM002
Mar 26 05:25:56 localhost slapd[4444]: Message: [iODBC][Driver
Manager]Data source name not found and no default driver specified.
Driver could not be loaded
Mar 26 05:25:56 localhost slapd[4444]: backsql_get_db_conn(): could not
get connection handle -- returning NULL
Mar 26 05:25:56 localhost slapd[4444]: backsql_db_open(): connection
failed, exiting
Mar 26 05:25:56 localhost slapd[4444]: backend_startup: bi_db_open(0)
failed! (1)
Mar 26 05:25:56 localhost slapd[4444]: slapd shutdown: initiated
Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_db_close()
Mar 26 05:25:56 localhost slapd[4444]: <==backsql_db_close()
Mar 26 05:25:56 localhost slapd[4444]: slapd shutdown: freeing system
resources.
Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_db_destroy()
Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_free_db_env()
Mar 26 05:25:56 localhost slapd[4444]: <==backsql_free_db_env()
Mar 26 05:25:56 localhost slapd[4444]: ==>destroy_schema_map()
Mar 26 05:25:56 localhost slapd[4444]: <==destroy_schema_map()
Mar 26 05:25:56 localhost slapd[4444]: <==backsql_db_destroy()
Mar 26 05:25:56 localhost slapd[4444]: slapd stopped.
Mar 26 05:25:56 localhost slapd[4444]: connections_destroy: nothing to
destroy.
~
Other details :
It connects via SQLPLUS and also JDBC..i have checked my tnsnames.ora
file many times...i still have no idea why this error occurs when I try
to connect :
[root@localhost bin]# ./isql ORACLE -v
[08001][unixODBC][Easysoft][Oracle]ORA-12154: TNS:could not resolve
service name
[ISQL]ERROR: Could not SQLConnect
Here is my odbc.ini and odbcinst.ini files and also my tnsnames.ora
odbc.ini
========
[ODBC Data Sources]
[ORACLE]
Driver = ORACLE
Database = loe
Host = 15.70.187.13
ServerType = Oracle 9
SID = newsid
Port = 1521
User = loe
Password = loe
METADATA_ID = 0
ENABLE_USER_CATALOG = 1
ENABLE_SYNONYMS = 1
====================
Odbcinst.ini
============
[ORACLE]
Description = Easysoft ODBC Oracle Driver
Driver = /opt/easysoft/oracle/libesoracle.so
Setup = /opt/easysoft/oracle/libesoraclesetup.so
FileUsage = 1
Tnsnames.ora
===========
w2k3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 15.70.187.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = newsid)
)
)
Sqlnet.ra
==========
#NAMES.DEFAULT_DOMAIN = localdomain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
============================
This is what I get when I connect thro SQLPLUS...
[root@localhost bin]# cat /home/ravi/OraHome1/network/admin/sqlnet.ora
# SQLNET.ORA Network Configuration File:
/home/ravi/OraHome1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
#NAMES.DEFAULT_DOMAIN = localdomain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
[root@localhost bin]# /home/ravi/OraHome1/bin/sqlplus loe/loe@w2k3
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Mar 26 01:55:51 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>
Any pointers would be appreciated,
Any ideas??
Thanks,
Ravi