概述: 生产库需要把原有的RAC集群 11.2.0.3 升级 到11.2.0.4 ,以下便做了一个测试:
RAC ORACLE_UNQNAME =DOMINIC
ORACLE_SID=DOMINIC1 / DOMINIC2
OS redhat 6.4 x86 64bit
说明: 部分截图没有上传,需要的联系我: email : lmlimin_2006@163.com
以下是测试第一手手稿,基本都贴了出来,当然在DB 升级的时候,有几种方式。
升级步骤: 备份,前期检查
GRID 升级
grid 升级后检测
DATABASE soft 升级
database db 升级
升级后检测
一: 11.2.0.3 parameter
su - oracle
$ sqlplus / as sysdba
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY boolean FALSE
active_instance_count integer
aq_tm_processes integer 1
archive_lag_target integer 0
asm_diskgroups string
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
audit_file_dest string /dba/app/oracle/admin/dominic/
adump
audit_sys_operations boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
audit_trail string DB
awr_snapshot_time_offset integer 0
background_core_dump string partial
background_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/trace
backup_tape_io_slaves boolean FALSE
bitmap_merge_area_size integer 1048576
blank_trimming boolean FALSE
buffer_pool_keep string
buffer_pool_recycle string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offload_compaction string ADAPTIVE
cell_offload_decryption boolean TRUE
cell_offload_parameters string
cell_offload_plan_display string AUTO
cell_offload_processing boolean TRUE
circuits integer
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
clonedb boolean FALSE
cluster_database boolean TRUE
cluster_database_instances integer 2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_interconnects string
commit_logging string
commit_point_strength integer 1
commit_wait string
commit_write string
compatible string 11.2.0.0.0
control_file_record_keep_time integer 7
control_files string +DATA/dominic/controlfile/curr
ent.260.873641213, +LOGFILE/do
minic/controlfile/current.256.
873641213
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access string DIAGNOSTIC+TUNING
core_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/cdump
cpu_count integer 1
create_bitmap_area_size integer 8388608
create_stored_outlines string
cursor_bind_capture_destination string memory+disk
cursor_sharing string EXACT
cursor_space_for_time boolean FALSE
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
db_create_file_dest string +DATA
db_create_online_log_dest_1 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string
db_file_multiblock_read_count integer 70
db_file_name_convert string
db_files integer 200
db_flash_cache_file string
db_flash_cache_size big integer 0
db_flashback_retention_target integer 1440
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size big integer 0
db_lost_write_protect string NONE
db_name string dominic
db_recovery_file_dest string +LOGFILE
db_recovery_file_dest_size big integer 4347M
db_recycle_cache_size big integer 0
db_securefile string PERMITTED
db_ultra_safe string OFF
db_unique_name string dominic
db_unrecoverable_scn_tracking boolean TRUE
db_writer_processes integer 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dbwr_io_slaves integer 0
ddl_lock_timeout integer 0
deferred_segment_creation boolean TRUE
dg_broker_config_file1 string /dba/app/oracle/product/11.2/d
bhome_1/dbs/dr1dominic.dat
dg_broker_config_file2 string /dba/app/oracle/product/11.2/d
bhome_1/dbs/dr2dominic.dat
dg_broker_start boolean FALSE
diagnostic_dest string /dba/app/oracle
disk_asynch_io boolean TRUE
dispatchers string (PROTOCOL=TCP) (SERVICE=domini
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cXDB)
distributed_lock_timeout integer 60
dml_locks integer 2076
dst_upgrade_insert_conv boolean TRUE
enable_ddl_logging boolean FALSE
event string
fal_client string
fal_server string
fast_start_io_target integer 0
fast_start_mttr_target integer 0
fast_start_parallel_rollback string LOW
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
file_mapping boolean FALSE
fileio_network_adapters string
filesystemio_options string none
fixed_date string
gcs_server_processes integer 1
global_context_pool_size string
global_names boolean FALSE
global_txn_processes integer 1
hash_area_size integer 131072
hi_shared_memory_address integer 0
hs_autoregister boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ifile file
instance_groups string
instance_name string dominic1
instance_number integer 1
instance_type string RDBMS
java_jit_enabled boolean TRUE
java_max_sessionspace_size integer 0
java_pool_size big integer 0
java_soft_sessionspace_limit integer 0
job_queue_processes integer 1000
large_pool_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ldap_directory_access string NONE
ldap_directory_sysauth string no
license_max_sessions integer 0
license_max_users integer 0
license_sessions_warning integer 0
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.5.113)(PORT=1521))))
lock_name_space string
lock_sga boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string location=+logfile/dominic/arch
ivelog
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 5836800
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dispatchers integer
max_dump_file_size string unlimited
max_enabled_roles integer 150
max_shared_servers integer
memory_max_target big integer 900M
memory_target big integer 900M
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_timestamp_tz_format string
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
olap_page_pool_size big integer 0
open_cursors integer 300
open_links integer 4
open_links_per_instance integer 4
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.2.0.3
optimizer_index_caching integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
optimizer_secure_view_merging boolean TRUE
optimizer_use_invisible_indexes boolean FALSE
optimizer_use_pending_statistics boolean FALSE
optimizer_use_sql_plan_baselines boolean TRUE
os_authent_prefix string ops$
os_roles boolean FALSE
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_limit string CPU
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_degree_policy string MANUAL
parallel_execution_message_size integer 16384
parallel_force_local boolean FALSE
parallel_instance_group string
parallel_io_cap_enabled boolean FALSE
parallel_max_servers integer 40
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_min_time_threshold string AUTO
parallel_server boolean TRUE
parallel_server_instances integer 2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_servers_target integer 16
parallel_threads_per_cpu integer 2
permit_92_wrap_format boolean TRUE
pga_aggregate_target big integer 0
plscope_settings string IDENTIFIERS:NONE
plsql_ccflags string
plsql_code_type string INTERPRETED
plsql_debug boolean FALSE
plsql_optimize_level integer 2
plsql_v2_compatibility boolean FALSE
plsql_warnings string DISABLE:ALL
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pre_page_sga boolean FALSE
processes integer 300
processor_group_name string
query_rewrite_enabled string TRUE
query_rewrite_integrity string enforced
rdbms_server_dn string
read_only_open_delayed boolean FALSE
recovery_parallelism integer 0
recyclebin string on
redo_transport_user string
remote_dependencies_mode string TIMESTAMP
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string dominic-scan:1521
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
replication_dependency_tracking boolean TRUE
resource_limit boolean FALSE
resource_manager_cpu_allocation integer 1
resource_manager_plan string
result_cache_max_result integer 5
result_cache_max_size big integer 2304K
result_cache_mode string MANUAL
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_remote_expiration integer 0
resumable_timeout integer 0
rollback_segments string
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
sec_protocol_error_further_action string CONTINUE
sec_protocol_error_trace_action string TRACE
sec_return_server_release_banner boolean FALSE
serial_reuse string disable
service_names string dominic
session_cached_cursors integer 50
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
session_max_open_files integer 10
sessions integer 472
sga_max_size big integer 900M
sga_target big integer 0
shadow_core_dump string partial
shared_memory_address integer 0
shared_pool_reserved_size big integer 12373196
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 1
skip_unusable_indexes boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
smtp_out_server string
sort_area_retained_size integer 0
sort_area_size integer 65536
spfile string +DATA/dominic/spfiledominic.or
a
sql92_security boolean FALSE
sql_trace boolean FALSE
sqltune_category string DEFAULT
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
star_transformation_enabled string FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
streams_pool_size big integer 0
tape_asynch_io boolean TRUE
thread integer 1
timed_os_statistics integer 0
timed_statistics boolean TRUE
trace_enabled boolean TRUE
tracefile_identifier string
transactions integer 519
transactions_per_rollback_segment integer 5
undo_management string AUTO
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 1800
undo_tablespace string UNDOTBS1
use_indirect_data_buffers boolean FALSE
use_large_pages string TRUE
user_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/trace
utl_file_dir string
workarea_size_policy string AUTO
xml_db_events string enable
su - grid
[grid@dominic1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 6 22:04:56 2015
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 Real Application Clusters and Automatic Storage Management options
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA, LOGFILE
asm_diskstring string /dev/asm-disk*
asm_power_limit integer 1
asm_preferred_read_failure_groups string
audit_file_dest string /dba/app/11.2/grid/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
background_core_dump string partial
background_dump_dest string /dba/app/grid/diag/asm/+asm/+A
SM1/trace
cluster_database boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
cluster_interconnects string
core_dump_dest string /dba/app/grid/diag/asm/+asm/+A
SM1/cdump
cpu_count integer 1
db_cache_size big integer 0
db_ultra_safe string OFF
db_unique_name string +ASM
diagnostic_dest string /dba/app/grid
event string
file_mapping boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string none
ifile file
instance_name string +ASM1
instance_number integer 1
instance_type string asm
large_pool_size big integer 12M
ldap_directory_sysauth string no
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.5.113)(PORT=1521))))
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_name_space string
lock_sga boolean FALSE
max_dump_file_size string unlimited
memory_max_target big integer 272M
memory_target big integer 272M
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix string ops$
os_roles boolean FALSE
parallel_execution_message_size integer 16384
pga_aggregate_target big integer 0
processes integer 120
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
service_names string +ASM
sessions integer 202
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 272M
sga_target big integer 0
shadow_core_dump string partial
shared_pool_reserved_size big integer 8M
shared_pool_size big integer 0
sort_area_size integer 65536
spfile string +OCR/dominic/asmparameterfile/
registry.253.873636763
sql_trace boolean FALSE
statistics_level string TYPICAL
timed_os_statistics integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
timed_statistics boolean TRUE
trace_enabled boolean TRUE
use_large_pages string TRUE
user_dump_dest string /dba/app/grid/diag/asm/+asm/+A
SM1/trace
workarea_size_policy string AUTO
二,升级前的准备工作: 检查,备份
2 升级前检查:
[grid@dominic1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n dominic1,dominic2 -rolling -src_crshome /dba/app/11.2/grid -dest_crshome /dba/app/11.2.4/grid -dest_version 11.2.0.4.0 -fixup --注意这里的目录,
Performing pre-checks for cluster services setup
Checking node reachability...
Node reachability check passed from node "dominic1"
Checking user equivalence...
User equivalence check passed for user "grid"
Checking CRS user consistency
CRS user consistency check successful
Checking node connectivity...
Checking hosts config file...
Verification of the hosts config file successful
Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.5.0"
Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"
TCP connectivity check passed for subnet "192.168.56.0"
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.5.0".
Subnet mask consistency check passed for subnet "192.168.56.0".
Subnet mask consistency check passed.
Node connectivity check passed
Checking multicast communication...
Checking subnet "192.168.5.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.5.0" for multicast communication with multicast group "230.0.1.0" passed.
Checking subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.56.0" for multicast communication with multicast group "230.0.1.0" passed.
Check of multicast communication passed.
Checking OCR integrity...
OCR integrity check passed
Checking ASMLib configuration.
Check for ASMLib configuration passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "dominic2:/dba/app/11.2.4/grid,dominic2:/tmp"
Free disk space check passed for "dominic1:/dba/app/11.2.4/grid,dominic1:/tmp"
Check for multiple users with UID value 1100 passed
User existence check passed for "grid"
Group existence check passed for "oinstall"
Membership check for user "grid" in group "oinstall" [as Primary] passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
There are no oracle patches required for home "/dba/app/11.2/grid".
There are no oracle patches required for home "/dba/app/11.2.4/grid".
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "binutils"
Package existence check passed for "compat-libcap1"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "gcc"
Package existence check passed for "gcc-c++"
Package existence check passed for "ksh"
Package existence check passed for "make"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Check for multiple users with UID value 0 passed
Current group ID check passed
Starting check for consistency of primary group of root user
Check for consistency of root user's primary group passed
Package existence check passed for "cvuqdisk"
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
NTP Configuration file check passed
Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes
NTP daemon slewing option check passed
NTP daemon's boot time configuration check for slewing option passed
NTP common Time Server Check started...
PRVF-5408 : NTP Time Server "202.112.10.60" is common only to the following nodes "dominic1"
Check of common NTP Time Server passed
Clock time offset check from NTP Time Server started...
PRVF-5413 : Node "dominic2" has a time offset of -33937.0 that is beyond permissible limit of 1000.0 from NTP Time Server "202.118.1.46"
PRVF-5413 : Node "dominic1" has a time offset of -33787.0 that is beyond permissible limit of 1000.0 from NTP Time Server "202.118.1.46"
Clock time offset check passed
Clock synchronization check using Network Time Protocol(NTP) passed
Core file name pattern consistency check passed.
User "grid" is not part of "root" group. Check passed
Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes
File "/etc/resolv.conf" does not have both domain and search entries defined
domain entry in file "/etc/resolv.conf" is consistent across nodes
search entry in file "/etc/resolv.conf" is consistent across nodes
The DNS response time for an unreachable node is within acceptable limit on all nodes
File "/etc/resolv.conf" is consistent across nodes
UDev attributes check for OCR locations started...
UDev attributes check passed for OCR locations
UDev attributes check for Voting Disk locations started...
UDev attributes check passed for Voting Disk locations
Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.
Checking Oracle Cluster Voting Disk configuration...
ASM Running check passed. ASM is running on all specified nodes
Oracle Cluster Voting Disk configuration check passed
Clusterware version consistency passed
Starting check for Reverse path filter setting ...
Check for Reverse path filter setting passed
Pre-check for cluster services setup was successful.
软件grid_base备份如下:tar -cvf grid_base_11203_bak.tar.gz $ORACLE_BASE。
软件ORACLE_BASE 备份: tar -cvf oracle_base_11203_bak_tar.gz $ORACLE_BASE
数据库备份: rman 备份, expdp 备份.
新创建目录:
[root@dominic1 ~]# mkdir -pv /dba/app/11.2.4/grid (两个节点都需要创建)
mkdir: created directory `/dba/app/11.2.4'
mkdir: created directory `/dba/app/11.2.4/grid'
[root@dominic1 ~]# chown -R grid.oinstall /dba/app/11.2.4/
[root@dominic1 ~]# chmod -R 775 /dba/app/11.2.4/
[root@dominic2 ~]# mkdir -pv /dba/app/11.2.4/grid
mkdir: created directory `/dba/app/11.2.4'
mkdir: created directory `/dba/app/11.2.4/grid'
[root@dominic2 ~]# chown -R grid.oinstall /dba/app/11.2.4/
[root@dominic2 ~]# chmod -R 775 /dba/app/11.2.4/
[root@dominic1 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.5.111 dominic1
192.168.5.112 dominic2
192.168.56.111 priv1
192.168.56.112 priv2
192.168.5.113 vip1
192.168.5.114 vip2
192.168.5.115 dominic-scan
192.168.5.116 dominic-scan
192.168.5.117 dominic-scan
[root@dominic1 ~]# su - grid
[grid@dominic1 ~]$ unset ORACLE_BASE
[grid@dominic1 ~]$ unset ORACLE_HOME
[grid@dominic1 ~]$ unset ORACLE_SID
[root@dominic1 ~]# /dba/app/11.2.4/grid/rootupgrade.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /dba/app/11.2.4/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /dba/app/11.2.4/grid/crs/install/crsconfig_params
Creating trace directory
Installing Trace File Analyzer
ASM upgrade has started on first node.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dominic1'
CRS-2673: Attempting to stop 'ora.crsd' on 'dominic1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dominic1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'dominic1'
CRS-2673: Attempting to stop 'ora.dominic.db' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.cvu' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.dominic1.vip' on 'dominic1'
CRS-2677: Stop of 'ora.scan3.vip' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'dominic2'
CRS-2677: Stop of 'ora.dominic1.vip' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.dominic1.vip' on 'dominic2'
CRS-2677: Stop of 'ora.scan2.vip' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'dominic2'
CRS-2676: Start of 'ora.dominic1.vip' on 'dominic2' succeeded
CRS-2676: Start of 'ora.scan3.vip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'dominic2'
CRS-2676: Start of 'ora.scan2.vip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'dominic2'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'dominic2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.dominic.db' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LOGFILE.dg' on 'dominic1'
CRS-2677: Stop of 'ora.LOGFILE.dg' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'dominic1' succeeded
CRS-2675: Stop of 'ora.oc4j' on 'dominic1' failed
CRS-2679: Attempting to clean 'ora.oc4j' on 'dominic1'
CRS-2677: Stop of 'ora.cvu' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'dominic2'
CRS-2681: Clean of 'ora.oc4j' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'dominic2'
CRS-2676: Start of 'ora.cvu' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dominic1'
CRS-2677: Stop of 'ora.asm' on 'dominic1' succeeded
CRS-2676: Start of 'ora.oc4j' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'dominic1'
CRS-2677: Stop of 'ora.ons' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'dominic1'
CRS-2677: Stop of 'ora.net1.network' on 'dominic1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dominic1' has completed
CRS-2677: Stop of 'ora.crsd' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'dominic1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'dominic1'
CRS-2673: Attempting to stop 'ora.evmd' on 'dominic1'
CRS-2673: Attempting to stop 'ora.asm' on 'dominic1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dominic1'
CRS-2677: Stop of 'ora.crf' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.asm' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dominic1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dominic1'
CRS-2677: Stop of 'ora.cssd' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dominic1'
CRS-2677: Stop of 'ora.gipcd' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dominic1'
CRS-2677: Stop of 'ora.gpnpd' on 'dominic1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dominic1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@dominic2 ~]# /dba/app/11.2.4/grid/rootupgrade.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /dba/app/11.2.4/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /dba/app/11.2.4/grid/crs/install/crsconfig_params
Creating trace directory
Installing Trace File Analyzer
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dominic2'
CRS-2673: Attempting to stop 'ora.crsd' on 'dominic2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dominic2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dominic2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'dominic2'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'dominic2'
CRS-2673: Attempting to stop 'ora.dominic.db' on 'dominic2'
CRS-2673: Attempting to stop 'ora.cvu' on 'dominic2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'dominic2'
CRS-2677: Stop of 'ora.cvu' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'dominic2'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'dominic2'
CRS-2676: Start of 'ora.cvu' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'dominic1'
CRS-2677: Stop of 'ora.scan2.vip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.dominic2.vip' on 'dominic2'
CRS-2677: Stop of 'ora.dominic2.vip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.dominic2.vip' on 'dominic1'
CRS-2676: Start of 'ora.scan3.vip' on 'dominic1' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'dominic1' succeeded
CRS-2676: Start of 'ora.dominic2.vip' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'dominic1'
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'dominic1'
CRS-2677: Stop of 'ora.dominic.db' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dominic2'
CRS-2673: Attempting to stop 'ora.LOGFILE.dg' on 'dominic2'
CRS-2677: Stop of 'ora.DATA.dg' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.LOGFILE.dg' on 'dominic2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'dominic1' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dominic2'
CRS-2677: Stop of 'ora.asm' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'dominic2'
CRS-2677: Stop of 'ora.ons' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'dominic2'
CRS-2677: Stop of 'ora.net1.network' on 'dominic2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dominic2' has completed
CRS-2677: Stop of 'ora.crsd' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'dominic2'
CRS-2673: Attempting to stop 'ora.evmd' on 'dominic2'
CRS-2673: Attempting to stop 'ora.asm' on 'dominic2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dominic2'
CRS-2677: Stop of 'ora.evmd' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dominic2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dominic2'
CRS-2677: Stop of 'ora.cssd' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'dominic2'
CRS-2677: Stop of 'ora.crf' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dominic2'
CRS-2677: Stop of 'ora.gipcd' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dominic2'
CRS-2677: Stop of 'ora.gpnpd' on 'dominic2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dominic2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. This operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Successfully upgraded the Oracle Clusterware.
Oracle Clusterware operating version was successfully set to 11.2.0.4.0
ASM upgrade has finished on last node.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
-------对应的trace log -------
在执行脚本式,实例反复的重启,
Sat Mar 07 09:13:51 2015
Archived Log entry 23 added for thread 2 sequence 13 ID 0x7767c3b9 dest 1:
Sat Mar 07 10:14:06 2015
Dumping diagnostic data in directory=[cdmp_20150307101404], requested by (instance=1, osid=3662 (QMNC)), summary=[incident=14745].
Sat Mar 07 12:31:26 2015
Reconfiguration started (old inc 4, new inc 6)
List of instances:
2 (myinst: 2)
Global Resource Directory frozen
* dead instance detected - domain 0 invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sat Mar 07 12:31:28 2015
LMS 0: 2 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Sat Mar 07 12:31:32 2015
minact-scn: Inst 2 is now the master inc#:6 mmon proc-id:3339 status:0x7
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.0014ba6d gcalc-scn:0x0000.0014ba78
minact-scn: master found reconf/inst-rec before recscn scan old-inc#:6 new-inc#:6
Sat Mar 07 12:31:33 2015
Instance recovery: looking for dead threads
Beginning instance recovery of 1 threads
Started redo scan
Sat Mar 07 12:31:38 2015
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Completed redo scan
read 179 KB redo, 91 data blocks need recovery
Sat Mar 07 12:31:44 2015
Started redo application at
Thread 1: logseq 15, block 52268
Recovery of Online Redo Log: Thread 1 Group 1 Seq 15 Reading mem 0
Mem# 0: +DATA/dominic/onlinelog/group_1.261.873641217
Mem# 1: +LOGFILE/dominic/onlinelog/group_1.257.873641219
Completed redo application of 0.09MB
Sat Mar 07 12:31:48 2015
Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Completed instance recovery at
Thread 1: logseq 15, block 52627, scn 1378524
81 data blocks read, 93 data blocks written, 179 redo k-bytes read
Thread 1 advanced to log sequence 16 (thread recovery)
Sat Mar 07 12:31:54 2015
Redo thread 1 internally disabled at seq 16 (SMON)
Sat Mar 07 12:32:03 2015
minact-scn: master continuing after IR
Sat Mar 07 12:32:15 2015
Archived Log entry 24 added for thread 1 sequence 15 ID 0x7767c3b9 dest 1:
Sat Mar 07 12:32:16 2015
ARC0: Archiving disabled thread 1 sequence 16
Archived Log entry 25 added for thread 1 sequence 16 ID 0x7767c3b9 dest 1:
Sat Mar 07 12:36:40 2015
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [2.31%] pct of memory swapped out [3.77%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Sat Mar 07 12:39:30 2015
Reconfiguration started (old inc 6, new inc 8)
List of instances:
1 2 (myinst: 2)
Global Resource Directory frozen
Communication channels reestablished
Sat Mar 07 12:39:32 2015
* domain 0 valid = 1 according to instance 1
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sat Mar 07 12:39:33 2015
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Sat Mar 07 12:39:39 2015
minact-scn: Master returning as live inst:1 has inc# mismatch instinc:0 cur:8 errcnt:0
Sat Mar 07 12:41:03 2015
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Mar 07 12:42:07 2015
db_recovery_file_dest_size of 4347 MB is 5.15% 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.
Sat Mar 07 12:43:16 2015
Shutting down instance (abort)
License high water mark = 9
USER (ospid: 3391): terminating the instance
Instance terminated by USER, pid = 3391
Sat Mar 07 12:43:20 2015
Instance shutdown complete
Sat Mar 07 12:48:51 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Sat Mar 07 12:49:07 2015
Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
[name='eth1:1', type=1, ip=169.254.110.115, mac=08-00-27-93-99-c9, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
[name='eth0', type=1, ip=192.168.5.112, mac=08-00-27-de-35-d2, net=192.168.5.0/24, mask=255.255.255.0, use=public/1]
Public Interface 'eth0:1' configured from GPnP for use as a public interface.
[name='eth0:1', type=1, ip=192.168.5.114, mac=08-00-27-de-35-d2, net=192.168.5.0/24, mask=255.255.255.0, use=public/1]
Public Interface 'eth0:2' configured from GPnP for use as a public interface.
[name='eth0:2', type=1, ip=192.168.5.115, mac=08-00-27-de-35-d2, net=192.168.5.0/24, mask=255.255.255.0, use=public/1]
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /dba/app/oracle/product/11.2/dbhome_1
System name: Linux
Node name: dominic2
Release: 2.6.39-400.17.1.el6uek.x86_64
Version: #1 SMP Fri Feb 22 18:16:18 PST 2013
Machine: x86_64
Using parameter settings in server-side pfile /dba/app/oracle/product/11.2/dbhome_1/dbs/initdominic2.ora
System parameters with non-default values:
processes = 300
sessions = 472
spfile = "+DATA/dominic/spfiledominic.ora"
memory_target = 900M
control_files = "+DATA/dominic/controlfile/current.260.873641213"
control_files = "+LOGFILE/dominic/controlfile/current.256.873641213"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=+LOGFILE/dominic/archivelog"
log_archive_format = "%t_%s_%r.dbf"
cluster_database = TRUE
db_create_file_dest = "+DATA"
db_recovery_file_dest = "+LOGFILE"
db_recovery_file_dest_size= 4347M
thread = 2
undo_tablespace = "UNDOTBS2"
undo_retention = 1800
instance_number = 2
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=dominicXDB)"
remote_listener = "dominic-scan:1521"
audit_file_dest = "/dba/app/oracle/admin/dominic/adump"
audit_trail = "DB"
db_name = "dominic"
open_cursors = 300
diagnostic_dest = "/dba/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
169.254.110.115
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Mar 07 12:49:11 2015
PMON started with pid=2, OS id=20411
Sat Mar 07 12:49:11 2015
PSP0 started with pid=3, OS id=20413
Sat Mar 07 12:49:12 2015
VKTM started with pid=4, OS id=20415 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Mar 07 12:49:12 2015
GEN0 started with pid=5, OS id=20419
Sat Mar 07 12:49:12 2015
DIAG started with pid=6, OS id=20421
Sat Mar 07 12:49:12 2015
DBRM started with pid=7, OS id=20423
Sat Mar 07 12:49:12 2015
PING started with pid=8, OS id=20425
Sat Mar 07 12:49:12 2015
ACMS started with pid=9, OS id=20427
Sat Mar 07 12:49:12 2015
DIA0 started with pid=10, OS id=20429
Sat Mar 07 12:49:12 2015
LMON started with pid=11, OS id=20431
Sat Mar 07 12:49:14 2015
LMD0 started with pid=12, OS id=20433
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [960 - 1280]
Sat Mar 07 12:49:15 2015
LMS0 started with pid=13, OS id=20441 at elevated priority
Sat Mar 07 12:49:15 2015
RMS0 started with pid=14, OS id=20446
Sat Mar 07 12:49:15 2015
LMHB started with pid=15, OS id=20448
Sat Mar 07 12:49:15 2015
MMAN started with pid=16, OS id=20450
Sat Mar 07 12:49:17 2015
DBW0 started with pid=17, OS id=20453
Sat Mar 07 12:49:17 2015
LGWR started with pid=18, OS id=20455
Sat Mar 07 12:49:17 2015
CKPT started with pid=19, OS id=20459
Sat Mar 07 12:49:17 2015
SMON started with pid=20, OS id=20461
Sat Mar 07 12:49:19 2015
RECO started with pid=21, OS id=20463
Sat Mar 07 12:49:19 2015
RBAL started with pid=22, OS id=20465
Sat Mar 07 12:49:19 2015
ASMB started with pid=23, OS id=20467
Sat Mar 07 12:49:19 2015
MMON started with pid=24, OS id=20469
Sat Mar 07 12:49:19 2015
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Mar 07 12:49:19 2015
MMNL started with pid=25, OS id=20471
starting up 1 shared server(s) ...
lmon registered with NM - instance number 2 (internal mem no 1)
NOTE: initiating MARK startup
Starting background process MARK
Sat Mar 07 12:49:22 2015
MARK started with pid=28, OS id=20493
NOTE: MARK has subscribed
Sat Mar 07 12:49:27 2015
Reconfiguration started (old inc 0, new inc 12)
List of instances:
1 2 (myinst: 2)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Sat Mar 07 12:49:29 2015
* domain 0 valid = 1 according to instance 1
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sat Mar 07 12:49:30 2015
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Sat Mar 07 12:49:30 2015
LCK0 started with pid=30, OS id=20522
Sat Mar 07 12:49:30 2015
Starting background process RSMN
Sat Mar 07 12:49:30 2015
RSMN started with pid=31, OS id=20526
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Sat Mar 07 12:49:48 2015
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.5.114)(PORT=1521))' SCOPE=MEMORY SID='dominic2';
ALTER DATABASE MOUNT /* db agent *//* {2:10848:2} */
Sat Mar 07 12:49:50 2015
NOTE: Loaded library: System
Sat Mar 07 12:49:50 2015
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup LOGFILE was mounted
Sat Mar 07 12:49:50 2015
NOTE: dependency between database dominic and diskgroup resource ora.DATA.dg is established
NOTE: dependency between database dominic and diskgroup resource ora.LOGFILE.dg is established
Sat Mar 07 12:49:54 2015
Successful mount of redo thread 2, with mount id 2003383582
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT /* db agent *//* {2:10848:2} */
ALTER DATABASE OPEN /* db agent *//* {2:10848:2} */
Picked broadcast on commit scheme to generate SCNs
ARCH: STARTING ARCH PROCESSES
Sat Mar 07 12:49:57 2015
ARC0 started with pid=35, OS id=20646
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Mar 07 12:49:58 2015
ARC1 started with pid=36, OS id=20648
Sat Mar 07 12:49:58 2015
ARC2 started with pid=37, OS id=20650
ARC1: Archival started
ARC2: Archival started
Sat Mar 07 12:49:58 2015
ARC3 started with pid=38, OS id=20652
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 2 opened at log sequence 16
Current log# 4 seq# 16 mem# 0: +DATA/dominic/onlinelog/group_4.267.873641567
Current log# 4 seq# 16 mem# 1: +LOGFILE/dominic/onlinelog/group_4.260.873641567
Successful open of redo thread 2
Sat Mar 07 12:49:59 2015
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Mar 07 12:49:59 2015
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat Mar 07 12:50:06 2015
minact-scn: Inst 2 is a slave inc#:12 mmon proc-id:20469 status:0x2
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
[20542] Successfully onlined Undo Tablespace 5.
Undo initialization finished serial:0 start:58561264 end:58563054 diff:1790 (17 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
Sat Mar 07 12:50:09 2015
Starting background process GTX0
Sat Mar 07 12:50:10 2015
GTX0 started with pid=39, OS id=20710
Starting background process RCBG
Sat Mar 07 12:50:10 2015
RCBG started with pid=40, OS id=20712
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Mar 07 12:50:10 2015
QMNC started with pid=41, OS id=20714
Completed: ALTER DATABASE OPEN /* db agent *//* {2:10848:2} */
Sat Mar 07 12:50:27 2015
Starting background process CJQ0
Sat Mar 07 12:50:27 2015
CJQ0 started with pid=44, OS id=20770
Sat Mar 07 12:50:27 2015
Starting background process SMCO
Sat Mar 07 12:50:27 2015
SMCO started with pid=48, OS id=20776
Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Mar 07 12:50:31 2015
Starting background process VKRM
Sat Mar 07 12:50:31 2015
VKRM started with pid=49, OS id=20800
----------------------------------------
[grid@dominic1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LISTENER.lsnr
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LOGFILE.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.OCR.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.asm
ONLINE ONLINE dominic1 Started
ONLINE ONLINE dominic2 Started
ora.gsd
OFFLINE OFFLINE dominic1
OFFLINE OFFLINE dominic2
ora.net1.network
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.ons
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.registry.acfs
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dominic2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE dominic1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE dominic1
ora.cvu
1 ONLINE ONLINE dominic1
ora.dominic.db
1 ONLINE ONLINE dominic1 Open
2 ONLINE ONLINE dominic2 Open
ora.dominic1.vip
1 ONLINE ONLINE dominic1
ora.dominic2.vip
1 ONLINE ONLINE dominic2
ora.oc4j
1 ONLINE ONLINE dominic2
ora.scan1.vip
1 ONLINE ONLINE dominic2
ora.scan2.vip
1 ONLINE ONLINE dominic1
ora.scan3.vip
1 ONLINE ONLINE dominic1
[grid@dominic2 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LISTENER.lsnr
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LOGFILE.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.OCR.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.asm
ONLINE ONLINE dominic1 Started
ONLINE ONLINE dominic2 Started
ora.gsd
OFFLINE OFFLINE dominic1
OFFLINE OFFLINE dominic2
ora.net1.network
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.ons
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.registry.acfs
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dominic2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE dominic1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE dominic1
ora.cvu
1 ONLINE ONLINE dominic1
ora.dominic.db
1 ONLINE ONLINE dominic1 Open
2 ONLINE ONLINE dominic2 Open
ora.dominic1.vip
1 ONLINE ONLINE dominic1
ora.dominic2.vip
1 ONLINE ONLINE dominic2
ora.oc4j
1 ONLINE ONLINE dominic2
ora.scan1.vip
1 ONLINE ONLINE dominic2
ora.scan2.vip
1 ONLINE ONLINE dominic1
ora.scan3.vip
1 ONLINE ONLINE dominic1
修改 grid 下GRID_HOME 目录在.barch_profile
[grid@dominic1 ~]$ cat .bash_profile
# for oracle11g grid
export ORACLE_BASE=/dba/app/grid
#export ORACLE_HOME=/dba/app/11.2/grid
export ORACLE_HOME=/dba/app/11.2.4/grid
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LANG=C
umask 022
[grid@dominic1 ~]$ . .bash_profile
[grid@dominic2 ~]$ cat .bash_profile
export PATH
# for oracle11g grid
export ORACLE_BASE=/dba/app/grid
#export ORACLE_HOME=/dba/app/11.2/grid
export ORACLE_HOME=/dba/app/11.2.4/grid
export ORACLE_SID=+ASM2
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LANG=C
umask 022
[grid@dominic2 ~]$ . .bash_profile
=======================================================================
1.2 重启oracle (这里,这步骤可以约过,因升级的时候,已经重启了)
[root@rac01 /]# cd/u01/app/11.2.0.4/grid/bin
[root@rac01 bin]# ./crsctlstop cluster –all
[root@rac01 bin]# ./crsctlstart cluster -all
========================================================================
[grid@dominic1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[grid@dominic1 ~]$ crsctl query crs -h
Usage:
crsctl query crs administrator
Display admin list
crsctl query crs activeversion
Lists the Oracle Clusterware operating version
crsctl query crs releaseversion
Lists the Oracle Clusterware release version
crsctl query crs softwareversion [<nodename>| -all]
Lists the version of Oracle Clusterware software installed
where
Default List software version of the local node
nodename List software version of named node
-all List software version for all the nodes in the cluster
[grid@dominic1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[grid@dominic1 ~]$ crsctl query crs softwareversion -all
Oracle Clusterware version on node [dominic1] is [11.2.0.4.0]
Oracle Clusterware version on node [dominic2] is [11.2.0.4.0]
[grid@dominic2 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[grid@dominic2 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
--在这里GRID 升级完成:
开始对database soft 升级:
unset ORACLE_HOME
unset ORACLE_BASE
unset ORACLE_SID
这里 备份 oracle_base 目录: tar -cvf 11203ORACLE_BASE.bak.tar.gz $ORACLE_BASE
[oracle@dominic1/2 ~]$ tar -cvf oraInventory_bak.tar.gz /dba/app/oraInventory
[oracle@dominic1/2 ~]$ tar -cvf oracle_base.tar.gz /dba/app/oracle/admin/ /dba/app/oracle/cfgtoollogs/ /dba/app/oracle/checkpoints/ /dba/app/oracle/diag/
[oracle@dominic1 ~]$ ls
oraInventory_bak.tar.gz oracle_base.tar.gz
--这里也可以备份DB--
[root@dominic1 ~]# mkdir -pv /dba/app/oracle/product/11.2.4/dbhome_1/
mkdir: created directory `/dba/app/oracle/product/11.2.4'
mkdir: created directory `/dba/app/oracle/product/11.2.4/dbhome_1/'
[root@dominic1 ~]# chown -R oracle.oinstall /dba/app/oracle/product/11.2.4/
[root@dominic1 ~]# chmod -R 775 /dba/app/oracle/product/11.2.4/
[root@dominic2 ~]# mkdir -pv /dba/app/oracle/product/11.2.4/dbhome_1/
mkdir: created directory `/dba/app/oracle/product/11.2.4'
mkdir: created directory `/dba/app/oracle/product/11.2.4/dbhome_1/'
[root@dominic2 ~]# chown -R oracle.oinstall /dba/app/oracle/product/11.2.4/
[root@dominic2 ~]# chmod -R 775 /dba/app/oracle/product/11.2.4/
[oracle@dominic1 ~]$ xhost +
access control disabled, clients can connect from any host
[root@dominic1 ~]# /dba/app/oracle/product/11.2.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /dba/app/oracle/product/11.2.4/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@dominic2 ~]# /dba/app/oracle/product/11.2.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /dba/app/oracle/product/11.2.4/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
DB升级:
[oracle@dominic1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 7 14:46:58 2015
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@dominic1 ~]$ /dba/app/oracle/product/11.2.4/dbhome_1/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 7 14:47:58 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@dominic1 ~]$ /dba/app/oracle/product/11.2.4/dbhome_1/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 7 14:50:57 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @/dba/app/oracle/product/11.2.4/dbhome_1/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 03-07-2015 14:52:21
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: DOMINIC
--> version: 11.2.0.3.0
--> compatible: 11.2.0.0.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V14
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 935 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 710 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 310 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> The "cluster_database" parameter is currently "TRUE"
.... and must be set to "FALSE" prior to running a manual upgrade.
WARNING: --> Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APEX_030200 has dependent objects.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
[oracle@dominic1 ~]$ cd /dba/app/oracle/product/11.2.4/dbhome_1/bin/
[oracle@dominic1 bin]$ ./dbua --这里数据库会来回重启,通过trace log 查看:
同时,这个过程 只有一个节点 是active 状态,另一个节点时shutdown . 之后,所有的db 节点自动启动
修改 oracle_home 为新目录:
##for oracle11g
export ORACLE_SID=dominic1
export ORACLE_UNQNAME=dominic
export ORACLE_BASE=/dba/app/oracle
#export ORACLE_HOME=$ORACLE_BASE/product/11.2/dbhome_1
export ORACLE_HOME=$ORACLE_BASE/product/11.2.4/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export LANG=C
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export ORACLE_HOSTNAME=localhost
[oracle@dominic2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 7 16:30:50 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[root@dominic1 ~]# su - grid
[grid@dominic1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LISTENER.lsnr
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.LOGFILE.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.OCR.dg
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.asm
ONLINE ONLINE dominic1 Started
ONLINE ONLINE dominic2 Started
ora.gsd
OFFLINE OFFLINE dominic1
OFFLINE OFFLINE dominic2
ora.net1.network
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.ons
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
ora.registry.acfs
ONLINE ONLINE dominic1
ONLINE ONLINE dominic2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dominic2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE dominic1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE dominic1
ora.cvu
1 ONLINE ONLINE dominic1
ora.dominic.db
1 ONLINE ONLINE dominic1 Open
2 ONLINE ONLINE dominic2 Open
ora.dominic1.vip
1 ONLINE ONLINE dominic1
ora.dominic2.vip
1 ONLINE ONLINE dominic2
ora.oc4j
1 ONLINE ONLINE dominic2
ora.scan1.vip
1 ONLINE ONLINE dominic2
ora.scan2.vip
1 ONLINE ONLINE dominic1
ora.scan3.vip
1 ONLINE ONLINE dominic1
重启所有的服务:
[root@dominic1 ~]# cd /dba/app/11.2.4/grid/bin/
[root@dominic1 bin]# ./crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'dominic1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dominic1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'dominic1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dominic1'
CRS-2673: Attempting to stop 'ora.dominic.db' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'dominic1'
CRS-2673: Attempting to stop 'ora.cvu' on 'dominic1'
CRS-2677: Stop of 'ora.cvu' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'dominic2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dominic2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'dominic2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dominic2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dominic2'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'dominic2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dominic2'
CRS-2673: Attempting to stop 'ora.dominic.db' on 'dominic2'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'dominic1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.dominic1.vip' on 'dominic1'
CRS-2677: Stop of 'ora.scan2.vip' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.dominic1.vip' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.dominic.db' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dominic1'
CRS-2673: Attempting to stop 'ora.LOGFILE.dg' on 'dominic1'
CRS-2677: Stop of 'ora.registry.acfs' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'dominic2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.dominic2.vip' on 'dominic2'
CRS-2677: Stop of 'ora.dominic2.vip' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.dominic.db' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dominic2'
CRS-2673: Attempting to stop 'ora.LOGFILE.dg' on 'dominic2'
CRS-2677: Stop of 'ora.LOGFILE.dg' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dominic1'
CRS-2677: Stop of 'ora.asm' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.LOGFILE.dg' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dominic2'
CRS-2677: Stop of 'ora.asm' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'dominic2'
CRS-2677: Stop of 'ora.ons' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'dominic2'
CRS-2677: Stop of 'ora.net1.network' on 'dominic2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dominic2' has completed
CRS-2673: Attempting to stop 'ora.ons' on 'dominic1'
CRS-2677: Stop of 'ora.ons' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'dominic1'
CRS-2677: Stop of 'ora.net1.network' on 'dominic1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dominic1' has completed
CRS-2677: Stop of 'ora.crsd' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'dominic1'
CRS-2673: Attempting to stop 'ora.evmd' on 'dominic1'
CRS-2673: Attempting to stop 'ora.asm' on 'dominic1'
CRS-2677: Stop of 'ora.crsd' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'dominic2'
CRS-2673: Attempting to stop 'ora.evmd' on 'dominic2'
CRS-2673: Attempting to stop 'ora.asm' on 'dominic2'
CRS-2677: Stop of 'ora.evmd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dominic2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dominic1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dominic1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dominic1'
CRS-2677: Stop of 'ora.asm' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dominic2'
CRS-2677: Stop of 'ora.cssd' on 'dominic1' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dominic2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dominic2'
CRS-2677: Stop of 'ora.cssd' on 'dominic2' succeeded
[root@dominic1 bin]# ./crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'dominic2'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'dominic1'
CRS-2676: Start of 'ora.cssdmonitor' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'dominic1'
CRS-2672: Attempting to start 'ora.diskmon' on 'dominic1'
CRS-2676: Start of 'ora.cssdmonitor' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'dominic2'
CRS-2672: Attempting to start 'ora.diskmon' on 'dominic2'
CRS-2676: Start of 'ora.diskmon' on 'dominic1' succeeded
CRS-2676: Start of 'ora.diskmon' on 'dominic2' succeeded
CRS-2676: Start of 'ora.cssd' on 'dominic1' succeeded
CRS-2676: Start of 'ora.cssd' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'dominic2'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'dominic2'
CRS-2672: Attempting to start 'ora.ctssd' on 'dominic1'
CRS-2676: Start of 'ora.ctssd' on 'dominic2' succeeded
CRS-2676: Start of 'ora.ctssd' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'dominic1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'dominic1'
CRS-2672: Attempting to start 'ora.evmd' on 'dominic2'
CRS-2676: Start of 'ora.evmd' on 'dominic2' succeeded
CRS-2676: Start of 'ora.evmd' on 'dominic1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'dominic2'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'dominic1'
CRS-2676: Start of 'ora.asm' on 'dominic2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'dominic2'
CRS-2676: Start of 'ora.asm' on 'dominic1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'dominic1'
CRS-2676: Start of 'ora.crsd' on 'dominic2' succeeded
CRS-2676: Start of 'ora.crsd' on 'dominic1' succeeded
[oracle@dominic1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 7 16:47:50 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY boolean FALSE
active_instance_count integer
aq_tm_processes integer 1
archive_lag_target integer 0
asm_diskgroups string
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
audit_file_dest string /dba/app/oracle/admin/dominic/
adump
audit_sys_operations boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
audit_trail string DB
awr_snapshot_time_offset integer 0
background_core_dump string partial
background_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/trace
backup_tape_io_slaves boolean FALSE
bitmap_merge_area_size integer 1048576
blank_trimming boolean FALSE
buffer_pool_keep string
buffer_pool_recycle string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offload_compaction string ADAPTIVE
cell_offload_decryption boolean TRUE
cell_offload_parameters string
cell_offload_plan_display string AUTO
cell_offload_processing boolean TRUE
cell_offloadgroup_name string
circuits integer
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
clonedb boolean FALSE
cluster_database boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 2
cluster_interconnects string
commit_logging string
commit_point_strength integer 1
commit_wait string
commit_write string
compatible string 11.2.0.0.0
control_file_record_keep_time integer 7
control_files string +DATA/dominic/controlfile/curr
ent.260.873641213, +LOGFILE/do
minic/controlfile/current.256.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
873641213
control_management_pack_access string DIAGNOSTIC+TUNING
core_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/cdump
cpu_count integer 1
create_bitmap_area_size integer 8388608
create_stored_outlines string
cursor_bind_capture_destination string memory+disk
cursor_sharing string EXACT
cursor_space_for_time boolean FALSE
db_16k_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
db_create_file_dest string +DATA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string
db_file_multiblock_read_count integer 45
db_file_name_convert string
db_files integer 200
db_flash_cache_file string
db_flash_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 1440
db_keep_cache_size big integer 0
db_lost_write_protect string NONE
db_name string dominic
db_recovery_file_dest string +LOGFILE
db_recovery_file_dest_size big integer 4347M
db_recycle_cache_size big integer 0
db_securefile string PERMITTED
db_ultra_safe string OFF
db_unique_name string dominic
db_unrecoverable_scn_tracking boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_writer_processes integer 1
dbwr_io_slaves integer 0
ddl_lock_timeout integer 0
deferred_segment_creation boolean TRUE
dg_broker_config_file1 string /dba/app/oracle/product/11.2.4
/dbhome_1/dbs/dr1dominic.dat
dg_broker_config_file2 string /dba/app/oracle/product/11.2.4
/dbhome_1/dbs/dr2dominic.dat
dg_broker_start boolean FALSE
diagnostic_dest string /dba/app/oracle
disk_asynch_io boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=domini
cXDB)
distributed_lock_timeout integer 60
dml_locks integer 2076
dnfs_batch_size integer 4096
dst_upgrade_insert_conv boolean TRUE
enable_ddl_logging boolean FALSE
enable_goldengate_replication boolean FALSE
event string
fal_client string
fal_server string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_io_target integer 0
fast_start_mttr_target integer 0
fast_start_parallel_rollback string LOW
file_mapping boolean FALSE
fileio_network_adapters string
filesystemio_options string none
fixed_date string
gcs_server_processes integer 1
global_context_pool_size string
global_names boolean FALSE
global_txn_processes integer 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hash_area_size integer 131072
hi_shared_memory_address integer 0
hs_autoregister boolean TRUE
ifile file
instance_groups string
instance_name string dominic1
instance_number integer 1
instance_type string RDBMS
instant_restore boolean FALSE
java_jit_enabled boolean TRUE
java_max_sessionspace_size integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_pool_size big integer 0
java_restrict string none
java_soft_sessionspace_limit integer 0
job_queue_processes integer 1000
large_pool_size big integer 0
ldap_directory_access string NONE
ldap_directory_sysauth string no
license_max_sessions integer 0
license_max_users integer 0
license_sessions_warning integer 0
listener_networks string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.5.113)(PORT=1521))
lock_name_space string
lock_sga boolean FALSE
log_archive_config string
log_archive_dest string
log_archive_dest_1 string location=+LOGFILE/dominic/arch
ivelog
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 5812224
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string
max_dispatchers integer
max_dump_file_size string unlimited
max_enabled_roles integer 150
max_shared_servers integer
memory_max_target big integer 900M
memory_target big integer 900M
nls_calendar string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
nls_sort string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
olap_page_pool_size big integer 0
open_cursors integer 300
open_links integer 4
open_links_per_instance integer 4
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.2.0.4
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
optimizer_secure_view_merging boolean TRUE
optimizer_use_invisible_indexes boolean FALSE
optimizer_use_pending_statistics boolean FALSE
optimizer_use_sql_plan_baselines boolean TRUE
os_authent_prefix string ops$
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_roles boolean FALSE
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_limit string CPU
parallel_degree_policy string MANUAL
parallel_execution_message_size integer 16384
parallel_force_local boolean FALSE
parallel_instance_group string
parallel_io_cap_enabled boolean FALSE
parallel_max_servers integer 40
parallel_min_percent integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_min_servers integer 0
parallel_min_time_threshold string AUTO
parallel_server boolean TRUE
parallel_server_instances integer 2
parallel_servers_target integer 16
parallel_threads_per_cpu integer 2
permit_92_wrap_format boolean TRUE
pga_aggregate_target big integer 0
plscope_settings string IDENTIFIERS:NONE
plsql_ccflags string
plsql_code_type string INTERPRETED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
plsql_debug boolean FALSE
plsql_optimize_level integer 2
plsql_v2_compatibility boolean FALSE
plsql_warnings string DISABLE:ALL
pre_page_sga boolean FALSE
processes integer 300
processor_group_name string
query_rewrite_enabled string TRUE
query_rewrite_integrity string enforced
rdbms_server_dn string
read_only_open_delayed boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recovery_parallelism integer 0
recyclebin string on
redo_transport_user string
remote_dependencies_mode string TIMESTAMP
remote_listener string dominic-scan:1521
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
replication_dependency_tracking boolean TRUE
resource_limit boolean FALSE
resource_manager_cpu_allocation integer 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string SCHEDULER[0x318E]:DEFAULT_MAIN
TENANCE_PLAN
result_cache_max_result integer 5
result_cache_max_size big integer 2304K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
resumable_timeout integer 0
rollback_segments string
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
sec_protocol_error_further_action string CONTINUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_protocol_error_trace_action string TRACE
sec_return_server_release_banner boolean FALSE
serial_reuse string disable
service_names string dominic
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 472
sga_max_size big integer 900M
sga_target big integer 0
shadow_core_dump string partial
shared_memory_address integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size big integer 9017753
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 1
skip_unusable_indexes boolean TRUE
smtp_out_server string
sort_area_retained_size integer 0
sort_area_size integer 65536
spfile string +DATA/dominic/spfiledominic.or
a
sql92_security boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean FALSE
sqltune_category string DEFAULT
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
star_transformation_enabled string FALSE
statistics_level string TYPICAL
streams_pool_size big integer 0
tape_asynch_io boolean TRUE
thread integer 1
timed_os_statistics integer 0
timed_statistics boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
trace_enabled boolean TRUE
tracefile_identifier string
transactions integer 519
transactions_per_rollback_segment integer 5
undo_management string AUTO
undo_retention integer 1800
undo_tablespace string UNDOTBS1
use_indirect_data_buffers boolean FALSE
use_large_pages string TRUE
user_dump_dest string /dba/app/oracle/diag/rdbms/dom
inic/dominic1/trace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string
workarea_size_policy string AUTO
xml_db_events string enable
完成: