Hi Reader,
Sharing the following RAC online training URLs from Oracle University,
RAC & ASM - http://oukc.oracle.com/static05/opn/oracle9i_database/40168/053107_40168_source/index.htm
RAC Tuning Steps : http://oukc.oracle.com/static05/opn/oracle9i_database/49466/040908_49466_source/index.htm
RAC Beginners : http://oukc.oracle.com/static05/opn/oracle9i_database/64339/120408_64339_source/index.htm
RAC Internels : http://oukc.oracle.com/static05/opn/oracle9i_database/40168/053107_40168_source/index.htm
Comments are welcome !!!
- Thanks.
Monday, January 11, 2010
Concurrent Manager issue ( Actual 0, Target 1 ) in R12
Dear Reader,
Today, One of my application user reported that the workflow services were down on TEST instance.
When I checked through OAM ( System Administrator --> OAM --> Workflow Manager ), I saw all service components are down.
Then, I checked in Concurrent Administrator window, I saw all Workflow managers ( ie. Workflow Notification Mailer, Workflow Agent Listener,Workflow Document Web Services Service ) were having their actul value as 0 and target value as 1.
I have tried with Restarting Workflow managers one by one, Activating and Deactivating the managers. But still issue was persist. So, many of the notes suggested to run cmclean.sql and bounce entire CM services.
Finally, I have decided to fix this issue without bouncing any services. I have completely reviewed the CMCLEAN.sql and execute the following update statements manually for all the WF Managers,
-- Updating process value as Zero
UPDATE fnd_concurrent_queues
SET running_processes = 0, max_processes = 0
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
-- Updating Control code with NULL
UPDATE fnd_concurrent_queues
SET control_code = NULL
WHERE concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC')
AND control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL;
-- Making Target node as Null
UPDATE fnd_concurrent_queues
SET target_node = null
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
commit;
After making these updates statements, Immediately Internal manager brought up all Workflow managers with actual and target value as 1 and all service components showed as UP in OAM.
Same update statements I have performed for "Output Post Processor" concurrent manager and this also fixed.
Finally I have ignored the bouncing of ICM Services. :)
You can also do the same and update your comments here.
Thanks once again for visiting our blog !!!
Today, One of my application user reported that the workflow services were down on TEST instance.
When I checked through OAM ( System Administrator --> OAM --> Workflow Manager ), I saw all service components are down.
Then, I checked in Concurrent Administrator window, I saw all Workflow managers ( ie. Workflow Notification Mailer, Workflow Agent Listener,Workflow Document Web Services Service ) were having their actul value as 0 and target value as 1.
I have tried with Restarting Workflow managers one by one, Activating and Deactivating the managers. But still issue was persist. So, many of the notes suggested to run cmclean.sql and bounce entire CM services.
Finally, I have decided to fix this issue without bouncing any services. I have completely reviewed the CMCLEAN.sql and execute the following update statements manually for all the WF Managers,
-- Updating process value as Zero
UPDATE fnd_concurrent_queues
SET running_processes = 0, max_processes = 0
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
-- Updating Control code with NULL
UPDATE fnd_concurrent_queues
SET control_code = NULL
WHERE concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC')
AND control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL;
-- Making Target node as Null
UPDATE fnd_concurrent_queues
SET target_node = null
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
commit;
After making these updates statements, Immediately Internal manager brought up all Workflow managers with actual and target value as 1 and all service components showed as UP in OAM.
Same update statements I have performed for "Output Post Processor" concurrent manager and this also fixed.
Finally I have ignored the bouncing of ICM Services. :)
You can also do the same and update your comments here.
Thanks once again for visiting our blog !!!
Sunday, January 10, 2010
Application Index
Utilities
Find What Services Running in R12
AD Utilities
Performance
Forms Performance Issue in R12
Bug Fixes
CLASSCAST Exception in Supplier Portal R12
Find What Services Running in R12
AD Utilities
Performance
Forms Performance Issue in R12
Bug Fixes
CLASSCAST Exception in Supplier Portal R12
Sunday, January 3, 2010
Hot Backup
Dear Friends,
From long back, I have doubt on What exactly happening when Database is in HOT BACKUP mode ?
Here we have explaniation for this,
- When an 'alter tablespace begin backup' command is issued the datafiles that belong to the tablespace are marked as hot-backup-in-progress.
- The dirty databuffers in the database buffer cache that belong to the database files are written out to the files and the datafiles are checkpointed.
- The datafile headers are updated to the SCN captured when the begin backup is issued.
- The datafile headers are not updated until the 'alter tablespace end backup' command is issued;
- However, the datablock within the database files can continue to be read and updated.
- When the datafile is restored from a hot backup, the recovery will begin from the SCN captured during the begin backup is issued.
- All changes applied during the hot backup time period will be rolled forward from the redo logs.
Hope this information will clear all our doubts.
From long back, I have doubt on What exactly happening when Database is in HOT BACKUP mode ?
Here we have explaniation for this,
- When an 'alter tablespace begin backup' command is issued the datafiles that belong to the tablespace are marked as hot-backup-in-progress.
- The dirty databuffers in the database buffer cache that belong to the database files are written out to the files and the datafiles are checkpointed.
- The datafile headers are updated to the SCN captured when the begin backup is issued.
- The datafile headers are not updated until the 'alter tablespace end backup' command is issued;
- However, the datablock within the database files can continue to be read and updated.
- When the datafile is restored from a hot backup, the recovery will begin from the SCN captured during the begin backup is issued.
- All changes applied during the hot backup time period will be rolled forward from the redo logs.
Hope this information will clear all our doubts.
Friday, January 1, 2010
SPFILE and INIT.ORA
Hi Peers,
This is the article which will explain you about init parameter reposistory feature.
However this is basic level but helping us to understand stronger.
SPFILE and INIT.ORA
Oracle9i allows more and more parameters to be changed on-the-fly without having torestart the database. Consequently, the DBA has to remember, more and more often, to change the parameter file accordingly before the next restart of the database. Oracle9i enables dynamically altered parameters to be simultaneously written to the parameter file using server parameter files (SPFILE) so that changes are consistent with ALTER SYSTEM.
$ Up to version 8i, Oracle traditionally stored initialization parameters in a text file INIT.ORA (PFILE).
$ With Oracle9i, server parameter files (SPFILE) can also be used.
$ An SPFILE can be regarded as a repository for initialization parameters which is located on the database server.
$ SPFILEs are small binary files that cannot be edited.
$ Editing SPFILEs corrupts the file and either the instance fails to start or an active instance may crash.
eg ( Content ):
*.db_block_size=8192
*.db_domain='ttc.trivadis.com'
*.db_file_multiblock_read_count=16
*.db_files=1022
*.db_name='TVD901A'
...
*. means:
all instances of this database system. This is also valid syntax in conventional INIT.ORA files.
*. This is particularly interesting for Real Application Cluster (RAC) – see below for more information.
At database startup, if no PFILE is specified at the OS-dependent default location
($ORACLE_HOME/dbs under UNIX, $ORACLE_HOME\database under NT),
the startup command searches for:
1. spfile${ORACLE_SID}.ora
2. spfile.ora
3. init${ORACLE_SID}.ora
Of course, the option of explicitly specifying a PFILE is still available.
SQL> connect sys/manager as sysdba
Connected to an idle instance.
SQL> startup pfile=/tmp/initTVD901A.ora
ORACLE instance started.
Total System Global Area 172967504 bytes
...
SQL>
However, a SPFILE cannot be specified for STARTUP with PFILE :
SQL> startup pfile='tmp/spfileTVD901A.ora'
LRM-00101: unknown parameter name 's044'
ORA-01078: failure in processing system parameters
To facilitate this, the best option is to create a conventional INIT.ORA with default name:
init${ORACLE_SID}.ora
This file only contains the path of the SPFILE:
SPFILE = c:\oracle\admin\db1\pfile\spfileDB1.ora
Create SPFILE
A SPFILE is initially created from a conventional text initialization parameters file (PFILE,
INIT.ORA). This can be carried out without a started instance. SYSDBA or SYSOPER
privileges are required to create the SPFILE.
If SPFILE is available at the default location, STARTUP uses this SPFILE if no PFILE is specified.
Creating an SPFILE from a PFILE at the default location:
SQL> CREATE SPFILE FROM PFILE='/u00/app/oracle/admin/TVD901A/pfile/initTVD901A.ora';
File created.
SQL>
Creating an SPFILE from a PFILE at the non-default location:
SQL> CREATE SPFILE='/u00/app/oracle/admin/TVD901A/pfile/spfileTVD901A.ora'
FROM PFILE='/u00/app/oracle/admin/TVD901A/pfile/initTVD901A.ora';
File created.
SQL>
The best solution is to create a (conventional) INIT.ORA with default name in the default location,
which contains only the path to the SPFILE.
Working with links, if necessary, on UNIX:
sqlplus "/ as sysdba"
startup create spfile='/u00/app/oracle/admin/TDBT901A/pfile/spfileTVD901A.ora' from
pfile='/u00/app/oracle/admin/SID/pfile/initTVD901A.ora';
shutdown immediate
exit
cd $ORACLE_HOME/dbs
ln -s /u00/app/oracle/admin/TDBT901A/pfile/spfileTVD901A.ora .
sqlplus "/ as sysdba"
startup
Backing up an SPFILE
The CREATE PFILE command can be used to back up an SPFILE:
SQL> CREATE PFILE='/u00/app/oracle/admin/TVD901A/pfile/bck_init.ora' FROM SPFILE;
File created.
SQL>
This creates a directly usable INIT.ORA file:
*.background_dump_dest='/u00/app/oracle/admin/TVD901A/bdump'
*.compatible='9.0.1'
*.control_file_record_keep_time=90
*.core_dump_dest='/u00/app/oracle/admin/TVD901A/cdump'
Continue.........
This is the article which will explain you about init parameter reposistory feature.
However this is basic level but helping us to understand stronger.
SPFILE and INIT.ORA
Oracle9i allows more and more parameters to be changed on-the-fly without having torestart the database. Consequently, the DBA has to remember, more and more often, to change the parameter file accordingly before the next restart of the database. Oracle9i enables dynamically altered parameters to be simultaneously written to the parameter file using server parameter files (SPFILE) so that changes are consistent with ALTER SYSTEM.
$ Up to version 8i, Oracle traditionally stored initialization parameters in a text file INIT.ORA (PFILE).
$ With Oracle9i, server parameter files (SPFILE) can also be used.
$ An SPFILE can be regarded as a repository for initialization parameters which is located on the database server.
$ SPFILEs are small binary files that cannot be edited.
$ Editing SPFILEs corrupts the file and either the instance fails to start or an active instance may crash.
eg ( Content ):
*.db_block_size=8192
*.db_domain='ttc.trivadis.com'
*.db_file_multiblock_read_count=16
*.db_files=1022
*.db_name='TVD901A'
...
*. means:
all instances of this database system. This is also valid syntax in conventional INIT.ORA files.
*. This is particularly interesting for Real Application Cluster (RAC) – see below for more information.
At database startup, if no PFILE is specified at the OS-dependent default location
($ORACLE_HOME/dbs under UNIX, $ORACLE_HOME\database under NT),
the startup command searches for:
1. spfile${ORACLE_SID}.ora
2. spfile.ora
3. init${ORACLE_SID}.ora
Of course, the option of explicitly specifying a PFILE is still available.
SQL> connect sys/manager as sysdba
Connected to an idle instance.
SQL> startup pfile=/tmp/initTVD901A.ora
ORACLE instance started.
Total System Global Area 172967504 bytes
...
SQL>
However, a SPFILE cannot be specified for STARTUP with PFILE :
SQL> startup pfile='tmp/spfileTVD901A.ora'
LRM-00101: unknown parameter name 's044'
ORA-01078: failure in processing system parameters
To facilitate this, the best option is to create a conventional INIT.ORA with default name:
init${ORACLE_SID}.ora
This file only contains the path of the SPFILE:
SPFILE = c:\oracle\admin\db1\pfile\spfileDB1.ora
Create SPFILE
A SPFILE is initially created from a conventional text initialization parameters file (PFILE,
INIT.ORA). This can be carried out without a started instance. SYSDBA or SYSOPER
privileges are required to create the SPFILE.
If SPFILE is available at the default location, STARTUP uses this SPFILE if no PFILE is specified.
Creating an SPFILE from a PFILE at the default location:
SQL> CREATE SPFILE FROM PFILE='/u00/app/oracle/admin/TVD901A/pfile/initTVD901A.ora';
File created.
SQL>
Creating an SPFILE from a PFILE at the non-default location:
SQL> CREATE SPFILE='/u00/app/oracle/admin/TVD901A/pfile/spfileTVD901A.ora'
FROM PFILE='/u00/app/oracle/admin/TVD901A/pfile/initTVD901A.ora';
File created.
SQL>
The best solution is to create a (conventional) INIT.ORA with default name in the default location,
which contains only the path to the SPFILE.
Working with links, if necessary, on UNIX:
sqlplus "/ as sysdba"
startup create spfile='/u00/app/oracle/admin/TDBT901A/pfile/spfileTVD901A.ora' from
pfile='/u00/app/oracle/admin/SID/pfile/initTVD901A.ora';
shutdown immediate
exit
cd $ORACLE_HOME/dbs
ln -s /u00/app/oracle/admin/TDBT901A/pfile/spfileTVD901A.ora .
sqlplus "/ as sysdba"
startup
Backing up an SPFILE
The CREATE PFILE command can be used to back up an SPFILE:
SQL> CREATE PFILE='/u00/app/oracle/admin/TVD901A/pfile/bck_init.ora' FROM SPFILE;
File created.
SQL>
This creates a directly usable INIT.ORA file:
*.background_dump_dest='/u00/app/oracle/admin/TVD901A/bdump'
*.compatible='9.0.1'
*.control_file_record_keep_time=90
*.core_dump_dest='/u00/app/oracle/admin/TVD901A/cdump'
Continue.........
OPatch - Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
Hello Friends,
Today, I faced the following OPATCH issue when I tried to apply the patch 8450774.
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 > opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/10.2.0.4/TEST01
Central Inventory : /oracle/product/10.2.0.4/TEST01/oraInventory
from : /oracle/product/10.2.0.4/TEST01/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /oracle/product/10.2.0.4/TEST01/oui
Log file location : /oracle/product/10.2.0.4/TEST01/cfgtoollogs/opatch/opatch2009-12-07_09-55-44AM.log
ApplySession applying interim patch '8450774' to OH '/oracle/product/10.2.0.4/TEST01'
Interim patch 8450774 is a superset of the patch(es) [ 7263055 ] in OH /oracle/product/10.2.0.4/TEST01
OPatch will rollback the subset patches and apply the given patch.
Running prerequisite checks...
Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
The details are:
Patch 7263055:
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqmn.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqmn.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/knlp.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/knlp.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqa.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqa.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqit.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqit.o'
Copy Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/rdbms/admin/prvtaqds.plb" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot copy file from 'prvtaqds.plb' to '/oracle/product/10.2.0.4/TEST01/rdbms/admin/prvtaqds.plb'
ApplySession failed during prerequisite checks: Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
System intact, OPatch will not attempt to restore the system
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 8450774 is a superset of the patch(es) [ 7263055 ] in OH /oracle/product/10.2.0.4/TEST01
--------------------------------------------------------------------------------
OPatch failed with error code 74
db-node1 TEST01
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 >
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/10.2.0.4/TEST01
Central Inventory : /oracle/product/10.2.0.4/TEST01/oraInventory
from : /oracle/product/10.2.0.4/TEST01/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /oracle/product/10.2.0.4/TEST01/oui
Log file location : /oracle/product/10.2.0.4/TEST01/cfgtoollogs/opatch/opatch2009-12-07_09-55-44AM.log
ApplySession applying interim patch '8450774' to OH '/oracle/product/10.2.0.4/TEST01'
Interim patch 8450774 is a superset of the patch(es) [ 7263055 ] in OH /oracle/product/10.2.0.4/TEST01
OPatch will rollback the subset patches and apply the given patch.
Running prerequisite checks...
Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
The details are:
Patch 7263055:
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqmn.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqmn.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/knlp.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/knlp.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqa.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqa.o'
Archive Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/lib/libserver10.a/kwqit.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/oracle/product/10.2.0.4/TEST01/lib/libserver10.a' with '/kwqit.o'
Copy Action: Source file "/oracle/product/10.2.0.4/TEST01/.patch_storage/7263055_Jul_21_2008_01_37_17/files/rdbms/admin/prvtaqds.plb" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot copy file from 'prvtaqds.plb' to '/oracle/product/10.2.0.4/TEST01/rdbms/admin/prvtaqds.plb'
ApplySession failed during prerequisite checks: Prerequisite check "CheckRollbackable" on auto-rollback patches failed.
System intact, OPatch will not attempt to restore the system
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 8450774 is a superset of the patch(es) [ 7263055 ] in OH /oracle/product/10.2.0.4/TEST01
--------------------------------------------------------------------------------
OPatch failed with error code 74
db-node1 TEST01
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 >
This issue is because, opatch is trying to rollback the existing patch ( because of confilct issue ) from backup area i.e $ORACLE_HOME/.patch_storage. But somehow, the backup of that particular patch is not there. So, OPatch is failing with this error message.
So, When I checked the URL " http://download.oracle.com/docs/cd/B14099_19/manage.1012/b16227/oui8_opatch.htm ", I came to know the option " -no_sysmod ".no_sysmod used to Specifies that the OPatch utility need not update the files in the system. It will only update the inventory.
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 > opatch rollback -id 7263055 -no_sysmod -invPtrLoc $ORACLE_HOME/oraInst.loc
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/10.2.0.4/TEST01
Central Inventory : /oracle/product/10.2.0.4/TEST01/oraInventory
from : /oracle/product/10.2.0.4/TEST01/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /oracle/product/10.2.0.4/TEST01/oui
Log file location : /oracle/product/10.2.0.4/TEST01/cfgtoollogs/opatch/opatch2009-12-07_10-02-14AM.log
RollbackSession rolling back interim patch '7263055' from OH '/oracle/product/10.2.0.4/TEST01'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Skip patching component oracle.rdbms, 10.2.0.4.0 and its actions.
The actions are reported here, but are not performed.
Deleting "lib/libserver10.a/kwqmn.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqmn.ois not modified
Deleting "lib/libserver10.a/knlp.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so knlp.ois not modified
Deleting "lib/libserver10.a/kwqa.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqa.ois not modified
Deleting "lib/libserver10.a/kwqit.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqit.ois not modified
Running make for target ioracle
RollbackSession removing interim patch '7263055' from inventory
OPatch succeeded.
db-node1 TEST01
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 >
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/10.2.0.4/TEST01
Central Inventory : /oracle/product/10.2.0.4/TEST01/oraInventory
from : /oracle/product/10.2.0.4/TEST01/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /oracle/product/10.2.0.4/TEST01/oui
Log file location : /oracle/product/10.2.0.4/TEST01/cfgtoollogs/opatch/opatch2009-12-07_10-02-14AM.log
RollbackSession rolling back interim patch '7263055' from OH '/oracle/product/10.2.0.4/TEST01'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Skip patching component oracle.rdbms, 10.2.0.4.0 and its actions.
The actions are reported here, but are not performed.
Deleting "lib/libserver10.a/kwqmn.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqmn.ois not modified
Deleting "lib/libserver10.a/knlp.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so knlp.ois not modified
Deleting "lib/libserver10.a/kwqa.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqa.ois not modified
Deleting "lib/libserver10.a/kwqit.o" from archive "/oracle/product/10.2.0.4/TEST01/lib/libserver10.a"
ArchiveAction::rollback() failed: File is not present in backup area so kwqit.ois not modified
Running make for target ioracle
RollbackSession removing interim patch '7263055' from inventory
OPatch succeeded.
db-node1 TEST01
/oracle/product/10.2.0.4/TEST01/PATCHES/8450774 >
So, I have rollback the patch manually with using option called " -no_sysmod " and continued with main patch.
Subscribe to:
Posts (Atom)
Posts
