ORA-12514: : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Try to comment the line

SQLNET.AUTHENTICATION_SERVICES= (NTS)

in sqlnet.ora

or set it so

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Of course stop/start the Listener:

lsnrctl stop
lsnrctl start

If it all works when you restart the database service, then its probably working because the database has reregistered itself with the listener, and you are connecting via this service.

This would tend to suggest that your original service is not working/connectable.

When everything is working fine, do a

lsnrctl services
lsnrctl status

you will probably see two services for each database, one (the default one) with all the successful connections, and the one manually specified with none.

If tnsping is working, then you are hitting the listener correctly which is a good start. The next stage of the connection is for the listener to determine which database to connect you to, and this is where its going pear shaped.

Post your listener.ora and tnsnames.ora, and we'll advise further.

HTH
Bob

Here's my listener.ora

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = e:\apps\oracle)
      (PROGRAM = extproc)
    )
  )

and my tnsnames is

podium=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = comp3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = odr)
    )
  )

Sorry my see the correct listener.ora

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = e:\apps\oracle)
      (PROGRAM = extproc)
    )
  )

C:>tnsping podium

to check the Listener

Your listener knows where to listen (port and protocol) as specified in the LISTENER= part.
However if it receives a request, and the database hasnt registered itself, it wont know what to do with it.

Try changing this portion of your listener.ora to explicity name the instance (static registration)


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = e:\apps\oracle)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (ORACLE_HOME = e:\apps\oracle)
      (SID_NAME = odr)
    )
  )

Look at the connect string in the tnsnames.ora file that OEM 2.0.4 is using.  The "CONNECT_DATA" parameter uses "SERVICE_NAME" not "SID".

  You need to change the SERVICE_NAME to SID.



 The tnsnames.ora is using the SERVICE_NAME instead of SID. This is an 815 sqlnet parameter and the OEM 2.0.4 is based off of Oracle 8.0.4. The 8.0.4 uses SID in tnsnames.

Any update>?