OraFAQ Forum: Server Administration » Error ORA-12505 : Listener could not resolve SID given in connect descriptor

Home » RDBMS Server » Server Administration » Error ORA-12505 : Listener could not resolve SID given in connect descriptor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error ORA-12505 : Listener could not resolve SID given in connect descriptor [message #52482]

Thu, 25 July 2002 06:24

steph
Messages: 15
Registered: July 2002

Junior Member

Hello,

I've got problem with my new database
1 I create Database 'TOTO'
2 -I configure Listener.ora
(SID_DESC =
(GLOBAL_DBNAME = server name)
(SID_NAME = TOTO)

3 -I configure Tnsname

TOTO.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server name)(PORT = 1521))
(CONNECT_DATA = (SID = TOTO))
)

But I can't connect to databases, the error message is :
" ORA-12505 : TNS : Listener could not resolve SID given in connect descriptor"

I don't understand the problem Can you help me.

Thanks

Steph

Report message to a moderator

Re: Error ORA-12505 : Listener could not resolve SID given in connect descriptor [message #52483 is a reply to message #52482]

Thu, 25 July 2002 06:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

how are u issuing the connect string?

try
userName/passCode@toto.world

Report message to a moderator

Previous Topic:	replicate some table from one database server to a remote database server
Next Topic:	Re: Error ORA-12505 : Listener could not resolve SID given in connect descriptor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 11:51:35 CST 2025