Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ORA-12505:
ORA-12505: [message #130652] Mon, 01 August 2005 17:58 Go to next message
Ayswarya Sundaram
Messages: 12
Registered: May 2005
Junior Member
hi,
I tried to connect to the database in the following way:

sqlplus scott/tiger@PROD

but i get the following message :
SQL*Plus: Release 8.0.6.0.0 - Production on Mon Aug 1 18:39:49 2005

(c) Copyright 1999 Oracle Corporation. All rights reserved.

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


the tns listener and tnsping are working fine.

Can someone tell me why i am getting this message.

thanks,
ash
Re: ORA-12505: [message #130727 is a reply to message #130652] Tue, 02 August 2005 02:47 Go to previous messageGo to next message
slim
Messages: 6
Registered: November 2004
Junior Member
Hi,
Please give the entry in the tnsname.ora and listener.ora.
Re: ORA-12505: [message #130780 is a reply to message #130652] Tue, 02 August 2005 07:53 Go to previous messageGo to next message
Ayswarya Sundaram
Messages: 12
Registered: May 2005
Junior Member
My tns.ora file is :

$Header: tnsnames.ora 115.7 2002/12/05 05:28:43 dduruvan ship $
# TNSNAMES.ORA FOR APPLICATIONS
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and overwritten.
# If you were instructed to edit this file, or if you are not able to use the settings
# created by AutoConfig, refer to Metalink document 165195.1 for assistance.
#
# ###############################################################

#

#
# Net8 definition for the database
#

PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=nystar06)(PORT=1521))
(CONNECT_DATA=(SID=PROD))
)


#
# Net8 definitions for FNDFS and FNDSM on the HTTP server node - nystar06
#

FNDFS_nystar06 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=nystar06)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)

FNDFS_nystar06.linuxlab.marist.edu = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=nystar06)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)






My listener.ora file is :


Net8 definition for Database listener
#

PROD =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCPROD))
(ADDRESS= (PROTOCOL= TCP)(Host= nystar06)(Port= 1521))
)

SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= PROD)
(ORACLE_HOME= /home/oracle/d02/oracle/proddb/9.2.0)
(SID_NAME = PROD)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/d02/oracle/proddb/9.2.0)
(PROGRAM = extproc)
)
)

STARTUP_WAIT_TIME_PROD = 0
CONNECT_TIMEOUT_PROD = 10
TRACE_LEVEL_PROD = OFF

LOG_DIRECTORY_PROD = /home/oracle/d02/oracle/proddb/9.2.0/network/admin
LOG_FILE_PROD = PROD
TRACE_DIRECTORY_PROD = /home/oracle/d02/oracle/proddb/9.2.0/network/admin
TRACE_FILE_PROD = PROD

thanks,
ash
Re: ORA-12505: [message #130841 is a reply to message #130780] Tue, 02 August 2005 17:41 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
On Unix you can check that tnsping and sqlplus are part of the same oracle home. The following should be in the same path:
which tnsping
which sqlplus

If they are, they will use the same tnsnames.ora file. If not, you probably have different tnsnames.ora files in each of the homes. You can set TNS_ADMIN=<full path to tnsnames.ora> so that tnsping and sqlplus both use the tnsnames.ora you want.
Re: ORA-12505: [message #130842 is a reply to message #130780] Tue, 02 August 2005 17:46 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Ignore my previous post. Check the SID in the listener by running:
lsnrctl services

Try pointing winsid to your listener to get a simple clipboard copy of a working tnsnames.ora entry for PROD.

http://www.syntheticbytes.com/oracle/ro/WinSID.html
Re: ORA-12505: [message #130941 is a reply to message #130842] Wed, 03 August 2005 07:18 Go to previous messageGo to next message
Ayswarya Sundaram
Messages: 12
Registered: May 2005
Junior Member
hi Andrew,
I am working ina Linux environment. So i cannot use winsid as it is for a Windows environment.

When i try lsnctrl services i get the following message:

LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 03-AUG-2005 08:02:55

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
The listener supports no services
The command completed successfully

thanks,
ash
Re: ORA-12505: [message #130946 is a reply to message #130842] Wed, 03 August 2005 08:27 Go to previous messageGo to next message
Paul Breniuc
Messages: 1
Registered: August 2005
Location: Rome, Italy
Junior Member

Hi,
Usually this "The listener supports no services" come from duplicate service name registering before/after self-registering...(you have just register a service with similar parameters...)

You wrote:
"My listener.ora file is "

and in your sid_list you are using:

"...
SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
..."

Now from Oracle docs:
"The SID_LIST_LISTENER_NAME contains information about the SIDs of the databases for which a listener can listen."

(for the future
1. Try to check if you client can know who is "nystar06" (nystar06 machine name is resolved? try to use the IP instead, in client tnsnames). Ping -a rezolve the server name?

2. Cut GLOBAL_DBNAME= PROD from your listener if you do not use it, or put different GLOBAL_DBNAME and SIDs (in some situation using GLOBAL_DBNAME and same SID give you strange - bugs - rezults).

3. WinSID is intended to be used to detect REMOTE services (you can use a windows client to check connectivity).
)

Regards...

(if you like to provide feedback...)
icon7.gif  Re: ORA-12505: [message #342399 is a reply to message #130652] Fri, 22 August 2008 04:38 Go to previous message
ref74
Messages: 1
Registered: August 2008
Junior Member
Hi folks,

Just to share my findings because my solution was not apparent.

I am a novice with Oracle and encountered this problem several hrs ago.

Tried a lot of things, looked up several pages on Net, got hints like those on this thread but nothing to solve my problem.

Basically, lsnrctl services did not return the SID I have been using. (BTW, it was working fine before, until I bounced this Wintel host).

Finally, what resolved it was to run lsnrctl services listener. The result shows my intended SID, and subsequently, lsnrctl services also shows it.

Problem solved!


Rgds,
Shahril
Previous Topic: Problem with placing .fmx on 10AS
Next Topic: Oracle 10g IAS and PCL Printer Problem
Goto Forum:
  


Current Time: Thu Mar 28 06:40:57 CDT 2024