Prev: get distinct values
Next: Oracle Auditing
From: Clive_S on 13 Mar 2010 19:54
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>@<tns_name_of_db> as sysdba
connect sys/<sys_password>@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)
)
)
From: John Hurley on 13 Mar 2010 20:54
On Mar 13, 7:54 pm, Clive_S <clives...(a)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>@<tns_name_of_db> as sysdba
> connect sys/<sys_password>@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
"@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?
From: ddf on 15 Mar 2010 10:00
On Mar 13, 8:54 pm, Clive_S <clives...(a)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>@<tns_name_of_db> as sysdba
> connect sys/<sys_password>@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
From: Shakespeare on 15 Mar 2010 14:53
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>@<tns_name_of_db> as sysdba
> connect sys/<sys_password>@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

 | 
Pages: 1
Prev: get distinct values
Next: Oracle Auditing