ORA-12518

[ALAN WILSON RESENDE]

Hi !

I have an Oracle 8.1.7.0 RDBMS on a Win 2003 Server server with some Oracle database instances. I installed RDBMS 10G R2 and set up an instance in this release. I installed a 10G listener and disabled the 8i. Now, I get connected to instance 10g but when you try to connect to the 8i instances I get the following error:

Select all

ORA-12518: TNS:listener não conseguiu distribuir conexão cliente

The listener is already configured to listen to the 8i banks .

Does anyone have any idea what might be causing this error?

Thank you very much any kind of help.

Att.

al @ n

[erthal]

Alan,

By Metalink's page, the 8i version is no longer supported by Oracle. If you can not migrate your bank to version 9i or 10g try solving your problem with the solution below, collected from Metalink.

For you to make a commercially speaking version upgrade, you will need to have support contract with Oracle. If it is not for commercial use you can download any of the versions of OTN.

Solution

1. Use 8i or 9i TNS Listener to Service Connections to the 8i Database. By Default to Database Will Registered With TNS Listener Running on Port 1521. Following Article Explains Service Registration in Full. Note 76636.1 Service Registration in NET 8I

2. Switch Connection Model to Mts. To make the 8i database use mts, add the pfile mts_dispatchers = "(protocol=TCP) quot;

Restart The Database and Enter You Can See the Started Dispatcher. LSNRCTL Services Command Should Show Something Along The Lines Of:

Select all

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 <machine: nodea, pid: 2164> 
         (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:

Select all

v8174 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = nodea)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
       (SERVER = SHARED) 
      (SERVICE_NAME = v8174.uk.oracle.com) 
    ) 
  )

/ quote]

Hugs,
Gustavo.

[ALAN WILSON RESENDE]

Good morning Gustavo!

Thanks for your information.

I installed a version of Listener 8i and I was able to connect to the 8i banks. I put a listening at port 1521 and another in 1522.
I was just with the Listener 10G Start.

Once again, thank you for your attention.

Hugs,

al @ n.