8Subject: ORA-12518 Reported When Using 10gr2 TNS Listener to Connect To a 8i Database
Doc ID: Note:341482.1 Type: PROBLEM
Last Revision Date: 11-JAN-2006 Status: PUBLISHED
In this Document
Symptoms
Cause
Solution
_____
Applies to:
Oracle Net Services - Version: 10.2.0.1.0
Microsoft Windows
All Dedicated Oracle Net connections to the database
Symptoms
When using a 10.2 TNS listener to connection to an 8i database, via dedicated connection model, the following error is reported :
ORA-12518: TNS:listener could not hand off client connection
Cause
10.2 TNS Listener and 8i database is not a supported combination Note 207303.1 describes the interoperability certification for different Oracle versions.
Solution
1. Use a 8i or 9i TNS listener to service connections to the 8i database. By default a database will registered with a TNS listener running on port 1521. Following article explains service registration in full. Note 76636.1 Service Registration in Net 8i
2. Upgrade the 8i database to 9i or 10g.
3. Switch connection model to MTS. To make a 8i database use MTS, add the pfile
mts_dispatchers = "(protocol=TCP)"
Restart the database and ensure you can see a dispatcher started. lsnrctl services command should show something along the lines of :
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nodea)(PORT=1521)))
Services Summary...
Service "v8174.uk.oracle.com" has 1 instance(s).
Instance "v8174", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D000" established:1 refused:2 current:3 max:1022 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=nodea)(PORT=3330))
The command completed successfully
Then ensure the net service name being used to connect has (SERVER = SHARED)
Example:
v8174 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodea)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = v8174.uk.oracle.com)
)
)
_____
Help us improve our service. Please email us your comments for this document. .
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/412/viewspace-903897/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/412/viewspace-903897/