[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