Prev: optimizer_secure_view_merging
Next: numeric check
From: naboeger on 19 Mar 2006 14:36
This is my problem:

FAIL (Cannot create PoolableConnectionFactory (Listener refused the
connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect
descriptor
The Connection descriptor used by the client was:
192.168.1.7:1521:system

A little googling describes the meaning:
ORA-12224: TNS: listener could not resolve SID given in connection
description.

The SID specified in the connection was not found in the listener's
tables. This error will be returned if the database instance has not
registered with the listener.
Possible Remedy:

Check to make sure that the SID is correct. The SIDs that are currently
registered with the listener can be obtained by typing:

LSNRCTL SERVICES <listener-name>

These SIDs correspond to SID_NAMEs in TNSNAMES.ORA or DB_NAME in the
initialisation file.


I'm not sure how to set up a new schema, say "test". The SID of
"system" should always exist, right? What is registering it with the
listner? How is this accomplished on a Windows platform?

Thanks for your help,

----
Nathan Boeger
Integrator, Microsoft Certified Systems Engineer
http://www.inductiveautomation.com
"Specializing in SQL and web based HMI systems"

From: DA Morgan on 19 Mar 2006 14:49
naboeger(a)gmail.com wrote:

> This is my problem:
>
> FAIL (Cannot create PoolableConnectionFactory (Listener refused the
> connection with the following error:
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
> The Connection descriptor used by the client was:
> 192.168.1.7:1521:system

10gR1 or 10gR2?
Where did this Connection descriptor originate?

This is a typical TNSNAMES entry:

ORABASE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = perrito)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orabase)
)
)

Where, in here, do you see the equivalent to what you posted?
--
Daniel A. Morgan
http://www.psoug.org
damorgan(a)x.washington.edu
(replace x with u to respond)
From: StefanKapitza on 19 Mar 2006 15:09

naboeger(a)gmail.com wrote:
> This is my problem:
>
> FAIL (Cannot create PoolableConnectionFactory (Listener refused the
> connection with the following error:
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
> The Connection descriptor used by the client was:
> 192.168.1.7:1521:system
>
> A little googling describes the meaning:
> ORA-12224: TNS: listener could not resolve SID given in connection
> description.
>
> The SID specified in the connection was not found in the listener's
> tables. This error will be returned if the database instance has not
> registered with the listener.
> Possible Remedy:
>
> Check to make sure that the SID is correct. The SIDs that are currently
> registered with the listener can be obtained by typing:
>
> LSNRCTL SERVICES <listener-name>
>
> These SIDs correspond to SID_NAMEs in TNSNAMES.ORA or DB_NAME in the
> initialisation file.
>
>
> I'm not sure how to set up a new schema, say "test". The SID of
> "system" should always exist, right? What is registering it with the
> listner? How is this accomplished on a Windows platform?
>
> Thanks for your help,
>
> ----
> Nathan Boeger
> Integrator, Microsoft Certified Systems Engineer
> http://www.inductiveautomation.com
> "Specializing in SQL and web based HMI systems"

The SID is defined when the Database is created, and as the error
message say's
it's not system. Maybe you ask your DBA what the SID is.

regards

s.kapitza

From: frank.van.bortel@gmail.com on 20 Mar 2006 03:39

naboeger(a)gmail.com schreef:

> This is my problem:
>
> FAIL (Cannot create PoolableConnectionFactory (Listener refused the
> connection with the following error:
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
> The Connection descriptor used by the client was:
> 192.168.1.7:1521:system

It should be in the form:
username/password@ [//] hostname [:port] [/service_name]

system/manager@//192.168.1.7:1521/my_sid would be correct.
See:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_04

 | 
Pages: 1
Prev: optimizer_secure_view_merging
Next: numeric check