Startup Alter.log Spfile.ora

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.