最近两接点的ops经常连接不上，帮忙分析一下：
OS: TRU64 5.1, 1G内存
ORACLE 8.1.7.0.0
init.ora如下：
db_name = "ddb"
service_names = ddb
control_files = ("/dev/rdisk/dsk8b", "/dev/rdisk/dsk9b"
open_cursors = 300
max_enabled_roles = 30
db_block_buffers = 34818
shared_pool_size = 95076352
large_pool_size = 614400
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 150
log_buffer = 163840
# audit_trail = false# if you want auditing
# timed_statistics = false# if you want timed statistics
# max_dump_file_size = 10000# limit trace file size to 5M each
# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/usr/oracle/home/admin/dmsdb/arch"
# log_archive_format = arch_%t_%s.arc
max_rollback_segments = 64
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false
# oracle_trace_enable = true
# define directories to store trace and alert files
background_dump_dest = /usr/oracle/home/admin/dmsdb/bdump
core_dump_dest = /usr/oracle/home/admin/dmsdb/cdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = /usr/oracle/home/admin/dmsdb/udump
db_block_size = 8192
#remote_login_passwordfile = exclusive
os_authent_prefix = ""
# The following parameters are needed for the Advanced Replication Option
job_queue_processes = 4
job_queue_interval = 60
distributed_transactions = 10
open_links = 4
compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536
alter日志没发现明显的错误
Tue Jan 14 11:59:05 2003
Shutting down instance (abort)
License high water mark = 27
Instance terminated by USER, pid = 1418652
Tue Jan 14 11:59:10 2003
Starting ORACLE instance (normal)
Tue Jan 14 11:59:10 2003
DLM Resources = 56966
DLM Locks = 58707
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 95076352
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /dev/rdisk/dsk8b, /dev/rdisk/dsk9b
db_block_buffers = 34818
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
parallel_server
= TRUE
thread
= 2
max_rollback_segments= 64
rollback_segments= RBS2_0, RBS2_1, RBS2_2, RBS2_3, RBS2_4, RBS2_5, RBS2_6, RBS2_7, RBS2_8, RBS2_9, TRANS_RBS02
max_enabled_roles= 30
distributed_transactions = 10
instance_name
= dmsdb2
service_names
= dmsdb
open_links
= 4
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= dmsdb
open_cursors
= 300
ifile
= /usr/oracle/home/admin/dmsdb/pfile/initdmsdb.ora
os_authent_prefix=
job_queue_processes= 4
job_queue_interval = 60
background_dump_dest = /usr/oracle/home/admin/dmsdb/bdump
user_dump_dest = /usr/oracle/home/admin/dmsdb/udump
core_dump_dest = /usr/oracle/home/admin/dmsdb/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
SNP0 started with pid=10
SNP1 started with pid=11
SNP2 started with pid=12
SNP3 started with pid=13
Tue Jan 14 11:59:14 2003
alter databasemount
Tue Jan 14 11:59:16 2003
lmon registered with NM - instance id 1 (internal mem no 0)
Tue Jan 14 11:59:18 2003
Reconfiguration started
List of nodes: 0,1,
Lock DB frozen
Non-local Process blocks cleaned out
Non-local Group blocks cleaned out
Resources and locks cleaned out
Resources remastered 0
Traffic controller Initialized
Communication channels reestablished
Submitted all rdomain info
Submitted all remote-lock requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable locks granted
Tue Jan 14 11:59:25 2003
Reconfiguration complete
LCK0 started with pid=15
BSP0 started with pid=16
Tue Jan 14 11:59:30 2003
Successful mount of redo thread 2, with mount id 3507405458.
Tue Jan 14 11:59:30 2003
Database mounted in Shared Mode (PARALLEL_SERVER=TRUE).
Completed: alter databasemount
Tue Jan 14 11:59:30 2003
alter database open
SSN Service opened - SCN: 0x0000.01586241
Picked Lamport scheme to generate SCNs
Tue Jan 14 11:59:31 2003
Thread 2 advanced to log sequence 101
Thread 2 opened at log sequence 101
Current log# 3 seq# 101 mem# 0: /dev/rdisk/dsk8h
Successful open of redo thread 2.
Tue Jan 14 11:59:31 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jan 14 11:59:39 2003
Completed: alter database open
Thu Jan 16 08:25:08 2003
Shutting down instance (abort)
License high water mark = 32
Thu Jan 16 08:29:11 2003
Instance terminated by USER, pid = 1453688
Thu Jan 16 08:29:59 2003
Starting ORACLE instance (normal)
Thu Jan 16 08:29:59 2003
DLM Resources = 56966
DLM Locks = 58707
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 95076352
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /dev/rdisk/dsk8b, /dev/rdisk/dsk9b
db_block_buffers = 34818
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
parallel_server
= TRUE
thread
= 2
max_rollback_segments= 64
rollback_segments= RBS2_0, RBS2_1, RBS2_2, RBS2_3, RBS2_4, RBS2_5, RBS2_6, RBS2_7, RBS2_8, RBS2_9, TRANS_RBS02
max_enabled_roles= 30
distributed_transactions = 10
instance_name
= dmsdb2
service_names
= dmsdb
open_links
= 4
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= dmsdb
open_cursors
= 300
ifile
= /usr/oracle/home/admin/dmsdb/pfile/initdmsdb.ora
os_authent_prefix=
job_queue_processes= 4
job_queue_interval = 60
background_dump_dest = /usr/oracle/home/admin/dmsdb/bdump
user_dump_dest = /usr/oracle/home/admin/dmsdb/udump
core_dump_dest = /usr/oracle/home/admin/dmsdb/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
SNP0 started with pid=10
SNP1 started with pid=11
SNP2 started with pid=12
SNP3 started with pid=13
Thu Jan 16 08:30:04 2003
alter databasemount
Thu Jan 16 08:30:06 2003
lmon registered with NM - instance id 1 (internal mem no 0)
Thu Jan 16 08:30:08 2003
Reconfiguration started
List of nodes: 0,1,
Lock DB frozen
Non-local Process blocks cleaned out
Non-local Group blocks cleaned out
Resources and locks cleaned out
Resources remastered 0
Traffic controller Initialized
Communication channels reestablished
Submitted all rdomain info
Submitted all remote-lock requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable locks granted
Thu Jan 16 08:30:15 2003
Reconfiguration complete
LCK0 started with pid=16
BSP0 started with pid=17
Thu Jan 16 08:30:20 2003
Successful mount of redo thread 2, with mount id 3507580769.
Thu Jan 16 08:30:20 2003
Database mounted in Shared Mode (PARALLEL_SERVER=TRUE).
Completed: alter databasemount
Thu Jan 16 08:30:20 2003
alter database open
SSN Service opened - SCN: 0x0000.01597143
Picked Lamport scheme to generate SCNs
Thu Jan 16 08:30:20 2003
Thread 2 advanced to log sequence 102
Thread 2 opened at log sequence 102
Current log# 4 seq# 102 mem# 0: /dev/rdisk/dsk9f
Successful open of redo thread 2.
Thu Jan 16 08:30:21 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jan 16 08:30:29 2003
Completed: alter database open
Fri Jan 17 10:39:01 2003
Shutting down instance (abort)
License high water mark = 56
Instance terminated by USER, pid = 1474995
Fri Jan 17 10:39:05 2003
Starting ORACLE instance (normal)
Fri Jan 17 10:39:05 2003
DLM Resources = 56966
DLM Locks = 58707
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 95076352
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /dev/rdisk/dsk8b, /dev/rdisk/dsk9b
db_block_buffers = 34818
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
parallel_server
= TRUE
thread
= 2
max_rollback_segments= 64
rollback_segments= RBS2_0, RBS2_1, RBS2_2, RBS2_3, RBS2_4, RBS2_5, RBS2_6, RBS2_7, RBS2_8, RBS2_9, TRANS_RBS02
max_enabled_roles= 30
distributed_transactions = 10
instance_name
= dmsdb2
service_names
= dmsdb
open_links
= 4
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= dmsdb
open_cursors
= 300
ifile
= /usr/oracle/home/admin/dmsdb/pfile/initdmsdb.ora
os_authent_prefix=
job_queue_processes= 4
job_queue_interval = 60
background_dump_dest = /usr/oracle/home/admin/dmsdb/bdump
user_dump_dest = /usr/oracle/home/admin/dmsdb/udump
core_dump_dest = /usr/oracle/home/admin/dmsdb/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
SNP0 started with pid=10
SNP1 started with pid=11
SNP2 started with pid=12
SNP3 started with pid=13
Fri Jan 17 10:39:10 2003
alter databasemount
Fri Jan 17 10:39:12 2003
lmon registered with NM - instance id 1 (internal mem no 0)
Fri Jan 17 10:39:14 2003
Reconfiguration started
List of nodes: 0,1,
Lock DB frozen
Non-local Process blocks cleaned out
Non-local Group blocks cleaned out
Resources and locks cleaned out
Resources remastered 0
Traffic controller Initialized
Communication channels reestablished
Submitted all rdomain info
Submitted all remote-lock requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable locks granted
Fri Jan 17 10:39:18 2003
Reconfiguration complete
Fri Jan 17 10:39:18 2003
This instance was first to mount
LCK0 started with pid=15
BSP0 started with pid=16
Fri Jan 17 10:39:22 2003
Successful mount of redo thread 2, with mount id 3507675482.
Fri Jan 17 10:39:22 2003
Database mounted in Shared Mode (PARALLEL_SERVER=TRUE).
Completed: alter databasemount
Fri Jan 17 10:39:22 2003
alter database open
This instance was first to open
Beginning crash recovery of 2 threads
Fri Jan 17 10:39:23 2003
Thread recovery: start rolling forward thread 2
Recovery of Online Redo Log: Thread 2 Group 4 Seq 102 Reading mem 0
Mem# 0 errs 0: /dev/rdisk/dsk9f
Fri Jan 17 10:39:24 2003
Thread recovery: finish rolling forward thread 2
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Fri Jan 17 10:39:24 2003
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 173 Reading mem 0
Mem# 0 errs 0: /dev/rdisk/dsk8g
Fri Jan 17 10:39:24 2003
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
SSN Service opened - initial SCN: 0x0000.0159f8f6
Picked Lamport scheme to generate SCNs
Fri Jan 17 10:39:25 2003
Thread 2 advanced to log sequence 103
Thread 2 opened at log sequence 103
Current log# 3 seq# 103 mem# 0: /dev/rdisk/dsk8h
Successful open of redo thread 2.
Fri Jan 17 10:39:25 2003
SMON: enabling cache recovery
Fri Jan 17 10:39:25 2003
Halting cache operation for instance recovery roll forward.
DBWs continuing - recovery is being done by this instance.
Fri Jan 17 10:39:25 2003
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Fri Jan 17 10:39:27 2003
Reconfiguration started
List of nodes: 0,
Lock DB frozen
Non-local Process blocks cleaned out
Non-local Group blocks cleaned out
Resources and locks cleaned out
Resources remastered 260
Communication channels reestablished
Submitted all rdomain info
Submitted all remote-lock requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable locks granted
Fri Jan 17 10:39:29 2003
Reconfiguration complete
Fri Jan 17 10:39:29 2003
Halting cache operation for instance recovery roll forward.
DBWs continuing - recovery is being done by this instance.
Fri Jan 17 10:39:29 2003
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
SMON: enabling tx recovery
Fri Jan 17 10:39:33 2003
Completed: alter database open
Fri Jan 17 10:39:44 2003
Reconfiguration started
List of nodes: 0,1,
Lock DB frozen
Non-local Process blocks cleaned out
Non-local Group blocks cleaned out
Resources and locks cleaned out
Resources remastered 2431
Traffic controller Initialized
Communication channels reestablished
Submitted all rdomain info
Submitted all remote-lock requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable locks granted
Fri Jan 17 10:39:47 2003
Reconfiguration complete
Fri Jan 17 10:39:49 2003
Halting cache operation for instance recovery roll forward.
DBWs continuing - recovery is being done by this instance.
Fri Jan 17 10:39:49 2003
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
|
