Home » RDBMS Server » Server Administration » 10g Listener servicing SID requests
icon8.gif  10g Listener servicing SID requests [message #249691] Thu, 05 July 2007 09:58 Go to next message
rfsteel
Messages: 2
Registered: July 2007
Junior Member
I have a problem, where we use a third party application that connects to Oracle via JDBC, we are in the process of testing 10gR2 for this product, but finding it impossible to connect due to the fact that the JDBC connectors are hard coded with SID indentifiers.

I have since on the web that you should be able to use the SID_LIST_LISTENER entries to over come this, but what ever I do I always get;

ORA-12518: TNS:listener could not hand off client connection

Before my listener.ora looked like;

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ln0093.******.com)(PORT = 1521))
)
)

to which it now looks like;

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ******10.ln0093.******.com)s
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ******)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ln0093.******.com)(PORT = 1521))
)
)

No matter which GLOBAL_DBNAME I specify, or even if I comment this line out, I still get the above error.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select value from v$parameter where name ='service_names';

VALUE
-------------------------------------------------------------
celona10g

SQL> show parameter db_name

NAME TYPE VALUE
------------------------------------ -----------
db_name string celona10

Any pointers on where I'm going wrong ?

[Updated on: Thu, 05 July 2007 10:46]

Report message to a moderator

Re: 10g Listener servicing SID requests [message #249694 is a reply to message #249691] Thu, 05 July 2007 10:04 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>(GLOBAL_DBNAME = celona10.ln0093.celona.com)s
Does the trailing "s" really exist in the file? ( rightmost character?)

Can SQL*Plus or any other client successfully connect to DB using SQL*Net?

[Updated on: Thu, 05 July 2007 10:04] by Moderator

Report message to a moderator

Re: 10g Listener servicing SID requests [message #249706 is a reply to message #249694] Thu, 05 July 2007 10:45 Go to previous message
rfsteel
Messages: 2
Registered: July 2007
Junior Member
anacedent wrote on Thu, 05 July 2007 10:04
>(GLOBAL_DBNAME = celona10.ln0093.celona.com)s
Does the trailing "s" really exist in the file? ( rightmost character?)

Can SQL*Plus or any other client successfully connect to DB using SQL*Net?


The extra s did exist in the listener.ora file, though I've removed and retest with the same results.

As for using sql*plus to connect using the SID, this is how I'm testing the listener changes before I start playing with the third party app.
Previous Topic: Ora-12801 with ora-00600
Next Topic: Exchange partition
Goto Forum:
  


Current Time: Sat Dec 10 04:53:50 CST 2016

Total time taken to generate the page: 0.08413 seconds