TNS-03505 and ORA-12154 Error

From: WStern <WolfgangStern_at_gmx.de>
Date: 7 Oct 2004 05:13:41 -0700
Message-ID: <b7e912a2.0410070413.e59a7a4@posting.google.com>

Hello together,

sorry for my bad english.

I have here a Problem with a Oracle Standby DB, the Connection (per Service-Name) to the different Databases makes problems.

I become with all SID Connects (per TNSPING) a positive Return-Message, but only when I will check the SERVICE_NAME-Connection then i become an TNS-03505 or when i make the test over SQL then i become the ORA-12154 Error.

The Systemenvirement is Windows 64-bit and Oracle 9.0.2.0.5 (64-bit)

Listener Side 1:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMI)(PORT = 1521))
      )

)
)

LISTENER_DBA =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMI)(PORT = 1522))     )
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMI)(PORT = 1523))     )
  )

SID_LIST_LISTENER_DBA =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = DMI_WLSDMI.WORLD)
      (SID_NAME = DMI)
      (ORACLE_HOME = E:\oracle\DMI\920)

)
(SID_DESC =

      (GLOBAL_DBNAME = DMI_WLSDMI_SB.WORLD)
      (SID_NAME = DMI)
      (ORACLE_HOME = E:\oracle\DMI\920)

)
)

Listener Side 2:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMS)(PORT = 1521))
      )

)
)

LISTENER_DBA =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMS)(PORT = 1522))     )
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = WLSDMS)(PORT = 1523))     )
  )

SID_LIST_LISTENER_DBA =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = DMI_WLSDMS.WORLD)
      (SID_NAME = DMI)
      (ORACLE_HOME = E:\oracle\DMI\920)

)
(SID_DESC =

      (GLOBAL_DBNAME = DMI_WLSDMS_SB.WORLD)
      (SID_NAME = DMI)
      (ORACLE_HOME = E:\oracle\DMI\920)

)
)

Tnsnames Side 1:

DMI.WORLD=
(DESCRIPTION=
(SDU=32768)
(ADDRESS_LIST=

      (LOAD_BALANCE=OFF)
      (FAILOVER=ON)
      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMI)(PORT=1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMS)(PORT=1521))

)
(CONNECT_DATA=(SERVICE_NAME=DMI_PR))
)

DMI_WLSDMI.WORLD=
  (DESCRIPTION=
(SDU=32768)
(ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMI)(PORT=1522))     )
(CONNECT_DATA=(SID=DMI))

  )

DMI_WLSDMS.WORLD=
  (DESCRIPTION=
(SDU=32768)
(ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMS)(PORT=1522))     )
(CONNECT_DATA=(SID=DMI))

  )

DMI_WLSDMI_SB.WORLD=
  (DESCRIPTION=
(SDU=32768)
(ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMI)(PORT=1523))     )
(CONNECT_DATA=(SID=DMI))

  )

DMI_WLSDMS_SB.WORLD=
  (DESCRIPTION=
(SDU=32768)
(ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=TCP)(HOST=WLSDMS)(PORT=1523))     )
(CONNECT_DATA=(SID=DMI))

  )

EXTPROC_CONNECTION_DATA=
  (DESCRIPTION=
(ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))     )
(CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO))
  )

Tnsnames Side 2: