Search This Blog

Total Pageviews

Saturday, 24 January 2015

Oracle export as sysdba

Oracle export as sysdba


How to use "/ as sysdba" to exp and imp
How to use / as sysdba to exp
exp userid=\'/ as sysdba\'


*************************************************************************************************
-bash-4.1$ !sql
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 24 17:54:11 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> def
DEFINE _DATE           = "24-JAN-15" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihaan" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR         = "ed" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1201000100" (CHAR)


***********************************************************************************************************

parafile 

-bash-4.1$ cat exp.par
file=mydump.dmp
userid="/ as sysdba"               <<<<<<<<<<----- with sys user 
compress=n
log=mydump.log
direct=y
full=n
owner=TEST
consistent=y
feedback=10000



-bash-4.1$ exp parfile=exp.par

Export: Release 12.1.0.1.0 - Production on Sat Jan 24 17:51:53 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
EXP-00105: parameter CONSISTENT is not supported for this user
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Direct Path ...
. . exporting table                           TEST
                                                         2803 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.


done .....


-bash-4.1$ ls -ltr *.dmp
-rw-r--r-- 1 oracle oinstall 876544 Jan 24 17:52 mydump.dmp

Posted by at No comments:

Monday, 19 January 2015

INS-40922 Invalid Scan Name - Unresolvable to IP address

INS-40922 Invalid Scan Name - Unresolvable to IP address in Grid installation 

Include scan IPs in host file and try again

nslookup mrac-scan
Server:        127.0.0.1
Address:    127.0.0.1#53

Name:    rac-scan
Address: 192.168.0.153
Name:    rac-scan
Address: 192.168.0.154
Name:    rac-scan
Address: 192.168.0.155


on all nodes

cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
################################################################
####### ---------------   eth0 - PUBLIC ------------ ###########
################################################################
192.168.0.49      mrac1.localdomain            mrac1
192.168.0.50      mrac2.localdomain            mrac2
################################################################
####### ---------------- eth1 priv------------------ ###########
################################################################
192.168.1.49       mrac1-priv.localdomain   mrac1-priv
192.168.1.50       mrac2-priv.localdomain   mrac2-priv
################################################################
####### -----------------VIP------------------------ ###########
################################################################
192.168.0.151      mrac1-vip.localdomain        mrac1-vip
192.168.0.152      mrac2-vip.localdomain        mrac2-vip
#################################################################
#                   SCAN IP           #########################################
################################################################
192.168.0.153 mrac-scan.localdomain mrac-scan
192.168.0.154 mrac-scan.localdomain mrac-scan
192.168.0.155 mrac-scan.localdomain mrac-scan
#################################################################








Posted by at No comments:

Monday, 17 November 2014

ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation 

error
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation
FROM  ."GGS_SETUP" ERROR at line 2: ORA-00942: table or view does not exist
FROM "GGATE" ."GGS_SETUP" ERROR at line 2:ORA-00942: table or view does not exist



error in GoldenGate while setting up ....

[oracle@db ~]$ cd /u01/app/oracle/product/gg/
[oracle@db gg]$ sqlplus / as sysdba

SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @ddl_enable.sql


ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation
FROM  ."GGS_SETUP" ERROR at line 2: ORA-00942: table or view does not exist
FROM "GGATE" ."GGS_SETUP" ERROR at line 2:ORA-00942: table or view does not exist




DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED
FROM "GGATE" ."GGS_SETUP"
              *
ERROR at line 2:
ORA-00942: table or view does not exist


FROM "GGATE" ."GGS_SETUP"
              *
ERROR at line 2:
ORA-00942: table or view does not exist


FROM "GGATE" ."GGS_SETUP"
              *
ERROR at line 2:
ORA-00942: table or view does not exist



==============================
solution 

drop this trigger 
as sys

SQL> drop TRIGGER SYS.GGS_DDL_TRIGGER_BEFORE ;

Trigger dropped.


grant following 
SQL> grant create any table to ggate;
grant create any view to ggate;
grant create any procedure to ggate;
grant create any sequence to ggate;
grant create any index to ggate;
grant create any trigger to ggate;
grant create any view to ggate;



Check this shold be true
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication        boolean     TRUE




[oracle@db ~]$ cd /u01/app/oracle/product/gg/
[oracle@db gg]$ sqlplus / as sysdba

SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @ddl_enable.sql


our user ggate ...



SQL>  @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ggate

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

Check complete.







Using GGATE as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGATE

CLEAR_TRACE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

CREATE_TRACE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

TRACE_PUT_LINE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

INITIAL_SETUP STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL IGNORE TABLE
-----------------------------------
OK

DDL IGNORE LOG TABLE
-----------------------------------
OK

DDLAUX  PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

SYS.DDLCTXINFO  PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

SYS.DDLCTXINFO  PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL HISTORY TABLE
-----------------------------------
OK

DDL HISTORY TABLE(1)
-----------------------------------
OK

DDL DUMP TABLES
-----------------------------------
OK

DDL DUMP COLUMNS
-----------------------------------
OK

DDL DUMP LOG GROUPS
-----------------------------------
OK

DDL DUMP PARTITIONS
-----------------------------------
OK

DDL DUMP PRIMARY KEYS
-----------------------------------
OK

DDL SEQUENCE
-----------------------------------
OK

GGS_TEMP_COLS
-----------------------------------
OK

GGS_TEMP_UK
-----------------------------------
OK

DDL TRIGGER CODE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED

STAYMETADATA IN TRIGGER
-----------------------------------
OFF

DDL TRIGGER SQL TRACING
-----------------------------------
0

DDL TRIGGER TRACE LEVEL
-----------------------------------
0

LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/vihaan/vihaan/trace/ggs_ddl_trace.log

Analyzing installation status...


STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

Script complete.
SQL> @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ggate

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

Check complete.


Using GGATE as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGATE

CLEAR_TRACE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

CREATE_TRACE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

TRACE_PUT_LINE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

INITIAL_SETUP STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL IGNORE TABLE
-----------------------------------
OK

DDL IGNORE LOG TABLE
-----------------------------------
OK

DDLAUX  PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

SYS.DDLCTXINFO  PACKAGE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

SYS.DDLCTXINFO  PACKAGE BODY STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL HISTORY TABLE
-----------------------------------
OK

DDL HISTORY TABLE(1)
-----------------------------------
OK

DDL DUMP TABLES
-----------------------------------
OK

DDL DUMP COLUMNS
-----------------------------------
OK

DDL DUMP LOG GROUPS
-----------------------------------
OK

DDL DUMP PARTITIONS
-----------------------------------
OK

DDL DUMP PRIMARY KEYS
-----------------------------------
OK

DDL SEQUENCE
-----------------------------------
OK

GGS_TEMP_COLS
-----------------------------------
OK

GGS_TEMP_UK
-----------------------------------
OK

DDL TRIGGER CODE STATUS:

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors

DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED

STAYMETADATA IN TRIGGER
-----------------------------------
OFF

DDL TRIGGER SQL TRACING
-----------------------------------
0

DDL TRIGGER TRACE LEVEL
-----------------------------------
0

LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/vihaan/vihaan/trace/ggs_ddl_trace.log

Analyzing installation status...


STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

Script complete.
SQL> @role_setup.sql

GGS Role setup script

This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:ggate
Wrote file role_setup_set.txt

PL/SQL procedure successfully completed.


Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO <loggedUser>

where <loggedUser> is the user assigned to the GoldenGate processes.
SQL> grant GGS_GGSUSER_ROLE to ggate;

Grant succeeded.

SQL> @ddl_enable.sql

Trigger altered.

Posted by at 2 comments:

Saturday, 15 November 2014

Search string in database


Oracle find string or number in the database

search string
find text in database



set serveroutput on size 1000000
accept string char prompt "Enter Char String to search for:"
accept owner_name prompt "Enter Owner Name:"

set term off
set verify off
set lines 80
set feedback off

spool find_string.tmp

prompt spool find_string.out
prompt set feedback off
prompt set pages 1000
prompt set lines 132
prompt set wrap on
prompt break on found_in skip 1
prompt col found_in format a55 heading "Found In .."
prompt col string format a70 heading "String Found"
-- prompt col row_id format 99999999999999999999
prompt set term on
prompt 

declare

cursor varchar_tables_cur IS
select owner
, table_name
, column_name
from dba_tab_columns
where owner != 'SYS'
and owner != 'SYSTEM'
and owner = upper('&OWNER_NAME')
and data_type in ( 'VARCHAR2','VARCHAR','CHAR');

begin
for v_t_rec in varchar_tables_cur loop
dbms_output.put_line('--');
-- dbms_output.put_line('prompt '||v_t_rec.owner||'.'||v_t_rec.table_name||'.'||v_t_rec.column_name||'');
dbms_output.put('select '''||v_t_rec.owner||'.'||v_t_rec.table_name||'.'||v_t_rec.column_name||''' Found_In ,');
dbms_output.new_line;
dbms_output.put(''||v_t_rec.column_name||' String ');
dbms_output.new_line;
-- dbms_output.put_line('rowid Row_id ');
dbms_output.put_line('from '||v_t_rec.owner||'.'||v_t_rec.table_name||'');
dbms_output.put_line('where '||v_t_rec.column_name||' like '||chr(39)||'&string'||chr(39)||'');
dbms_output.put_line('/'); 
end loop;
end;
/

prompt spool off
prompt prompt ====> created file find_string.out for your review

spool off

@find_string.tmp


===


-- set term off
set verify off
set lines 80
set feedback off
set serveroutput on


spool find_string.tmp


prompt spool find_string.out
prompt set feedback off
prompt set pages 1000
prompt set lines 132
prompt set wrap on
prompt break on found_in skip 1
prompt col found_in format a55 heading "Found In .."
prompt col string format a70 heading "String Found"
-- prompt col row_id format 99999999999999999999
prompt set term on
prompt

declare
cursor varchar_tables_cur IS
select table_name,
column_name
from user_tab_columns a, user_objects b
where data_type in ( 'VARCHAR2','VARCHAR','CHAR')
and object_name=table_name
and object_type='TABLE' ;
-- and a.OWNER not in ('SYS','SYSTEM') ;
begin
for v_t_rec in varchar_tables_cur loop
dbms_output.put_line('--');
-- dbms_output.put_line('prompt '||v_t_rec.table_name||'.'||v_t_rec.column_name||'');
dbms_output.put('select distinct'''||v_t_rec.table_name||'.'||v_t_rec.column_name||''' Found_In ,');
dbms_output.new_line;
dbms_output.put(''||v_t_rec.column_name||' String ');
dbms_output.new_line;
-- dbms_output.put_line('rowid Row_id ');
dbms_output.put_line('from '||v_t_rec.table_name||'');
dbms_output.put_line('where '||v_t_rec.column_name||' like '||chr(39)||'&string'||chr(39)||'');
dbms_output.put_line('/');
end loop;
end;
/

prompt spool off
prompt prompt ====> created file find_string.out for your review

spool off

@find_string.tmp
===
Oracle search string from a database 

-- set term off
set verify off
set lines 80
set feedback off
set serveroutput on


spool find_string.tmp


prompt spool find_string.out
prompt set feedback off
prompt set pages 1000
prompt set lines 132
prompt set wrap on
prompt break on found_in skip 1
prompt col found_in format a55 heading "Found In .."
prompt col string format a70 heading "String Found"
-- prompt col row_id format 99999999999999999999
prompt set term on
prompt

declare
cursor varchar_tables_cur IS
select table_name,a.owner owner, column_name
-- from user_tab_columns a, user_objects b
from dba_tab_columns a, dba_objects b
where data_type in ( 'VARCHAR2','VARCHAR','CHAR')
and object_name=table_name
and object_type='TABLE'
and a.OWNER not in ('SYS','SYSTEM') ;
begin
for v_t_rec in varchar_tables_cur loop
dbms_output.put_line('--');
-- dbms_output.put_line('prompt '||v_t_rec.table_name||'.'||v_t_rec.column_name||'');
dbms_output.put('select distinct'''||v_t_rec.table_name||'.'||v_t_rec.column_name||''' Found_In ,');
dbms_output.new_line;
dbms_output.put(''||v_t_rec.column_name||' String ');
dbms_output.new_line;
-- dbms_output.put_line('rowid Row_id ');
dbms_output.put_line('from '||v_t_rec.owner||'.'||v_t_rec.table_name||'');
dbms_output.put_line('where '||v_t_rec.column_name||' like '||chr(39)||'&string'||chr(39)||'');
dbms_output.put_line('/');
end loop;
end;
/

prompt spool off
prompt prompt ====> created file find_string.out for your review

spool off

@find_string.tmp

====
set serveroutput on size 1000000
accept string char prompt "Enter Char String to search for:"
accept owner_name prompt "Enter Owner Name:"

set term off
set verify off
set lines 80
set feedback off

spool find_string.tmp

prompt spool c:\temp\find_string.out
prompt set feedback off
prompt set pages 1000
prompt set lines 132
prompt set wrap on
prompt break on found_in skip 1
prompt col found_in format a55 heading "Found In
.."
p rompt col string format a70 heading "String Found"
-- prompt col row_id format 99999999999999999999
prompt set term on
prompt

declare

cursor varchar_tables_cur IS
select owner
, table_name
, column_name
from dba_tab_columns
where owner != 'SYS'
and owner != 'SYSTEM'
and owner = '&OWNER_NAME'
and data_type in ( 'VARCHAR2','VARCHAR','CHAR');

begin
for v_t_rec in varchar_tables_cur loop
dbms_output.put_line('--');
-- dbms_output.put_line('prompt '||v_t_rec.owner||'.'||v_t_rec.table_name||'.'||v_t_rec.column_n ame||'');
dbms_output.put('select '''||v_t_rec.owner||'.'||v_t_rec.table_name||'.'||v_t_rec.column_name||''' Found_In ,');
dbms_output.new_line;
dbms_output.put(''||v_t_rec.column_name||' String ');
dbms_output.new_line;
-- dbms_output.put_line('rowid Row_id ');
dbms_output.put_line('from '||v_t_rec.owner||'.'||v_t_rec.table_name||'');
dbms_output.put_line('where '||v_t_rec.column_name||' like '||chr(39)||'%&string%'||chr(39)||'');
dbms_output.put_line('/');
end loop;
end;
/

prompt spool off
prompt prompt ====> created file find_string.out for your review

spool off

@find_string.tmp

Posted by at No comments:

sqlplus set vi editor



vi editor in sqlplus   ..
vi editor in sqlplus 

 EDITOR=vi; export EDITOR    in .profile file 
Posted by at 1 comment:

Friday, 14 November 2014

Oracle software download

Posted by at No comments:

Saturday, 8 November 2014

Oracle Parameter info 


Oracle Parameter info  

set termout off
store set sqlplus_settings replace
set serveroutput on size 1000000 linesize 132 pagesize 120  termout off verify off head off
ttitle off
btitle off
clear columns
clear breaks
column param_name format a40 heading "Parameter Name"
column param_value format a38 heading "Parameter Value" word_wrap
column isdefault format a7 heading "Default|Value"
column ismod heading "Is|Modified"
column isses_modifiable format a10 heading "Session|Modifiable"
column issys_modifiable format a10 heading "System|Modifiable"
-- Get database name and store in variable
column name new_value s_dbname
SELECT rtrim(name) name from v$database;
-- Get today's date
column today new_value s_curDate
SELECT to_char(sysdate, 'Month DD, YYYY') today from dual;
-- Get host name and store in variable
column host_name new_value s_machine
SELECT host_name from v$instance;
set termout  feedback off  head on
spool databaseParametersInfo_&s_dbname._&s_machine
ttitle left &s_curDate -
center "List of Database Parameters in Instance " &s_dbname " on " &s_machine skip 2
select name param_name, 
value param_value, 
isdefault,
ismodified ismod, 
isses_modifiable,
issys_modifiable
from v$parameter
where value is not null
order by param_name;
spool off
ttitle off
btitle off
clear columns
clear breaks
set feedback on termout on  verify on 

  List of Database Parameters in Instance VIHAAN on ora-gold1

                                                                                Default Is         Session    System
Parameter Name                           Parameter Value                        Value   Modified   Modifiable Modifiable
---------------------------------------- -------------------------------------- ------- ---------- ---------- ----------
DBFIPS_140                               FALSE                                  TRUE    FALSE      FALSE      FALSE
O7_DICTIONARY_ACCESSIBILITY              FALSE                                  TRUE    FALSE      FALSE      FALSE
aq_tm_processes                          1                                      TRUE    FALSE      FALSE      IMMEDIATE
archive_lag_target                       0                                      FALSE   FALSE      FALSE      IMMEDIATE
asm_power_limit                          1                                      TRUE    FALSE      TRUE       IMMEDIATE
audit_file_dest                          /u01/app/oracle/admin/vihaan/adump     FALSE   FALSE      FALSE      DEFERRED
audit_sys_operations                     TRUE                                   TRUE    FALSE      FALSE      FALSE
audit_trail                              DB                                     FALSE   FALSE      FALSE      FALSE
awr_snapshot_time_offset                 0                                      TRUE    FALSE      FALSE      IMMEDIATE
background_core_dump                     partial                                TRUE    FALSE      FALSE      FALSE
background_dump_dest                     /u01/app/oracle/product/12.1.0/db_1/rd TRUE    FALSE      FALSE      IMMEDIATE
                                         bms/log

backup_tape_io_slaves                    FALSE                                  TRUE    FALSE      FALSE      DEFERRED
bitmap_merge_area_size                   1048576                                TRUE    FALSE      FALSE      FALSE
blank_trimming                           FALSE                                  TRUE    FALSE      FALSE      FALSE
cell_offload_compaction                  ADAPTIVE                               TRUE    FALSE      TRUE       IMMEDIATE
cell_offload_decryption                  TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
cell_offload_plan_display                AUTO                                   TRUE    FALSE      TRUE       IMMEDIATE
cell_offload_processing                  TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
client_result_cache_lag                  3000                                   TRUE    FALSE      FALSE      FALSE
client_result_cache_size                 0                                      TRUE    FALSE      FALSE      FALSE
clonedb                                  FALSE                                  TRUE    FALSE      FALSE      FALSE
cluster_database                         FALSE                                  TRUE    FALSE      FALSE      FALSE
cluster_database_instances               1                                      TRUE    FALSE      FALSE      FALSE
commit_point_strength                    1                                      TRUE    FALSE      FALSE      FALSE
common_user_prefix                       C##                                    TRUE    FALSE      FALSE      FALSE
compatible                               12.1.0.2.0                             FALSE   FALSE      FALSE      FALSE
connection_brokers                       ((TYPE=DEDICATED)(BROKERS=1)),         TRUE    FALSE      FALSE      IMMEDIATE
                                         ((TYPE=EMON)(BROKERS=1))

control_file_record_keep_time            7                                      TRUE    FALSE      FALSE      IMMEDIATE
control_files                            /u01/app/oracle/oradata/VIHAAN/control FALSE   FALSE      FALSE      FALSE
                                         file/o1_mf_b282tp9s_.ctl,
                                         /u01/app/oracle/fast_recovery_area/VIH
                                         AAN/controlfile/o1_mf_b282tpl6_.ctl

control_management_pack_access           DIAGNOSTIC+TUNING                      TRUE    FALSE      FALSE      IMMEDIATE
core_dump_dest                           /u01/app/oracle/diag/rdbms/vihaan_prim TRUE    FALSE      FALSE      IMMEDIATE
                                         /vihaan/cdump

cpu_count                                1                                      TRUE    FALSE      FALSE      IMMEDIATE
create_bitmap_area_size                  8388608                                TRUE    FALSE      FALSE      FALSE
cursor_bind_capture_destination          memory+disk                            TRUE    FALSE      TRUE       IMMEDIATE
cursor_sharing                           EXACT                                  TRUE    FALSE      TRUE       IMMEDIATE
cursor_space_for_time                    FALSE                                  TRUE    FALSE      FALSE      FALSE
db_16k_cache_size                        0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_2k_cache_size                         0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_32k_cache_size                        0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_4k_cache_size                         0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_8k_cache_size                         0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_big_table_cache_percent_target        0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_block_buffers                         0                                      TRUE    FALSE      FALSE      FALSE
db_block_checking                        FALSE                                  TRUE    FALSE      FALSE      IMMEDIATE
db_block_checksum                        TYPICAL                                TRUE    FALSE      FALSE      IMMEDIATE
db_block_size                            8192                                   FALSE   FALSE      FALSE      FALSE
db_cache_advice                          ON                                     TRUE    FALSE      FALSE      IMMEDIATE
db_cache_size                            0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_create_file_dest                      /u01/app/oracle/oradata                FALSE   FALSE      TRUE       IMMEDIATE
db_file_multiblock_read_count            53                                     TRUE    FALSE      TRUE       IMMEDIATE
db_files                                 200                                    TRUE    FALSE      FALSE      FALSE
db_flash_cache_size                      0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_flashback_retention_target            1440                                   TRUE    FALSE      FALSE      IMMEDIATE
db_index_compression_inheritance         NONE                                   TRUE    FALSE      TRUE       IMMEDIATE
db_keep_cache_size                       0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_lost_write_protect                    NONE                                   TRUE    FALSE      FALSE      IMMEDIATE
db_name                                  vihaan                                 FALSE   FALSE      FALSE      FALSE
db_recovery_file_dest                    /u01/app/oracle/fast_recovery_area     FALSE   FALSE      FALSE      IMMEDIATE
db_recovery_file_dest_size               4781506560                             FALSE   FALSE      FALSE      IMMEDIATE
db_recycle_cache_size                    0                                      TRUE    FALSE      FALSE      IMMEDIATE
db_securefile                            PREFERRED                              TRUE    FALSE      TRUE       IMMEDIATE
db_ultra_safe                            OFF                                    TRUE    FALSE      FALSE      FALSE
db_unique_name                           vihaan_prim                            FALSE   FALSE      FALSE      FALSE
db_unrecoverable_scn_tracking            TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
db_writer_processes                      1                                      TRUE    FALSE      FALSE      FALSE
dbwr_io_slaves                           0                                      TRUE    FALSE      FALSE      FALSE
ddl_lock_timeout                         0                                      TRUE    FALSE      TRUE       IMMEDIATE
deferred_segment_creation                TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
dg_broker_config_file1                   /u01/app/oracle/product/12.1.0/db_1/db TRUE    FALSE      FALSE      IMMEDIATE
                                         s/dr1vihaan_prim.dat

dg_broker_config_file2                   /u01/app/oracle/product/12.1.0/db_1/db TRUE    FALSE      FALSE      IMMEDIATE
                                         s/dr2vihaan_prim.dat

dg_broker_start                          TRUE                                   FALSE   FALSE      FALSE      IMMEDIATE
diagnostic_dest                          /u01/app/oracle                        FALSE   FALSE      FALSE      IMMEDIATE
disk_asynch_io                           TRUE                                   TRUE    FALSE      FALSE      FALSE
dispatchers                              (PROTOCOL=TCP) (SERVICE=vihaanXDB)     FALSE   FALSE      FALSE      IMMEDIATE
distributed_lock_timeout                 60                                     TRUE    FALSE      FALSE      FALSE
dml_locks                                2076                                   TRUE    FALSE      FALSE      FALSE
dnfs_batch_size                          4096                                   TRUE    FALSE      FALSE      FALSE
dst_upgrade_insert_conv                  TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
enable_ddl_logging                       FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
enable_goldengate_replication            FALSE                                  TRUE    FALSE      FALSE      IMMEDIATE
enable_pluggable_database                FALSE                                  TRUE    FALSE      FALSE      FALSE
exclude_seed_cdb_view                    TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
fal_client                               (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P FALSE   FALSE      FALSE      IMMEDIATE
                                         ROTOCOL=TCP)(HOST=192.168.0.27)(PORT=1
                                         521)))(CONNECT_DATA=(SERVICE_NAME=viha
                                         an_prim)(INSTANCE_NAME=vihaan)(SERVER=
                                         dedicated)))

fal_server                               NULL                                   FALSE   FALSE      FALSE      IMMEDIATE
fast_start_io_target                     0                                      TRUE    FALSE      FALSE      IMMEDIATE
fast_start_mttr_target                   0                                      TRUE    FALSE      FALSE      IMMEDIATE
fast_start_parallel_rollback             LOW                                    TRUE    FALSE      FALSE      IMMEDIATE
file_mapping                             FALSE                                  TRUE    FALSE      FALSE      IMMEDIATE
filesystemio_options                     none                                   TRUE    FALSE      FALSE      FALSE
gcs_server_processes                     0                                      TRUE    FALSE      FALSE      FALSE
global_names                             FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
global_txn_processes                     1                                      TRUE    FALSE      FALSE      IMMEDIATE
hash_area_size                           131072                                 TRUE    FALSE      TRUE       FALSE
heat_map                                 OFF                                    TRUE    FALSE      TRUE       IMMEDIATE
hi_shared_memory_address                 0                                      TRUE    FALSE      FALSE      FALSE
hs_autoregister                          TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
inmemory_force                           DEFAULT                                TRUE    FALSE      FALSE      IMMEDIATE
inmemory_max_populate_servers            0                                      TRUE    FALSE      FALSE      IMMEDIATE
inmemory_query                           DISABLE                                FALSE   FALSE      TRUE       IMMEDIATE
inmemory_size                            0                                      TRUE    FALSE      FALSE      IMMEDIATE
inmemory_trickle_repopulate_servers_perc 1                                      TRUE    FALSE      FALSE      IMMEDIATE
ent

instance_name                            vihaan                                 TRUE    FALSE      FALSE      FALSE
instance_number                          0                                      TRUE    FALSE      FALSE      FALSE
instance_type                            RDBMS                                  TRUE    FALSE      FALSE      FALSE
instant_restore                          FALSE                                  TRUE    FALSE      FALSE      FALSE
java_jit_enabled                         TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
java_max_sessionspace_size               0                                      TRUE    FALSE      FALSE      FALSE
java_pool_size                           0                                      TRUE    FALSE      FALSE      IMMEDIATE
java_restrict                            none                                   TRUE    FALSE      FALSE      FALSE
java_soft_sessionspace_limit             0                                      TRUE    FALSE      FALSE      FALSE
job_queue_processes                      1000                                   TRUE    FALSE      FALSE      IMMEDIATE
large_pool_size                          0                                      TRUE    FALSE      FALSE      IMMEDIATE
ldap_directory_access                    NONE                                   TRUE    FALSE      FALSE      IMMEDIATE
ldap_directory_sysauth                   no                                     TRUE    FALSE      FALSE      FALSE
license_max_sessions                     0                                      TRUE    FALSE      FALSE      IMMEDIATE
license_max_users                        0                                      TRUE    FALSE      FALSE      IMMEDIATE
license_sessions_warning                 0                                      TRUE    FALSE      FALSE      IMMEDIATE
local_listener                           (ADDRESS_LIST = (ADDRESS = (PROTOCOL = FALSE   FALSE      FALSE      IMMEDIATE
                                         TCP)(HOST = 192.168.0.27)(PORT =
                                         1521)))

lock_sga                                 FALSE                                  TRUE    FALSE      FALSE      FALSE
log_archive_config                       DG_CONFIG=(vihaan_prim, vihaan_stdy)   FALSE   FALSE      FALSE      IMMEDIATE
log_archive_dest_1                       location=/u01/app/oracle/ArchiveLog    FALSE   FALSE      TRUE       IMMEDIATE
log_archive_dest_2                       service="stdy1", ASYNC NOAFFIRM        FALSE   FALSE      TRUE       IMMEDIATE
                                         delay=0 optional compression=disable
                                         max_failure=0 max_connections=1
                                         reopen=300
                                         db_unique_name="vihaan_stdy"
                                         net_timeout=30,
                                         valid_for=(online_logfile,all_roles)

log_archive_dest_state_1                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_10                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_11                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_12                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_13                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_14                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_15                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_16                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_17                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_18                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_19                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_2                 RESET                                  FALSE   FALSE      TRUE       IMMEDIATE
log_archive_dest_state_20                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_21                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_22                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_23                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_24                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_25                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_26                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_27                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_28                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_29                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_3                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_30                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_31                enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_4                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_5                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_6                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_7                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_8                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_dest_state_9                 enable                                 TRUE    FALSE      TRUE       IMMEDIATE
log_archive_format                       Log%s_%t_%r.Arc                        FALSE   FALSE      FALSE      FALSE
log_archive_max_processes                4                                      FALSE   FALSE      FALSE      IMMEDIATE
log_archive_min_succeed_dest             1                                      FALSE   FALSE      TRUE       IMMEDIATE
log_archive_start                        FALSE                                  TRUE    FALSE      FALSE      FALSE
log_archive_trace                        0                                      FALSE   SYSTEM_MOD FALSE      IMMEDIATE
log_buffer                               5193728                                TRUE    FALSE      FALSE      FALSE
log_checkpoint_interval                  0                                      TRUE    FALSE      FALSE      IMMEDIATE
log_checkpoint_timeout                   1800                                   TRUE    FALSE      FALSE      IMMEDIATE
log_checkpoints_to_alert                 FALSE                                  TRUE    FALSE      FALSE      IMMEDIATE
max_dump_file_size                       unlimited                              TRUE    FALSE      TRUE       IMMEDIATE
max_enabled_roles                        150                                    TRUE    FALSE      FALSE      FALSE
max_string_size                          STANDARD                               TRUE    FALSE      FALSE      IMMEDIATE
memory_max_target                        0                                      TRUE    FALSE      FALSE      FALSE
memory_target                            0                                      TRUE    FALSE      FALSE      IMMEDIATE
nls_comp                                 BINARY                                 TRUE    FALSE      TRUE       FALSE
nls_date_format                          DD-MON HH24:MI                         TRUE    MODIFIED   TRUE       FALSE
nls_language                             AMERICAN                               TRUE    FALSE      TRUE       FALSE
nls_length_semantics                     BYTE                                   TRUE    FALSE      TRUE       IMMEDIATE
nls_nchar_conv_excp                      FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
nls_territory                            AMERICA                                TRUE    FALSE      TRUE       FALSE
noncdb_compatible                        FALSE                                  TRUE    FALSE      FALSE      FALSE
object_cache_max_size_percent            10                                     TRUE    FALSE      TRUE       DEFERRED
object_cache_optimal_size                102400                                 TRUE    FALSE      TRUE       DEFERRED
olap_page_pool_size                      0                                      TRUE    FALSE      TRUE       DEFERRED
open_cursors                             300                                    FALSE   FALSE      FALSE      IMMEDIATE
open_links                               4                                      TRUE    FALSE      FALSE      FALSE
open_links_per_instance                  4                                      TRUE    FALSE      FALSE      FALSE
optimizer_adaptive_features              TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
optimizer_adaptive_reporting_only        FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
optimizer_capture_sql_plan_baselines     FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
optimizer_dynamic_sampling               2                                      TRUE    FALSE      TRUE       IMMEDIATE
optimizer_features_enable                12.1.0.2                               TRUE    FALSE      TRUE       IMMEDIATE
optimizer_index_caching                  0                                      TRUE    FALSE      TRUE       IMMEDIATE
optimizer_index_cost_adj                 100                                    TRUE    FALSE      TRUE       IMMEDIATE
optimizer_inmemory_aware                 TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
optimizer_mode                           ALL_ROWS                               TRUE    FALSE      TRUE       IMMEDIATE
optimizer_secure_view_merging            TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
optimizer_use_invisible_indexes          FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
optimizer_use_pending_statistics         FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
optimizer_use_sql_plan_baselines         TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
os_authent_prefix                        ops$                                   TRUE    FALSE      FALSE      FALSE
os_roles                                 FALSE                                  TRUE    FALSE      FALSE      FALSE
parallel_adaptive_multi_user             TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
parallel_automatic_tuning                FALSE                                  TRUE    FALSE      FALSE      FALSE
parallel_degree_level                    100                                    TRUE    FALSE      TRUE       IMMEDIATE
parallel_degree_limit                    CPU                                    TRUE    FALSE      TRUE       IMMEDIATE
parallel_degree_policy                   MANUAL                                 TRUE    FALSE      TRUE       IMMEDIATE
parallel_execution_message_size          16384                                  TRUE    FALSE      FALSE      FALSE
parallel_force_local                     FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
parallel_io_cap_enabled                  FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
parallel_max_servers                     40                                     TRUE    FALSE      FALSE      IMMEDIATE
parallel_min_percent                     0                                      TRUE    FALSE      TRUE       FALSE
parallel_min_servers                     4                                      TRUE    FALSE      FALSE      IMMEDIATE
parallel_min_time_threshold              AUTO                                   TRUE    FALSE      TRUE       IMMEDIATE
parallel_server                          FALSE                                  TRUE    FALSE      FALSE      FALSE
parallel_server_instances                1                                      TRUE    FALSE      FALSE      FALSE
parallel_servers_target                  16                                     TRUE    FALSE      FALSE      IMMEDIATE
parallel_threads_per_cpu                 2                                      TRUE    FALSE      FALSE      IMMEDIATE
permit_92_wrap_format                    TRUE                                   TRUE    FALSE      FALSE      FALSE
pga_aggregate_limit                      2147483648                             TRUE    FALSE      FALSE      IMMEDIATE
pga_aggregate_target                     152043520                              FALSE   FALSE      FALSE      IMMEDIATE
plscope_settings                         IDENTIFIERS:NONE                       TRUE    FALSE      TRUE       IMMEDIATE
plsql_code_type                          INTERPRETED                            TRUE    FALSE      TRUE       IMMEDIATE
plsql_debug                              FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
plsql_optimize_level                     2                                      TRUE    FALSE      TRUE       IMMEDIATE
plsql_v2_compatibility                   FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
plsql_warnings                           DISABLE:ALL                            TRUE    FALSE      TRUE       IMMEDIATE
pre_page_sga                             TRUE                                   TRUE    FALSE      FALSE      FALSE
processes                                300                                    FALSE   FALSE      FALSE      FALSE
query_rewrite_enabled                    TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
query_rewrite_integrity                  enforced                               TRUE    FALSE      TRUE       IMMEDIATE
read_only_open_delayed                   FALSE                                  TRUE    FALSE      FALSE      FALSE
recovery_parallelism                     0                                      TRUE    FALSE      FALSE      FALSE
recyclebin                               OFF                                    FALSE   FALSE      TRUE       DEFERRED
remote_dependencies_mode                 TIMESTAMP                              TRUE    FALSE      TRUE       IMMEDIATE
remote_login_passwordfile                EXCLUSIVE                              FALSE   FALSE      FALSE      FALSE
remote_os_authent                        FALSE                                  TRUE    FALSE      FALSE      FALSE
remote_os_roles                          FALSE                                  TRUE    FALSE      FALSE      FALSE
replication_dependency_tracking          TRUE                                   TRUE    FALSE      FALSE      FALSE
resource_limit                           TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
resource_manager_cpu_allocation          1                                      TRUE    FALSE      FALSE      IMMEDIATE
resource_manager_plan                    SCHEDULER[0x4448]:DEFAULT_MAINTENANCE_ TRUE    FALSE      FALSE      IMMEDIATE
                                         PLAN

result_cache_max_result                  5                                      TRUE    FALSE      FALSE      IMMEDIATE
result_cache_max_size                    2293760                                TRUE    FALSE      FALSE      IMMEDIATE
result_cache_mode                        MANUAL                                 TRUE    FALSE      TRUE       IMMEDIATE
result_cache_remote_expiration           0                                      TRUE    FALSE      TRUE       IMMEDIATE
resumable_timeout                        0                                      TRUE    FALSE      TRUE       IMMEDIATE
sec_case_sensitive_logon                 TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
sec_max_failed_login_attempts            3                                      TRUE    FALSE      FALSE      FALSE
sec_protocol_error_further_action        (DROP,3)                               TRUE    FALSE      FALSE      IMMEDIATE
sec_protocol_error_trace_action          TRACE                                  TRUE    FALSE      FALSE      IMMEDIATE
sec_return_server_release_banner         FALSE                                  TRUE    FALSE      FALSE      FALSE
serial_reuse                             disable                                TRUE    FALSE      FALSE      FALSE
service_names                            VIHAAN1, VIHAAN2                       FALSE   FALSE      FALSE      IMMEDIATE
session_cached_cursors                   50                                     TRUE    FALSE      TRUE       FALSE
session_max_open_files                   10                                     TRUE    FALSE      FALSE      FALSE
sessions                                 472                                    TRUE    FALSE      FALSE      IMMEDIATE
sga_max_size                             457179136                              TRUE    FALSE      FALSE      FALSE
sga_target                               457179136                              FALSE   FALSE      FALSE      IMMEDIATE
shadow_core_dump                         partial                                TRUE    FALSE      FALSE      FALSE
shared_memory_address                    0                                      TRUE    FALSE      FALSE      FALSE
shared_pool_reserved_size                5033164                                TRUE    FALSE      FALSE      FALSE
shared_pool_size                         0                                      TRUE    FALSE      FALSE      IMMEDIATE
shared_servers                           1                                      TRUE    FALSE      FALSE      IMMEDIATE
skip_unusable_indexes                    TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
sort_area_retained_size                  0                                      TRUE    FALSE      TRUE       DEFERRED
sort_area_size                           65536                                  TRUE    FALSE      TRUE       DEFERRED
spatial_vector_acceleration              FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
spfile                                   /u01/app/oracle/product/12.1.0/db_1/db TRUE    FALSE      FALSE      IMMEDIATE
                                         s/spfilevihaan.ora

sql92_security                           FALSE                                  TRUE    FALSE      FALSE      FALSE
sql_trace                                FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
sqltune_category                         DEFAULT                                TRUE    FALSE      TRUE       IMMEDIATE
standby_archive_dest                     ?/dbs/arch                             TRUE    FALSE      FALSE      IMMEDIATE
standby_file_management                  MANUAL                                 FALSE   FALSE      FALSE      IMMEDIATE
star_transformation_enabled              FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
statistics_level                         TYPICAL                                TRUE    FALSE      TRUE       IMMEDIATE
streams_pool_size                        0                                      TRUE    FALSE      FALSE      IMMEDIATE
tape_asynch_io                           TRUE                                   TRUE    FALSE      FALSE      FALSE
temp_undo_enabled                        FALSE                                  TRUE    FALSE      TRUE       IMMEDIATE
thread                                   0                                      TRUE    FALSE      FALSE      IMMEDIATE
threaded_execution                       FALSE                                  TRUE    FALSE      FALSE      FALSE
timed_os_statistics                      0                                      TRUE    FALSE      TRUE       IMMEDIATE
timed_statistics                         TRUE                                   TRUE    FALSE      TRUE       IMMEDIATE
trace_enabled                            TRUE                                   TRUE    FALSE      FALSE      IMMEDIATE
transactions                             519                                    TRUE    FALSE      FALSE      FALSE
transactions_per_rollback_segment        5                                      TRUE    FALSE      FALSE      FALSE
undo_management                          AUTO                                   TRUE    FALSE      FALSE      FALSE
undo_retention                           900                                    TRUE    FALSE      FALSE      IMMEDIATE
undo_tablespace                          UNDOTBS1                               FALSE   FALSE      FALSE      IMMEDIATE
unified_audit_sga_queue_size             1048576                                TRUE    FALSE      FALSE      FALSE
use_dedicated_broker                     FALSE                                  TRUE    FALSE      FALSE      IMMEDIATE
use_indirect_data_buffers                FALSE                                  TRUE    FALSE      FALSE      FALSE
use_large_pages                          TRUE                                   TRUE    FALSE      FALSE      FALSE
user_dump_dest                           /u01/app/oracle/product/12.1.0/db_1/rd TRUE    FALSE      FALSE      IMMEDIATE
                                         bms/log

workarea_size_policy                     AUTO                                   TRUE    FALSE      TRUE       IMMEDIATE
xml_db_events                            enable                                 TRUE    FALSE      TRUE       IMMEDIATE

289 rows selected.

















Posted by



at





1 comment:
  

































        

      









Subscribe to:
Posts (Atom)







Oracle DBA



My photo








Essex, United Kingdom











anuj blog Archive