Apply patch using response file ( Disabling Oracle Support)

We need to edit the below parameters in respose file to apply Oracle patch on the existed Oracle Home.

Example values :

ORACLE_HOME=/app/oracle/product/10.2/db_1
ORACLE_HOME_NAME=OraDbHome1
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

Now you can go for the runInstaller.

$ ./runInstaller -silent -responseFile /path/patchset.rsp -ignoreSysprereqs

That's it.

if you donot modify the 3 and 4 parameter , given above Then you will be encountered with below error.

SEVERE:Values for the following variables could not be obtained from the command line or response file(s):
MYORACLESUPPORT_USERNAME(MyOracleSupportUsername)
 


Tips for using parameter values  :

SECURITY_UPDATES_VIA_MYORACLESUPPORT

This parameter is equivalent to the OUI window checkbox that enables users to receive security updates. ("I wish to receive security updates via My Oracle Support," followed by a My Oracle Support Password field.) This parameter enables you to set the password for My Oracle Support credentials. The default is False. If you set this to true, the user must enter a password.

MYORACLESUPPORT_PASSWORD

This parameter indicates the My Oracle Support password used in Oracle Configuration Manager (OCM) configuration. This parameter is used for validation only if the direct connection is available, or if there is a valid proxy connection (in case no direct connection is available). The default is Empty.
For information on OCM, see the Oracle® Configuration Manager Installation and Administration Guide.

 

DECLINE_SECURITY_UPDATES

If the direct connection is unavailable, set this parameter to false if you do not want to configure Oracle Configuration Manager, or do not want to provide any proxy details for the connection. The default is False.

If you do not set MYORACLESUPPORT_USERNAME to any value and you set this parameter to true, the Oracle Configuration Manager is not configured.
For information on the Oracle Configuration Manager, see the Oracle® Configuration Manager Installation and Administration Guide.

 

PROXY_HOST

This proxy connection server is used only if the direct connection is not available and DECLINE_SECURITY_UPDATES=false.

 

PROXY_PORT

This proxy connection port is used only if the direct connection is not available and DECLINE_SECURITY_UPDATES=false.

 

PROXY_USER

This proxy connection user name is used only if the direct connection is not available and DECLINE_SECURITY_UPDATES=false.

 

PROXY_PWD

This proxy connection password is used only if the direct connection is not available and DECLINE_SECURITY_UPDATES=false.

Database Creation using DBCA - Silent Mode.

We can create the database using dbca in silent mode to meet the below requirements.

DBname                 :  ramdb
SID                        :  ramdb
CharacterSet          :  AL32UTF8
datafileDestination  :  /export/home/oracle/oradg/oradg/oradata


bash $ dbca -silent -createDatabase -datafileDestination /export/home/oracle/oradg/oradg/oradata -templateName General_Purpose.dbc -gdbname ramdb -sid ramdb -responseFile NO_VALUE -characterSet AL32UTF8

Below o/p will be expected : 

Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
57% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "c:\oracle\product\1020\cfgtoollogs\dbca\myoracle\myoracle0.log" for further details.

Now we can find the below values from database :

sql> select name,value from v$parameter where value like '%/%';

spfile                         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/spfileramdb.ora
control_files                  /export/home/oracle/oradg/oradg/oradata/ramdb/control01.ctl, /export/home/oracle/oradg/oradg/oradata/ramdb/control02.ctl, /export/home/oracle/oradg/oradg/oradata/ramdb/control03.ctl
standby_archive_dest           ?/dbs/arch
db_recovery_file_dest          /export/home/u01/app/oracle/flash_recovery_area
background_dump_dest           /export/home/u01/app/oracle/admin/ramdb/bdump
user_dump_dest                 /export/home/u01/app/oracle/admin/ramdb/udump
core_dump_dest                 /export/home/u01/app/oracle/admin/ramdb/cdump
audit_file_dest                /export/home/u01/app/oracle/admin/ramdb/adump
dg_broker_config_file1         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/dr1ramdb.dat
dg_broker_config_file2         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/dr2ramdb.dat


Below is the spfile created by dbca :

cat spfileramdb.ora
====================
ramdb.__java_pool_size=4194304
ramdb.__large_pool_size=4194304
ramdb.__shared_pool_size=79691776
ramdb.__streams_pool_size=0
*.audit_file_dest='/export/home/u01/app/oracle/admin/ramdb/adump'
*.background_dump_dest='/export/home/u01/app/oracle/admin/ramdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/export/home/oracle/oradg/oradg/oradata/ramdb/control01.ctl','/export/home/oracle/oradg/oradg/oradata/ramdb/control02.ctl','/export/home/oracle/oradg/oradg/oradata/ramdb/control03.ctl'
*.core_dump_dest='/export/home/u01/app/oracle/admin/ramdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ramdb'
*.db_recovery_file_dest='/export/home/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ramdbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=96468992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=290455552
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/export/home/u01/app/oracle/admin/ramdb/udump'

======= End of the post =========

RMAN backup and recovery checklist

Click here to Opnen in New Tab.