ORA-12514 ..kann den angegebenen Service aktuell nicht auflösen

[webrookie]

Moin Freunde,

mal wieder ein altes Problem, an welchem ich hänge

"ORA-12514 TNS LISTENER kann in Connect-Deskriptor angegebenen Service aktuell nicht auflösen"

Habe meine TNSNAMES.ORA und LISTENER.ORA zitiert.

Die Instancen ...01.. und ...04... sind problemlos zu erreichen. Maßgeblich ist die Instance "VFML0003....."

VFAC0004LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0004.verkfuesys.org)
)
)

VFOP0002LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = verkfuedb.logzbw.skb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0002.verkfuesys.org)
)
)

VFED0003LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0003.verkfuesys.org)
)
)

VFED0001LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0001.verkfuesys.org)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

VFMKD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0002.verkfuesys.org)
)
)

VFED0004LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0004.verkfuesys.org)
)
)

VFOP0001LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0001.verkfuesys.org)
)
)

VFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = verkfueweb.logzbw.skb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfdb)
)
)

VFPL0001LOC.VERKFUESYS.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vfml0001.verkfuesys.org)
)
)

# listener.ora Network Configuration File: C:\ora_app\product\11.2.0\dbhome_1\network\admin\l istener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\ora_app\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\ora_app\product\11.2.0\dbhom e_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PALERMO)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\ora_app

Als Dateianhang noch je ein Screen von tnsping und lsnrctl:

Danke

[Uschi Blanz]

Der lsnrctl Status zeigt : BLOCKED für diese Instanz, die auf den Service *04* registriert ist.
Das problem liegt in der DB, nicht im Listener.
Schau Dir mal die Parameter an. z.B.:

show parameters service
show parameters listener
show parameters proc

sind meistens die Kandidaten, an denen es klemmt.

Gruß
Uschi

[webrookie]

Danke Uschi,

hab das Problem in der Datenbank gefunden.

Selbst schuld.