ORA-12535 Problem

From: erbilkonuk <erbilkonuk_at_gmail.com>
Date: 3 Nov 2006 07:50:24 -0800
Message-ID: <1162569024.717737.218020@m7g2000cwm.googlegroups.com>

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)

    )
  )