SQL> conn system/system@gsi ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 警告: 您不再连接到 ORACLE。
startup没起来,看一下日志里面的具体错误,sga都没有分配
Starting up ORACLE RDBMS Version: 9.2.0.1.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 50331648 large_pool_size = 8388608 java_pool_size = 33554432 control_files = D:\oracle\oradata\gsi\control01.ctl, D:\oracle\oradata\gsi\control02.ctl, D:\oracle\oradata\gsi\control03.ctl db_block_size = 8192 db_cache_size = 25165824 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = gsi dispatchers = (protocol=TCP) job_queue_processes = 10 hash_join_enabled = TRUE background_dump_dest = D:\oracle\admin\gsi\bdump user_dump_dest = D:\oracle\admin\gsi\udump core_dump_dest = D:\oracle\admin\gsi\cdump sort_area_size = 524288 db_name = gsi open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 aq_tm_processes = 1 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 QMN0 started with pid=9 Tue Mar 24 15:28:52 2009 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Mar 24 15:28:53 2009 ALTER DATABASE MOUNT Tue Mar 24 15:28:57 2009 Successful mount of redo thread 1, with mount id 47987829. Tue Mar 24 15:28:57 2009 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Tue Mar 24 15:29:10 2009 Shutting down instance: further logons disabled Shutting down instance (normal) License high water = 3 Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Tue Mar 24 15:29:13 2009 ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Tue Mar 24 15:29:13 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active
conn / as sysdba shutdown immediate startup nomount alter database mount alter database open
shutdown immediate
还没结束啊 。
或者你startup没起来。
建议重新做一次
shutdown immediate
startup
undotbs01.dbf online
cwmlite01.dbf online
drsys01.dbf online
example01.dbf online
indx01.dbf online
odm01.dbf online
tools01.dbf online
users01.dbf online
xdb01.dbf online
data.ora online
那你startup看下什么提示,贴上来
ORACLE 例程已经启动。Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
警告: 您不再连接到 ORACLE。
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\gsi\control01.ctl, D:\oracle\oradata\gsi\control02.ctl, D:\oracle\oradata\gsi\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = gsi
dispatchers = (protocol=TCP)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\gsi\bdump
user_dump_dest = D:\oracle\admin\gsi\udump
core_dump_dest = D:\oracle\admin\gsi\cdump
sort_area_size = 524288
db_name = gsi
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Mar 24 15:28:52 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Mar 24 15:28:53 2009
ALTER DATABASE MOUNT
Tue Mar 24 15:28:57 2009
Successful mount of redo thread 1, with mount id 47987829.
Tue Mar 24 15:28:57 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Mar 24 15:29:10 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Mar 24 15:29:13 2009
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Mar 24 15:29:13 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
shutdown immediate
startup nomount
alter database mount
alter database open
startup;
很好很强大~~~解决问题·~~~