EMCA insists that it cannot connect to the service
0
votes
1
answer
262
views
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe
I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log:
> CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me.
###Listener.ora
ADR_BASE_VLISTENER = D:\app\Administrator
VLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
)
)
###lsnrctl status
.... truncated ....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521)))
Services Summary...
Service "prodbkp" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
Service "prodbkpXDB" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
The command completed successfully
That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with
sqlplus sys@prodbkp as sysdba
just fine. Case should not be an issue with service names as per docs.oracle.com
###tsnnames.ora
PRODBKP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodbkp)
)
)
Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't _appear_ to have one.
###v$parameter output
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
prodbkp
That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it.
Basically everything looks right but something is still wrong. I cannot install Enterprise Manager
__Environment__
- Windows Server 2008R2
- Oracle 11g
Asked by Matt
(365 rep)
Aug 28, 2017, 01:58 PM
Last activity: May 18, 2025, 06:04 PM
Last activity: May 18, 2025, 06:04 PM