Re: ORA-12535 Problem

From: <fitzjarrell_at_cox.net>
Date: 3 Nov 2006 08:12:19 -0800
Message-ID: <1162570339.222417.161810@f16g2000cwb.googlegroups.com>

Comments embedded.
erbilkonuk wrote:
> I am very sure that this is a very simple problem but I can't find it.
>
> I have installed ORACLE 9i on 2 different Win2K systems and created 2
> databases. One is MCC on computer named AKM, the other one is AMCC on
> YAKM.
> I created the same listeners on both systems and also defined their IPs
> on TNSNAMES.ORA file.
> The computer AKM gets static IP, the other one gets dynamic IP which I
> change to static IP manually.
> The problem is that when I start ORACLE Enterprise Manager Tool and
> want to connect to remote database, I get ORA-12535.
>

Meaning you either have a DNS issue or you have entered the incorrect IP address in the tnsnames.ora file. I would change the listener to use the same address listed in your tnsnames.ora file rather than use the hostname. You could also change the tnsnames.ora flie to use the hostname instead of the IP address. Somewhere you have a situation where what you're looking for and where you're listening don't match up.

> The things I tried are:
> * stop and start listeners with lsnrctl
> all listeners stop and start correctly
> * TNSPING utility
> the same error is prompted
>
> I can connect the local databases, that is fine.

Of course you can; localhost (if configured correctly) always resolves.  And you don't need SQL*Net for a local connection.

>
>
> Here are the tnsnames.ora and listener.ora files on both machines.
>
>
> What may be the problem?
>
> B. Erbil KONUK
>
>
>
>
>
>
>
>
> The files on AKM are
>
> # LISTENER.ORA Network Configuration File:
> d:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = AKM)(PORT = 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = eaksmcc.eaks.com)
> (ORACLE_HOME = D:\oracle\ora92)
> (SID_NAME = eaksmcc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = nirvana1.ups.com)
> (ORACLE_HOME = D:\oracle\ora92)
> (SID_NAME = nirvana1)
> )
> )
>
>
>
>
> # TNSNAMES.ORA Network Configuration File:
> d:\oracle\ora92\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>

Try this change:

> EAKSAMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = YAKM)(PORT = 1521))


>     )

>     (CONNECT_DATA =

>       (SERVER = DEDICATED)

>       (SERVICE_NAME = eaksamcc.eaks.com)

>     )

> )
>
> EAKSMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = eaksmcc.eaks.com)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = AKM)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> NIRVANA1.UPS.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = nirvana1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = nirvana1)
> (SERVER = DEDICATED)
> )
> )
>
>
>
>
>
> The files on YAKM are
>
> # LISTENER.ORA Network Configuration File:
> C:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = YAKM)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = eaksamcc.eaks.com)
> (ORACLE_HOME = C:\oracle\ora92)
> (SID_NAME = eaksamcc)
> )
> )
>
>
>
> # TNSNAMES.ORA Network Configuration File:
> C:\oracle\ora92\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> EAKSAMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = eaksamcc.eaks.com)
> )
> )
>

Try this change as well:

> EAKSMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = AKM)(PORT = 1521))


>     )

>     (CONNECT_DATA =

>       (SERVER = DEDICATED)

>       (SERVICE_NAME = eaksmcc.eaks.com)

>     )

> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = YAKM)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> NIRVANA1.UPS.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = nirvana1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = nirvana1)
> (SERVER = DEDICATED)
> )
> )

David Fitzjarrell Received on Fri Nov 03 2006 - 10:12:19 CST