登陆SQLPlus时出现:
ORA-01034:ORACLE not avaiable
ORA-27101 : shared memory realm does not exist
Process ID:0
Session ID:0 Serial Number:0
之前可以登陆的,后来隔了一段时间后突然进不去,请问要怎么解决?OS是Win XP Professional.PS:SQL Developer也是,突然进不去了,连接connection时显示错误:
ora-12528, TNS:listener all appropriate instances are blocking new connections
ORA-01034:ORACLE not avaiable
ORA-27101 : shared memory realm does not exist
Process ID:0
Session ID:0 Serial Number:0
之前可以登陆的,后来隔了一段时间后突然进不去,请问要怎么解决?OS是Win XP Professional.PS:SQL Developer也是,突然进不去了,连接connection时显示错误:
ora-12528, TNS:listener all appropriate instances are blocking new connections
怎样查看ORACLE 数据库现在是什么状态? 怎样连接直接指定一下Oracle SID?
怎样看数据库是不是安装在磁盘阵列上的哟?如果是的话,怎样挂阵列,启动?
请详细说明,谢谢
里面的log如下:
Wed Aug 04 14:53:15 2010
C:\Oracle\Administrator\product\11.2.0\dbhome_2\bin\oradim.exe -shutdown -sid orcl -usrpwd * -shutmode immediate -log oradim.log
Wed Aug 04 14:53:16 2010
ORA-28056: Writing audit records to Windows Event Log failed
OSD-00004: additional error information
O/S-Error: (OS 1502) ??????????????????
ORA-01075: you are currently logged on
Wed Aug 04 14:55:47 2010
C:\Oracle\Administrator\product\11.2.0\dbhome_2\bin\oradim.exe -startup -sid orcl -usrpwd * -log oradim.log -nocheck 0
Wed Aug 04 14:55:47 2010
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1917760: Message 1917760 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1917760: Message 1917760 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
Wed Aug 04 15:31:22 2010
C:\Oracle\Administrator\product\11.2.0\dbhome_2\bin\oradim.exe -shutdown -sid orcl -usrpwd * -shutmode immediate -log oradim.log
Wed Aug 04 15:31:23 2010
ORA-28056: Writing audit records to Windows Event Log failed
OSD-162573544: Message 162573544 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
ORA-28056: Writing audit records to Windows Event Log failed
OSD-162573544: Message 162573544 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
Wed Aug 04 16:26:28 2010
C:\Oracle\Administrator\product\11.2.0\dbhome_2\bin\oradim.exe -shutdown -sid orcl -usrpwd * -shutmode immediate -log oradim.log
Wed Aug 04 16:26:29 2010
ORA-28056: Writing audit records to Windows Event Log failed
OSD-00004: additional error information
O/S-Error: (OS 1502) ??????????????????
ORA-01075: you are currently logged on
Wed Aug 04 16:26:31 2010
C:\Oracle\Administrator\product\11.2.0\dbhome_2\bin\oradim.exe -startup -sid orcl -usrpwd * -log oradim.log -nocheck 0
Wed Aug 04 16:26:31 2010
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1917760: Message 1917760 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
ORA-28056: Writing audit records to Windows Event Log failed
OSD-1917760: Message 1917760 not found; product=RDBMS; facility=SOSDO/S-Error: (OS 1502) ??????????????????
运行conn /as sysdba 出现错误
ORA-28056: Writing audit records to Windows Event Log failed
然后运行startup force,出现错误
ORA-01031: insufficient privileges
找到原因了,是系统的日志满了。
控制面板-》管理工具-》事件查看器 清理满了的log,然后按Phoenix_99所说的startup force便可
第一把注册表的HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1中的oracle_sid是否正确,
第二 dos 下运行set oracle_sid='你的正确oracle_sid'
在emctl dbcoonsole db ; 如果还有问题在重新配置
dos 输入 emca -config dbcontrol db 命令重新配置,你根据提示一步一步来
ORA-01031: insufficient privileges
看这里面sqlnet.ora 中的SQLNET.AUTHENTICATION_SERVICES= (NTS)