Hi,
I have a Virtual box with Oracle db . Here goes configuration details.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
I have Oracle Grid control 11g. Bear with me , since i am new to Grid control.
The OMS was up and running, but i couldn't login to grid using sysman password, so first quick reaction was to acknowledge that I am entering wrong password, so took a connection using sqlplus and just changed the sysman password using "alter user sysman identified by " syntax. Little did i knew that changing sysman password is more than performing "alter user ...." . So after stopping the oms, now i cannot bring it up. Here's what happens every time.
[oracle@ocmgrid11g bin]$ ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Could Not Be Started
Error Occurred: WebTier Could Not Be Started
It did not even indicate the log file path, but based on little googling i was able to find the log file location.
/u01/app/oracle/Oracle/gc_inst/em/EMGC_OMS1/sysman/log
Please refer to below log file. Though logfile doesn't indicate password as the culprit, but i am pretty sure, it's probably password issue that is not registered in oms repo, since everything was working finer until i changed the password. Can anyone guide me how to fix this ?
2015-09-10 11:32:51,157 [Main Thread] DEBUG wls.OMSController main.167 - Log location is /u01/app/oracle/Oracle/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log
2015-09-10 11:32:51,178 [Main Thread] INFO wls.OMSController startOMS.489 - admin start is false
2015-09-10 11:32:51,179 [Main Thread] INFO wls.OMSController startOMS.490 - is service is false
2015-09-10 11:32:51,205 [Main Thread] INFO wls.OMSController getEnvProps.348 - Setting trust store system properties: -Dweblogic.security.TrustKeyStore=DemoTrust -Dweblogic.security.SSL.ignoreHostnameVerification=true -Djava.security.egd=file:///dev/urandom
2015-09-10 11:32:51,208 [Main Thread] INFO wls.OMSController startOMS.508 - Starting WebTier...
2015-09-10 11:32:51,216 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: /u01/app/oracle/Oracle/gc_inst/WebTierIH1/bin/opmnctl stopall
2015-09-10 11:33:12,081 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl stopall: opmn is not running.
2015-09-10 11:33:12,085 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error: getaddrinfo(localhost, NULL, 1) failed (Temporary failure in name resolution): Connection timed out
2015-09-10 11:33:12,086 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 0
2015-09-10 11:33:12,089 [Main Thread] INFO util.WebTierUtil execCmd.134 - Running the command: /u01/app/oracle/Oracle/gc_inst/WebTierIH1/bin/opmnctl startall
2015-09-10 11:34:24,960 [Main Thread] INFO util.WebTierUtil getProcessResult.196 - opmnctl cmd output: opmnctl startall: starting opmn and all managed processes...
opmnctl startall: opmn failed to start.
2015-09-10 11:34:24,966 [Main Thread] INFO util.WebTierUtil getProcessResult.204 - opmnctl cmd error: getaddrinfo(localhost, NULL, 1) failed (Temporary failure in name resolution): Connection timed out
getaddrinfo(localhost, NULL, 1) failed (Temporary failure in name resolution): Connection timed out
getaddrinfo(localhost, NULL, 1) failed (Temporary failure in name resolution): Connection timed out
2015-09-10 11:34:24,966 [Main Thread] INFO util.WebTierUtil getProcessResult.208 - opmnctl cmd exited with code 2
2015-09-10 11:34:24,966 [Main Thread] INFO wls.OMSController startOMS.524 - WebTier Could Not Be Started
2015-09-10 11:34:24,967 [Main Thread] ERROR wls.OMSController main.258 - OMSController failed for start oms
2015-09-10 11:34:24,969 [Main Thread] ERROR wls.OMSController main.259 - OMSController Error: WebTier Could Not Be Started
java.lang.Exception: WebTier Could Not Be Started
at oracle.sysman.emctl.wls.OMSController.startOMS(OMSController.java:525)
at oracle.sysman.emctl.wls.OMSController.main(OMSController.java:213)
Also fyi, I am able to connect to sql via sysman id / new pwd that i got from sqlplus prompt.
As of now my database and listener is up and running but OMS is down. I also tried executing following command to change the password, but it's not taking the new password that i set using sqlplus which is pretty obvious since repository wouldn't have any clue on my new password.
[oracle@ocmgrid11g bin]$ ./emctl config oms -change_repos_pwd -change_in_db
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :
ORA-01017: invalid username/password; logon denied
Failed to connect to repository. Check the credentials supplied.
-Learner