Oracle EM Configuration
Start Stop DBConsole Service for Oracle EM
emctl status dbconsole
emctl start dbconsole
emctl stop dbconsole
OC4J Configuration issue
If you get following error in starting dbconsole
OC4J_DBConsole_
then drop and re-create OC4J configuration first drop existing configuration and then create new.
To drop existing configuration
emca -deconfig dbcontrol db -repos drop
To create configuration
emca -config dbcontrol db -repos create
If you get following error / exception in re-creating configuration
In console window
Exception in thread “main” oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
In log file
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges
Steps to resolve this issue (Steps 3 onward are optional)
- Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in init.ora (located in %ORACLE_HOME%\dbs)
confirm this by issuing command show paramter remote_login_passwordfile - Create password file by using ORAPWD
orapwd file=%ORACLE_HOME%/dbs/pwd.ora password= entries=5 - In listener.ora
ADR_BASE_LISTENER = C:\Oracle\Oracle11g - In sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS) - Environment Variables
ORACLE_HOME=<Home>
ORACLE_SID=<sid>
ORACLE_HOSTNAME=<host name>
ORACLE_UNQNAME=<sid>
DBCA can also be used to re-configure Oracle EM Settings
Oracle Listener
Listener Start/Stop/Status
lsnrctl start
lsnrctl stop
lsnrctl status
lsnrctl service