Create EM using emca failed with error "Database connection through listener failed"
I use command "emca -config dbcontrol db -repos create" and the emca failed with
the following errors:
===========================================
Oct 12, 2012 1:58:09 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-01031: insufficient privileges
Oct 12, 2012 1:58:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
Some of the possible reasons may be:
1) Listener port 1526 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service PROD is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.