今天重启oracle数据库的命令和alter日志：
oracle@NMSSERVER1:~> sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 27 18:49:13 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 5.1310E+10 bytes
Fixed Size 2240344 bytes
Variable Size 3.1407E+10 bytes
Database Buffers 1.9864E+10 bytes
Redo Buffers 36098048 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
日志：
Wed Jan 27 18:52:07 2016
opidcl aborting process unknown ospid (31681) as a result of ORA-2396
Wed Jan 27 18:52:07 2016
opidcl aborting process unknown ospid (40274) as a result of ORA-2396
Wed Jan 27 18:52:07 2016
opidcl aborting process unknown ospid (40174) as a result of ORA-2396
Wed Jan 27 18:52:07 2016
opidcl aborting process unknown ospid (53767) as a result of ORA-2396
Wed Jan 27 18:52:08 2016
opidcl aborting process unknown ospid (31415) as a result of ORA-2396
Wed Jan 27 18:52:06 2016
opidcl aborting process unknown ospid (55276) as a result of ORA-2396
Wed Jan 27 18:52:08 2016
opidcl aborting process unknown ospid (27878) as a result of ORA-2396
Wed Jan 27 18:52:08 2016
opidcl aborting process unknown ospid (24925) as a result of ORA-2396
Wed Jan 27 18:52:08 2016
opidcl aborting process unknown ospid (42658) as a result of ORA-2396
Wed Jan 27 18:52:08 2016
opidcl aborting process unknown ospid (61016) as a result of ORA-2396
Shutting down instance: further logons disabled
Wed Jan 27 18:52:12 2016
kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089
Stopping background process CJQ0
Wed Jan 27 18:52:21 2016
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1509
Stopping Job queue slave processes, flags = 7
Job queue slave processes stopped
Wed Jan 27 18:55:00 2016
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 27-JAN-2016 18:55:00
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.25.110.39)(PORT=59810))
Wed Jan 27 18:57:24 2016
Active call for process 16334 user 'oracle' program 'oracle@NMSSERVER1'
SHUTDOWN: waiting for active calls to complete.
Wed Jan 27 18:58:00 2016
ALTER DATABASE CLOSE NORMAL
Wed Jan 27 18:58:37 2016
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jan 27 18:58:44 2016
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 72469
Successful close of redo thread 1
Wed Jan 27 19:00:28 2016
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Jan 27 19:00:30 2016
Stopping background process VKTM
Wed Jan 27 19:00:51 2016
Instance shutdown complete
Wed Jan 27 19:01:08 2016
Starting ORACLE instance (normal)
Wed Jan 27 19:01:22 2016
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =499
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /opt/oracle/app/oracle/product/11gR2/db
System name: Linux
Node name: NMSSERVER1
Release: 3.0.76-0.11-default
Version: #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990)
Machine: x86_64
Using parameter settings in server-side spfile /opt/oracle/app/oracle/product/11gR2/db/dbs/spfilepm4h.ora
System parameters with non-default values:
processes = 3000
sessions = 4544
resource_limit = TRUE
sga_max_size = 48G
shared_pool_size = 2G
sga_target = 0
memory_target = 48G
memory_max_target = 48G
control_files = "/oradata/db/pm/pm4h/control01.ctl"
control_files = "/opt/oracle/app/oracle/fast_recovery_area/pm4h/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_files = 3000
db_recovery_file_dest = "/opt/oracle/app/oracle/fast_recovery_area"
db_recovery_file_dest_size= 4G
undo_tablespace = "UNDOTBS1"
recyclebin = "OFF"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/opt/oracle/app/oracle/admin/pm4h/adump"
audit_trail = "NONE"
db_name = "pm4h"
open_cursors = 300
pga_aggregate_target = 12G
diagnostic_dest = "/opt/oracle/app/oracle"
Wed Jan 27 19:01:24 2016
PMON started with pid=2, OS id=55659
Wed Jan 27 19:01:24 2016
PSP0 started with pid=3, OS id=55661
Wed Jan 27 19:01:26 2016
VKTM started with pid=4, OS id=55670 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Jan 27 19:01:26 2016
GEN0 started with pid=5, OS id=55674
Wed Jan 27 19:01:26 2016
DIAG started with pid=6, OS id=55676
Wed Jan 27 19:01:26 2016
DBRM started with pid=7, OS id=55678
Wed Jan 27 19:01:26 2016
DIA0 started with pid=8, OS id=55680
Wed Jan 27 19:01:26 2016
MMAN started with pid=9, OS id=55682
Wed Jan 27 19:01:26 2016
DBW0 started with pid=10, OS id=55684
Wed Jan 27 19:01:26 2016
DBW1 started with pid=11, OS id=55686
Wed Jan 27 19:01:26 2016
DBW2 started with pid=12, OS id=55688
Wed Jan 27 19:01:26 2016
DBW3 started with pid=13, OS id=55690
Wed Jan 27 19:01:26 2016
DBW4 started with pid=14, OS id=55692
Wed Jan 27 19:01:26 2016
DBW5 started with pid=15, OS id=55695
Wed Jan 27 19:01:26 2016
DBW6 started with pid=16, OS id=55697
Wed Jan 27 19:01:26 2016
DBW7 started with pid=17, OS id=55699
Wed Jan 27 19:01:26 2016
LGWR started with pid=18, OS id=55701
Wed Jan 27 19:01:26 2016
CKPT started with pid=19, OS id=55703
Wed Jan 27 19:01:26 2016
SMON started with pid=20, OS id=55705
Wed Jan 27 19:01:26 2016
RECO started with pid=21, OS id=55707
Wed Jan 27 19:01:26 2016
MMON started with pid=22, OS id=55709
Wed Jan 27 19:01:26 2016
MMNL started with pid=23, OS id=55711
ORACLE_BASE from environment = /opt/oracle/app/oracle
Wed Jan 27 19:01:26 2016
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 3936072072
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Jan 27 19:01:32 2016
ALTER DATABASE OPEN
Thread 1 opened at log sequence 72469
Current log# 8 seq# 72469 mem# 0: /oradata/db/pm/pm4h/redo08.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[55762] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2889332676 end:2889332876 diff:200 (2 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Jan 27 19:01:37 2016
QMNC started with pid=25, OS id=55807
Completed: ALTER DATABASE OPEN
Wed Jan 27 19:01:39 2016
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Jan 27 19:01:39 2016
Starting background process CJQ0
Wed Jan 27 19:01:39 2016
CJQ0 started with pid=26, OS id=55838