 10g Listener servicing SID requests [message #249691] |
Thu, 05 July 2007 09:58  |
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 #249706 is a reply to message #249694] |
Thu, 05 July 2007 10:45  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
