Home » RDBMS Server » Server Administration » ORA-12505 error
ORA-12505 error [message #55631] Wed, 05 February 2003 14:13 Go to next message
Carlos Olmeda
Messages: 22
Registered: January 2003
Junior Member
Hello, I am running Oracle 7.3 with 3 diffrent databases that I set up. However I cannot connect to them. I keep recieving ORA-12505: TNS listener could not resolve SID given to connect descriptor. Do I have to modify the listener file to reflect all 3 databases?. If so is there a sample script?. Do I need to do anything with the tnsmanes.ora file.

Thank You

Report message to a moderator

Re: ORA-12505 error [message #55668 is a reply to message #55631] Fri, 07 February 2003 01:52 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
HEllo,
Yes, listener should have the entries of all the databases..or else create separate listeners to separate databases and make sure that they are all running ...
also while connecting try connecting as
username/password@databasename

sai

Report message to a moderator

Re: ORA-12505 error [message #55686 is a reply to message #55631] Fri, 07 February 2003 16:36 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You can do that manually. If you have this starter file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:oracleora73)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db1)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db1)
)
)

keep adding

(SID_DESC =
(GLOBAL_DBNAME = db2)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db2)
)

for the second db.

(SID_DESC =
(GLOBAL_DBNAME = db3)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db3)
)

for the third db, until you get:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:oracleora73)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db1)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db1)
)
(SID_DESC =
(GLOBAL_DBNAME = db2)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db2)
)
(SID_DESC =
(GLOBAL_DBNAME = db3)
(ORACLE_HOME = c:oracleora73)
(SID_NAME = db3)
)
)

For each new database you want the listener to listen, add it in listener.ora. That's for listening.

For connecting - you have to edit tnsnames, but on your clients to include TNS aliases for these three databases.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

errorORA-12505: TNS:listener could not resolve SID given in connect descriptor [message #63239 is a reply to message #55631] Tue, 21 September 2004 03:21 Go to previous message
Vineet
Messages: 10
Registered: September 2000
Junior Member
i am trying to connect database but getting the following error

ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Details:
oci.dll found
2) Oracle Home Key is SOFTWAREORACLEHOME0
Looking for TNS_ADMIN environmental variable
TNS_ADMIN environmental variable doesnt exist,
looking for TNS_ADMIN reg key using home key: >SOFTWAREORACLEHOME0<
TNS_ADMIN does not exist in SOFTWAREORACLEHOME0
looking for TNS_ADMIN reg key in Oracle: >SOFTWAREORACLEHOME0<
Looking for OracleHomeKeyORACLE_HOME
Oracle Path is now D:OracleOra81NetworkAdmin
Looking for D:OracleOra81NetworkAdmintnsnames.ora
tnsnames.ora found
tnsnames entry: gsat.mahindrabt.com
tnsnames entry: gupg.mahindrabt.com
tnsnames entry: faupg.mahindrabt.com
tnsnames entry: gsit.mahindrabt.com
tnsnames entry: gsit4.mahindrabt.com
tnsnames entry: guat4.mahindrabt.com
tnsnames entry: guat.mahindrabt.com
tnsnames entry: guat2.mahindrabt.com
tnsnames entry: gsup.mahindrabt.com
tnsnames entry: fasat.mahindrabt.com
tnsnames entry: fasat.world
tnsnames entry: gu20.mahindrabt.com
tnsnames entry: gi20.mahindrabt.com
tnsnames entry: riu20.mahindrabt.com
tnsnames entry: risat.mahindrabt.com
tnsnames entry: gsit1.mahindrabt.com
tnsnames entry: gsit2.mahindrabt.com
tnsnames entry: risit1.mahindrabt.com
tnsnames entry: guat1.mahindrabt.com
tnsnames entry: rii1.mahindrabt.com
tnsnames entry: gi1.mahindrabt.com
tnsnames entry: riuat1.mahindrabt.com
tnsnames entry: fasit1.mahindrabt.com
tnsnames entry: fauat1.mahindrabt.com
tnsnames entry: ncdb_test
tnsnames entry: GIVVT4.BFSEC.BT.CO.UK
tnsnames entry: FAIVVT4.BFSEC.BT.CO.UK
tnsnames.ora found
tnsnames entry: gsat.mahindrabt.com
tnsnames entry: gupg.mahindrabt.com
tnsnames entry: faupg.mahindrabt.com
tnsnames entry: gsit.mahindrabt.com
tnsnames entry: gsit4.mahindrabt.com
tnsnames entry: guat4.mahindrabt.com
tnsnames entry: guat.mahindrabt.com
tnsnames entry: guat2.mahindrabt.com
tnsnames entry: gsup.mahindrabt.com
tnsnames entry: fasat.mahindrabt.com
tnsnames entry: fasat.world
tnsnames entry: gu20.mahindrabt.com
tnsnames entry: gi20.mahindrabt.com
tnsnames entry: riu20.mahindrabt.com
tnsnames entry: risat.mahindrabt.com
tnsnames entry: gsit1.mahindrabt.com
tnsnames entry: gsit2.mahindrabt.com
tnsnames entry: risit1.mahindrabt.com
tnsnames entry: guat1.mahindrabt.com
tnsnames entry: rii1.mahindrabt.com
tnsnames entry: gi1.mahindrabt.com
tnsnames entry: riuat1.mahindrabt.com
tnsnames entry: fasit1.mahindrabt.com
tnsnames entry: fauat1.mahindrabt.com
tnsnames entry: ncdb_test
tnsnames entry: GIVVT4.BFSEC.BT.CO.UK
tnsnames entry: FAIVVT4.BFSEC.BT.CO.UK

could u suggest somthing

Report message to a moderator

Previous Topic: query to slow after lots of insert and delete operations
Next Topic: locating mountpoint/filesystem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:22:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.