ICOS_ICT
asked on
Unable to connect via Oracle Enterprise Manager - ORA-12514
Hi Experts,
We have 3 Oracle databases. 2 of them where created by me, one is created by an external firm. For the two databases that I created, we have an URL to access it via the Oracle Enterprise Manager. For the third one we never got such an URL (or it was never created).
If I look in the services I saw two services: OracleDBConsoleBWISE and OracleDBConsoleCOMPASS, which allow me to connect. For Sibersafe this service was not there.
Now I configured one via C:\EMCA -r which also returned an URL.
There are now three services: OracleDBConsoleSIBERSAFE, OracleDBConsoleBWISE and OracleDBConsoleCOMPASS
If I want to connect to the database through the OEM it gives me the following error (http://ICOSNV100.icos.be:5501/EM):
Database Error
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST =(ADDRESS= (PROTOCOL= TCP)(HOST= ICOSNV100. ICOS.be)(P ORT=1521)) )(CONNECT_ DATA=(SERV ICE_NAME=O racleServi ceSIBERSAF E)))
I have no problem connecting to the database via sqlplus
I am also an Oracle lay person
Can someone help me on this issue?
Thanks in advance
We have 3 Oracle databases. 2 of them where created by me, one is created by an external firm. For the two databases that I created, we have an URL to access it via the Oracle Enterprise Manager. For the third one we never got such an URL (or it was never created).
If I look in the services I saw two services: OracleDBConsoleBWISE and OracleDBConsoleCOMPASS, which allow me to connect. For Sibersafe this service was not there.
Now I configured one via C:\EMCA -r which also returned an URL.
There are now three services: OracleDBConsoleSIBERSAFE, OracleDBConsoleBWISE and OracleDBConsoleCOMPASS
If I want to connect to the database through the OEM it gives me the following error (http://ICOSNV100.icos.be:5501/EM):
Database Error
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST
I have no problem connecting to the database via sqlplus
I am also an Oracle lay person
Can someone help me on this issue?
Thanks in advance
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
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\driver s\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.
In your computer go to C:\WINDOWS\system32\driver
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.
ASKER
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\d b_1\networ k\admin\sq lnet.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\d b_1\NETWOR K\ADMIN\sq lnet.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_SERV ICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
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\d
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\d
# 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_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES)
Comment
# SQLNET.AUTHENTICATION_SERV ICES= (NTS)
or
SQLNET.AUTHENTICATION_SERV ICES= (NONE)
# SQLNET.AUTHENTICATION_SERV
or
SQLNET.AUTHENTICATION_SERV
ASKER
Hello,
The tnsping works, but I still can't access the database via the Oracle Enterprise Manager.
Any suggestions left?
Thanks
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.
9i,
10g R1
or
10g R2
?
Also go to DBCA and try to reconfig your existing DB creating OEM.
ASKER
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.
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 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?
ASKER
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?
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.
Try very careful to reconfigure the instance you are woried,
providing it with Database Control.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
set oracle_sid=sibersafe
emca -config dbcontrol db