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