Notice that sometime the Solution will be different Regarding to DB version and OS Version I will Post Some MOS notes that could help you. Sometimes you need to apply Patch and on other hand there’s Workaround.
Error #1 :
Exception in thread “main” oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable
Solution :
- -Make Sure you Database is Up and Running.
- -Set/export ORACLE_SID.
- -Check if Database registered with Listener.
You can get back to this MOS note :
EMCA fails with “SEVERE: Database instance unavailable” [ID 750697.1]
EMCA fails with Database Instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again. [ID 1511262.1]
Creating dbconsole 11.2 fails with “Exception in thread “main” oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable” on Windows [ID 1332546.1]
Error #2:
Running EMCA fails with “SEVERE: Invalid username/password”
Solution :
- -Make Sure You Insert Correct Password.
- -In Some Version you can use “Password”
- -Recreate Password File.
You can Get back to this MOS note :
Problem: Running EMCA fails with “SEVERE: Invalid username/password” [ID 744176.1]
EMCA fails with SEVERE: Invalid username/password or database/scan listener not up or database service is not registered with scan listener. [ID 1330272.1]
Error #3:
WARNING: ORA-01031: insufficient privileges
Solution
You need to check the logs, different error could be appear.
Failed to unlock all EM-related accounts
Alter User Identified By
Also Check MOS Notes :
Troubleshooting the ‘ORA-01031: insufficient privileges’ error when using EMCA to Create or Drop DBconsole [ID 358201.1]
Error #4:
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Solution :
- – set/export ORACLE_SID
- -Check your Listener.
- -Check if Database Registered.
Check the below MOS note :
Troubleshooting the EMCA Error “ORA-12514” “Listener is not up. Start the Listener and run EM Configuration Assistant again” When Creating or Dropping DBConsole [ID 368591.1]
EMCA Fails With Error “ORA-12541: TNS:no listener” and “Listener is not up. Start the Listener and run EM Configuration Assistant again” [ID 975024.1]
thanks for share.
LikeLike
Your welcome
LikeLike
Thanks for the great post and explaining the issue step by step.
LikeLike
Thanks a lot for taking time off to put together this good job
LikeLike
Your Welcome
LikeLike