 | |
Oracle SQL Developer && LDAP Connection
comp.databases.oracle.tools comp.databases.oracle.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Oracle SQL Developer && LDAP Connection -
10-02-2008
, 01:26 AM
#2
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#3
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#4
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#5
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#6
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#7
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#8
| |||
| |||
|
|
Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. |
DIRECTORY_SERVER_TYPE = OID
is not correct. OID is Oracle Internet Directory, which is not OpenLdap.
Shakespeare
#9
| |||
| |||
|
|
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) com> schreef in bericht news:a5f9d061-fdac-4878-8c50-a7444db44bfb (AT) b1g2000hsg (DOT) googlegroups.com... Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. If you configured openldap, I think this: DIRECTORY_SERVER_TYPE = OID is not correct. OID is Oracle Internet Directory, which is not OpenLdap. Shakespeare |
DIRECTORY_SERVER_TYPE = OID as well. As long as you load the OID
objectclasses, this could work indeed....
Shakespeare
#10
| |||
| |||
|
|
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) com> schreef in bericht news:a5f9d061-fdac-4878-8c50-a7444db44bfb (AT) b1g2000hsg (DOT) googlegroups.com... Hello! I've configured openldap to store information from tnsnames.ora. See http://oracle-cookies.blogspot.com/2...-openldap.html for details. Then I configured Naming Methods via netca as follows: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/sqlnet.ora 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/ oracle/product/10.2.0/network/admin/sqlnet.ora 2. Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) olimpico_work ~ # This is my ldap.ora file: olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/ network/admin/ldap.ora DIRECTORY_SERVERS = (develop2:389:636) DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz" DIRECTORY_SERVER_TYPE = OID olimpico_work ~ # As shown below tnsping works fine: olimpico_work ~ # tnsping sumtel_fake TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30- SEP-2008 11:58:48 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=sumtel.clients.net)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORANGE))) OK (690 msec) olimpico_work ~ # The problem lies in that I can't create LDAP connection in Oracle SQL Developer. Doc says that sql developer should load entries from ldap.ora (http:// http://www.oracle.com/technology/ora...y/o38sql.html). However, I found that it even doesn't read ldap.ora file (I'm sure since I traced sqldeveloper via "strace" utility). How to get it work? Any ideas? Thank you beforehand! P.S. I'm using the latest Gentoo Linux with kernel 2.6.22. The version of Oracle installed is 10.2.0.1.0. The version of Oracle SQL developer is 1.5.1.54.40. If you configured openldap, I think this: DIRECTORY_SERVER_TYPE = OID is not correct. OID is Oracle Internet Directory, which is not OpenLdap. Shakespeare |
DIRECTORY_SERVER_TYPE = OID as well. As long as you load the OID
objectclasses, this could work indeed....
Shakespeare
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.