knowledge_base_Compatible

10.91.35.
14
before activity
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Solaris: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> set lines 167 pages 1000

SQL> col NAME for a25
SQL> col VALUE for a25
SQL> select NAME,TYPE,VALUE,ISMODIFIED from v$parameter where name='compatible';
NAME TYPE VALUE ISMODIFIED

------------------------- ---------- ------------------------- ----------
compatible 2 10.2.0.3.0 FALSE
SQL> show parameter compatible
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
compatible string 10.2.0.3.0
SQL> select name,open_mode,log_mode,database_role from v$database;
NAME OPEN_MODE LOG_MODE DATABASE_ROLE

------------------------- -------------------- ------------ ----------------
CRM MOUNTED ARCHIVELOG PHYSICAL STANDBY
[oracrm@crmupgdb][crm]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 28 19:28:25 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
With the Partitioning, OLAP, Data Mining and Real Application Testing options
BANNER
--------------------------------------------------------------------------------


------------------------- ---------- ------------------------- ----------
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

------------------------- -------------------- ------------ ----------------
SQL> show parameter dump
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /sieb_dbdata/drcrm/trace/diag/
rdbms/drcrm/crm/trace
core_dump_dest string /sieb_dbdata/drcrm/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /sieb_dbdata/drcrm/trace/diag/
rdbms/drcrm/crm/trace
SQL> show parameter spfile
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string /oracle/product/11.2.0.4/oracr
m/dbs/spfilecrm.ora
SQL> !pwd
/oracle
SQL> create pfile='/oracle/initCRM_BKP.ora' from spfile;
File created.
SQL> !more /oracle/initCRM_BKP.ora

crm.__java_pool_size=67108864
crm.__large_pool_size=33554432
crm.__oracle_base='/oracle/product'#ORACLE_BASE set from environment
crm.__shared_pool_size=1543503872
crm.__streams_pool_size=0
*._b_tree_bitmap_plans=FALSE
*._gc_defer_time=0
*._optimizer_max_permutations=100
*._partition_view_enabled=false
*.compatible='10.2.0.3.0'
*.control_files='/sieb_dbdata/drcrm/controlfile/control01.ctl','/sieb_dbdata/
drcrm/controlfile/control02.ctl','/archive/drcrm/controlfile/control03.ctl'
*.core_dump_dest='/sieb_dbdata/drcrm/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='crm'
*.db_recovery_file_dest='/archive/flash'
*.db_recovery_file_dest_size=5368709120
*.db_unique_name='drcrm'
*.diagnostic_dest='/sieb_dbdata/drcrm/trace'
*.fal_server='CRM'
*.job_queue_processes=10
*.log_archive_config='dg_config=(crm,drcrm)'
*.log_archive_dest_1='LOCATION=/archive/drcrm'
*.log_archive_format='%t_%s_%r.dbf'
*.Log_archive_max_processes=10
*.open_cursors=3000
*.OPTIMIZER_DYNAMIC_SAMPLING=1
*.pga_aggregate_target=5368709120
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=40
*.sessions=2205
*.sga_target=10737418240
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS2'
SQL>
SQL> alter system set compatible='11.2.0.4.0' scope=spfile;^C
SQL> recover managed standby database cancel;

Media recovery complete.
SQL>
SQL> show parameter cluster
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string
SQL> alter system set compatible='11.2.0.4.0' scope=spfile;
System altered.
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

------------------------- ---------- ------------------------- ----------
SQL> shut immediate;

ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0693E+10 bytes
Fixed Size 2190976 bytes
Variable Size 1677726080 bytes
Database Buffers 8992587776 bytes
Redo Buffers 20160512 bytes
SQL> alter database mount standby database;
Database altered.
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

------------------------- ---------- ------------------------- ----------
SQL> alter database recover standby database disconnect from session;

alter database recover standby database disconnect from session
*
ERROR at line 1:
ORA-00905: missing keyword
SQL> recover mangaged standby database disconnect from session;

ORA-00905: missing keyword
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select * from gv$instance;
INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME

VERSION STARTUP_T STATUS PAR THREAD#
---------- --------------- ----------------
---------------------------------------------------------------- -----------------
--------- ------------ --- ----------
ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE
ACTIVE_ST BLO
------- --------------- ---------- --- ----------------- ------------------
--------- ---
1 1 crm crmupgdb
11.2.0.4.0 28-JUL-17 MOUNTED NO 1
STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
NO

------------------------- -------------------- ------------ ----------------

------------------------- ---------- ------------------------- ----------
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
[oracrm@crmupgdb][crm]$ sqlplus / as sysdba
Connected to:
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
SQL> !pwd
/oracle
SQL> create pfile='/oracle/initCRM_BKP_After.ora' from spfile;
File created.
SQL> !more /oracle/initCRM_BKP_After.ora

crm.__db_cache_size=8992587776
crm.__oracle_base='/oracle/product'#ORACLE_BASE set from environment
crm.__pga_aggregate_target=5368709120
crm.__sga_target=10737418240
crm.__shared_io_pool_size=0
*._gc_defer_time=0
*.control_files='/sieb_dbdata/drcrm/controlfile/control01.ctl','/sieb_dbdata/
drcrm/controlfile/control02.ctl','/archive/drcrm/controlfile/control03.ctl'
*.core_dump_dest='/sieb_dbdata/drcrm/cdump'
*.db_domain=''
*.db_name='crm'
*.db_recovery_file_dest='/archive/flash'
*.db_recovery_file_dest_size=5368709120
*.db_unique_name='drcrm'
*.diagnostic_dest='/sieb_dbdata/drcrm/trace'
*.fal_server='CRM'
*.log_archive_config='dg_config=(crm,drcrm)'
*.log_archive_dest_1='LOCATION=/archive/drcrm'
*.open_cursors=3000
*.sessions=2205
*.sga_target=10737418240
SQL>
===================================================================================
=========================
10.90.33.94
INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION

STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU
---------- --------------- ---------------- -------------------------
----------------- --------- ------------ --- ---------- ------- ---------------
---------- ---
DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
----------------- ------------------ --------- ---
1 1 crm siebeldb02 11.2.0.4.0
19-MAY-17 OPEN NO 1 STARTED ALLOWED NO
ACTIVE PRIMARY_INSTANCE NORMAL NO
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

--------- -------------------- ------------ ----------------
CRM READ WRITE ARCHIVELOG PRIMARY
NAME
TYPE
--------------------------------------------------------------------------------
----------
VALUE
-----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
ISMODIFIED
----------
compatible
2
10.2.0.3.0
FALSE
SQL> show parameter dump
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
background_dump_dest string /sieb_dbdata/crmupg/trace/diag
/rdbms/crm/crm/trace
core_dump_dest string /sieb_dbdata/crmupg/cdump
user_dump_dest string /sieb_dbdata/crmupg/trace/diag
/rdbms/crm/crm/trace
SQL>
SQL> show parameter spfile
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string /oracle_bi/oracle/product/11.2
.0.4/oracrm/dbs/spfilecrm.ora
SQL> !pwd
/oracle_bi/aj_scripts/monitoring
SQL> create pfile='/oracle_bi/aj_scripts/monitoring/initCRM_SAFE.ora' from spfil
File created.
SQL> !more /oracle_bi/aj_scripts/monitoring/initCRM_SAFE.ora

crm.__oracle_base='/oracle_bi/oracle/product'#ORACLE_BASE set from environment
*._gc_defer_time=0
*.control_file_record_keep_time=30
*.control_files='/sieb_dbdata/crmupg/controlfile/control01.ctl','/sieb_dbdata/
crmupg/controlfile/control02.ctl','/archive/crmupg/controlfile/control03.ctl'
*.core_dump_dest='/sieb_dbdata/crmupg/cdump'
*.db_domain=''
*.db_name='crm'
*.db_unique_name='crm'
*.diagnostic_dest='/sieb_dbdata/crmupg/trace'
*.fal_server='crm_rbl','drcrm'
*.log_archive_config='DG_CONFIG=(crm,crm_rbl,drcrm)'
*.log_archive_dest_1='LOCATION=/archive/crmupg'
*.log_archive_dest_2='SERVICE=drcrm LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=drcrm'
*.log_archive_dest_3='service=crm_rbl NOAFFIRM ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=crm_rbl'
*.log_archive_dest_state_3='enable'
*.log_file_name_convert='/sieb_redo1_1/oradata/crm/','/redo1/crmupg/','/
sieb_redo2_1/oradata/crm/','/redo2/crmupg/',"/sieb_redo1_2/oradata/crm'",'/redo1/
crmupg/','/sieb
_redo2_2/oradata/crm','/redo2/crmupg/'
*.open_cursors=3000
*.sessions=2205
*.sga_target=10737418240
SQL>
SQL> show parameter spfile;
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string /oracle_bi/oracle/product/11.2
.0.4/oracrm/dbs/spfilecrm.ora
SQL> alter system set compatible='11.2.0.4.0' scope=spfile;
System altered.
SQL> show parameter compatible;
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
Total System Global Area 1.0693E+10 bytes

Database mounted.
Database opened.
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION

STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU
---------- --------------- ---------------- -------------------------
----------------- --------- ------------ --- ---------- ------- ---------------
---------- ---
DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
----------------- ------------------ --------- ---
1 1 crm siebeldb02 11.2.0.4.0
28-JUL-17 OPEN NO 1 STARTED ALLOWED NO
ACTIVE PRIMARY_INSTANCE NORMAL NO
SQL> !pwd
/oracle_bi/aj_scripts/monitoring
SQL> create pfile='/oracle_bi/aj_scripts/monitoring/initCRM_SAFE_After.ora' from

spfile;
File created.
SQL> !more /oracle_bi/aj_scripts/monitoring/initCRM_SAFE_After.ora

crm.__oracle_base='/oracle_bi/oracle/product'#ORACLE_BASE set from environment
crm.__pga_aggregate_target=5368709120
crm.__sga_target=10737418240
crm.__shared_io_pool_size=0
*._gc_defer_time=0
*.control_file_record_keep_time=30
*.control_files='/sieb_dbdata/crmupg/controlfile/control01.ctl','/sieb_dbdata/
crmupg/controlfile/control02.ctl','/archive/crmupg/controlfile/control03.ctl'
*.core_dump_dest='/sieb_dbdata/crmupg/cdump'
*.db_domain=''
*.db_name='crm'
*.db_unique_name='crm'
*.diagnostic_dest='/sieb_dbdata/crmupg/trace'
*.fal_server='crm_rbl','drcrm'
*.log_archive_config='DG_CONFIG=(crm,crm_rbl,drcrm)'
*.log_archive_dest_1='LOCATION=/archive/crmupg'
*.log_archive_dest_2='SERVICE=drcrm LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=drcrm'
*.log_archive_dest_3='service=crm_rbl NOAFFIRM ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=crm_rbl'
*.log_file_name_convert='/sieb_redo1_1/oradata/crm/','/redo1/crmupg/','/
sieb_redo2_1/oradata/crm/','/redo2/crmupg/',"/sieb_redo1_2/oradata/crm'",'/redo1/
crmupg/','/sieb
_redo2_2/oradata/crm','/redo2/crmupg/'
*.open_cursors=3000
*.sessions=2205
*.sga_target=10737418240
NAME
TYPE
--------------------------------------------------------------------------------
----------
VALUE
-----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
ISMODIFIED
----------
compatible
2
11.2.0.4.0
FALSE
Fri Jul 28 19:56:11 2017

Instance shutdown complete
SQL> SQL>
INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME
STATUS
---------------- ------------------------- ----------------- -------------------
------------
crm siebeldb02 11.2.0.4.0 28-07-2017 19:56:32
OPEN
===================================================================================
===============================
10.91.35.42
[oracle][DRHRMS]$ sqlplus / as sysdba

Connected to:
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
INST_ID INSTANCE_NUMBER INSTANCE_NAME

---------- --------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 1 DRHRMS
drhrmsdb01
11.2.0.4.0 07-JUL-17 MOUNTED NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

--------- -------------------- ------------ ----------------
HRMS MOUNTED ARCHIVELOG PHYSICAL STANDBY
BANNER
--------------------------------------------------------------------------------
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
SQL>
SQL> show parameter spfile;
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string
SQL>
SQL>
SQL> !pwd
/oracle
SQL> create spfile='/oracle/initHRMSDR_BKP' from pfile;

File created.
SQL> !more /oracle/initHRMSDR_BKP

C"Vp08�k�C
C"eb*.audit_file_dest='/u01/app/oracle/product/11.2.0/db_1/rdbms/audit'
*.cluster_database=false
*.control_files='+DATA_DG/drhrms/controlfile/current.507.948739715'
*.DB_CREATE_FILE_DEST='+DATA_DG'
*.db_files=1024
*.db_name='hrms'
*.db_unique_name='drhrms'
*.diagnostic_dest='/u01/app/oracle'
*.fal_server='HRMS'
*.log_archive_config='dg_config=(hrms,drhrms)'
*.log_archive_dest_1='LOCCC"lATION=+ARCH_DG'
*.log_archive_dest_2='SERVICE=HRMS NOAFFIRM ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=HRMS'
*.log_archive_dest_state_2='defer'
*.log_archive_max_processes=10
*.nls_length_semantics='CHAR'
*.open_cursors=1000
*.pga_aggregate_target=1G
*.processes=2000
*.remote_login_passwordfile='exclusive'
*.sec_case_sensitive_logon=FALSE
*.sessions=2205
*.sga_target=4G
*.standby_file_managemenCC"='AUTO'
*.thread=1
*.undo_retention=900
CC""
CC"!
CC"
C
SQL> PuTTY
SP2-0042: unknown command "PuTTY" - rest of line ignored.
SQL>
SQL>
SQL> create pfile='/oracle/initHRMSDR_BKP_PFILE.ora' from spfile;
create pfile='/oracle/initHRMSDR_BKP_PFILE.ora' from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/[email protected]'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> create pfile='/oracle/initHRMSDR_BKP_PFILE.ora' from memory;

File created.
SQL> !more /oracle/initHRMSDR_BKP_PFILE.ora

# Oracle init.ora parameter file generated by instance DRHRMS on 07/28/2017
20:56:47
__db_cache_size=3248M
__java_pool_size=32M
__large_pool_size=32M
__oracle_base='/u01/app/oracle' # ORACLE_BASE set from environment
__pga_aggregate_target=1G
__sga_target=4G
__shared_io_pool_size=0
__shared_pool_size=752M
__streams_pool_size=0
_aggregation_optimization_settings=0
_always_anti_join='CHOOSE'
_always_semi_join='CHOOSE'
_and_pruning_enabled=TRUE
_b_tree_bitmap_plans=TRUE
_bloom_filter_enabled=TRUE
_bloom_folding_enabled=TRUE
_bloom_pruning_enabled=TRUE
_complex_view_merging=TRUE
_compression_compatibility='11.2.0.0.0'
_connect_by_use_union_all='TRUE'
_convert_set_to_join=FALSE
_cost_equality_semi_join=TRUE
_cpu_to_io=0
_dimension_skip_null=TRUE
_eliminate_common_subexpr=TRUE
_enable_type_dep_selectivity=TRUE
_fast_full_scan_enabled=TRUE
_first_k_rows_dynamic_proration=TRUE
_gby_hash_aggregation_enabled=TRUE
_generalized_pruning_enabled=TRUE
_globalindex_pnum_filter_enabled=TRUE
_gs_anti_semi_join_allowed=TRUE
_improved_outerjoin_card=TRUE
_improved_row_length_enabled=TRUE
_index_join_enabled=TRUE
_ksb_restart_policy_times='0'
_ksb_restart_policy_times='240' # internal update to set default
_left_nested_loops_random=TRUE
_local_communication_costing_enabled=TRUE
_minimal_stats_aggregation=TRUE
_mmv_query_rewrite_enabled=TRUE
_new_initial_join_orders=TRUE
_new_sort_cost_estimate=TRUE
_nlj_batching_enabled=1
_optim_adjust_for_part_skews=TRUE
_optim_enhance_nnull_detection=TRUE
_optim_new_default_join_sel=TRUE
_optim_peek_user_binds=TRUE
_optimizer_adaptive_cursor_sharing=TRUE
_optimizer_better_inlist_costing='ALL'
_optimizer_cbqt_no_size_restriction=TRUE
_optimizer_coalesce_subqueries=TRUE
_optimizer_complex_pred_selectivity=TRUE
_optimizer_compute_index_stats=TRUE
_optimizer_connect_by_combine_sw=TRUE
_optimizer_connect_by_cost_based=TRUE
_optimizer_connect_by_elim_dups=TRUE
_optimizer_correct_sq_selectivity=TRUE
_optimizer_cost_based_transformation='LINEAR'
_optimizer_cost_hjsmj_multimatch=TRUE
_optimizer_cost_model='CHOOSE'
_optimizer_dim_subq_join_sel=TRUE
_optimizer_distinct_agg_transform=TRUE
_optimizer_distinct_elimination=TRUE
_optimizer_distinct_placement=TRUE
_optimizer_eliminate_filtering_join=TRUE
_optimizer_enable_density_improvements=TRUE
_optimizer_enable_extended_stats=TRUE
_optimizer_enable_table_lookup_by_nl=TRUE
_optimizer_enhanced_filter_push=TRUE
_optimizer_extend_jppd_view_types=TRUE
_optimizer_extended_cursor_sharing='UDO'
_optimizer_extended_cursor_sharing_rel='SIMPLE'
_optimizer_extended_stats_usage_control=192
_optimizer_false_filter_pred_pullup=TRUE
_optimizer_fast_access_pred_analysis=TRUE
_optimizer_fast_pred_transitivity=TRUE
_optimizer_filter_pred_pullup=TRUE
_optimizer_fkr_index_cost_bias=10
_optimizer_full_outer_join_to_outer=TRUE
_optimizer_group_by_placement=TRUE
_optimizer_improve_selectivity=TRUE
_optimizer_interleave_jppd=TRUE
_optimizer_join_elimination_enabled=TRUE
_optimizer_join_factorization=TRUE
_optimizer_join_order_control=3
_optimizer_join_sel_sanity_check=TRUE
_optimizer_max_permutations=2000
_optimizer_mode_force=TRUE
_optimizer_multi_level_push_pred=TRUE
_optimizer_native_full_outer_join='FORCE'
_optimizer_new_join_card_computation=TRUE
_optimizer_null_aware_antijoin=TRUE
_optimizer_or_expansion='DEPTH'
_optimizer_order_by_elimination_enabled=TRUE
_optimizer_outer_join_to_inner=TRUE
_optimizer_outer_to_anti_enabled=TRUE
_optimizer_push_down_distinct=0
_optimizer_push_pred_cost_based=TRUE
_optimizer_rownum_bind_default=10
_optimizer_rownum_pred_based_fkr=TRUE
_optimizer_skip_scan_enabled=TRUE
_optimizer_sortmerge_join_inequality=TRUE
_optimizer_squ_bottomup=TRUE
_optimizer_star_tran_in_with_clause=TRUE
_optimizer_system_stats_usage=TRUE
_optimizer_table_expansion=TRUE
_optimizer_transitivity_retain=TRUE
_optimizer_try_st_before_jppd=TRUE
_optimizer_undo_cost_change='11.2.0.4'
_optimizer_unnest_corr_set_subq=TRUE
_optimizer_unnest_disjunctive_subq=TRUE
_optimizer_use_cbqt_star_transformation=TRUE
_optimizer_use_feedback=TRUE
_or_expand_nvl_predicate=TRUE
_ordered_nested_loop=TRUE
_parallel_broadcast_enabled=TRUE
_partition_view_enabled=TRUE
_pivot_implementation_method='CHOOSE'
_pre_rewrite_push_pred=TRUE
_pred_move_around=TRUE
_push_join_predicate=TRUE
_push_join_union_view=TRUE
_push_join_union_view2=TRUE
_px_minus_intersect=TRUE
_px_partition_scan_enabled=TRUE
_px_pwg_enabled=TRUE
_px_ual_serial_input=TRUE
_query_rewrite_setopgrw_enable=TRUE
_remove_aggr_subquery=TRUE
_replace_virtual_columns=TRUE
_right_outer_hash_enable=TRUE
_selfjoin_mv_duplicates=TRUE
_sql_model_unfold_forloops='RUN_TIME'
_subquery_pruning_enabled=TRUE
_subquery_pruning_mv_enabled=FALSE
_table_scan_cost_plus_one=TRUE
_union_rewrite_for_gs='YES_GSET_MVS'
_unnest_subquery=TRUE
_use_column_stats_for_function=TRUE
audit_file_dest='/u01/app/oracle/product/11.2.0/db_1/rdbms/audit'
background_dump_dest='/u01/app/oracle/diag/rdbms/drhrms/DRHRMS/trace' #Deprecate
parameter
cluster_database=FALSE
compatible='11.2.0.0.0'
control_files='+DATA_DG/drhrms/controlfile/current.507.948739715'
core_dump_dest='/u01/app/oracle/diag/rdbms/drhrms/DRHRMS/cdump'
db_block_size=8192
db_create_file_dest='+DATA_DG'
db_file_multiblock_read_count=16
db_files=1024
db_name='hrms'
db_unique_name='drhrms'
diagnostic_dest='/u01/app/oracle'
fal_server='HRMS'
job_queue_processes=10
log_archive_config='dg_config=(hrms,drhrms)'
log_archive_dest_1='LOCATION=+ARCH_DG'
log_archive_dest_2='SERVICE=HRMS NOAFFIRM ASYNC
log_archive_dest_state_1='enable'
log_archive_dest_state_2='defer'
log_archive_format='%t_%s_%r.dbf'
log_archive_max_processes=10
log_buffer=12943360 # log buffer update
nls_length_semantics='CHAR'
open_cursors=1000
optimizer_dynamic_sampling=2
optimizer_mode='ALL_ROWS'
pga_aggregate_target=1G
plsql_warnings='DISABLE:ALL' # PL/SQL warnings at init.ora
processes=2000
query_rewrite_enabled='TRUE'
remote_login_passwordfile='EXCLUSIVE'
result_cache_max_size=20992K
sec_case_sensitive_logon=FALSE
sessions=3024
sga_target=4G
skip_unusable_indexes=TRUE
standby_file_management='AUTO'
thread=1
undo_management='AUTO'
undo_retention=900
undo_tablespace='UNDOTBS1'
user_dump_dest='/u01/app/oracle/diag/rdbms/drhrms/DRHRMS/trace' #Deprecate
parameter
SQL>
SQL>
SQL> pwd
SP2-0042: unknown command "pwd" - rest of line ignored.
SQL> exit
Production
Connected to:
SQL> sho parameter dump
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
background_dump_dest string /u01/app/oracle/diag/rdbms/drh
rms/DRHRMS/trace
core_dump_dest string /u01/app/oracle/diag/rdbms/drh
rms/DRHRMS/cdump
user_dump_dest string /u01/app/oracle/diag/rdbms/drh
rms/DRHRMS/trace
SQL> exit
Production
[oracle][DRHRMS]$
[oracle][DRHRMS]$
[oracle][DRHRMS]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
[oracle][DRHRMS]$ ls -lrt
total 155306
-rwxrwxrwx 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 24 Sep 12 2015 lkDRHRMS
-rwxr-xr-x 1 oracle dba 1384 Sep 14 2015 initdrhrms.ora_14092015
-rw-r----- 1 oracle dba 2560 Sep 14 2015 orapwdrhrms_old
-rw-r----- 1 oracle dba 30572544 Sep 16 2015 c-707347879-20150916-00
-rwxr-xr-x 1 oracle dba 1036 Oct 2 2015 initdrhrms.ora_02102015
-rwxrwxrwx 1 oracle dba 1036 Oct 2 2015 initdrhrms.ora_old
-rw-r----- 1 oracle dba 2560 Oct 5 2015 orapwhrms1
-rw-r----- 1 oracle dba 2560 Oct 5 2015 orapwDRHRMS
-rwxr-xr-x 1 oracle dba 1030 Jul 6 15:57 initDRHRMS.ora_bkp7jul17
-rwxr-xr-x 1 oracle dba 1071 Jul 7 18:51 initDRHRMS.ora
-rw-r----- 1 oracle dba 48742400 Jul 9 17:50 snapcf_DRHRMS.f
-rw-rw---- 1 oracle dba 1544 Jul 24 23:42 hc_DRHRMS.dat
[oracle][DRHRMS]$ more initDRHRMS.ora
*.audit_file_dest='/u01/app/oracle/product/11.2.0/db_1/rdbms/audit'
*.fal_server='HRMS'
*.db_files=1024
*.db_name='hrms'
*.log_archive_dest_1='LOCATION=+ARCH_DG'
*.open_cursors=1000
*.processes=2000
*.sessions=2205
*.sga_target=4G
*.thread=1
[oracle][DRHRMS]$ cp -rP initDRHRMS.ora initDRHRMS.ora_BKP_28072017
[oracle][DRHRMS]$ ls- lrt
bash: ls-: command not found
[oracle][DRHRMS]$ ls -lrt
total 155307
-rwxrwxrwx 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 24 Sep 12 2015 lkDRHRMS
-rwxr-xr-x 1 oracle dba 1384 Sep 14 2015 initdrhrms.ora_14092015
-rw-r----- 1 oracle dba 2560 Sep 14 2015 orapwdrhrms_old
-rw-r----- 1 oracle dba 30572544 Sep 16 2015 c-707347879-20150916-00
-rwxr-xr-x 1 oracle dba 1036 Oct 2 2015 initdrhrms.ora_02102015
-rwxrwxrwx 1 oracle dba 1036 Oct 2 2015 initdrhrms.ora_old
-rw-r----- 1 oracle dba 2560 Oct 5 2015 orapwhrms1
-rw-r----- 1 oracle dba 2560 Oct 5 2015 orapwDRHRMS
-rwxr-xr-x 1 oracle dba 1030 Jul 6 15:57 initDRHRMS.ora_bkp7jul17
-rw-r----- 1 oracle dba 48742400 Jul 9 17:50 snapcf_DRHRMS.f
-rwxr-xr-x 1 oracle dba 1071 Jul 28 20:59 initDRHRMS.ora_BKP_28072017
[oracle][DRHRMS]$ more initDRHRMS.ora_BKP_28072017
*.fal_server='HRMS'
*.db_files=1024
*.db_name='hrms'
*.open_cursors=1000
*.processes=2000
*.sessions=2205
*.sga_target=4G
*.thread=1
[oracle][DRHRMS]$
-rwxr-xr-x 1 oracle dba 1071 Jul 28 20:59 initDRHRMS.ora_BKP_28072017

[oracle][DRHRMS]$ more initDRHRMS.ora
*.fal_server='HRMS'
*.db_files=1024
*.db_name='hrms'
*.open_cursors=1000
*.processes=2000
*.sessions=2205
*.sga_target=4G
*.thread=1
[oracle][DRHRMS]$
[oracle][DRHRMS]$
Connected to an idle instance.
SQL> startup nomount;

Total System Global Area 4277059584 bytes

SQL> alter database mount standby database;
Database altered.
BANNER
--------------------------------------------------------------------------------
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

------------------------- ---------- ------------------------- ----------
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

------------------------- -------------------- ------------ ----------------
HRMS MOUNTED ARCHIVELOG PHYSICAL STANDBY
Fri Jul 28 21:18:28 2017

Instance shutdown complete (node1)
Fri Jul 28 21:31:22 2017

Completed: ALTER DATABASE OPEN
Fri Jul 28 21:19:24 2017

Instance shutdown complete (node2)
Completed: ALTER DATABASE OPEN

Fri Jul 28 21:31:23 2017
*.compatible='12.2.0.1'

knowledge_base_Compatible

Uploaded by

Copyright:

Available Formats

knowledge_base_Compatible

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

knowledge_base_Compatible

Uploaded by

Copyright:

Available Formats

10.91.35.

SQL> select * from v$version;

SQL> set lines 167 pages 1000

NAME TYPE VALUE ISMODIFIED

SQL> show parameter compatible

NAME TYPE VALUE

NAME OPEN_MODE LOG_MODE DATABASE_ROLE

[oracrm@crmupgdb][crm]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 28 19:28:25 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> select * from v$version;

SQL> set lines 167 pages 1000

NAME TYPE VALUE ISMODIFIED

SQL> show parameter compatible

NAME TYPE VALUE

NAME OPEN_MODE LOG_MODE DATABASE_ROLE

SQL> show parameter dump

NAME TYPE VALUE

NAME TYPE VALUE

SQL> create pfile='/oracle/initCRM_BKP.ora' from spfile;

SQL> !more /oracle/initCRM_BKP.ora

SQL> recover managed standby database cancel;

NAME TYPE VALUE

SQL> show parameter compatible

NAME TYPE VALUE

NAME TYPE VALUE ISMODIFIED

SQL> shut immediate;

SQL> show parameter compatible

NAME TYPE VALUE

NAME TYPE VALUE ISMODIFIED

SQL> alter database recover standby database disconnect from session;

SQL> recover mangaged standby database disconnect from session;

SQL> select * from gv$instance;

INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME

SQL> select name,open_mode,log_mode,database_role from v$database;

NAME OPEN_MODE LOG_MODE DATABASE_ROLE

SQL> select NAME,TYPE,VALUE,ISMODIFIED from v$parameter where name='compatible';

SQL> show parameter compatible

NAME TYPE VALUE

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 28 19:39:48 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> show parameter compatible

NAME TYPE VALUE

SQL> create pfile='/oracle/initCRM_BKP_After.ora' from spfile;

SQL> !more /oracle/initCRM_BKP_After.ora

SQL> select * from gv$instance;

INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION

SQL> show parameter compatible

NAME TYPE VALUE

NAME OPEN_MODE LOG_MODE DATABASE_ROLE

SQL> select NAME,TYPE,VALUE,ISMODIFIED from v$parameter where name='compatible';

SQL> show parameter dump

NAME TYPE VALUE

NAME TYPE VALUE

SQL> create pfile='/oracle_bi/aj_scripts/monitoring/initCRM_SAFE.ora' from spfil

SQL> !more /oracle_bi/aj_scripts/monitoring/initCRM_SAFE.ora

NAME TYPE VALUE

SQL> show parameter compatible;

NAME TYPE VALUE

Total System Global Area 1.0693E+10 bytes