Restarts an operation command and alter LOG for the Oracle database.

Restart the Oracle database command and ALTER LOG today:

[Email protected]:~> sqlplus '/as sysdba '

Sql*plus:release 11.2.0.3.0 Production on Wed Jan 27 18:49:13 2016

Copyright (c) 1982, 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

Log:

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 to process 16334 user ' Oracle ' program ' [email protected] '

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 June 08:21:43 UTC (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 on elevated priority

Vktm running at (1) millisec precision with DBRM quantum (+) 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 are 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 would 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

Restarts an operation command and alter LOG for the Oracle database.