Created On:  11 April 2012

Problem:

When trying to open a workspace or create a new workspace the ORA – 12514 TNS:Listerner does not currently know of service requested in connect descriptor error is sometimes reported.

Resolution:

The problem is that the Oracle client and server are using different service names. The simplest thing is to change the service name used by the client to match the one defined at the server.

To find out the name of the service on the server, based on the standard MWB Oracle install, run the following command from a command prompt:

lsnrctl status

On windows this displays the following information:

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-APR-2012 11:02:33

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                27-MAR-2012 17:11:50

Uptime                    8 days 17 hr. 50 min. 44 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   E:\Oracle\11.2.0\home\network\admin\listener.ora

Listener Log File         e:\oracle\diag\tnslsnr\nwb-peterh790\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))

Services Summary...

Service "DB11GR2.microfocus.com" has 1 instance(s).

  Instance "db11gr2", status READY, has 1 handler(s) for this service...

Service "DB11GR2XDB.microfocus.com" has 1 instance(s).

  Instance "db11gr2", status READY, has 1 handler(s) for this service...

The command completed successfully

So this shows that at the database end, the service name is DB11GR2XDB.microfocus.com

The contents of the server listerner.ora is

# listener.ora Network Configuration File: E:\Oracle\11.2.0\home\network\admin\listener.ora

# Generated by Oracle configuration tools.

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

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

    )

  )

 

ADR_BASE_LISTENER = E:\oracle

On the client side the entry in the TNS NAMES needs to look like this:

 

RMW_REPOSITORY =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = DB11GR2.microfocus.com)

    )

  )

What we do see is that the service name in the tnsnames.ora is DB11GR2., eg DB11GR2.oracle.com. This needs to be changed to DB11GR2.microfocus.com

Incident #2567430