Unable to connect via Oracle Enterprise Manager - ORA-12514

For 10g under Windows this is a known issue.
Use static registration of the instance to the Listener:

For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start


Another possibility is error in the connection string
Try to ping the listener:
c:\>tnsping entry_from_tnsnames.ora

I resolve this issue in my computer with this steps:

In your computer go to C:\WINDOWS\system32\drivers\etc  and modify the file named hosts with notepad.

You are going to add the Ip address of ICOSNV100.ICOS.be, then hit the "tab key" and then enter ICOSNV100.ICOS.be, then hit the "tab key" again and enter ICOSNV100.ICOS.
Save it.
Go again and try your  Url.  It should function.

Hello All,

I tried all of the above to no avail.  In the Oracle Enterprise Manager I still get the ORA-12514 error message.
The syntax -config dbcontrol db for emca is not correct.

When I try to ping to the listener I get the following message:

Used parameter files:
C:\Oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name

The file sqlnet.ora only contains the following lines:
# sqlnet.ora Network Configuration File: C:\Oracle\product\10.1.0\db_1\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

Comment

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

or

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Hello,

The tnsping works, but I still can't access the database via the Oracle Enterprise Manager.

Any suggestions left?

Thanks

What is the version of Oracle:
9i,
10g R1  
or  
10g  R2
?

Also go to DBCA and try to reconfig your existing DB creating OEM.

The version of Oracle is 10g release 10.1.0.3.0 Production.
 Running the DBCA only let me reconfigure the connection mode (dedicated or shared server mode), all the rest is greyed out.

Seems the agent is running bad.
I know how to reconfigure the Repository in 10.1 but we have never done this
with 3 running instances. It is relativelly complex - you have to delete all sysman schema,
but it works.

It is easier to do this job in 10g R2.
Is it possible for you to migrate to
this newer version?

I prefer not to migrate to this newer version and I don't think I have this release.
But, the 3 instances are all separate databases.  This is done for maintenance  reason.  
Can this make life easier?

Go to DBCA utility.
Try very careful to reconfigure the instance you are woried,
providing it with Database Control.

Sorry for the very late reaction..
I cannot reconfigure the instance .  The only option available is the connection mode (dedicated or shared server mode), all the rest is greyed out.
Is it possible to remove the entire console configuration for this instance? i.e using the EMCA command?
This way I can try to configure the OEM DBConsole from scratch again.

Yes you can, using -deconfig flag.

Hi.
I think it is about time you distribute the points as we have separated precious time of our own to help you.
Now it is time you help us giving the points we deserve.