Re: Network Configuration Assistant error
Date: Sat, 13 Mar 2010 17:54:21 -0800 (PST)
On Mar 13, 7:54 pm, Clive_S <clives..._at_yahoo.co.uk> wrote:
> 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
> # Generated by Oracle configuration tools.
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = WINDOWS-READ)(PORT = 1521))
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
What does your listener.ora and sqlnet.ora look like?
If you want to connect to an instance ORCL you use that not "_at_NT.test" ...
Looks of examples on the internet of setting up oracle on windows maybe you might want to follow a documented example that works? Received on Sat Mar 13 2010 - 19:54:21 CST