OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ORA-12505:

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

ORA-12505: [message #130652]

Mon, 01 August 2005 17:58

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

Report message to a moderator

Re: ORA-12505: [message #130727 is a reply to message #130652]

Tue, 02 August 2005 02:47

slim
Messages: 6
Registered: November 2004

Junior Member

Hi,
Please give the entry in the tnsname.ora and listener.ora.

Report message to a moderator

Re: ORA-12505: [message #130780 is a reply to message #130652]

Tue, 02 August 2005 07:53

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

Report message to a moderator

Re: ORA-12505: [message #130841 is a reply to message #130780]

Tue, 02 August 2005 17:41

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.

Report message to a moderator

Re: ORA-12505: [message #130842 is a reply to message #130780]

Tue, 02 August 2005 17:46

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

Report message to a moderator

Re: ORA-12505: [message #130941 is a reply to message #130842]

Wed, 03 August 2005 07:18

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

Report message to a moderator

Re: ORA-12505: [message #130946 is a reply to message #130842]

Wed, 03 August 2005 08:27

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...)

Report message to a moderator

Re: ORA-12505: [message #342399 is a reply to message #130652]

Fri, 22 August 2008 04:38

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

Report message to a moderator

Previous Topic:	Problem with placing .fmx on 10AS
Next Topic:	Oracle 10g IAS and PCL Printer Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:16:20 CST 2024