3 Replies Latest reply: Nov 12, 2012 10:48 AM by user735250 RSS

    dbconsole doesn't start -- ORA-01017 -- Database connection through listene

    Artem Khisamiev
      I've upgraded my 9.2.0.8 db to 11.2.0.3
      and during start dbconsole --
      ./emca -config dbcontrol db -repos create
      I've faced a problem --
      Nov 9, 2012 10:44:42 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      WARNING: ORA-01017: invalid username/password; logon denied
      
      Nov 9, 2012 10:44:42 AM 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 1521 provided is incorrect. Provide the correct port.
      2) Listener is not up. Start the Listener.
      3) Database service ACTUAL22.cyberplat.com 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.
      5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
      6) /etc/hosts does not have correct entry for hostname.
      
      Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ACTUAL22/emca_2012_11_09_10_44_16.log for more details.
      Nov 9, 2012 10:44:42 AM oracle.sysman.emcp.EMConfig perform
      CONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException:
      
      Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
      
      Some of the possible reasons may be:
      
      1) Listener port 1521 provided is incorrect. Provide the correct port.
      2) Listener is not up. Start the Listener.
      3) Database service ACTUAL22.cyberplat.com 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.
      5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
      6) /etc/hosts does not have correct entry for hostname.
      
              at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3342)
              at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:858)
              at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:288)
              at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:198)
              at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
              at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
              at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
              at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
              at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
      Nov 9, 2012 10:44:42 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
      CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0.3e/db_1/oui
      I'm following those 6 recomendations and none of them is a remedy.
      Any suggestions?

      Thanks,
      Artem.