11gR2 DBCA Can not Connect to Database/Instance in Multiple Listener Environment

(Doc ID 1352890.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database Configuration Assistant - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

11gR2 Grid Infrastructure/RAC with multiple listeners on different ports, dbca fails to connect to database with the following symptoms:

Connection to the database cannot be established because the listener could be down. Please make sure that the service is registered with a listener and the listener is up.

Connection to the database failed. Please make sure that service "racnode1-vip:1521:racdb1" is registered with the listener, user name "sys" has SYSDBA privilege, password is correct and then try again
[AWT-EventQueue-0] [ 2011-02-03 08:49:00.866 EST ] [HADatabaseUtils.getDefaultListenerConnectString:1865]  inside getDefaultListenerConnectString : ConnectString : racnode1-vip:1521:racdb1
[AWT-EventQueue-0] [ 2011-02-03 08:49:00.866 EST ] [DatabaseListPage.validate:753]  setting connect service racnode1-vip:1521:racdb1
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.356 PDT ] [DatabaseListPage.validate:759]  DatabaseListPage: localInstanceName=racdb1
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.356 PDT ] [Verifier.validateCredentials:451]  Verifier: service = racnode1-vip:1521:racdb1
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.358 PDT ] [Verifier.validateCredentials:452]  Verifier: bRemote = true
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.358 PDT ] [Verifier.validateCredentials:453]  Verifier: err after calling getUserNameError function  = null
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.359 PDT ] [Verifier.validateCredentials:463]  Verifier: err after calling getPswdError function = null
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.359 PDT ] [Verifier.validateCredentials:476]  Verifier: err after calling getServiceError function = null
May 25, 2011 9:37:44 AM oracle.jdbc.driver.OracleDriver registerMBeans
WARNING: Error while registering Oracle JDBC Diagnosability MBean.
java.security.AccessControlException: access denied (javax.management.MBeanTrustPermission register)
        at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)
        at java.lang.SecurityManager.checkPermission(SecurityManager.java:568)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrustPermission(DefaultMBeanServerInterceptor.java:1724)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:335)
        at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:497)
        at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:342)
        at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:199)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:195)
        at oracle.sysman.vdb.VdbSessionFactory.construct(VdbSessionFactory.java:532)
        at oracle.sysman.vdb.VdbSessionFactory.<init>(VdbSessionFactory.java:434)
        at oracle.sysman.assistants.dbca.backend.ServerObjectFactory.getSqlEngine(ServerObjectFactory.java:133)
        at oracle.sysman.assistants.dbca.backend.DatabaseAttributes.<init>(DatabaseAttributes.java:158)
        at oracle.sysman.assistants.dbca.backend.Verifier.validateCredentials(Verifier.java:494)
        at oracle.sysman.assistants.dbca.ui.DatabaseListPage.validate(DatabaseListPage.java:768)
        at oracle.sysman.assistants.util.wizard.WizardPageExt.wizardValidatePage(WizardPageExt.java:214)
        at oracle.ewt.wizard.WizardPage.processWizardValidateEvent(Unknown Source)
        at oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)
        at oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:265)
        at oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
        at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at oracle.ewt.button.PushButton.activate(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[AWT-EventQueue-0] [ 2011-05-25 09:37:44.948 PDT ] [Verifier.validateCredentials:511]  SID given in connect descriptor could not be resolved
SQL> show parameter local_listener
--------------------------------------
local_listener  string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myracnode1-vip)(PORT=1529))))
$GRID_HOME/bin/crsctl stat res -t
..
ora.LISTENER.lsnr
               ONLINE  ONLINE       racnode1
               ONLINE  ONLINE       racnode2
ora.LISTENER_RACDB.lsnr
               ONLINE  ONLINE       racnode1
               ONLINE  ONLINE       racnode2


$GRID_HOME/bin/lsnrctl status listener
..
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.X.X.AA)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.X.X.BB)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...



$GRID_HOME/bin/lsnrctl status listener_racdb
..
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_RACDB)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.X.X.AA)(PORT=1529)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.X.X.BB)(PORT=1529)))
Services Summary...
Service "racdb" has 1 instance(s).
  Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
  Instance "racdb1", status READY, has 1 handler(s) for this service...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms