Re: ORA-12535 Problem

Sorry for a very late response..
The problem was due to the mismatching on tnsnames.ora and listener.ora files.

B. Erbil KONUK

On Nov 9, 1:45 pm, "erbilkonuk" <erbilko..._at_gmail.com> wrote:
> 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.comwebsiteI 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 Tue Dec 12 2006 - 14:07:09 CST