Re: ORA-12535 Problem

Thanks for the help and the replies... I am a bit drifted off to the GUI part of the project such that I will try to resolve this conflict on our test system later on. I keep your help in my mind. I will post the reason of the problem as soon as I get the system up.

B. Erbil KONUK

On Nov 3, 6:13 pm, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> 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.
>
> > 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
>
> > 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)
> > )
> > )Although it is possible to run oracle on windows with a DHCP address it
> can get complicated and messy and unless you are prepared to deal with,
> it may not be a good idea.
>
> There's a way around it by doing some extra plumbing. I forget what
> it's called exactly ( sorry we don't run oracle on windows here ) but
> it involves some variation on creating a virtual interface so that
> oracle uses that.
>
> Look around on thehttp://www.dizwell.comwebsite I think it's
> documented how to do it over there. ( Or maybe google "oracle windows
> dhcp" and see what you come up with ).
Received on Thu Nov 09 2006 - 05:45:05 CST