Re: Help!! Ora- 12505

From: Kumar, Sai (EXCHANGE:PERPK:3374) <saikumar_at_nortel.com>
Date: Fri, 26 Mar 1999 11:35:13 -0500
Message-ID: <36FBB741.1D68F7EA@nortel.com>

Rob Fisher wrote:

> I'm new to Oracle 7.3 and need to create a new database/instance which I
> have successfully done.
>
> I have created a connection using SQL Net Easy Config, using the new SID as
> the database instance.
>
> My new services are up and running, but when I try to connect I get a ORA
> 12505 error : TNS: Listener could not resolve SID given in connect
> descriptor.
>
> What am I doing wrong? Can anyone help?
>
> Thanks
>
> Rob Fisher
> QA Engineer
> Computer Associates
> Robert.Fisher_at_cai.com

Rob,

I had a similar problem, and this is how I fixed it :-

Check the format of the listener.ora :-

LISTENER=
(ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))
  (ADDRESS=(PROTOCOL=IPC)(KEY=<servicename>))
  (ADDRESS=(PROTOCOL=IPC)(KEY=<servicename>))

)

CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=(SID_NAME=<sidname>)(ORACLE_HOME=<oracle_home_dir)) (SID_DESC=(SID_NAME=<sidname>)(ORACLE_HOME=<oracle_home_dir)) )

This is the portion that fixed my problem :-

(SID_DESC=(SID_NAME=<sidname>)(ORACLE_HOME=<oracle_home_dir)) (SID_DESC=(SID_NAME=<sidname>)(ORACLE_HOME=<oracle_home_dir))

Thanks
Sai Received on Fri Mar 26 1999 - 10:35:13 CST