Hello,
We have recently upgraded our oracle database from 11g to 12c (12.1.0.2.0). I have installed the cloud control in a separate server and was managing the database using that. Everything was working fine after upgrade. Recently the server in which cloud control is installed was restarted, after which OMS could not be reached. I noticed that the repository database and listeners were down after restart, i have brought everything up and tried starting OMS but it fails giving below error message,
[oracle@Server bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Could Not Be Started
Check EM Server log file for details: /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out
Oracle Management Server is Down
Log file shows the below error message,
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Tnsnames.ora:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EMREP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = emrep)
)
)
Below is the result of OMS repos connection:
[oracle@Caesar bin]$ ./emctl config oms -list_repos_details
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=caesar.ave.lan)(PORT=1521)))(CONNECT_DATA=(SID=emrep)))
Repository User : SYSMAN
Tnsnames.ora has SERVICE_NAME but OMS repos has SID. I doubted whether this might be the reason for the problem, hence tried using SID in tnsnames.ora. But same problem persists. I could so many archives in community forum with the same error message, but they were not answered. I also searched MOS and read the related documents but could not find anything relevant to this scenerio. Some of them suggested to user new parameters in tnsnames.ora such as USER_SID_AS_SERVICE_listenername , DEFAULT_SERVICE_listenername=emrep, but none of them helped.
Could anyone please help to resolve this issue?
Thanks in advance,
AGana