I have two database instances that reside on the same server for whatever reason one of the Oracle Enterprise Managers does not seem to work. When I run the emca -config dbcontrol db I get the following:
C:\windows\system32>D:\app\product\11.2.0\dbhome_1/bin/emca -config dbcontrol db
STARTED EMCA at Feb 10, 2014 1:19:42 PM
EM Configuration Assistant, Version 22.214.171.124.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: raster
Feb 10, 2014 1:19:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01031: insufficient privileges
Feb 10, 2014 1:19:45 PM oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.
Some of the possible reasons may be :
1) Database may not be up.
2) Database is started setting environment variable ORACLE_HOME with trailing '/
'. Reset ORACLE_HOME and bounce the database.
For eg. Database is started setting environment variable ORACLE_HOME=/scratch/db/ . Reset ORACLE_HOME=/scratch/db and bounce the database.
And from what you see from the above I also ran the -repose. Where it says the database may not be up well I confirmed that it is. I guess the only question I have is I am not entirely sure what the second reason means. Any help would be appreciated.