While Applying Patches In Oracle Home Space Not Sufficient
Mar 18, 2011
Im applying patch which is an upgrade to 10.2.0.5 from 10.2.0.3. Its a 2 node RAC. While applying patches the installer mentioned space are sufficient, but while applying patches it throws message that in oracle home space not sufficient. Im able to apply patches in cluster home successfully. How much space required in oracle home for this patch? There is no information mentioned the document as well.
We have almost 400 production two-node RAC clusters in the environment I manage - all these sites have databases where the database name is exactly the same, so using Grid Control right now isn't in the cards (and yes - I am working on assigning them all a unique name ). We want to use IBM's BIGFIX to deploy patch 32 on top of 10.2.0.3 for Windows Itanium. BigFix runs as a user different from that used to install the Oracle software originally. There is nothing in the patch notes to suggest that you must use a certain Windows user to install the patch - so the question is, does it matter what Windows User I use as long as they are an 'Administrator' equivalent?
how do you perform mass updates/patches in your Windows server environments? I am looking for examples outside of Grid Control - which I know would work if only my predecessor didn't name these databases the same .
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
I am currently in the process of trying to upgrade a 10.2.0.4 database to 11.2.0.2. I am using DBUA to complete this work. I have a small issue which I cant work out and cant find anything on Google or oracle docs about it.
The home where the software for 11.2.0.2 is an ORACLE_HOME that was recently cloned from another 11g home. When im in the DBUA summary page before I kick off the upgrade the summary page lists the "TARGET" oracle home as the old 11g home and not the new "CLONED" one.
Obviously DBUA is picking up the target ORACLE_HOME from a file in the cloned home that has not been updated with the new CLONED home info. I have made sure all variables are set correctly including the PATH variable.
I am trying to patch an Oracle 11g database. I can see from the logs that is was patched after it was created by a consultant but I cannot get Opatch to work.
C:\app\Oracle\product\11.2.0\dbhome_1>java -version java version "1.5.0_17" Java™ 2 Runtime Environment, Standard Edition (build 1.5.0_17-b03) Java HotSpot™ Client VM (build 1.5.0_17-b03, mixed mode) C:\app\Oracle\product\11.2.0\dbhome_1>opatch>set ORACLE_HOME=C:\app\Oracle\product\11.2.0\dbhome_1 C:\app\Oracle\product\11.2.0\dbhome_1>opatch lsinventory -all ORACLE_HOME is NOT set at OPatch invocation The Oracle Home C:\app\Oracle\product is not OUI based home. Please give proper Oracle Home. OPatch returns with error code = 1
OPatch failed with error code = 1
Java is set in the environment path but the Oracle home seems to be the issue. I checked the LOC parameter in the Oracle/Inventory folder and it is set correctly to C:\app\Oracle\product\11.2.0\dbhome_1.
I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.
But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.
I need to install Oracle 10g in windows 7 home premium which version of oracle 10g will work better with Windows 7 home premium. I need to download «& install.
Suppose my oracle database server IP is 128.1.1.100 in the office & the internet static IP is 115.118.33.100 is on that server. I want to retrieve the data by using oracle forms & report from my home's computer having different internet IP 115.118.33.25 on my home's computer.
what would be the settings on my home's computer for the same. i mean tnsname.ora file or any other setting.
We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.
How will you find out the list of patches applied to Oracle Database Home without using commands like opatch lsinventory -detal etc...
I think registry$history is a view from where we can find out the list of patches applied.
But I think it will not include all the bug fixes,stand alone or one-off patches.It will mainly list out the CPU patches applied(correct me if I am wrong).
My client asked me to "apply the newest patch" on his RAC 10.2.0.5 environment on Windows.
I've downloaded 10.2.0.5 Patch 20 (the newest version).
My question is: Should i apply it using OPatch to both: ORACLE_HOME and CRS_HOME? or only in ORACLE_HOME? What with 10.2.0.5.2 CRS Patch? Should i apply earlier CPU patches?
Recently, my client side report runtime experience the following bug:
--> ORA-0999:UnImplemented Error
When user attempts to convert the generated report into PDF format.
I had found out from the net that by applying the following: Patch 18 for Windows Client/Server Forms 6i.
The Ora-0999 bug will be resolved. True enough the bug has been resolved.
However, I had chanced a post recently and this raised my concern on whether I had done the patching correctly.
From the post it stated that,
Quote:Forms 6i ( stand alone ) is currently desupported/extended support. So patch 17 is the last one.
2. Forms 6i is still supported for Ebusiness Suite. Hence patche 18 is the latest patch for form 6i with fixes specific to ebusiness suite. There might be an another patch for forms6i later but specific to ebusiness suite. This is because Forms 6i is supported for EB.
If you are not using Forms along with EB then I dont think the new patches are useful. So remaining at patch 17 is recommended.
Link: [URL]
FYI, I had only selected the custom installation with only the Report Runtime to be patch over the previous version.
Sysaux Tablespace is running low. WE SET AWR RETENTION TIME=60 DAYS. WE ARE NOT INTEREST TO EXTEND SYSAUX TABLESPACE SIZE. Usually we take AWR weekly once. Some times we did ADDM report and ASH.
CODEsql>select TABLESPACE_NAME, FILE_NAME, BYTES/(1024*1024), AUTOEXTENSIBLE, MAXBYTES/(1024*1024) from dba_data_files where tablespace_name = 'SYSAUX';
1. What's the best SOLUTION ? 2. Can i shrink sysaux tablespace ? 3. I think , The size for all occupants in sysaux tablespace is less than 200 MB => how to find actual content of sysaux tablespace ? 4. What could be the reason for growth? Is there any way to free the space from sysaux table space?
I have the following query. The problem is that in case of dense_rank it gives wrong result when there is multi sort involved,So lets say if following data i get from inner query before applying dense_rank
Seq_uid Status Salary Pre_sort_col 1 A 4 A 1 A 3 A 2 B 5 B 3 A 0 A
After dense_rank when ordering by pre_sort_col desc and seq_uid desc the result set is
Seq_uid Status Salary ROW_NUM pre_sort_col 3 A 0 1 A 1 A 4 3 A 1 A 3 3 A 2 B 5 2 B
which is wrong as seq_uid 3 shld nt come first. I cant have salary in dense rank as these are dynamic columns,if on 3 columns multi sort is selected,the first column will come in pre_sort_col, SEq_uid has to be used as to distinguish from other records which get same pre_sort_col
SELECT c.ROW_NUM, c.RECORD_TOTAL, VW.* FROM (SELECT distinct seq_uid,ROW_NUM,RECORD_TOTAL FROM (SELECT dense_rank(order by pre_sort_col desc,seq_uid desc)row_num,a.* FROM (SELECT COUNT(DISTINCT V1.seq_uid) OVER() RECORD_TOTAL, [code]....
I am able to assign a user to a user group using the User Admin in Apex.I don't know how I would be able to assign a role (that I know how to define that for an individual user).The only thing I can see is a name for User Group and a Description! My requirement is to define a group of people to be assigned to one group/role, so that every change to that role can be automatically be applied to each user in that group
I have got a form in tabular format. each record contains some specific colour or it may not contain.
i want to chage the backgroud colour of that record based on what so ever user wants. for example, user want first record should be of RED back groud, second green, third blue etc.
colours are available in RGB format.
when i try to set_item_property(backgroundcolor) on post-query or on when new item instance, it makes all record of same colour.
note:- if a put another text/display item and make it number of record displayed property = 1 , then it works, because only one record colour is seen at a time.
I can not use multiple visual attributes because number of colours are up to user feedback.
We are trying eliminate/minimize the downtime for our application. As part of new code deployments sometimes we need to modify DB Structure also. As it is taking time to backup current DB and apply new DDL, the application is down.
Is there a way to eliminate the downtime, if I can leverage Data Guard, Golden Gate or RAC concepts?
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?
I am trying to apply patch 16619892 on 11.2.0.3.0 to upgrade it to 11.2.0.3.7.
I hope this is a straight forword stuff i beleive, but i am getting the following errors and log details.
$ cd /noracle/patch/16619892/ xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved.
We have a 11r2 primary and standby running on RHEL 5. The primary lost network connectivity for a time and VMWare locked up. The VM admin restarted the primary VM (it was a hard-boot). This all happened while I was gone and when I came into work, the primary database appeared to be working. I decided to dig deeper and check out the standby. On the standby...