Re: ORA-12535 Problem

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.

Debug the configuration with sqlplus prior to brining OEM into the mix.

>
> 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.
>
>
> Here are the tnsnames.ora and listener.ora files on both machines.
>
>
> What may be the problem?
>
> B. Erbil KONUK

post the sqlnet.ora file contents.
you're using fully qualified global_names for some and non-qualified names for others.
(looking for sqlnet.ora names.default_domain)

also - post the status output from each listener so that we can see what services are registered (even though for some strange reason you have configured static registration).

-bdbafh

>
>
>
>
>
>
>
>
> 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.
>
> EAKSAMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 111.112.115.160)(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)
> )
> )
>
> EAKSMCC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 111.112.115.140)(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)
> )
> )
Received on Fri Nov 03 2006 - 10:05:11 CST