Re: Network Configuration Assistant error

From: ddf <oratune_at_msn.com>
Date: Mon, 15 Mar 2010 07:00:39 -0700 (PDT)
Message-ID: <fe11bca5-ec9d-4202-8d69-16d660e038f7_at_b9g2000pri.googlegroups.com>

On Mar 13, 8: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
> \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)
> )
> )

I expect that the actiual service name is ORCL, not orcl. This value is case-sensitive.

David Fitzjarrell Received on Mon Mar 15 2010 - 09:00:39 CDT