[oracle_br] Socorro !!!!! ORA-12154: TNS:could not resolve the connect identifier specified

2007-09-14 Por tôpico Antonio Stuart

Pessoal nao consigo utilizar o sqlplus , alguem pode me ajudar abaixo o 
sqlnet.ora tnsnames.ora e listener.ora

NULL /u01/app/oracle/ product/10. 1.0/network/ admin  more sqlnet.ora
NAMES.DEFAULT_ DOMAIN = localdomain
NAMES.DIRECTORY_ PATH= (TNSNAMES, ONAMES, HOSTNAME)

more listener.ora
LISTENER =
(DESCRIPTION_ LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.51.162.10) (PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = site1)
(GLOBAL_DB_NAME = site1)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
(SID_DESC =
(SID_NAME = cent1)
(GLOBAL_DB_NAME = cent1)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
(SID_DESC =
(SID_NAME = site2)
(GLOBAL_DB_NAME = site2)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
(SID_DESC =
(SID_NAME = cent2)
(GLOBAL_DB_NAME = cent2)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
(SID_DESC =
(SID_NAME = site3)
(GLOBAL_DB_NAME = site3)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
(SID_DESC =
(SID_NAME = cent3)
(GLOBAL_DB_NAME = cent3)
(ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
)
)

TRACE_LEVEL_ LISTENER = 16
SUBSCRIBE_FOR_ NODE_DOWN_ EVENT_LISTENER= OFF
logging = off
logging LISTENER = off

Tnsnames.ora

DEV.server.servidor .site3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10) (PORT = 1521))
)
(CONNECT_DATA =
(SID = site3)
)
)
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10) (PORT = 1521))
)
(CONNECT_DATA =
(SID = site3)
)
)

   Flickr agora em português. Você clica, todo mundo vê. Saiba mais.

[As partes desta mensagem que não continham texto foram removidas]



Re: [oracle_br] Socorro !!!!! ORA-12154: TNS:could not resolve the connect identifier specified

2007-09-14 Por tôpico Milton Bastos Henriquis Jr.
Esse erro deu no SQLPLUS do proprio servidor?
ou de algum client?
qual comando vc usou para se conectar??





On 9/14/07, Antonio Stuart [EMAIL PROTECTED] wrote:


 Pessoal nao consigo utilizar o sqlplus , alguem pode me ajudar abaixo o
 sqlnet.ora tnsnames.ora e listener.ora

 NULL /u01/app/oracle/ product/10. 1.0/network/ admin  more sqlnet.ora
 NAMES.DEFAULT_ DOMAIN = localdomain
 NAMES.DIRECTORY_ PATH= (TNSNAMES, ONAMES, HOSTNAME)

 more listener.ora
 LISTENER =
 (DESCRIPTION_ LIST =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST =10.51.162.10) (PORT = 1521))
 )
 )
 )
 SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
 (SID_NAME = site1)
 (GLOBAL_DB_NAME = site1)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 (SID_DESC =
 (SID_NAME = cent1)
 (GLOBAL_DB_NAME = cent1)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 (SID_DESC =
 (SID_NAME = site2)
 (GLOBAL_DB_NAME = site2)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 (SID_DESC =
 (SID_NAME = cent2)
 (GLOBAL_DB_NAME = cent2)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 (SID_DESC =
 (SID_NAME = site3)
 (GLOBAL_DB_NAME = site3)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 (SID_DESC =
 (SID_NAME = cent3)
 (GLOBAL_DB_NAME = cent3)
 (ORACLE_HOME = /u01/app/oracle/ product/10. 1.0)
 )
 )

 TRACE_LEVEL_ LISTENER = 16
 SUBSCRIBE_FOR_ NODE_DOWN_ EVENT_LISTENER= OFF
 logging = off
 logging LISTENER = off

 Tnsnames.ora

 DEV.server.servidor .site3 =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10) (PORT = 1521))
 )
 (CONNECT_DATA =
 (SID = site3)
 )
 )
 =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10) (PORT = 1521))
 )
 (CONNECT_DATA =
 (SID = site3)
 )
 )

 Flickr agora em português. Você clica, todo mundo vê. Saiba mais.

 [As partes desta mensagem que não continham texto foram removidas]

  



[As partes desta mensagem que não continham texto foram removidas]