Re: Network Configuration Assistant error

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Sat, 13 Mar 2010 17:54:21 -0800 (PST)
Message-ID: <60c6bc55-0360-46ee-b2fa-6663c37f1a70_at_o30g2000yqb.googlegroups.com>

On Mar 13, 7:54 pm, Clive_S <clives..._at_yahoo.co.uk> wrote:

snip

> 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 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