不知道什么原因:之前刚刚是好的 后来登陆pl/sql 本地数据库时,服务都已启动了 提示:ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 我还在网上查了下,已经确定不是ORACLE_SID和ORACLE_HOME 的问题了,检查过没改变,并且昨天还用的好好的,今天突然就出了这个问题,不可能是修改了ORACLE_SID和ORACLE_HOME。
不过我也试了下: 1. cmd 命令下: set ORACLE_SID=orcl;之后在重新启动服务 还是不行;
2. (1). 在运行中输入cmd,输入sqlplus /nolog,回车, 这时出现了SQL>;
(2).输入connect / as sysdba;回车;提示:
ORACLE 例程已经启动。
Total System Global Area 390070272 bytes
Fixed Size 1249152 bytes
Variable Size 150995072 bytes
Database Buffers 230686720 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
ORA-01092: ORACLE 实例终止。强制断开连接 /**它又出现这种错误**、
赶紧检查alert_orcl.log日志:D:\oracle\product\10.2.0\admin\Oracle_SID\bdump\alert_orcl.log :
Sat Nov 05 11:42:27 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 142606336
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 390070272
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 230686720
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 128974848
PMON started with pid=2, OS id=5760
PSP0 started with pid=3, OS id=5152
MMAN started with pid=4, OS id=5068
DBW0 started with pid=5, OS id=3504
LGWR started with pid=6, OS id=3892
CKPT started with pid=7, OS id=724
SMON started with pid=8, OS id=6052
RECO started with pid=9, OS id=4988
CJQ0 started with pid=10, OS id=3884
MMON started with pid=11, OS id=5288
MMNL started with pid=12, OS id=4360
Sat Nov 05 11:42:28 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Nov 05 11:42:28 2011
ALTER DATABASE MOUNT
Sat Nov 05 11:42:33 2011
Setting recovery target incarnation to 2
Sat Nov 05 11:42:33 2011
Successful mount of redo thread 1, with mount id 1294209829
Sat Nov 05 11:42:33 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Nov 05 11:42:34 2011
ALTER DATABASE OPEN
Sat Nov 05 11:42:34 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Sat Nov 05 11:42:34 2011
Started redo scan
Sat Nov 05 11:42:34 2011
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Sat Nov 05 11:42:34 2011
Started redo application at
Thread 1: logseq 113, block 2, scn 3553200
Sat Nov 05 11:42:34 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 113 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Nov 05 11:42:34 2011
Completed redo application
Sat Nov 05 11:42:34 2011
Completed crash recovery at
Thread 1: logseq 113, block 3, scn 3573202
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sat Nov 05 11:42:35 2011
Thread 1 advanced to log sequence 114
Thread 1 opened at log sequence 114
Current log# 2 seq# 114 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sat Nov 05 11:42:35 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Nov 05 11:42:35 2011
SMON: enabling cache recovery
Sat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1764.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00904: "D_OBJ#": 标识符无效Sat Nov 05 11:42:36 2011
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_5760.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_4988.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_5152.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_5068.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_3892.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_3504.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_724.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_6052.trc:
ORA-00704: bootstrap process failureInstance terminated by USER, pid = 1764
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sat Nov 05 12:11:11 2011
WARNING: inbound connection timed out (ORA-3136)
它又出现了上面:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00904: "D_OBJ#": 标识符无效
这些错误;网上查了半天试试了 还是不行了,所以请教各位兄弟姐妹们,在下先谢了啊O(∩_∩)O
不过我也试了下: 1. cmd 命令下: set ORACLE_SID=orcl;之后在重新启动服务 还是不行;
2. (1). 在运行中输入cmd,输入sqlplus /nolog,回车, 这时出现了SQL>;
(2).输入connect / as sysdba;回车;提示:
ORACLE 例程已经启动。
Total System Global Area 390070272 bytes
Fixed Size 1249152 bytes
Variable Size 150995072 bytes
Database Buffers 230686720 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
ORA-01092: ORACLE 实例终止。强制断开连接 /**它又出现这种错误**、
赶紧检查alert_orcl.log日志:D:\oracle\product\10.2.0\admin\Oracle_SID\bdump\alert_orcl.log :
Sat Nov 05 11:42:27 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 142606336
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 390070272
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 230686720
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 128974848
PMON started with pid=2, OS id=5760
PSP0 started with pid=3, OS id=5152
MMAN started with pid=4, OS id=5068
DBW0 started with pid=5, OS id=3504
LGWR started with pid=6, OS id=3892
CKPT started with pid=7, OS id=724
SMON started with pid=8, OS id=6052
RECO started with pid=9, OS id=4988
CJQ0 started with pid=10, OS id=3884
MMON started with pid=11, OS id=5288
MMNL started with pid=12, OS id=4360
Sat Nov 05 11:42:28 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Nov 05 11:42:28 2011
ALTER DATABASE MOUNT
Sat Nov 05 11:42:33 2011
Setting recovery target incarnation to 2
Sat Nov 05 11:42:33 2011
Successful mount of redo thread 1, with mount id 1294209829
Sat Nov 05 11:42:33 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Nov 05 11:42:34 2011
ALTER DATABASE OPEN
Sat Nov 05 11:42:34 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Sat Nov 05 11:42:34 2011
Started redo scan
Sat Nov 05 11:42:34 2011
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Sat Nov 05 11:42:34 2011
Started redo application at
Thread 1: logseq 113, block 2, scn 3553200
Sat Nov 05 11:42:34 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 113 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Nov 05 11:42:34 2011
Completed redo application
Sat Nov 05 11:42:34 2011
Completed crash recovery at
Thread 1: logseq 113, block 3, scn 3573202
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sat Nov 05 11:42:35 2011
Thread 1 advanced to log sequence 114
Thread 1 opened at log sequence 114
Current log# 2 seq# 114 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sat Nov 05 11:42:35 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Nov 05 11:42:35 2011
SMON: enabling cache recovery
Sat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1764.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00904: "D_OBJ#": 标识符无效Sat Nov 05 11:42:36 2011
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_5760.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_4988.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_5152.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_5068.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_3892.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_3504.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_724.trc:
ORA-00704: bootstrap process failureSat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_6052.trc:
ORA-00704: bootstrap process failureInstance terminated by USER, pid = 1764
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sat Nov 05 12:11:11 2011
WARNING: inbound connection timed out (ORA-3136)
它又出现了上面:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00904: "D_OBJ#": 标识符无效
这些错误;网上查了半天试试了 还是不行了,所以请教各位兄弟姐妹们,在下先谢了啊O(∩_∩)O
Thread 1 advanced to log sequence 114
Thread 1 opened at log sequence 114
Current log# 2 seq# 114 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sat Nov 05 11:42:35 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Nov 05 11:42:35 2011
SMON: enabling cache recovery
Sat Nov 05 11:42:36 2011
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1764.trc:
=============================================================================
似乎是 REDO02.LOG 有问题了。