Reposting because of size limit
On 7/26/07, Charles Schultz <sacrophyte_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 26 2007 - 10:40:54 CDT
