Posted in Database, ORACLE

Applying Oracle Critical Patch Update of April 2017 on Oracle 12.1.0.2.0

 

1) Finding Current Opatch Version.

[grid@TESTING ora00]$ /ora00/app/grid/product/12.1.0/OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.

2) Download Updated Opatch patch from Oracle Metalink.

TESTING:oracle $ cd patchopatch/
TESTING:oracle $ ls
p21142429_121010_Linux-x86-64.zip

3) Applying Opatch patch on current Oracle Home and Grid Home.

Oracle Home:-

TESTING:oracle $ unzip -o -qq p21142429_121010_Linux-x86-64.zip -d /ora00/app/oracle/product/12.1.0
TESTING:oracle $ /ora00/app/oracle/product/12.1.0/OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.

Grid Home:–

[grid@TESTING patchopatch]$ unzip -o -qq p21142429_121010_Linux-x86-64.zip -d /ora00/app/grid/product/12.1.0
[grid@TESTING patchopatch]$ /ora00/app/grid/product/12.1.0/OPatch/opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.

4) Stop Grid and Database Services.

5) Analyze Current Patch with opatchauto utility.

[root@TESTING ora00]# /ora00/app/grid/product/12.1.0/OPatch/opatchauto apply /ora00/25434003 -analyze -oh /ora00/app/grid/product/12.1.0
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /ora00/app/grid/product/12.1.0

opatchauto log file: /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/25434003/opatch_gi_2017-06-22_05-45-15_analyze.log

NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /ora00/25434003
Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750
DB Patch(es): 25171037 25363740

Patch Validation: Successful
User specified following Grid Infrastructure home:
/ora00/app/grid/product/12.1.0




Analyzing patch(es) on "/ora00/app/grid/product/12.1.0" ...
Patch "/ora00/25434003/21436941" successfully analyzed on "/ora00/app/grid/product/12.1.0" for apply.
Patch "/ora00/25434003/25171037" successfully analyzed on "/ora00/app/grid/product/12.1.0" for apply.
Patch "/ora00/25434003/25363740" successfully analyzed on "/ora00/app/grid/product/12.1.0" for apply.
Patch "/ora00/25434003/25363750" successfully analyzed on "/ora00/app/grid/product/12.1.0" for apply.

Apply Summary:
Following patch(es) are successfully analyzed:
GI Home: /ora00/app/grid/product/12.1.0: 21436941,25171037,25363740,25363750

opatchauto succeeded.

6) Once above steps is completed successfully we will generate ocm.rsp file , If you have latter Opatch Version this rsp file is not needed

export ORACLE_HOME=/ora00/app/grid/product/12.1.0
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /ora00/ocm.rsp

Applying Opatch on Grid Home

[root@TESTING bin]# /ora00/app/grid/product/12.1.0/OPatch/opatchauto apply /ora00/25434003 -oh /ora00/app/grid/product/12.1.0 -ocmrf /ora00/app/oracle/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /ora00/app/grid/product/12.1.0

opatchauto log file: /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/25434003/opatch_gi_2017-06-22_06-07-58_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /ora00/25434003
Grid Infrastructure Patch(es): 21436941 25171037 25363740 25363750
DB Patch(es): 25171037 25363740

Patch Validation: Successful
User specified following Grid Infrastructure home:
/ora00/app/grid/product/12.1.0




Performing prepatch operations on SIHA Home... Successful

Applying patch(es) to "/ora00/app/grid/product/12.1.0" ...
Patch "/ora00/25434003/21436941" successfully applied to "/ora00/app/grid/product/12.1.0".
Patch "/ora00/25434003/25171037" successfully applied to "/ora00/app/grid/product/12.1.0".
Patch "/ora00/25434003/25363740" successfully applied to "/ora00/app/grid/product/12.1.0".
Patch "/ora00/25434003/25363750" successfully applied to "/ora00/app/grid/product/12.1.0".

Performing postpatch operations on SIHA Home... Successful

Apply Summary:
Following patch(es) are successfully installed:
GI Home: /ora00/app/grid/product/12.1.0: 21436941,25171037,25363740,25363750

opatchauto succeeded.

7) Repeat the same steps for Oracle Home:

[root@TESTING ~]# /ora00/app/oracle/product/12.1.0/OPatch/opatchauto apply /ora00/25434003 -oh /ora00/app/oracle/product/12.1.0/ -ocmrf /ora00/app/oracle/ocm.rsp

 

Posted in Database, ORACLE

addnode.sh hangs during copying files to other node.

 

Recently i was trying to add one node to cluster and after running addnode.sh it was hanging in below mentioned line

 

$ ./addnode.sh -silent "CLUSTER_NEW_NODES={SEP02PVVM335}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={SEP02PVVM335-VIP}"
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 40619 MB Passed
Checking swap space: must be greater than 150 MB. Actual 49143 MB Passed
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
 CAUSE: Some of the optional prerequisites are not met. See logs for details. /ora00/app/oraInventory/logs/addNodeActions2017-06-02_06-50-36AM.log
 ACTION: Identify the list of failed prerequisite checks from the log: /ora00/app/oraInventory/logs/addNodeActions2017-06-02_06-50-36AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

Prepare Configuration in progress.

Prepare Configuration successful.
.................................................. 8% Done.
You can find the log of this install session at:
 /ora00/app/oraInventory/logs/addNodeActions2017-06-02_06-50-36AM.log

Instantiate files in progress.

Instantiate files successful.
.................................................. 14% Done.

Copying files to node in progress.

 

First of all GRID_HOME should be owned by grid by default it will be root.

After searching on metalink find out sometime this issue may be because of below mentioned BUG:

Bug 12318325 – Addnode.sh takes longer due to audit files in GRID_HOME/rdbms/audit. (Doc ID 12318325.8)

 

Once i cleaned up those audit files i was able to run addnode.sh successfully.

 

$ ./addnode.sh -silent "CLUSTER_NEW_NODES={SEP02PVVM335}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={SEP02PVVM335-VIP}"
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 40543 MB Passed
Checking swap space: must be greater than 150 MB. Actual 49143 MB Passed

Prepare Configuration in progress.

Prepare Configuration successful.
.................................................. 8% Done.
You can find the log of this install session at:
/ora00/app/oraInventory/logs/addNodeActions2017-06-02_09-56-37AM.log

Instantiate files in progress.

Instantiate files successful.
.................................................. 14% Done.

Copying files to node in progress.

Copying files to node successful.
.................................................. 73% Done.

Saving cluster inventory in progress.
.................................................. 80% Done.

Saving cluster inventory successful.
The Cluster Node Addition of /ora00/grid/product/12.1.0 was successful.
Please check '/tmp/silentInstall.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
.................................................. 88% Done.

As a root user, execute the following script(s):
 1. /ora00/app/oraInventory/orainstRoot.sh
 2. /ora00/grid/product/12.1.0/root.sh

Execute /ora00/app/oraInventory/orainstRoot.sh on the following nodes:
[SEP02PVVM335]
Execute /ora00/grid/product/12.1.0/root.sh on the following nodes:
[SEP02PVVM335]

The scripts can be executed in parallel on all the nodes.

..........
Update Inventory in progress.
.................................................. 100% Done.

Update Inventory successful.
Successfully Setup Software.
$
Posted in Database, ORACLE

DBMS_REPCAT_ADMIN package not present on Oracle Release 12.2.0.1.0 after Upgrade

Recently we have upgraded Database Server from Oracle Version 12.1.0.2.0 to 12.2.0.1.0.

After Upgrade we are unable to finde DBMS_REPCAT_ADMIN package

SQL> select owner,object_type,object_name from dba_objects where object_name='DBMS_REPCAT_ADMIN'; 

no rows selected

Because of this our script are failing with this error :

BEGIN DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP(userid => 'admin' ); END; 

* 
ERROR at line 1: 
ORA-06550: line 1, column 7: 
PLS-00201: identifier 'DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP' must be 
declared 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored

Whereas on existing Oracle 12.1.0.2.0 version i can easily find those package:

SQL> select owner,object_type,object_name from dba_objects where object_name='DB MS_REPCAT_ADMIN'; 

OWNER 
-------------------------------------------------------------------------------- 
OBJECT_TYPE 
----------------------- 
OBJECT_NAME 
-------------------------------------------------------------------------------- 
SYS 
PACKAGE BODY 
DBMS_REPCAT_ADMIN

 

On further reading on Oracle release notes came to know that,These packages comes under advanced replication feature, which was not supported for 12.1 version but still could be used. Going forward in 12.2 these packages are completely removed and cannot be used further

Below mentioned is the Oracle link which mentioned this:

Desupport of Oracle Advanced Replication

Posted in Database, ORACLE

Upgrade to Oracle Database 12c Release 2 (12.2.0.1.0) — Part 2

In this part will be Upgrading Grid Home and Database home to Oracle 12.2.0.1.0.

Desired Software need to be downloaded from below mentioned link:

Oracle Software

Once desired Software is downloaded will be Upgrading Grid home first and then will be Upgrading Oracle Database.

 

1)Upgrading Grid Infrastructure to Oracle 12.2.0.1.0.

 

Grid1

Grid2

Grid3

Grid 4

Grid 5

Grid 6

Grid 7

Grid 8

 

Grid 9

 

Note:– It may happen that rootupgrade.sh may fails during Grid Installation with below mentioned error message.

a) ORA-01078 and ORA-29701

–ERROR MESSAGE–

[root@SEP02PVVM392 rpm]# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/sep02pvvm392/crsconfig/roothas_2017-03-23_04-46-20AM.log

Upgrade cannot proceed because the ASM instance failed to start. Fix the issue or startup the ASM instance, verify and try again.
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service


2017/03/23 04:46:26 CLSRSC-164: ASM upgrade failed
2017/03/23 04:46:26 CLSRSC-304: Failed to upgrade ASM for Oracle Restart configuration
Died at /ora00/app/grid/product/12.2.0/crs/install/crsupgrade.pm line 3083.
The command '/ora00/app/grid/product/12.2.0/perl/bin/perl -I/ora00/app/grid/product/12.2.0/perl/lib -I/ora00/app/grid/product/12.2.0/crs/install /ora00/app/grid/product/12.2.0/crs/install/roothas.pl -upgrade' execution failed

 

Solution: Start ASM  on new Grid Home and try again to run rootupgrade.sh

[root@TESTINGrpm]# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/testing/crsconfig/roothas_2017-03-23_04-50-44AM.log

ASM has been upgraded and started successfully.

Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node testing successfully pinned.
2017/03/23 04:51:10 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
CRS-4123: Oracle High Availability Services has been started.

2017/03/23 04:55:03 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p first'
2017/03/23 04:55:05 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p last'


testing 2017/03/23 04:55:06 /ora00/app/grid/product/12.2.0/cdata/testing/backup_20170323_045506.olr 0

testing 2016/07/20 10:18:23 /ora00/app/grid/product/12.1.0/cdata/testing/backup_20160720_101823.olr 0

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testing'
CRS-2673: Attempting to stop 'ora.evmd' on 'testing'
CRS-2677: Stop of 'ora.evmd' on 'testing' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testing' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2017/03/23 04:55:57 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

 

b) DIA-49802 and DIA-49801 .

Above mentioned error i got in different Cloned VM of this source VM.

# /ora00/app/grid/product/12.2.0/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
 ORACLE_OWNER= grid
 ORACLE_HOME= /ora00/app/grid/product/12.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /ora00/app/grid/product/12.2.0/crs/install/crsconfig_params
The log of current session can be found at:
 /ora00/app/grid/crsdata/sep02pvvm-405/crsconfig/roothas_2017-04-17_06-07-09AM.log


ASM has been upgraded and started successfully.

Oracle Clusterware infrastructure error in OCRCONFIG (OS PID 20893): CLSD/ADR initialization failed with return value -1
1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
 DIA-49802: missing read, write, or execute permission on specified ADR home directory [/ora00/app/grid/diag/crs/sep02pvvm-405/crs/log]
DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
DIA-48188: user missing read, write, or exec permission on specified directory
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Additional information: 511
Additional information: 16888
([all diagnostic data retrieved from ADR])]
2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/ora00/app/grid] Product Type: [CRS] Host Name: [sep02pvvm-405] Instance ID: [crs] User Name: [grid]]


Oracle Clusterware infrastructure error in CLSCFG (OS PID 20903): CLSD/ADR initialization failed with return value -1
1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
 DIA-49802: missing read, write, or execute permission on specified ADR home directory [/ora00/app/grid/diag/crs/sep02pvvm-405/crs/log]
DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
DIA-48188: user missing read, write, or exec permission on specified directory
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Additional information: 511
Additional information: 16888
([all diagnostic data retrieved from ADR])]
2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/ora00/app/grid] Product Type: [CRS] Host Name: [sep02pvvm-405] Instance ID: [crs] User Name: [grid]]

Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node sep02pvvm-405 successfully pinned.
2017/04/17 06:08:41 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2017/04/17 06:10:46 CLSRSC-214: Failed to start the resource 'ohasd'
Failed to start the Clusterware. Last 20 lines of the alert log follow:
2017-04-17 06:09:23.605
[client(22558)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22558
2017-04-17 06:09:23.611
[client(22558)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:25.240
[client(22651)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22651
2017-04-17 06:09:25.247
[client(22651)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:26.901
[client(22743)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22743
2017-04-17 06:09:26.908
[client(22743)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:28.415
[client(22831)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22831
2017-04-17 06:09:28.422
[client(22831)]CRS-2112:The OLR service started on node sep02pvvm-405.
2017-04-17 06:09:30.014
[client(22914)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 22914
2017-04-17 06:09:30.020
[client(22914)]CRS-2112:The OLR service started on node sep02pvvm-405.

2017/04/17 06:10:46 CLSRSC-318: Failed to start Oracle OHASD service
Died at /ora00/app/grid/product/12.2.0/crs/install/crsinstall.pm line 2775.
The command '/ora00/app/grid/product/12.2.0/perl/bin/perl -I/ora00/app/grid/product/12.2.0/perl/lib -I/ora00/app/grid/product/12.2.0/crs/install /ora00/app/grid/product/12.2.0/crs/install/roothas.pl -upgrade' execution failed

For above mentioned error i had to check ownership of  $GRID_HOME/diag/crs/testing/crs/* directories from root to grid user.

[root@SEP02PVVM-405 crs]# chown -R grid:oinstall alert
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall cdump/
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall incident/
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall incpkg
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall lck
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall log
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata_dgif
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall metadata_pv
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall stage
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall sweep
[root@SEP02PVVM-405 crs]# chown -R grid:oinstall trace

Once this is done you will be able to start ASM services from New Grid Home.Don’t know why this came may be something happened during Cloning process but thought of sharing this information

 2) Once rootupgrade.sh has run try to see the Upgraded releaseversion.

[grid@TESTING bin]$ ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]


[grid@TESTING bin]$ ./crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.2.0.1.0]

 

3) Once Grid is Upgraded we need to install Oracle Database 12.2.0.1.0 software.

db1

db2

db3

db4

db5

db6

db7

db8

db9

db10

4) Once Oracle 12.2.0.1.0 Software is installed you can easily Upgrade the Desired Database by Using DBUA.

Below mentioned metalink DOC ID contains all necessary information.

Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA (Doc ID 2189854.1)

 

Posted in Database, ORACLE

Upgrade to Oracle Database 12c Release 2 (12.2.0.1.0) — Part 1

In this part i will be completing the prerequisite condition of applying patch 21255373 .

Before Upgrading to Oracle 12c Release 2 (12.2.0.1.0) it is mandatory to Apply Patch 21255373.

Below mentioned are the Environment on which i will be certifying this Patch.

Oracle Version -- 12.1.0.2.0

OS Version -- RHEL 7.3

Database Filesystem -- ASM Filesystem

For Applying Patch 21255373 we need to download the neccessary Patch and Corresponding Opatch patch 6880880 for Oracle 12.2.0.1.0 (opatch 12.2.0.1.8) version from Oracle Metalink:

https://support.oracle.com/
Once Opatch and patch is downloaded we will apply patch in Grid Environment:

1) Updating OPatch Version for Grid Home and Oracle Home.
—Grid Home—-

[grid@TESTING ora00]$ unzip -o -qq p6880880_121010_Linux-x86-64.zip -d /ora00/app/grid/product/12.1.0

[grid@TESTING ~]$ /ora00/app/grid/product/12.1.0/OPatch/opatch version
OPatch Version: 12.2.0.1.8

OPatch succeeded.

—Oracle Home —-

TESTING:oracle $ unzip -o -qq p6880880_121010_Linux-x86-64.zip -d /ora00/app/oracle/product/12.1.0


TESTING:oracle $ /ora00/app/oracle/product/12.1.0/OPatch/opatch version
OPatch Version: 12.2.0.1.8

OPatch succeeded.

 

2) Unzip Patch on Desired Directory.

[grid@TESTING patch]$ unzip p21255373_12102160119forOCW_Linux-x86-64.zip

 

3) Run prepatch.sh from oracle user.

TESTING:oracle $ cd /ora00/patch/21255373/21255373/custom/scripts/
 
 TESTING:oracle $ ./prepatch.sh -dbhome /ora00/app/oracle/product/12.1.0/
./prepatch.sh completed successfully.

4) Stop Database and Grid Services.
5) Will be analyzing patch with root user for grid home and then apply the desired patch.
—Analyzing Patch —

[root@TESTING ~]# /ora00/app/grid/product/12.1.0/OPatch/opatchauto apply /ora00/patch/21255373 -analyze -oh /ora00/app/grid/product/12.1.0

OPatchauto session is initiated at Mon Apr 17 01:40:41 2017

System initialization log file is /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchautodb/systemconfig2017-04-17_01-40-44AM.log.

Session log file is /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/opatchauto2017-04-17_01-40-46AM.log
The id for this session is Y72U

Executing OPatch prereq operations to verify patch applicability on home /ora00/app/grid/product/12.1.0
Patch applicablity verified successfully on home /ora00/app/grid/product/12.1.0


Verifying patch inventory on home /ora00/app/grid/product/12.1.0
Patch inventory verified successfully on home /ora00/app/grid/product/12.1.0

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:TESTING
SIHA Home:/ora00/app/grid/product/12.1.0


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /ora00/patch/21255373/21255373
Log: /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2017-04-17_01-40-49AM_1.log

OPatchauto session completed at Mon Apr 17 01:41:20 2017
Time taken to complete the session 0 minute, 39 seconds

—- Applying Patch —–

[root@TESTING ~]# /ora00/app/grid/product/12.1.0/OPatch/opatchauto apply /ora00/patch/21255373 -oh /ora00/app/grid/product/12.1.0

OPatchauto session is initiated at Mon Apr 17 01:47:39 2017

System initialization log file is /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchautodb/systemconfig2017-04-17_01-47-41AM.log.

Session log file is /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/opatchauto2017-04-17_01-47-43AM.log
The id for this session is VEND

Executing OPatch prereq operations to verify patch applicability on home /ora00/app/grid/product/12.1.0
Patch applicablity verified successfully on home /ora00/app/grid/product/12.1.0


Verifying patch inventory on home /ora00/app/grid/product/12.1.0
Patch inventory verified successfully on home /ora00/app/grid/product/12.1.0


Bringing down CRS service on home /ora00/app/grid/product/12.1.0
Prepatch operation log file location: /ora00/app/grid/product/12.1.0/cfgtoollogs/crsconfig/hapatch_2017-04-17_01-48-13AM.log
CRS service brought down successfully on home /ora00/app/grid/product/12.1.0


Start applying binary patch on home /ora00/app/grid/product/12.1.0
Binary patch applied successfully on home /ora00/app/grid/product/12.1.0


Starting CRS service on home /ora00/app/grid/product/12.1.0
Postpatch operation log file location: /ora00/app/grid/product/12.1.0/cfgtoollogs/crsconfig/hapatch_2017-04-17_01-49-44AM.log
CRS service started successfully on home /ora00/app/grid/product/12.1.0


Verifying patches applied on home /ora00/app/grid/product/12.1.0
Patch verification completed with warning on home /ora00/app/grid/product/12.1.0

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:TESTING
SIHA Home:/ora00/app/grid/product/12.1.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /ora00/patch/21255373/21255373
Log: /ora00/app/grid/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2017-04-17_01-48-25AM_1.log

OPatchauto session completed at Mon Apr 17 01:50:02 2017
Time taken to complete the session 2 minutes, 23 seconds

 

6) Repeat the above mentioned steps with root user for Oracle Home.
— Analyze Patch —

[root@TESTING ~]# /ora00/app/oracle/product/12.1.0/OPatch/opatchauto apply /ora00/patch/21255373 -analyze -oh /ora00/app/oracle/product/12.1.0/

OPatchauto session is initiated at Mon Apr 17 01:58:38 2017

System initialization log file is /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatchautodb/systemconfig2017-04-17_01-58-40AM.log.

Session log file is /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatchauto/opatchauto2017-04-17_01-58-42AM.log
The id for this session is DNAP

Executing OPatch prereq operations to verify patch applicability on home /ora00/app/oracle/product/12.1.0
Patch applicablity verified successfully on home /ora00/app/oracle/product/12.1.0


Verifying patch inventory on home /ora00/app/oracle/product/12.1.0
Patch inventory verified successfully on home /ora00/app/oracle/product/12.1.0


Verifying SQL patch applicablity on home /ora00/app/oracle/product/12.1.0
No step execution required.........
SQL patch applicablity verified successfully on home /ora00/app/oracle/product/12.1.0

OPatchAuto successful.

--------------------------------Summary--------------------------------

OPatchauto session completed at Mon Apr 17 01:59:02 2017
Time taken to complete the session 0 minute, 25 seconds

— Applying Patch —

[root@TESTING ~]# /ora00/app/oracle/product/12.1.0/OPatch/opatchauto apply /ora00/patch/21255373 -oh /ora00/app/oracle/product/12.1.0/

OPatchauto session is initiated at Mon Apr 17 02:03:23 2017

System initialization log file is /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatchautodb/systemconfig2017-04-17_02-03-25AM.log.

Session log file is /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatchauto/opatchauto2017-04-17_02-03-27AM.log
The id for this session is 66N3

Executing OPatch prereq operations to verify patch applicability on home /ora00/app/oracle/product/12.1.0
Patch applicablity verified successfully on home /ora00/app/oracle/product/12.1.0


Verifying patch inventory on home /ora00/app/oracle/product/12.1.0
Patch inventory verified successfully on home /ora00/app/oracle/product/12.1.0


Verifying SQL patch applicablity on home /ora00/app/oracle/product/12.1.0
No step execution required.........
SQL patch applicablity verified successfully on home /ora00/app/oracle/product/12.1.0


Preparing to bring down database service on home /ora00/app/oracle/product/12.1.0
No step execution required.........
Successfully prepared home /ora00/app/oracle/product/12.1.0 to bring down database service


Bringing down database service on home /ora00/app/oracle/product/12.1.0
Database service successfully brought down on home /ora00/app/oracle/product/12.1.0


Performing prepatch operation on home /ora00/app/oracle/product/12.1.0
Perpatch operation completed successfully on home /ora00/app/oracle/product/12.1.0


Start applying binary patch on home /ora00/app/oracle/product/12.1.0
Binary patch applied successfully on home /ora00/app/oracle/product/12.1.0


Performing postpatch operation on home /ora00/app/oracle/product/12.1.0
Postpatch operation completed successfully on home /ora00/app/oracle/product/12.1.0


Starting database service on home /ora00/app/oracle/product/12.1.0
Database service successfully started on home /ora00/app/oracle/product/12.1.0


Preparing home /ora00/app/oracle/product/12.1.0 after database service restarted
No step execution required.........
Prepared home /ora00/app/oracle/product/12.1.0 successfully after database service restarted


Trying to apply SQL patch on home /ora00/app/oracle/product/12.1.0
No step execution required.........
SQL patch applied successfully on home /ora00/app/oracle/product/12.1.0


Verifying patches applied on home /ora00/app/oracle/product/12.1.0
No step execution required.........
Patch verification completed with warning on home /ora00/app/oracle/product/12.1.0

OPatchAuto successful.

--------------------------------Summary--------------------------------

OPatchauto session completed at Mon Apr 17 02:04:31 2017
Time taken to complete the session 1 minute, 8 seconds

7) Confirm whether the patch is applied with the help of lsinventory command:–

TESTING:oracle $ /ora00/app/oracle/product/12.1.0/OPatch/opatch lsinventory -detail -oh /ora00/app/oracle/product/12.1.0

Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.


Oracle Home : /ora00/app/oracle/product/12.1.0
Central Inventory : /ora00/app/oraInventory
 from : /ora00/app/oracle/product/12.1.0/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2017-04-17_02-07-31AM_1.log

Lsinventory Output file location : /ora00/app/oracle/product/12.1.0/cfgtoollogs/opatch/lsinv/lsinventory2017-04-17_02-07-31AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: TESTING.sweng.ncr.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.


Installed Products (135):

Assistant Common Files 12.1.0.2.0
Buildtools Common Files 12.1.0.2.0
Cluster Verification Utility Common Files 12.1.0.2.0
Database Configuration and Upgrade Assistants 12.1.0.2.0
Database Migration Assistant for Unicode 12.1.0.2.0
Database SQL Scripts 12.1.0.2.0
Database Workspace Manager 12.1.0.2.0
DB TOOLS Listener 12.1.0.2.0
Deinstallation Tool 12.1.0.2.0
Enterprise Edition Options 12.1.0.2.0
Expat libraries 2.0.1.0.2
Generic Connectivity Common Files 12.1.0.2.0
Hadoopcore Component 12.1.0.2.0
HAS Common Files 12.1.0.2.0
HAS Files for DB 12.1.0.2.0
Installation Common Files 12.1.0.2.0
Installation Plugin Files 12.1.0.2.0
Installer SDK Component 12.1.0.2.0
JAccelerator (COMPANION) 12.1.0.2.0
Java Development Kit 1.6.0.75.0
LDAP Required Support Files 12.1.0.2.0
OLAP SQL Scripts 12.1.0.2.0
Oracle Advanced Security 12.1.0.2.0
Oracle Application Express 12.1.0.2.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 12.1.0.2.0
Oracle Clusterware RDBMS Files 12.1.0.2.0
Oracle Configuration Manager 10.3.8.1.1
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.2.0
Oracle Context Companion 12.1.0.2.0
Oracle Core Required Support Files 12.1.0.2.0
Oracle Core Required Support Files for Core DB 12.1.0.2.0
Oracle Core XML Development Kit 12.1.0.2.0
Oracle Data Mining RDBMS Files 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c Multimedia Files 12.1.0.2.0
Oracle Database Deconfiguration 12.1.0.2.0
Oracle Database Gateway for ODBC 12.1.0.2.0
Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.2.0
Oracle Database Vault option 12.1.0.2.0
Oracle DBCA Deconfiguration 12.1.0.2.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support For Core 12.1.0.2.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 12.1.0.2.0
Oracle Java Client 12.1.0.2.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC Server Support Package 12.1.0.2.0
Oracle JDBC/OCI Instant Client 12.1.0.2.0
Oracle JDBC/THIN Interfaces 12.1.0.2.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.2.0
Oracle JVM For Core 12.1.0.2.0
Oracle Label Security 12.1.0.2.0
Oracle LDAP administration 12.1.0.2.0
Oracle Locale Builder 12.1.0.2.0
Oracle Message Gateway Common Files 12.1.0.2.0
Oracle Multimedia 12.1.0.2.0
Oracle Multimedia Client Option 12.1.0.2.0
Oracle Multimedia Java Advanced Imaging 12.1.0.2.0
Oracle Multimedia Locator 12.1.0.2.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0
Oracle Multimedia Locator RDBMS Files 12.1.0.2.0
Oracle Net 12.1.0.2.0
Oracle Net Java Required Support Files 12.1.0.2.0
Oracle Net Listener 12.1.0.2.0
Oracle Net Required Support Files 12.1.0.2.0
Oracle Net Services 12.1.0.2.0
Oracle Netca Client 12.1.0.2.0
Oracle Notification Service 12.1.0.2.0
Oracle Notification Service (eONS) 12.1.0.2.0
Oracle Notification Service for Instant Client 12.1.0.2.0
Oracle ODBC Driver 12.1.0.2.0
Oracle ODBC Driverfor Instant Client 12.1.0.2.0
Oracle OLAP 12.1.0.2.0
Oracle OLAP API 12.1.0.2.0
Oracle OLAP RDBMS Files 12.1.0.2.0
Oracle One-Off Patch Installer 12.1.0.1.2
Oracle Partitioning 12.1.0.2.0
Oracle Programmer 12.1.0.2.0
Oracle Quality of Service Management (Client) 12.1.0.2.0
Oracle R Enterprise Server Files 12.1.0.2.0
Oracle RAC Deconfiguration 12.1.0.2.0
Oracle RAC Required Support Files-HAS 12.1.0.2.0
Oracle Real Application Testing 12.1.0.2.0
Oracle Recovery Manager 12.1.0.2.0
Oracle Security Developer Tools 12.1.0.2.0
Oracle Spatial and Graph 12.1.0.2.0
Oracle SQL Developer 12.1.0.2.0
Oracle Starter Database 12.1.0.2.0
Oracle Text 12.1.0.2.0
Oracle Text ATG Language Support Files 12.1.0.2.0
Oracle Text for Core 12.1.0.2.0
Oracle Text Required Support Files 12.1.0.2.0
Oracle Universal Connection Pool 12.1.0.2.0
Oracle Universal Installer 12.1.0.2.0
Oracle USM Deconfiguration 12.1.0.2.0
Oracle Wallet Manager 12.1.0.2.0
Oracle XML Development Kit 12.1.0.2.0
Oracle XML Query 12.1.0.2.0
oracle.swd.oui.core.min 12.1.0.2.0
Parser Generator Required Support Files 12.1.0.2.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.2.0
PL/SQL Embedded Gateway 12.1.0.2.0
Platform Required Support Files 12.1.0.2.0
Precompiler Common Files 12.1.0.2.0
Precompiler Common Files for Core 12.1.0.2.0
Precompiler Required Support Files 12.1.0.2.0
Precompilers 12.1.0.2.0
RDBMS Required Support Files 12.1.0.2.0
RDBMS Required Support Files for Instant Client 12.1.0.2.0
RDBMS Required Support Files Runtime 12.1.0.2.0
Required Support Files 12.1.0.2.0
Sample Schema Data 12.1.0.2.0
Secure Socket Layer 12.1.0.2.0
SQL*Plus 12.1.0.2.0
SQL*Plus Files for Instant Client 12.1.0.2.0
SQL*Plus Required Support Files 12.1.0.2.0
SQLJ Runtime 12.1.0.2.0
SSL Required Support Files for InstantClient 12.1.0.2.0
Tracle File Analyzer 12.1.0.2.0
XDK Required Support Files 12.1.0.2.0
XML Parser for Java 12.1.0.2.0
XML Parser for Oracle JVM 12.1.0.2.0
There are 135 products installed in this Oracle Home.


Interim patches (1) :

Patch 21255373 : applied on Mon Apr 17 02:04:26 EDT 2017
Unique Patch ID: 19853332
Patch description: "OCW Interim patch for 21255373"
 Created on 19 Feb 2016, 17:21:55 hrs PST8PDT
 Bugs fixed:
 21339083, 19701617, 18589889, 20768643, 19280860, 19139608, 19061429
 19133945, 19521169, 19341538, 20011424, 18946768, 19135521, 18604143
 19361757, 19187207, 19627476, 19302350, 19130141, 19530755, 20317221
 19699720, 20177779, 19168690, 19266658, 18899171, 19244316, 18330979
 19653795, 19471722, 19027351, 18634372, 21227730, 18707416, 19536337
 19184188, 19131709, 21113068, 20160490, 20235486, 19925992, 20995001
 20006646, 18991776, 18439295, 19380733, 21245437, 20552947, 18943696
 19591984, 19550195, 18135723, 19163425, 20014326, 19524857, 18849021
 18890943, 18861196, 19154753, 17940721, 19522313, 18748932, 18835283
 19184765, 19499021, 20923930, 19046190, 14851828, 19051385, 19682695
 19050688, 19831611, 20598625, 19226141, 19053891, 18871287, 18998228
 18980002, 18922918, 19683886, 18956780, 19325604, 19026993, 18777835
 17338864, 18261648, 18945906, 19513650, 20185476, 18882642, 19702758
 18952577, 17447588, 19414274, 20752167, 19262534, 19147513, 21242118
 19473088, 20758997, 19178517, 18729269, 19659885, 19529729, 19455563
 19319904, 20877072, 18703978, 20340620, 18536826, 19700256, 19703246
 19292605, 20467806, 19192901, 21527118, 20660273, 20011635, 17592037
 19479503, 19147751, 19029647, 19179158, 18901356, 19140712, 20012766
 21232394, 18964974, 18835366, 19184276, 19207286, 19013789, 20001507
 20510208, 18950232, 19680763, 20079414, 19259765, 19148791, 19556820
 19449737, 18962892, 21646169, 19187515, 19513888, 14661880, 19230771
 21519340, 21222147, 20218012, 20795241, 19853036, 19453778, 19551830
 21616278, 19068333, 18520351, 18843572, 19185148, 18945435, 20775015
 19232454, 18541110, 18834955, 19319192, 19204743, 19178629, 20839581
 19304104, 18747335, 19140891, 20676340, 19270660, 19457575, 21297657
 19021575, 19069755, 18715884, 19584688, 18798573, 19812592, 19018001
 19325701, 19292272, 19270956, 20877003, 19222693, 18700893, 21276514
 19662663, 18406774, 19684131, 19010177, 21082737, 19272663, 18910576
 18907170, 19426384, 9372680, 20883009, 19700294, 19164099, 20289828
 19331454, 19155350, 20119857, 19703199, 18508710, 18955644, 19908346
 18798432, 19146822, 19589221, 21123424, 19471836, 19537762, 16286734
 20669114, 18762843, 18945249, 19045143, 19146980, 19184799, 19601003
 19205086, 20099624, 19351363, 20091753, 21378016, 19281106, 19537547
 18862203, 19031737, 19079087, 18968981, 19148367, 19150517, 20231741
 19954372, 19217019, 18730096, 18235274, 18975620, 19205617, 19513351
 20219458, 18843054, 19150313, 18708349, 18953639, 19332386, 21259359
 21423055, 19067804, 19371270, 19203996, 19318983, 20038431, 18747382
 19054979, 19209951, 19154673, 18752378, 19370846, 19150088, 19013444
 21053036, 19234177, 18998379, 20157569, 18999857, 19273577, 19367276
 19075747, 19632437, 19874047, 19612597, 18990354, 19288396, 19557558
 19427050, 19127078, 18910443, 20053557, 20033787, 19315567, 19444471
 19148982, 18290252, 19915945, 18813323, 19777496, 19500293, 18643483
 18523468, 19134098, 19277814, 20562133, 21420753, 19071526, 18965694
 19226858, 18850051, 19591356, 19602208, 20061168, 18417590, 19370739
 18920408, 19609388, 18636884, 20136892, 18776786, 18989446, 19148793
 19043795, 19585454, 20746507, 19955755, 18260170, 18317489, 19059053
 18919682, 19807548, 19124972, 18678829, 19617592, 19147509, 18910748
 18849896, 19319357, 19076165, 18953878, 19273758, 19704993, 19498411
 18999195, 18759724, 19459023, 20634511, 21474380, 20276459, 19066844
 17208793, 19234907, 20290467, 13843841, 19538714, 19383028, 19649640
 19062675, 19513969, 18859710, 20862812, 19504641, 19341481, 20293730
 19986391, 19343245, 18304090, 19314048, 19473851, 18834934, 19241655
 19470791, 18242738, 19458082, 18894342, 20649573, 18372060, 19522067
 18953889, 18827679, 19140711, 19023430, 19259290, 19045388, 20186278
 19241857, 19522571, 19076778, 19709663, 18875012, 19066699, 18861564
 19273760, 19225265, 20853464, 21696068, 18819158, 19068003, 18937186
 19916737, 21394146, 19049721, 19368917, 21255373, 19635215, 20408163
 18868829, 22024217, 19315522, 20783416, 19141785, 19885321, 19163887
 19820247, 20363708, 18715868, 18852058, 19538241, 19804032
 Files Touched:
 cluvfyrac.sh --> ORACLE_HOME/bin/cluvfyrac.sh
 crsdiag.pl --> ORACLE_HOME/bin/crsdiag.pl
 kfod --> ORACLE_HOME/bin/kfod
 lsnodes --> ORACLE_HOME/bin/lsnodes
 srvconfig --> ORACLE_HOME/bin/srvconfig
 libclsr12.a --> ORACLE_HOME/lib/libclsr12.a
 libskjcx12.so --> ORACLE_HOME/lib/libskjcx12.so
 libsrvm12.so --> ORACLE_HOME/oui/lib/libsrvm12.so
 ins_has.mk --> ORACLE_HOME/racg/lib/ins_has.mk
 clustdb.sql --> ORACLE_HOME/srvm/admin/clustdb.sql
 init.ora --> ORACLE_HOME/srvm/admin/init.ora
 libdbcfg12.a --> ORACLE_HOME/srvm/lib/libdbcfg12.a
 libocr12.a --> ORACLE_HOME/srvm/lib/libocr12.a
 libocrb12.a --> ORACLE_HOME/srvm/lib/libocrb12.a
 libocrutl12.a --> ORACLE_HOME/srvm/lib/libocrutl12.a
 libsrvm12.a --> ORACLE_HOME/srvm/lib/libsrvm12.a
 libsrvmhas12.a --> ORACLE_HOME/srvm/lib/libsrvmhas12.a
 libsrvmocr12.a --> ORACLE_HOME/srvm/lib/libsrvmocr12.a
 libuini12.a --> ORACLE_HOME/srvm/lib/libuini12.a
 pradmgrp.o --> ORACLE_HOME/srvm/lib/pradmgrp.o
 prifcg.o --> ORACLE_HOME/srvm/lib/prifcg.o
 prifcmn.o --> ORACLE_HOME/srvm/lib/prifcmn.o
 prifutl.o --> ORACLE_HOME/srvm/lib/prifutl.o
 prraw.o --> ORACLE_HOME/srvm/lib/prraw.o
 sprdbgrp.o --> ORACLE_HOME/srvm/lib/sprdbgrp.o
 sprifcg.o --> ORACLE_HOME/srvm/lib/sprifcg.o
 sprraw.o --> ORACLE_HOME/srvm/lib/sprraw.o
 srvm.jar --> ORACLE_HOME/oui/jlib/srvm.jar
 srvmasm.jar --> ORACLE_HOME/oui/jlib/srvmasm.jar
 libsrvm12.so --> ORACLE_HOME/oui/lib/linux/libsrvm12.so
 s_crsconfig_defs --> ORACLE_HOME/crs/install/s_crsconfig_defs
 env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
 crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
 crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
 crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
 crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
 crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
 crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
 crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
 crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
 crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
 crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
 crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
 crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
 crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
 crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
 crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb
 crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb
 crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb
 crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb
 crss.msb --> ORACLE_HOME/crs/mesg/crss.msb
 crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb
 crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb
 crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb
 crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb
 crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb
 crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg
 crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb
 crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb
 clsrwrap.sbs --> ORACLE_HOME/crs/sbs/clsrwrap.sbs
 diagcollection.sh.sbs --> ORACLE_HOME/crs/sbs/diagcollection.sh.sbs
 localconfig.sbs --> ORACLE_HOME/crs/sbs/localconfig.sbs
 srvctl.sbs --> ORACLE_HOME/crs/sbs/srvctl.sbs
 clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb
 clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb
 clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb
 clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb
 clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb
 clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb
 clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb
 clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb
 clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb
 clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb
 clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb
 clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb
 clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb
 clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb
 clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb
 clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb
 clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb
 clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb
 clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb
 clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb
 clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb
 clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb
 clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb
 clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb
 clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg
 clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb
 clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb
 catus.msg --> ORACLE_HOME/has/mesg/catus.msg
 clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb
 clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb
 clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb
 clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb
 clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb
 clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb
 clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb
 clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb
 clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb
 clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb
 clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb
 clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb
 clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb
 clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb
 clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb
 clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb
 clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb
 clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb
 clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb
 clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb
 clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb
 clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb
 clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb
 clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb
 clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb
 clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg
 clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb
 clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb
 clsgnar.msb --> ORACLE_HOME/has/mesg/clsgnar.msb
 clsgnca.msb --> ORACLE_HOME/has/mesg/clsgnca.msb
 clsgncs.msb --> ORACLE_HOME/has/mesg/clsgncs.msb
 clsgnd.msb --> ORACLE_HOME/has/mesg/clsgnd.msb
 clsgndk.msb --> ORACLE_HOME/has/mesg/clsgndk.msb
 clsgne.msb --> ORACLE_HOME/has/mesg/clsgne.msb
 clsgnel.msb --> ORACLE_HOME/has/mesg/clsgnel.msb
 clsgnesa.msb --> ORACLE_HOME/has/mesg/clsgnesa.msb
 clsgnf.msb --> ORACLE_HOME/has/mesg/clsgnf.msb
 clsgnhu.msb --> ORACLE_HOME/has/mesg/clsgnhu.msb
 clsgni.msb --> ORACLE_HOME/has/mesg/clsgni.msb
 clsgniw.msb --> ORACLE_HOME/has/mesg/clsgniw.msb
 clsgnja.msb --> ORACLE_HOME/has/mesg/clsgnja.msb
 clsgnko.msb --> ORACLE_HOME/has/mesg/clsgnko.msb
 clsgnn.msb --> ORACLE_HOME/has/mesg/clsgnn.msb
 clsgnnl.msb --> ORACLE_HOME/has/mesg/clsgnnl.msb
 clsgnpl.msb --> ORACLE_HOME/has/mesg/clsgnpl.msb
 clsgnpt.msb --> ORACLE_HOME/has/mesg/clsgnpt.msb
 clsgnptb.msb --> ORACLE_HOME/has/mesg/clsgnptb.msb
 clsgnro.msb --> ORACLE_HOME/has/mesg/clsgnro.msb
 clsgnru.msb --> ORACLE_HOME/has/mesg/clsgnru.msb
 clsgns.msb --> ORACLE_HOME/has/mesg/clsgns.msb
 clsgnsf.msb --> ORACLE_HOME/has/mesg/clsgnsf.msb
 clsgnsk.msb --> ORACLE_HOME/has/mesg/clsgnsk.msb
 clsgnth.msb --> ORACLE_HOME/has/mesg/clsgnth.msb
 clsgntr.msb --> ORACLE_HOME/has/mesg/clsgntr.msb
 clsgnus.msb --> ORACLE_HOME/has/mesg/clsgnus.msb
 clsgnus.msg --> ORACLE_HOME/has/mesg/clsgnus.msg
 clsgnzhs.msb --> ORACLE_HOME/has/mesg/clsgnzhs.msb
 clsgnzht.msb --> ORACLE_HOME/has/mesg/clsgnzht.msb
 clsnsar.msb --> ORACLE_HOME/has/mesg/clsnsar.msb
 clsnscs.msb --> ORACLE_HOME/has/mesg/clsnscs.msb
 clsnsd.msb --> ORACLE_HOME/has/mesg/clsnsd.msb
 clsnsdk.msb --> ORACLE_HOME/has/mesg/clsnsdk.msb
 clsnse.msb --> ORACLE_HOME/has/mesg/clsnse.msb
 clsnsel.msb --> ORACLE_HOME/has/mesg/clsnsel.msb
 clsnsf.msb --> ORACLE_HOME/has/mesg/clsnsf.msb
 clsnshu.msb --> ORACLE_HOME/has/mesg/clsnshu.msb
 clsnsi.msb --> ORACLE_HOME/has/mesg/clsnsi.msb
 clsnsiw.msb --> ORACLE_HOME/has/mesg/clsnsiw.msb
 clsnsja.msb --> ORACLE_HOME/has/mesg/clsnsja.msb
 clsnsko.msb --> ORACLE_HOME/has/mesg/clsnsko.msb
 clsnsn.msb --> ORACLE_HOME/has/mesg/clsnsn.msb
 clsnsnl.msb --> ORACLE_HOME/has/mesg/clsnsnl.msb
 clsnspl.msb --> ORACLE_HOME/has/mesg/clsnspl.msb
 clsnspt.msb --> ORACLE_HOME/has/mesg/clsnspt.msb
 clsnsptb.msb --> ORACLE_HOME/has/mesg/clsnsptb.msb
 clsnsro.msb --> ORACLE_HOME/has/mesg/clsnsro.msb
 clsnsru.msb --> ORACLE_HOME/has/mesg/clsnsru.msb
 clsnss.msb --> ORACLE_HOME/has/mesg/clsnss.msb
 clsnssf.msb --> ORACLE_HOME/has/mesg/clsnssf.msb
 clsnssk.msb --> ORACLE_HOME/has/mesg/clsnssk.msb
 clsnsth.msb --> ORACLE_HOME/has/mesg/clsnsth.msb
 clsnstr.msb --> ORACLE_HOME/has/mesg/clsnstr.msb
 clsnsus.msb --> ORACLE_HOME/has/mesg/clsnsus.msb
 clsnsus.msg --> ORACLE_HOME/has/mesg/clsnsus.msg
 clsnszhs.msb --> ORACLE_HOME/has/mesg/clsnszhs.msb
 clsnszht.msb --> ORACLE_HOME/has/mesg/clsnszht.msb
 clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb
 clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb
 clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb
 clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb
 clste.msb --> ORACLE_HOME/has/mesg/clste.msb
 clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb
 clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb
 clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb
 clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb
 clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb
 clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb
 clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb
 clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb
 clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb
 clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb
 clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb
 clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb
 clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb
 clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb
 clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb
 clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb
 clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb
 clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb
 clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb
 clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb
 clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg
 clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb
 clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb
 clsuar.msb --> ORACLE_HOME/has/mesg/clsuar.msb
 clsuca.msb --> ORACLE_HOME/has/mesg/clsuca.msb
 clsucs.msb --> ORACLE_HOME/has/mesg/clsucs.msb
 clsud.msb --> ORACLE_HOME/has/mesg/clsud.msb
 clsudk.msb --> ORACLE_HOME/has/mesg/clsudk.msb
 clsue.msb --> ORACLE_HOME/has/mesg/clsue.msb
 clsuel.msb --> ORACLE_HOME/has/mesg/clsuel.msb
 clsuf.msb --> ORACLE_HOME/has/mesg/clsuf.msb
 clsuhu.msb --> ORACLE_HOME/has/mesg/clsuhu.msb
 clsui.msb --> ORACLE_HOME/has/mesg/clsui.msb
 clsuiw.msb --> ORACLE_HOME/has/mesg/clsuiw.msb
 clsuja.msb --> ORACLE_HOME/has/mesg/clsuja.msb
 clsuko.msb --> ORACLE_HOME/has/mesg/clsuko.msb
 clsun.msb --> ORACLE_HOME/has/mesg/clsun.msb
 clsunl.msb --> ORACLE_HOME/has/mesg/clsunl.msb
 clsupl.msb --> ORACLE_HOME/has/mesg/clsupl.msb
 clsupt.msb --> ORACLE_HOME/has/mesg/clsupt.msb
 clsuptb.msb --> ORACLE_HOME/has/mesg/clsuptb.msb
 clsuro.msb --> ORACLE_HOME/has/mesg/clsuro.msb
 clsuru.msb --> ORACLE_HOME/has/mesg/clsuru.msb
 clsusf.msb --> ORACLE_HOME/has/mesg/clsusf.msb
 clsusk.msb --> ORACLE_HOME/has/mesg/clsusk.msb
 clsuth.msb --> ORACLE_HOME/has/mesg/clsuth.msb
 clsutr.msb --> ORACLE_HOME/has/mesg/clsutr.msb
 clsuus.msb --> ORACLE_HOME/has/mesg/clsuus.msb
 clsuus.msg --> ORACLE_HOME/has/mesg/clsuus.msg
 clsuzhs.msb --> ORACLE_HOME/has/mesg/clsuzhs.msb
 clsuzht.msb --> ORACLE_HOME/has/mesg/clsuzht.msb
 clswar.msb --> ORACLE_HOME/has/mesg/clswar.msb
 clswcs.msb --> ORACLE_HOME/has/mesg/clswcs.msb
 clswd.msb --> ORACLE_HOME/has/mesg/clswd.msb
 clswdk.msb --> ORACLE_HOME/has/mesg/clswdk.msb
 clswe.msb --> ORACLE_HOME/has/mesg/clswe.msb
 clswel.msb --> ORACLE_HOME/has/mesg/clswel.msb
 clswf.msb --> ORACLE_HOME/has/mesg/clswf.msb
 clswhu.msb --> ORACLE_HOME/has/mesg/clswhu.msb
 clswi.msb --> ORACLE_HOME/has/mesg/clswi.msb
 clswiw.msb --> ORACLE_HOME/has/mesg/clswiw.msb
 clswja.msb --> ORACLE_HOME/has/mesg/clswja.msb
 clswko.msb --> ORACLE_HOME/has/mesg/clswko.msb
 clswn.msb --> ORACLE_HOME/has/mesg/clswn.msb
 clswnl.msb --> ORACLE_HOME/has/mesg/clswnl.msb
 clswpl.msb --> ORACLE_HOME/has/mesg/clswpl.msb
 clswpt.msb --> ORACLE_HOME/has/mesg/clswpt.msb
 clswptb.msb --> ORACLE_HOME/has/mesg/clswptb.msb
 clswro.msb --> ORACLE_HOME/has/mesg/clswro.msb
 clswru.msb --> ORACLE_HOME/has/mesg/clswru.msb
 clsws.msb --> ORACLE_HOME/has/mesg/clsws.msb
 clswsf.msb --> ORACLE_HOME/has/mesg/clswsf.msb
 clswsk.msb --> ORACLE_HOME/has/mesg/clswsk.msb
 clswth.msb --> ORACLE_HOME/has/mesg/clswth.msb
 clswtr.msb --> ORACLE_HOME/has/mesg/clswtr.msb
 clswus.msb --> ORACLE_HOME/has/mesg/clswus.msb
 clswus.msg --> ORACLE_HOME/has/mesg/clswus.msg
 clswzhs.msb --> ORACLE_HOME/has/mesg/clswzhs.msb
 clswzht.msb --> ORACLE_HOME/has/mesg/clswzht.msb
 gipcar.msb --> ORACLE_HOME/has/mesg/gipcar.msb
 gipcca.msb --> ORACLE_HOME/has/mesg/gipcca.msb
 gipccs.msb --> ORACLE_HOME/has/mesg/gipccs.msb
 gipcd.msb --> ORACLE_HOME/has/mesg/gipcd.msb
 gipcdk.msb --> ORACLE_HOME/has/mesg/gipcdk.msb
 gipce.msb --> ORACLE_HOME/has/mesg/gipce.msb
 gipcel.msb --> ORACLE_HOME/has/mesg/gipcel.msb
 gipcf.msb --> ORACLE_HOME/has/mesg/gipcf.msb
 gipchu.msb --> ORACLE_HOME/has/mesg/gipchu.msb
 gipci.msb --> ORACLE_HOME/has/mesg/gipci.msb
 gipciw.msb --> ORACLE_HOME/has/mesg/gipciw.msb
 gipcja.msb --> ORACLE_HOME/has/mesg/gipcja.msb
 gipcko.msb --> ORACLE_HOME/has/mesg/gipcko.msb
 gipcn.msb --> ORACLE_HOME/has/mesg/gipcn.msb
 gipcnl.msb --> ORACLE_HOME/has/mesg/gipcnl.msb
 gipcpl.msb --> ORACLE_HOME/has/mesg/gipcpl.msb
 gipcpt.msb --> ORACLE_HOME/has/mesg/gipcpt.msb
 gipcptb.msb --> ORACLE_HOME/has/mesg/gipcptb.msb
 gipcro.msb --> ORACLE_HOME/has/mesg/gipcro.msb
 gipcru.msb --> ORACLE_HOME/has/mesg/gipcru.msb
 gipcsf.msb --> ORACLE_HOME/has/mesg/gipcsf.msb
 gipcsk.msb --> ORACLE_HOME/has/mesg/gipcsk.msb
 gipcth.msb --> ORACLE_HOME/has/mesg/gipcth.msb
 gipctr.msb --> ORACLE_HOME/has/mesg/gipctr.msb
 gipcus.msb --> ORACLE_HOME/has/mesg/gipcus.msb
 gipcus.msg --> ORACLE_HOME/has/mesg/gipcus.msg
 gipczhs.msb --> ORACLE_HOME/has/mesg/gipczhs.msb
 gipczht.msb --> ORACLE_HOME/has/mesg/gipczht.msb
 odigus.msb --> ORACLE_HOME/has/mesg/odigus.msb
 odigus.msg --> ORACLE_HOME/has/mesg/odigus.msg
 rdear.msb --> ORACLE_HOME/has/mesg/rdear.msb
 rdeca.msb --> ORACLE_HOME/has/mesg/rdeca.msb
 rdecs.msb --> ORACLE_HOME/has/mesg/rdecs.msb
 rded.msb --> ORACLE_HOME/has/mesg/rded.msb
 rdedk.msb --> ORACLE_HOME/has/mesg/rdedk.msb
 rdee.msb --> ORACLE_HOME/has/mesg/rdee.msb
 rdeel.msb --> ORACLE_HOME/has/mesg/rdeel.msb
 rdef.msb --> ORACLE_HOME/has/mesg/rdef.msb
 rdehu.msb --> ORACLE_HOME/has/mesg/rdehu.msb
 rdei.msb --> ORACLE_HOME/has/mesg/rdei.msb
 rdeiw.msb --> ORACLE_HOME/has/mesg/rdeiw.msb
 rdeja.msb --> ORACLE_HOME/has/mesg/rdeja.msb
 rdeko.msb --> ORACLE_HOME/has/mesg/rdeko.msb
 rden.msb --> ORACLE_HOME/has/mesg/rden.msb
 rdenl.msb --> ORACLE_HOME/has/mesg/rdenl.msb
 rdepl.msb --> ORACLE_HOME/has/mesg/rdepl.msb
 rdept.msb --> ORACLE_HOME/has/mesg/rdept.msb
 rdeptb.msb --> ORACLE_HOME/has/mesg/rdeptb.msb
 rdero.msb --> ORACLE_HOME/has/mesg/rdero.msb
 rderu.msb --> ORACLE_HOME/has/mesg/rderu.msb
 rdes.msb --> ORACLE_HOME/has/mesg/rdes.msb
 rdesf.msb --> ORACLE_HOME/has/mesg/rdesf.msb
 rdesk.msb --> ORACLE_HOME/has/mesg/rdesk.msb
 rdeth.msb --> ORACLE_HOME/has/mesg/rdeth.msb
 rdetr.msb --> ORACLE_HOME/has/mesg/rdetr.msb
 rdeus.msb --> ORACLE_HOME/has/mesg/rdeus.msb
 rdeus.msg --> ORACLE_HOME/has/mesg/rdeus.msg
 rdezhs.msb --> ORACLE_HOME/has/mesg/rdezhs.msb
 rdezht.msb --> ORACLE_HOME/has/mesg/rdezht.msb
 clsce.jar --> ORACLE_HOME/jlib/clsce.jar
 consoleapps.jar --> ORACLE_HOME/jlib/consoleapps.jar
 gns.jar --> ORACLE_HOME/jlib/gns.jar
 rd.jar --> ORACLE_HOME/jlib/rd.jar
 rdtool.jar --> ORACLE_HOME/jlib/rdtool.jar
 srvm.jar --> ORACLE_HOME/jlib/srvm.jar
 srvmasm.jar --> ORACLE_HOME/jlib/srvmasm.jar
 srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar
 supercluster-common.jar --> ORACLE_HOME/jlib/supercluster-common.jar
 supercluster.jar --> ORACLE_HOME/jlib/supercluster.jar
 libagfw12.so --> ORACLE_HOME/lib/libagfw12.so
 libclsce12.so --> ORACLE_HOME/lib/libclsce12.so
 libclsra12.so --> ORACLE_HOME/lib/libclsra12.so
 libdbcfg12.so --> ORACLE_HOME/lib/libdbcfg12.so
 libeons.so --> ORACLE_HOME/lib/libeons.so
 libgns12.so --> ORACLE_HOME/lib/libgns12.so
 libgnsjni12.so --> ORACLE_HOME/lib/libgnsjni12.so
 libhasgen12.so --> ORACLE_HOME/lib/libhasgen12.so
 libocr12.so --> ORACLE_HOME/lib/libocr12.so
 libocrb12.so --> ORACLE_HOME/lib/libocrb12.so
 libocrutl12.so --> ORACLE_HOME/lib/libocrutl12.so
 liboevm.a --> ORACLE_HOME/lib/liboevm.a
 librdjni12.so --> ORACLE_HOME/lib/librdjni12.so
 libsrvmcred12.so --> ORACLE_HOME/lib/libsrvmcred12.so
 libsrvmhas12.so --> ORACLE_HOME/lib/libsrvmhas12.so
 libsrvmocr12.so --> ORACLE_HOME/lib/libsrvmocr12.so
 libuini12.so --> ORACLE_HOME/lib/libuini12.so
 libsrvm12.so --> ORACLE_HOME/oui/lib/libsrvm12.so
 s0clsrdmai.o --> ORACLE_HOME/racg/lib/s0clsrdmai.o
 s0clsreut.o --> ORACLE_HOME/racg/lib/s0clsreut.o
 s0clsrmain.o --> ORACLE_HOME/racg/lib/s0clsrmain.o
 s0clsrmdb.o --> ORACLE_HOME/racg/lib/s0clsrmdb.o
 clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb
 clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb
 clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb
 clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb
 clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb
 clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb
 clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb
 clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb
 clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb
 clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb
 clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb
 clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb
 clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb
 clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb
 clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb
 clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb
 clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb
 clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb
 clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb
 clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb
 clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb
 clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb
 clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb
 clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb
 clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb
 clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg
 clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb
 clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb
 ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini
 antlr-3.3-complete.jar --> ORACLE_HOME/srvm/jlib/antlr-3.3-complete.jar
 srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar
 env_srvm.mk --> ORACLE_HOME/srvm/lib/env_srvm.mk
 ins_srvm.mk --> ORACLE_HOME/srvm/lib/ins_srvm.mk
 prgcrshm.o --> ORACLE_HOME/srvm/lib/prgcrshm.o
 sprgcrshm.o --> ORACLE_HOME/srvm/lib/sprgcrshm.o
 prcaus.msg --> ORACLE_HOME/srvm/mesg/prcaus.msg
 prccus.msg --> ORACLE_HOME/srvm/mesg/prccus.msg
 prcdus.msg --> ORACLE_HOME/srvm/mesg/prcdus.msg
 prceus.msg --> ORACLE_HOME/srvm/mesg/prceus.msg
 prcfus.msg --> ORACLE_HOME/srvm/mesg/prcfus.msg
 prchus.msg --> ORACLE_HOME/srvm/mesg/prchus.msg
 prcius.msg --> ORACLE_HOME/srvm/mesg/prcius.msg
 prclus.msg --> ORACLE_HOME/srvm/mesg/prclus.msg
 prcnus.msg --> ORACLE_HOME/srvm/mesg/prcnus.msg
 prcpus.msg --> ORACLE_HOME/srvm/mesg/prcpus.msg
 prcqus.msg --> ORACLE_HOME/srvm/mesg/prcqus.msg
 prcrus.msg --> ORACLE_HOME/srvm/mesg/prcrus.msg
 prcsus.msg --> ORACLE_HOME/srvm/mesg/prcsus.msg
 prctus.msg --> ORACLE_HOME/srvm/mesg/prctus.msg
 prcwus.msg --> ORACLE_HOME/srvm/mesg/prcwus.msg
 prczus.msg --> ORACLE_HOME/srvm/mesg/prczus.msg
 prghus.msg --> ORACLE_HOME/srvm/mesg/prghus.msg
 prgous.msg --> ORACLE_HOME/srvm/mesg/prgous.msg
 prgrus.msg --> ORACLE_HOME/srvm/mesg/prgrus.msg
 prgsus.msg --> ORACLE_HOME/srvm/mesg/prgsus.msg
 prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb
 prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb
 priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb
 prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb
 prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb
 prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb
 prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb
 prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb
 prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg
 prkaus.msg --> ORACLE_HOME/srvm/mesg/prkaus.msg
 prkcus.msg --> ORACLE_HOME/srvm/mesg/prkcus.msg
 prkdus.msg --> ORACLE_HOME/srvm/mesg/prkdus.msg
 prkeus.msg --> ORACLE_HOME/srvm/mesg/prkeus.msg
 prkfus.msg --> ORACLE_HOME/srvm/mesg/prkfus.msg
 prkhus.msg --> ORACLE_HOME/srvm/mesg/prkhus.msg
 prknus.msg --> ORACLE_HOME/srvm/mesg/prknus.msg
 prkous.msg --> ORACLE_HOME/srvm/mesg/prkous.msg
 prkpus.msg --> ORACLE_HOME/srvm/mesg/prkpus.msg
 prkrus.msg --> ORACLE_HOME/srvm/mesg/prkrus.msg
 prksus.msg --> ORACLE_HOME/srvm/mesg/prksus.msg
 prkuus.msg --> ORACLE_HOME/srvm/mesg/prkuus.msg
 prkzus.msg --> ORACLE_HOME/srvm/mesg/prkzus.msg
 procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb
 proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb
 procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb
 proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb
 procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb
 procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb
 procld.msb --> ORACLE_HOME/srvm/mesg/procld.msb
 procle.msb --> ORACLE_HOME/srvm/mesg/procle.msb
 proclf.msb --> ORACLE_HOME/srvm/mesg/proclf.msb
 procli.msb --> ORACLE_HOME/srvm/mesg/procli.msb
 proclja.msb --> ORACLE_HOME/srvm/mesg/proclja.msb
 proclko.msb --> ORACLE_HOME/srvm/mesg/proclko.msb
 proclptb.msb --> ORACLE_HOME/srvm/mesg/proclptb.msb
 proclus.msb --> ORACLE_HOME/srvm/mesg/proclus.msb
 proclus.msg --> ORACLE_HOME/srvm/mesg/proclus.msg
 proclzhs.msb --> ORACLE_HOME/srvm/mesg/proclzhs.msb
 proclzht.msb --> ORACLE_HOME/srvm/mesg/proclzht.msb
 procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb
 procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb
 procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg
 proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb
 proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb
 prveus.msg --> ORACLE_HOME/srvm/mesg/prveus.msg
 prvfus.msg --> ORACLE_HOME/srvm/mesg/prvfus.msg
 prvgus.msg --> ORACLE_HOME/srvm/mesg/prvgus.msg
 prvpus.msg --> ORACLE_HOME/srvm/mesg/prvpus.msg
 sclcus.msg --> ORACLE_HOME/srvm/mesg/sclcus.msg
 sclsus.msg --> ORACLE_HOME/srvm/mesg/sclsus.msg
 ins_srvm.mk --> ORACLE_HOME/srvm/lib/install_srvm
 ins_has.mk --> ORACLE_HOME/racg/lib/install
 Patch Location in Inventory:
 /ora00/app/oracle/product/12.1.0/inventory/oneoffs/21255373
 Patch Location in Storage area:
 /ora00/app/oracle/product/12.1.0/.patch_storage/21255373_Feb_19_2016_17_21_55

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

OPatch succeeded.
Posted in Database, ORACLE

Oracle dba Career in India!!!!

 

I have been working in INDIAN IT industry for past few years. Started working as a Junior DBA and then eventually working on System as Well as Database.

So i will break DBA life in these timelines based on my experience. It is pretty long but do keep up with me!!

  • Getting Job as an Oracle DBA

To enter in Oracle DBA job as a fresher is pretty tough thing to accomplish. You have to either work as a Oracle PL/SQL developer and then eventually if you get some opportunity in same company you can become a Junior DBA.Obviously If you have Certification it adds Up but doesn’t guarantee you a Job.

There is one more way you can try yourself to learn Oracle Database through Blogs or Videos there are many Oracle Geek present in this world who are sharing their work to help others. Learn from them and do practical and go for JOB-WALKINS and if you are Lucky you may end up being a Junior DBA.

  • Starting Life of a DBA

In starting part of your career everything seems new, so there is great Learning curve for you. Try to learn and practice everything you encountered in Job.

It is a good practice to follow Oracle Forum as it is good platform to learn new thing. This thing helped me a lot!!!!

Also some of you may end Up in Night Shift Jobs i myself try to avoid it but sadly it is truth of IT industry in India Wherever there is a Production Database you need 24*7 support.

In a support you initially join as a L1 executive and most of the company works on ticketing basis. There you have to solve day to day issue which involves managing Database Checklist, Checking Backup logs, User Creation and management, Database Management.

  • Transition Phase of a DBA.

The issue which you get in support become repetitive after sometime so  don’t become stagnant at one point.

Try implementing something you learn on your test system, Start Reading Blogs and Help people on Oracle Forum. Saying this point is easy but maintaining this routine is quite tough. This thing you have to follow if you have to transit yourself from being a Database Operator to Database Architect. Sad truth is most people especially in India i see after having 10 years of experience is doing Operator kind of Job.

  • Growing your career.

After sometime there comes a point when you may be needed to learn some new technologies of Database apart from Oracle DBA because frankly speaking Oracle Database is good but it is damn expensive when it comes to Licensing terms. Every IT company want to save money and one of the way for them is to use less expensive database technologies or open-source database technologies.

So you should prepare yourself for that because some-people are very adamant if someone tell them to learn some other technologies database. If you are really passionate in database as a whole, then there is nothing wrong in learning something new.

If you want to keep yourself inclined toward Oracle only and want to grow with Oracle technologies then start going to Oracle Meetup in your City or nearby places. In those meetup you will meet some of best DBA around world which will help in growing your network and also start sharing your work through Blogs or forums. There is Oracle ACE award which you can target and for this award you should be living and drinking Oracle!!!!!

  • Money Prospect and Future.

In India Starting salary of a DBA is pretty low and many companies want to hire them on low pay as compare to Market salary based on years of experience and knowledge.

After years of experience Companies expect people to be certified and be SME of Oracle and the salary they offer will be totally against it.

Sad truth is that there is only few companies which pays you as per market salary and also work etiquette is good.

DBA roles are changing with change in Technologies trend like Cloud Technologies so it would be better if you know business side of your Company.You can learn BI and become a BI professional or you can learn Data Warehousing or you can Become an Architect there is lots of Career Growth if you are a DBA.Do choose them wisely!!!!

  • Truth

Based on my experience i will tell you one thing is that maintaing Personal and Profession life after being a DBA is pretty tough. No matter how much people tell you but it is tough as you have to work on weekends and support any kind of Drills which happen and Work on Night Shift and you sometime if you are in support you get holidays not on weekend but on any weekdays. For these thing prepare yourself!!!!!!!

I myself feels sticking to one technologies may make you stagnant in long terms, It’s your passion that keep you going.

Choose your career wisely as it will take major part of your life and if you are not happy with it then there is no amount of money which can bring you happiness!!!!!!!