oracle11g安装后创建数据库提示问题

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/bca65432123/article/details/84695103
oracle 使用database control 配置数据库时,要求在当前oracle主目录中配置监听程序,必须运行Netca以配置

oracle是这样的:
监听与数据库的服务是分开的,是单独的一个Session线程。
监听是专门负责挂牌的,就想医院里面你看到的专门挂牌的那个地方用来接待病人的(即:访问IP)
但是监听到有病人的时候,知道她看妇科病,但是妇科医生没有坐诊(即:为所寻找的这个数据库实例没有启动,不坐诊)
现在你是强行让妇科医生坐诊,但是医院却不开门(即监听为关闭状态)

所以总让你先开启监听,开启监听的步骤如上图所说:
或者:
cmd-->lsnrctl start ----启动监听
-->sqlplus "/as sysdba"
-->startup;
此时就OK了。
展开阅读全文

Oracle11g创建数据库到40%就报错

04-04

在安装Oracle11g时,每次创建数据库到40%的时候就报错,我把所有报错忽略,完成安装。rn安装完成后使用Database configration assistant创建数据库,还是每次到40%的时候报同样的错误,rn昨晚上到现在一直没找到答案,请懂的朋友帮帮忙!在线等,谢谢了!rn截图及日志如下:rn日志文件详细记录:rn[AWT-EventQueue-0] [ 2014-04-04 14:34:33.666 CST ] [WindowsSystem.startRemoteExecServer:1728] _WS_: Checking if service is startedrnrn[AWT-EventQueue-0] [ 2014-04-04 14:34:33.666 CST ] [Utils.getLocalHost:356] Hostname retrieved: arthur-PC, returned: arthur-PCrn[AWT-EventQueue-0] [ 2014-04-04 14:34:33.666 CST ] [WindowsSystem.dorunRemoteExecCmd:2061] _WS_: Calling windowsNative with cmd: D:\app\arthur\product\11.2.0\dbhome_1\bin\getcrshome.exern[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [WindowsSystem.dorunRemoteExecCmd:2064] _WS_: WinNative returned: truern[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [WindowsSystem.dorunRemoteExecCmd:2078] _WS_: remote command executed, but didn't return zero.rn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed.rn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [DatabaseOperationsPage.reinitialize:520] PRCT-1400 : 未能执行 getcrshome。详细错误:rnlocalnodern[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINErn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySYSTEM\CurrentControlSet\Services\OracleServiceORCLrn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsWindows.enumerateSIDs:428] imagepath d:\app\arthur\product\11.2.0\dbhome_1\bin\ORACLE.EXE ORCL\binrn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsWindows.enumerateSIDs:432] adding sid to sidlist ORCLrn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINErn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySYSTEM\CurrentControlSet\Services\OracleServiceARTHURrn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsWindows.enumerateSIDs:428] imagepath d:\app\arthur\product\11.2.0\dbhome_1\bin\ORACLE.EXE ARTHUR\binrn[AWT-EventQueue-0] [ 2014-04-04 14:34:34.680 CST ] [OsUtilsWindows.enumerateSIDs:432] adding sid to sidlist ARTHURrn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [HAUtils.getHASHome:631] Oracle home from system properties: D:\app\arthur\product\11.2.0\dbhome_1rn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS home for Oracle home ( D:\app\arthur\product\11.2.0\dbhome_1 ) ...rn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [GETCRSHOMEUtil.:88] Toolname: getcrshome.exe --- Tool location: D:\app\arthur\product\11.2.0\dbhome_1\binTool dependencies: [Ljava.lang.String;@1a28362rn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [CmdToolUtil.doexecute:360] starting remote exec server on local node src=D:\app\arthur\product\11.2.0\dbhome_1\bin dest=C:\Users\ADMINI~1\AppData\Local\Temp\rn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [Utils.getLocalHost:356] Hostname retrieved: arthur-PC, returned: arthur-PCrn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [WindowsSystem.startRemoteExecServer:1728] _WS_: Checking if service is startedrnrn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [Utils.getLocalHost:356] Hostname retrieved: arthur-PC, returned: arthur-PCrn[AWT-EventQueue-0] [ 2014-04-04 14:34:35.569 CST ] [WindowsSystem.dorunRemoteExecCmd:2061] _WS_: Calling windowsNative with cmd: D:\app\arthur\product\11.2.0\dbhome_1\bin\getcrshome.exern[AWT-EventQueue-0] [ 2014-04-04 14:34:36.583 CST ] [WindowsSystem.dorunRemoteExecCmd:2064] _WS_: WinNative returned: truern[AWT-EventQueue-0] [ 2014-04-04 14:34:36.583 CST ] [WindowsSystem.dorunRemoteExecCmd:2078] _WS_: remote command executed, but didn't return zero.rn[AWT-EventQueue-0] [ 2014-04-04 14:34:36.583 CST ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed.rn[AWT-EventQueue-0] [ 2014-04-04 14:34:36.583 CST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1400 : 未能执行 getcrshome。详细错误:rnlocalnodernPRCT-1400 : 未能执行 getcrshome。详细错误:rnlocalnodern at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425)rn at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592)rn at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652)rn at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360)rn at oracle.sysman.assistants.dbca.ui.DatabaseOperationsPage.validate(DatabaseOperationsPage.java:324)rn at oracle.sysman.assistants.util.wizard.WizardPageExt.wizardValidatePage(WizardPageExt.java:214)rn at oracle.ewt.wizard.WizardPage.processWizardValidateEvent(Unknown Source)rn at oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)rn at oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)rn at oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)rn at oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:265)rn at oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)rn at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)rn at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)rn at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)rn at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)rn at oracle.ewt.button.PushButton.activate(Unknown Source)rn at oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)rn at oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)rn at java.awt.Component.processEvent(Component.java:5282)rn at java.awt.Container.processEvent(Container.java:1966)rn at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)rn at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)rn at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)rn at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)rn at java.awt.Component.dispatchEventImpl(Component.java:3984)rn at java.awt.Container.dispatchEventImpl(Container.java:2024)rn at java.awt.Component.dispatchEvent(Component.java:3819)rn at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)rn at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)rn at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)rn at java.awt.Container.dispatchEventImpl(Container.java:2010)rn at java.awt.Window.dispatchEventImpl(Window.java:1791)rn at java.awt.Component.dispatchEvent(Component.java:3819)rn at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)rn at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)rn at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)rn at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)rn at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)rn at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)rnCaused by: PRCT-1400 : 未能执行 getcrshome。详细错误:rnlocalnodern at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:161)rn at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:112)rn at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:422)rn ... 39 morern.......这里省略了很多rnrnexecuteImpl:419] Length of OriginalRedoLogsGrNames=3rn[Thread-42] [ 2014-04-04 14:37:47.650 CST ] [CloneDBCreationStep.executeImpl:427] 0th redoLogText = GROUP 1 ('ORACLE_BASE\oradata\DB_UNIQUE_NAME\redo01.log') SIZE 51200Krn[Thread-42] [ 2014-04-04 14:37:47.650 CST ] [CloneDBCreationStep.executeImpl:427] 1th redoLogText = GROUP 2 ('ORACLE_BASE\oradata\DB_UNIQUE_NAME\redo02.log') SIZE 51200Krn[Thread-42] [ 2014-04-04 14:37:47.650 CST ] [CloneDBCreationStep.executeImpl:427] 2th redoLogText = GROUP 3 ('ORACLE_BASE\oradata\DB_UNIQUE_NAME\redo03.log') SIZE 51200Krn[Thread-42] [ 2014-04-04 14:37:47.650 CST ] [CloneDBCreationStep.executeImpl:448] createCTLSql=Create controlfile reuse set database "arthur6"rnMAXINSTANCES 8rnMAXLOGHISTORY 1rnMAXLOGFILES 16rnMAXLOGMEMBERS 3rnMAXDATAFILES 100rnDatafile rn'D:\app\arthur\oradata\arthur6\SYSTEM01.DBF',rn'D:\app\arthur\oradata\arthur6\SYSAUX01.DBF',rn'D:\app\arthur\oradata\arthur6\UNDOTBS01.DBF',rn'D:\app\arthur\oradata\arthur6\USERS01.DBF'rnLOGFILE GROUP 1 ('D:\app\arthur\oradata\arthur6\redo01.log') SIZE 51200K,rnGROUP 2 ('D:\app\arthur\oradata\arthur6\redo02.log') SIZE 51200K,rnGROUP 3 ('D:\app\arthur\oradata\arthur6\redo03.log') SIZE 51200K RESETLOGS;rn[Thread-42] [ 2014-04-04 14:37:48.477 CST ] [CloneDBCreationStep.executeImpl:460] calling zerodbidrn[Thread-42] [ 2014-04-04 14:37:54.327 CST ] [CloneDBCreationStep.executeImpl:470] Shutdown databasern[Thread-42] [ 2014-04-04 14:37:54.327 CST ] [CloneDBCreationStep.executeImpl:492] Startup ......nomount......rn[Thread-42] [ 2014-04-04 14:37:58.290 CST ] [CloneDBCreationStep.executeImpl:511] Enabling restricted session.rn[Thread-42] [ 2014-04-04 14:38:00.333 CST ] [CloneDBCreationStep.executeImpl:513] alter database "arthur6" open resetlogs;rn[Thread-42] [ 2014-04-04 14:38:11.066 CST ] [CloneDBCreationStep.executeImpl:521] Removing existing services from sourcedb seeddatarn[Thread-56] [ 2014-04-04 14:38:11.128 CST ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@a7bd7a:messageHandlerrn[Thread-56] [ 2014-04-04 14:38:11.128 CST ] [BasicStep.handleNonIgnorableError:431] ORA-00604: error occurred at recursive SQL level 1rnORA-06553: PLS-801: internal error [56327]rn:msgrn[Thread-56] [ 2014-04-04 14:39:10.549 CST ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@a7bd7a:messageHandlerrn[color=#FF0000][color=#FF0000][Thread-56] [ 2014-04-04 14:39:10.549 CST ] [BasicStep.handleNonIgnorableError:431] ORA-00604: error occurred at recursive SQL level 1rnORA-06553: PLS-801: internal error [56327][/color]:msg[/color]rnrnrn 论坛

没有更多推荐了,返回首页