Apply 11.2.0.2 Database Server Patch In EBS 12i Env?
Jul 20, 2012
We need to apply the the 11.2.0.2 database server patch and this is a 12i Ebusiness suite env. Do we need to take any precautions(other than stopping the apps) on the APPS side when we are applying the patch on the database?
can we apply 11.1.0.7 Patch Set on a 10.2.0.3 database server? i mean are patch sets cumulative or do i have to install the patch specific to my release the issue is i have the below error with rman: RMAN-03009: failure of delete command on ORA_DISK_1 channel at ORA-19633: control file record is out of sync with recovery catalog
I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command
but then it says oplan is not recognized. I have set the Oracle_home and path variable
my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan
Note that my database version is 11.2.0.3 with ASM
Does we need to apply the patches in sequence. i installed oracle 11g r2 today only, then which patch i can install. if i like to install CPU, then does i need to install all the previous or only the latest one. if only latest one only, then how can i find the CPU patch number.
of course, instead of cpu i can install psu patch, then which one has to install. only latest one or all previous also. if latest one only how to find latest psu patch that has to apply.
I have a 2 node RAC environment (11.2.0.3) where each node has there own local Grid_home and RDBMS_home.
I am installing a Rolling Bundle Patch with OPatch in this environment. The installation document says that "The order of patching in RAC install is GRID_HOME, then RDBMS_HOME" so i did the following.
1. stopped all oracle related services on node1 2. set oracle_home=<Grid_home> 3. applied the opatch 4. opatch succeeded on node1 and it says "The node 'NODE2' will be patched next... Is the node ready for patching?
1. Should i shutdown the oracle services in Node2 and continue to patch the Grid_home ? If yes then the DB will be completely down for user access. This defeats the purpose of rolling mode which says there is no downtime. 2. Should i patch the RDBMS_home on node1 , start all the oracle services on node1 , stop the oracle services on node2 and then resume the opatch on node1 which is waiting to patch the Grid_home on node2 ?
I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply 2)Apply patches on logical standby database 3)let the name server point to the backup site 4)Apply patches on the primary database 5)Start SQL apply 6)Let the name server point back to the production site
We have configured oracle one way stream between two databases. Source database is capturing the changes (No downstream configured). Configuration was working fine but destination database was lagging behind very much i.e about 15 days behind the source database. We are ok with this but the problem is now that , as per client request we have restored previous backup and open the database with resetlog option in source database. After resetlog , archivelog sequence has been changed and stream is not working.
Can I apply the previous archivelog (before resetlog archivelogs ) in destination database anyway.Source database is a production database.
I need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.
Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."
So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?
1) The Primary Database is UP. The Physical Stand By Database is DOWN. The Current Archive Log Sequence is 99 in Primary.
We have to apply Archive Log from 51 to 99 to the Standby Database. But Unfortunately, there is no backup of those Archivelogs and the ArchiveLogs from 51 to 98 have got deleted at Primary end.
Now how will you apply these Archive Logs from Primary Database to Physical Standby Database?
I am reffering to one off patch "10402264" .I have to apply tihs patch to my 11.2.0.2.4 database.Is there any chart oracle provide to check if 10402264 is covered in any PSUs? or i have to go to each PSU readme and check "Bugs fixed" ?
i wish i could get somthing like this
11.2.0.2 One-off# PSU4 PSU5 11.2.0.3.0 10402264 NO YES YES
I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.
But when I try applying monitoring template and look for database in search window, it doesn't appear there.
We're thinking of moving from 10.2.0.3 to 10.2.0.5 in our production Oracle RAC. The 10.2.0.5 patch is quite new and I was wondering if any of you have upgraded to this patch in any of your environments and if you experienced any issues afterwards?
I installed Oracle 10.2.0.1.0 in RH Linux 4.5. After that applied patch for 10.2.0.4.0. Everything went smoothly, but at the last steps I unknowingly clicked next button. I dont know whether some scripts is to be run as I did during installation of 10.1.0.4.0. If it is to be done I didn't do that.
How can I proceed now? If some scripts to be run where is the location? Will it cause any issue if I running it after completing the update?
DECLARE @MainTable TABLE (UniqueID INTEGER, Category VARCHAR(200), WeekDate DATETIME, VALUE INTEGER) INSERT INTO @MainTable VALUES(123, 'Shirts', '10/07/2011', 5000) INSERT INTO @MainTable VALUES(123, 'Shirts', '10/14/2011', 8000) INSERT INTO @MainTable VALUES(124, 'Pants', '10/07/2011', 4000) INSERT INTO @MainTable VALUES(125, 'Shorts', '10/14/2011', 8000) INSERT INTO @MainTable VALUES(126, 'Shoes', '10/21/2011', 9000); --select * from @MainTable; [code]...
The query works with all the CTEs up to the last select statement. Oracle does not support the OUTER APPLY statement, how should the last piece be written to make it work in Oracle?
I am working on form 10g, here i am using post command in save procedure to apply some record in database temporary.
But Frm-40404 Message raise during saving record i need post commond but i dont want to this message should popup, is there any method to avoid the message only?
where i can download the patch documentation. Is it available in the metalink (my oracle support)? if yes then is there any other way i can get hold of it?
I am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.
1. Applied Opatch on grid. unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid
2. Validated the Oracle Inventory. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid
3. Shut down the databases. 4. Run the prepatch script ./9655006/custom/server/9655006/custom/scripts/prepatch.sh 5. Shutdown the ASM. 6. Ran the below command to stop CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock
8. Applied Opatch on Oracle home 9. Applied Oracle patch /opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516
8. Run the postpatch script ./9655006/custom/server/9655006/custom/scripts/postpatch.sh
9. Run the following script to enable CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -patch /opt/grid/11.2.0/grid/bin/crsctl check has /opt/grid/11.2.0/grid/bin/crsctl check css
10. If CSS is not online ran the below command. /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl stop has /opt/grid/11.2.0/grid/bin/crsctl start has
11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle. @catbundle.sql psu apply
12. Ran the below command on grid and Oracle. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory /opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory
1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). How should I know the patch is applied properly?
I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)
About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user TEST . exporting PUBLIC type synonyms . exporting private type synonyms
I have HP server with Windows 2008 Server R2 64bit. I installed latest 64-bit version of Oracle Database 10.2.0.4 and everything works fine and later installed the patch 10.2.0.5 (64 bits) as the Oracle maintains that with the R2 version of the system it is necessary to correct work.
Now, after uploading the patch database starts and closes after about 15 minutes - an additional log file is changed to the binary version which do not see anything.
how to solve problem? The move to Oracle 11 drops.
This is the link to my alert log file (it's strange after 10.2.0.5 patch installation):
I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.
We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.
Following files are active :
E:oracleproduct10.2.0inoraclient10.dll E:oracleproduct10.2.0inorapls10.dll E:oracleproduct10.2.0inoracommon10.dll E:oracleproduct10.2.0inorageneric10.dll E:oracleproduct10.2.0inoraplp10.dll [code]........ -------------------------------------------------------------------------------- The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ] in the Oracle Home -------------------------------------------------------------------------------- Its not an rac. We stopped all the services running on this server.
I need some detail information regarding the CPM Patches released by oracle quarterly.
Is it compulsory to set the CPM patch when it is being realized. How to set or apply this patch. (either by runInstaller or OPatch utility i am not sure about this)
What is the difference between the interim & CPM patches.
I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.
Tried the following methods.
1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.
2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)