Re: DBCA error while creating a 2nd database on RAC cluster

Reposting because of size limit

On 7/26/07, Charles Schultz <sacrophyte@xxxxxxxxx> wrote:

We are not seeing a sqlnet.log file. I tried some carefully controlled
tests, and found that only the dbca log and 3 audit files are modified when
we hit this error. The audit files are somewhat interesting, in a
mysterious, enigma sort of a way. The dbca log is quite useless, even with
tracing turned on.

This is the weird part. The audit files show that a total of 6 connections
to ASM were attempted, 2 for each audit file, one for each of SYS and '/'.
The SYS connection had a status of 1017:
Thu Jul 26 09:22:09 2007
ACTION : 'CONNECT'
DATABASE USER: 'SYS'
PRIVILEGE : NONE
CLIENT USER: oracle
CLIENT TERMINAL: Not Available
STATUS: 1017

The '/' connection has a status of 0:
Thu Jul 26 09:22:09 2007
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL: Not Available
STATUS: 0


I did several tests, and these three audit files seem to only show up when
we get this error. A strange coincedence, eh? Note the timestamps. I also
just noticed that the SYS connection is attempted with no privileges. I need
to research that a little better.

Here is the relevant part of the dbca log file, for the curious:
[AWT-EventQueue-0] [9:22:9:209] [ ASMInstanceRAC.validateASM:609]
oracle.sysman.assistants.util.sqlEngine.SQLE
ngine.executeImpl(SQLEngine.java:1467)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.startup (SQLEngine.java
:1860)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.startup (SQLEngine.java
:1847)
oracle.sysman.assistants.util.asm.ASMInstance.detectASMInstance (
ASMInstance.java:818)
oracle.sysman.assistants.util.asm.ASMInstanceRAC.detectASMInstance (
ASMInstanceRAC.java:1204)
oracle.sysman.assistants.util.asm.ASMInstanceRAC.validateASM (
ASMInstanceRAC.java:580)
oracle.sysman.assistants.util.asm.ASMInstanceRAC.validateASM (
ASMInstanceRAC.java:522)
oracle.sysman.assistants.util.asm.ASMInstanceRAC.validateASM (
ASMInstanceRAC.java:515)
oracle.sysman.assistants.dbca.ui.StorageOptionsPage.validate (
StorageOptionsPage.java:496)
oracle.sysman.assistants.util.wizard.WizardPageExt.wizardValidatePage (
WizardPageExt.java:206)
oracle.ewt.wizard.WizardPage.processWizardValidateEvent (Unknown Source)
oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)
oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)
oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)
oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:237)
oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
oracle.ewt.lwAWT.LWComponent.redispatchEvent (Unknown Source)
oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
oracle.ewt.button.PushButton.activate(Unknown Source)
oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Component.java:4897)
java.awt.Container.processEvent (Container.java:1569)
oracle.ewt.lwAWT.LWComponent.processEventImpl (Unknown Source)
oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Component.java:3615)
java.awt.Container.dispatchEventImpl(Container.java:1627)
java.awt.Component.dispatchEvent (Component.java:3477)
java.awt.LightweightDispatcher.retargetMouseEvent (Container.java:3483)
java.awt.LightweightDispatcher.processMouseEvent (Container.java:3198)
java.awt.LightweightDispatcher.dispatchEvent( Container.java:3128)
java.awt.Container.dispatchEventImpl(Container.java :1613)
java.awt.Window.dispatchEventImpl(Window.java:1606)
java.awt.Component.dispatchEvent(Component.java:3477)
java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
java.awt.EventDispatchThread.pumpOneEventForHierarchy (
EventDispatchThread.java:201)
java.awt.EventDispatchThread.pumpEventsForHierarchy (
EventDispatchThread.java:151)
java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java:145)
java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java:137)
java.awt.EventDispatchThread.run(EventDispatchThread.java :100)
[AWT-EventQueue-0] [9:22:9:210] [StorageOptionsPage.validate:611]  ASM
present but not startable, querying user..


--
Charles Schultz

Other related posts: