dbTalk Databases Forums  

Network Configuration Assistant error

comp.databases.oracle.server comp.databases.oracle.server


Discuss Network Configuration Assistant error in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Clive_S
 
Posts: n/a

Default Network Configuration Assistant error - 03-13-2010 , 07:54 PM






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)

Quote:

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

Reply With Quote
  #2  
Old   
John Hurley
 
Posts: n/a

Default Re: Network Configuration Assistant error - 03-13-2010 , 08:54 PM






On Mar 13, 7:54*pm, Clive_S <clives... (AT) yahoo (DOT) co.uk> wrote:

snip

Quote:
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?

Reply With Quote
  #3  
Old   
ddf
 
Posts: n/a

Default Re: Network Configuration Assistant error - 03-15-2010 , 09:00 AM



On Mar 13, 8:54*pm, Clive_S <clives... (AT) yahoo (DOT) co.uk> wrote:
Quote:
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

Reply With Quote
  #4  
Old   
Shakespeare
 
Posts: n/a

Default Re: Network Configuration Assistant error - 03-15-2010 , 01:53 PM



Op 14-3-2010 1:54, Clive_S schreef:
Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.