Is this the correct forum to ask questions about Oracle CPU's?
I ran the CPU-JUL-2012 on a workstation for version 11.1.0.7, got Return Code 0 and "OPatch Succeeded".
Yet a Retina scan ran after shows no change....?
I've tried reading the availability document, but I have no experience at Oracle patching.
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.
Just to confirm with you if we can apply the October 2011 Critical Patch Update (CPU) to address vulnerabilities covered from CPU 2007 up to CPU 2011?
The PC Server (staging) where patching will be applied is running under Windows Vista have not been patched since it's database creation. This is maintained by our Contractors.
I need to apply this Critical Patch in my databases but I have a doubt about if the component that I find out in the documentation is the component where the fix has to be applied or doesn't matter and I have to apply this fix on all my installations.
CVE# Component
CVE-2012-1740 - Oracle Application Express Listener
CVE-2011-3192 - Apache
CVE-2012-1737 - Enterprise Manager for Oracle Database
CVE-2012-1745 - The vulnerability affects Microsoft Windows platforms only.
CVE-2012-1746 - The vulnerability affects Microsoft Windows platforms only.
CVE-2012-1747 - The vulnerability affects Microsoft Windows platforms only.
CVE-2012-3134 - The vulnerability affects Microsoft Windows platforms only.
CVE-2011-4885 - PHP
identify the latest Critical Patch Update for 10g RAC. My DB server is 10g RAC 2 node cluster running on IBM Aix Pseries servers. The version is 10.2.0.3.
View 1 Replies View RelatedThis is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.
While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.
After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.
E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03
[code].....
Then i have tried to applied to old ocr backup also, then also i am getting same error.
Quote:Every patch or patch set also has a patch number to identify it
All patch and patch set releases carry version numbers.
For ex : Oracle 10g Release 10.2.0.1, then an available patch set might be 10.2.0.2 , .... , 10.2.4.0 , 10.2.5.0
My QUES is : How can i identify Patch no ? How it is differ from patchsets no ?..
How can i get latest patch official document links ?
ex : cpu , psu ,spu , Patchsets ,patch , Patchbundles , etc ..
(I don't have access METALINK)
Once i get Official doc id or weblinks , i will get it via my leads ..
Tried restarting OracaleDBConsole service after a Windows security patch was installed and now I'm getting error 1053:The service did not respond to the start or control request in a timely fashion" error message when you stop or pause a managed Windows service.
Apparently it was a MS known issue and it has been fixed in .NET v1.1 which is what was installed(& I didn't have any problems) before server team installed the latest security update which was .NET v2.0
SESSIONID , returns the auditing session identifier am i right ?
my question is when oracle updating session id ?
SQL> show user;
USER is "SYS"
SQL> select sid,serial# from v$session where audsid=sys_context
2 ('userenv','sessionid');
[code]....
Check the below simple sql stmts:
create table tab_tab(col1 number, col2 number);
insert into tab_tab values(1, 1);
insert into tab_tab values(2, 2);
insert into tab_tab values(3, null);
[code]......
My question is why the table content didn't look like:
col1 col2
----------
1 2
2 2
3 2
4 3
5 4
I thought that when oracle will update 1st, 2nd & 3rd rows then the sub query will get a count equal to 2, but the time when it goes to update the 4th & 5th row the sub query should get back a count equal to 3 & 4 resp. BUT that is not what exactly is happening!!
I am attempting to perform regular updates on several Oracle tables. The scripts performing the updates are scheduled to run every two minutes, get a value and update the table with that value.
The value doesn't always change but the scripts will still attempt to perform an update.
The same script is part of 7 objects, all of them are scheduled to run at the same time. They update the same table but never the same row.Even though the script is mostly the same on the 7 objects, they run completely independently of each other. The first object will usually perform the update without any problems but when it comes to the second object the script will time out.
Any documentation supporting Oracle 11G and Advanced Security stating encryption at rest is FIPS 140-2 compliant?
View 3 Replies View RelatedIn Sybase, my application was using system tables to perform application login security. Those tables obviously don't exist in Oracle. I am looking for ways to provide the following functionality in an Oracle world:
1. How to determine 'x' days of inactivity based on "last login date"?
2. How to determine when a new user logs in for the first time and force them to change their password?
3. If we need to reset a users password, how can we require the user to change their password?
4. Is there any other option other than storing a user-id/password in the application code for locking a user's account if their account needs to be locked due to inactivity?
5. In the USER_USERS view there is a status column. What the different status's can be?
I've been told by management this weekend I will be required to perform a complete patch of our Oracle 11g database.
Problem is I really have never installed / patched Oracle. I'm able to access pretty much any database here and interact with it from a SQL stand point so since I'm the only person in my entire office who knows SQL, they decided I can become their full blow DBA.
Currently the database is running a unpatched version:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Once I download the latest patch (11.2.0.2.0) files from Oracle & perform a complete backup using RMAN:
RMAN> backup full as compressed backupset database plus archivelog;
How exactly does one properly patch / update Oracle 11g to the latest version?
I am trying to patch 10.2.0.3 to 10.2.0.5.I run the runInstaller, it was not successful because it was pointing to a wrong home name and path.Then I changed according to working condition. Then the installation was successful.Then I run the catupgrd.sql. It was also successful with no errors.Then I run utlrp.sql, it was also successful with no error.I did a shutdown and startup.
When I query:
select * from v$version;
It is giving the output as the oldversion as 10.2.0.3
how can i find the oracle patch on os window. oracle 10.2.0.1
i m using sql>opatch lsinventory but cant work.
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?
View 2 Replies View RelatedI have installed Crystal reports server 2008 VI on a Windows 2008 64bit OS. I have added Crystal reports that connects to Oracle database through CMC. I then installed Oracle 10g client 32bit on the server and created and tested the required DSNs using ODBC 32bit. All the testings are successfull.
Now when I try to run my Oracle report through CMC it prompts for the parameters and when I enter them and click ok, gives me the following error: Failed to open the connection. Details: Database Vendor 12154.
I reported the above issue to SAP and they mentioned that this is a bug with Oracle and install the latest patch for my Oracle client software. My current Oracle client 10g 32bit version is: 10.2.0.1.0
I downloaded the patch 4923768 for Oracle client 10g. In the installation instructions, it mentions to apply the patch using OPatch. I already see the OPath folder in the C:\oracle\product\10.2.0\client_1 directory, but I am not sure how to enter the command to apply the patch using OPatch. Do I have to do it using DOS window or any other tool? I don't have an Oracle admin in our company, so I am trying to figure out how to apply this patch on client workstations.
[URL]......
The oracle documents mentions this file
$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/restore.sh
But what I find in that directory is
$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/rolback.sh
Where is the restore.sh file that the document is talking about.
i want to download the patch 17 for oracle developer 6i for. any link that i can download this patch from it?
View 5 Replies View RelatedYesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "
During Installation I found following Installation Option :
1) Install and configure Oracle grid Infrastructure for a cluster
2) Configure Oracle Grid Infrastructure for a Standalone Server
3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management
4) Install Oracle Grid Infrastructure Software Only
Which option should I have to choose here ?
I want to upgrade 10.2.0.1 to 10.2.0.5.
Can I straightly apply 10.2.0.5 or need to sequentially apply one by one?
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.
Grid home: /opt/grid/11.2.0/grid
Oracle Home: /opt/oracle/product/11.2.0/db
1. O patch (6880880)
2. Grid patch (9655006)
3. Oracle Patch (10248516)
I have followed the following steps.
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
7. Applied grid patch.
/opt/grid/11.2.0/grid/OPatch/opatch napply -oh /opt/grid/11.2.0/grid -id 9655006
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?
2. Is the above steps are applicable to HA setup.
I am running a 10g oracle DB on AIX the application running is SAP.
Now I will be applying the following patch
8201796:OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#10)
But I find the following patches are already applied to the system which happens to be included in 8201796
6934892,7228971,7278117.
Do i need to remove the above patches individually before applying 8201796 or will it automatically do the needful during 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.
View 4 Replies View RelatedI am trying to upgrade my database approx 20GB size from 8.1.7.2.1 to 8.1.7.4 runningon windows NT 32bit server.I found that we can download from metalink.oracle.comIs that any cost involved in downloading and installing or is it provided freely by Oracle.
View 7 Replies View RelatedI want download latest critical patches of 11.1.0.7.0, 11.1.0.6.0. how can i download
View 1 Replies View RelatedWe have a critical application batch that runs daily and had a 7.5 hr window after which the application needs to come online. During the peak batch times the truncates are running very slow leading to slow down of the batch jobs quite considerably due to which the batch is going beyond the window.
Technical details:
Database version: 11.2.0.2
OS: HP-UX 11.31
The wait events that show up when the truncates are running are local write wait
enq: RO fast object reuse
enq: CR block range reuse ckpt
db file parallel write
The ASH reports show that the top sessions are those executing DMLs(insert, merge, update) and DDLs(Create/alter index & truncate). In addition to this it also shows that the blocking sessions are background wait events: CKPT and DBWR. Changes to DB configuration done with respect to addressing these issues are:
1) We have increased the DBWR processes to 2
2) Reduced the buffer cache size to 20G(from the original 30G)
3) Flushing the buffer cache before the batch begins in order to reduce the load on DBWR during the batch peak time
4) Set the parameter filessytem_io to SETALL(from none)
5) Tuned the EVA(SAN storage) to improve its performance - by distributing the loads evenly between the controllers, reducing the IO transfer block size, etc
6) Suggested using the reuse storage clause to improve truncate performance.
All of these have worked bring a semblance of control but the fact remains that the batch is generating more jobs(hence increasing data volume) over time due to it being the peak season. This causes an inevitable increase in the number of sessions all running DMLs and DDLs which are IO intensive operations.
Suggestions pending from our end:
1) Increase DBWR beyond 2. For this we need a H/W upgrade since we have maxed out the maximum number of DBWR that can be configured
2) Implementing asynchronous IO for DBWR which on HP-UX requires moving to raw disks. Hence have suggested using ASM.
3) Tuning the application to either reduce the IO generated or redistribute the jobs such that those with maximum loads don't run together
instead of truncating tables, can we rename the tables and delete them later . will this improve performance ?
I have been working in the installation of oracle 11g r2 in my fedora 17 (32 bits) system for a few days and still have not gotten.Now I found that I need the OPtatch for enable the db console and even being a member of My Oracle Support I can not request the patch for a technical question.
1) Note to the Approver: I am that one because I am an end user (freelance)
2) Support Identifier: How can I get it?