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 Enterprise Linux Server release 5.5 (Carthage)
Kernel \ r on an \m
The study of Spfile.log and Alert.log is not excessive:
[Email protected] 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
*.processes=150
*.recyclebin= ' on '
*.remote_login_passwordfile= ' EXCLUSIVE '
*.service_names= ' A,b,c,d,diy,os '
*.trace_enabled=true
*.undo_tablespace= ' UNDOTBS1 '
Excerpt 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 = 404M
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= 3852M
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 June 12 00:52:58 2015
Pmon started with pid=2, OS id=24375
Fri June 12 00:52:58 2015
Vktm started with pid=3, OS id=24377 on elevated priority
Vktm running at (ten) Millisec precision with DBRM quantum (+) MS
Fri June 12 00:52:58 2015
GEN0 started with pid=4, OS id=24381
Fri June 12 00:52:59 2015
DIAG started with pid=5, OS id=24383
Fri June 12 00:52:59 2015
DBRM started with pid=6, OS id=24385
Fri June 12 00:52:59 2015
PSP0 started with pid=7, OS id=24387
Fri June 12 00:52:59 2015
DIA0 started with pid=8, OS id=24389
Fri June 12 00:52:59 2015
Mman started with pid=9, OS id=24391
Fri June 12 00:52:59 2015
DBW0 started with pid=10, OS id=24393
Fri June 12 00:52:59 2015
LGWR started with pid=11, OS id=24395
Fri June 12 00:52:59 2015
CKPT started with pid=12, OS id=24397
Fri June 12 00:52:59 2015
Smon started with pid=13, OS id=24399
Fri June 12 00:52:59 2015
RECO started with pid=14, OS id=24401
Fri June 12 00:52:59 2015
Mmon started with pid=15, OS id=24403
Fri June 12 00:52:59 2015
Starting up 1 Dispatcher (s) for network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...
Fri June 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 June 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 June 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 are 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 June 12 00:53:10 2015
QMNC started with pid=20, OS id=24454
Completed:alter DATABASE OPEN
Fri June 12 00:53:14 2015
Starting background Process CJQ0
Fri June 12 00:53:14 2015
CJQ0 started with pid=22, OS id=24475
Fri June 12 00:53:15 2015
Db_recovery_file_dest_size of 3852 MB is 18.77% 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.
Setting Resource Manager Plan scheduler[0x3006]:D Efault_maintenance_plan via SCHEDULER window
Setting Resource Manager plan Default_maintenance_plan via parameter
Fri June 12 00:53:17 2015
Starting background Process VKRM
Fri June 12 00:53:17 2015
VKRM started with pid=21, OS id=24482
Startup Alter.log Spfile.ora