Re: Network Configuration Assistant error
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 15 Mar 2010 19:53:41 +0100
Message-ID: <4b9e8239$0$22938$e4fe514c_at_news.xs4all.nl>
Op 14-3-2010 1:54, Clive_S schreef:
> Hi spent 12 hours trying to sort this.
>
> Any suggestions??
>
> My hostname is WINDOWS-READ
>
> Used Oracle Net Config Assistant to create Oracle Internet Directory
> Add the directory service:
> Hostname: WINDOWS-READ
> port: 389
> ssl: 636
>
> Get cannot connect to directory: directory bind error(5)
>
>>>>
>>>>
>
> connect sys/<sys_password>_at_<tns_name_of_db> as sysdba
> connect sys/<sys_password>_at_NT.test as sysdba
>
> Get error ORA-12504
> TNS:lisitener was not given the service_name in connect_data
>
>
> # tnsnames.ora Network Configuration File: D:\U01\app\Oracle\product
> \11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = WINDOWS-READ)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
> )
> )
Date: Mon, 15 Mar 2010 19:53:41 +0100
Message-ID: <4b9e8239$0$22938$e4fe514c_at_news.xs4all.nl>
Op 14-3-2010 1:54, Clive_S schreef:
> Hi spent 12 hours trying to sort this.
>
> Any suggestions??
>
> My hostname is WINDOWS-READ
>
> Used Oracle Net Config Assistant to create Oracle Internet Directory
> Add the directory service:
> Hostname: WINDOWS-READ
> port: 389
> ssl: 636
>
> Get cannot connect to directory: directory bind error(5)
>
>>>>
>>>>
>
> connect sys/<sys_password>_at_<tns_name_of_db> as sysdba
> connect sys/<sys_password>_at_NT.test as sysdba
>
> Get error ORA-12504
> TNS:lisitener was not given the service_name in connect_data
>
>
> # tnsnames.ora Network Configuration File: D:\U01\app\Oracle\product
> \11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = WINDOWS-READ)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
> )
> )
What are you exactly trying to do? You create a *directory service* but
you try to connect to a *database* . If you try to connect to a database
using OID you should have a line like
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT, ONAMES, HOSTNAME)
in your sqlnet.ora file (with LDAP in it).
But I don't actually think you use OID here.
Could you post your sqlnet.ora file here?
Shakespeare Received on Mon Mar 15 2010 - 13:53:41 CDT