Startup alter. log spfile. ora, startupspfile
SQL> select * from v $ version where rownum = 1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
SQL>! Cat/etc/issue
Enterprise Linux Server release 5.5 (Carthage)
Kernel \ r on an \ m
The Study of spfile. log and alert. log is not divided:
[Oracle @ localhost dbs] $ strings spfileorcl3939.ora
Orcl3939. _ db_cache_size = 79691776
Orcl3939. _ java_pool_size = 4194304
Orcl3939. _ large_pool_size = 4194304
Orcl3939. _ oracle_base = '/u01/app/oracle' # ORACLE_BASE set from environment
Orcl3939. _ pga_aggregate_target = 146800640
Orcl3939. _ sga_target = 276824064
Orcl3939. _ shared_io_pool_size = 0
Orcl3939. _ shared_pool_size = 176160768
Orcl3939. _ streams_pool_size = 4194304
*. Audit_file_dest = '/u01/app/oracle/admin/orcl3939/adump'
*. Audit_trail = 'db'
*. Compatible = '11. 2.0.0.0'
*. Control_files = '/u01/app/o
Racle/oradata/orcl3939/control01.ctl ','/u01/app/oracle/flash_recovery_area/orcl3939/control02.ctl ','/u01/app/oracle/oradata/orcl3939/control03.ctl'
*. Db_block_size = 8192
*. Db_domain = 'localdomain'
*. Db_name = 'orcl3939'
*. Db_recovery_file_dest = '/u01/app/oracle/flash_recovery_area'
*. Db_recovery_file_dest_size = 4039114752
*. Diagnostic_dest = '/u01/app/oracle'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = orcl3939XDB )'
*. Instance_name = 'orcl3939'
*. Local_listener = '(ADDRESS = (PROTOCOL = TCP) (HOST = 1
72.18.115.78) (PORT = 1590 ))'
*. Memory_target = 423624704
*. Open_cursors = 300
*. Processses = 150
*. Recyclebin = 'on'
*. Remote_login_passwordfile = 'clusive'
*. Service_names = 'a, B, c, d, diy, OS'
*. Trace_enabled = TRUE
*. Undo_tablespace = 'undotbs1'
From alter. log:
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl3939.ora
System parameters with non-default values:
Processes = 150
Memory_target = 404 M
Control_files = "/u01/app/oracle/oradata/orcl3939/control01.ctl"
Control_files = "/u01/app/oracle/flash_recovery_area/orcl3939/control02.ctl"
Control_files = "/u01/app/oracle/oradata/orcl3939/control03.ctl"
DB _ block_size = 8192
Compatible = "11.2.0.0.0"
Db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"
Db_recovery_file_dest_size = 3852 M
Undo_tablespace = "UNDOTBS1"
Recyclebin = "ON"
Remote_login_passwordfile = "EXCLUSIVE"
Db_domain = "localdomain"
Instance_name = "ORCL3939"
Service_names = "a, B, c, d, diy, OS"
Dispatchers = "(PROTOCOL = TCP) (SERVICE = orcl3939XDB )"
Local_listener = "(ADDRESS = (PROTOCOL = TCP) (HOST = 172.18.115.78) (PORT = 1590 ))"
Audit_file_dest = "/u01/app/oracle/admin/orcl3939/adump"
Audit_trail = "DB"
Db_name = "orcl3939"
Open_cursors = 300
Diagnostic_dest = "/u01/app/oracle"
Trace_enabled = TRUE
Fri Jun 12 00:52:58 2015
PMON started with pid = 2, OS id = 24375
Fri Jun 12 00:52:58 2015
VKTM started with pid = 3, OS id = 24377 at elevated priority
VKTM running at (10) millisec precision with DBRM quantum (100) MS
Fri Jun 12 00:52:58 2015
GEN0 started with pid = 4, OS id = 24381
Fri Jun 12 00:52:59 2015
DIAG started with pid = 5, OS id = 24383
Fri Jun 12 00:52:59 2015
DBRM started with pid = 6, OS id = 24385
Fri Jun 12 00:52:59 2015
PSP0 started with pid = 7, OS id = 24387
Fri Jun 12 00:52:59 2015
DIA0 started with pid = 8, OS id = 24389
Fri Jun 12 00:52:59 2015
MMAN started with pid = 9, OS id = 24391
Fri Jun 12 00:52:59 2015
DBW0 started with pid = 10, OS id = 24393
Fri Jun 12 00:52:59 2015
LGWR started with pid = 11, OS id = 24395
Fri Jun 12 00:52:59 2015
CKPT started with pid = 12, OS id = 24397
Fri Jun 12 00:52:59 2015
SMON started with pid = 13, OS id = 24399
Fri Jun 12 00:52:59 2015
RECO started with pid = 14, OS id = 24401
Fri Jun 12 00:52:59 2015
MMON started with pid = 15, OS id = 24403
Fri Jun 12 00:52:59 2015
Starting up 1 dispatcher (s) for network address '(ADDRESS = (PARTIAL = YES) (PROTOCOL = TCP ))'...
Fri Jun 12 00:52:59 2015
MMNL started with pid = 16, OS id = 24405
Starting up 1 shared server (s )...
ORACLE_BASE from environment =/u01/app/oracle
Fri Jun 12 00:52:59 2015
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 3870724267
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Fri Jun 12 00:53:05 2015
ALTER DATABASE OPEN
Thread 1 opened at log sequence 557
Current log #2 seq #557 mem #0:/u01/app/oracle/oradata/orcl3939/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
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
Fri Jun 12 00:53:10 2015
QMNC started with pid = 20, OS id = 24454
Completed: ALTER DATABASE OPEN
Fri Jun 12 00:53:14 2015
Starting background process CJQ0
Fri Jun 12 00:53:14 2015
CJQ0 started with pid = 22, OS id = 24475
Fri Jun 12 00:53:15 2015
Db_recovery_file_dest_size of 3852 MB is 18.77% used. This is
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
Space available in the underlying filesystem or ASM diskgroup.
Setting Resource Manager plan SCHEDULER [0x3006]: DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Jun 12 00:53:17 2015
Starting background process VKRM
Fri Jun 12 00:53:17 2015
VKRM started with pid = 21, OS id = 24482