f



Where to get oracle patch 9.2.0.4 and 9.2.0.5

I'm doing an install for work on a windows xp (32bit) development
station.  To mimik the production systems I need to install 9.2.0.1.0
and then the patches for 9.2.0.4 and 9.2.0.5.  I've installed 9.2.0.1
and I have a disk for the patches but it is corrupted.  Where can I get
these patches?  I've tried google to no avail.  Thanks in advance!

0
6/29/2006 10:13:24 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

3 Replies
1324 Views

Similar Articles

[PageSpeed] 43

On 29 Jun 2006 15:13:24 -0700, "David.E.M....@gmail.com"
<David.E.Murphy@gmail.com> wrote:

>I'm doing an install for work on a windows xp (32bit) development
>station.  To mimik the production systems I need to install 9.2.0.1.0
>and then the patches for 9.2.0.4 and 9.2.0.5.  I've installed 9.2.0.1
>and I have a disk for the patches but it is corrupted.  Where can I get
>these patches?  I've tried google to no avail.  Thanks in advance!

Patches are available on Metalink. And, yes, you need to have a paid
support contract for that.

--
Sybrand Bakker, Senior Oracle DBA
0
postbus (1497)
6/29/2006 10:34:11 PM
David.E.M....@gmail.com wrote:
> I'm doing an install for work on a windows xp (32bit) development
> station.  To mimik the production systems I need to install 9.2.0.1.0
> and then the patches for 9.2.0.4 and 9.2.0.5.  I've installed 9.2.0.1
> and I have a disk for the patches but it is corrupted.  Where can I get
> these patches?  I've tried google to no avail.  Thanks in advance!

You get the patches from oracle http://www.oracle.com then go to the
support link then metalink ...

0
johnbhurley (2707)
6/29/2006 11:00:46 PM
I'm guessing you don't have metalink access.
I found patch files for Linux by googling the file names.


0
googler1 (30)
6/30/2006 1:50:45 AM
Reply:

Similar Artilces:

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard disclaimer: http://www.dbainfopower.com/dbaip_advice_disclaimer.html "kumu" <forlist2001@yahoo.com> wrote in message news:a44abd39.0402161837.6badb9ed@posting.google.com... > Hello All, > I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or > 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? > > Also I had a bad experience with my development server when applying > 9.2.0.3 patchset. Is there anything you recommend before I start > again? > > Thanks > Kumu "Ron" <support@dbainfopower.com> wrote in message news:<QqWdnRM_cMiwWqzdRVn-vg@comcast.com>... > Hello Kumu, > > What is the reason for upgrade? Any specific bugs or issues you > experience? > > You can open TAR as well to get support recommendations for your > situation. > > New patches can introduce new...

Oracle 9.2 vs. Oracle 9.2.0.4.
I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4 client version. The 9.2 version behaves as expected. My problem only occurs with the 9.2.0.4. version. If I try to process the ResultSet of database query and the selected column data includes leading blanks, the 9.2.0.4 seems to trim these leading blanks. Is this behaviour known or am I doing something wrong ? <code snippet> ResultSet result = null; Connection con = null; Statement stmt = null; Vector vec = new Vector(); try { con = DriverManager.getConnection(dbUrl, dbUser, dbPassword); stmt = con.createStatement(); result = stmt.executeQuery("SELECT DATA FROM CPTMESSAGEDATA";); while (result.next()) { vec.add(result.getString("DATA")); } con.close(); stmt.close(); } catch (SQLException e) { } </code snippet> CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values like: " @20013 @E123 @G123 @ @ @ " " @3700167 @43186 @B50_300 @1 @20013 @1 @OK " Any help is appreciated. Alex ...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.com> schreef in bericht . > How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 > > 1-what scripts are to be used > 2-Where i can find these scripts. > > Thnks. Hi, I guess oracle dosen't support backword comatibilty.then how it is possible?? Thanks Alok. On 9 Aug 2005 22:05:49 -0700, alok.behria@gmail.com wrote: >Hi, > > I guess oracle dosen't support backword comatibilty.then how it is >possible?? > >Thanks >Alok. Oracle is backwards compatible provided you have the definition of backwards compatible correct. You can connect (again) *lower version client* to a *higher version database* The other way around has nothing to do with backwards compatible, though it usually works, *with the exception of export/import, AS DOCUMENTED* (but I guess no one ever reads the docs) -- Sybrand Bakker, Senior Oracle DBA Hi, ...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy the Oracle CD to the hard drive. I copied it to a subfolder directly to C:\Oracle9i 2. Change the file c:\oracle9i\install\ORAPARAM.INI to reflect the actual name of the directories listed in the install directories of the cd I just copied. I did this and next took out some "."s and put the absolute path to the java program and something called the "OUI_LOCATION". JRE_LOCATION=C:/oracle9i/stage/Components/oracleswdjre/13110a/1/DataFiles/Expanded OUI_LOCATION=C:/oracle9i/stage/Components/oracleswdoui/220120/1/DataFiles/Expanded Okay so good so far. This time the installer actually started. The problem occurs in the next few steps, when I click "next" (weiter in German) from the welcome screen- please understand if I translate something wrong here. Then I am shown the installation directory screen, where I select the default listed: Source : C:\Oracle...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

need to upgrade from 9.2.0.4 to 9.2.0.5
Hello, I hope this is an easy question. At any rate I need to upgrade from 9.2.0.4 to 9.2.0.5. I'm asking becuase I've intalled patches before but never changed release numbers and I don't want to screw anything up. Is upgrading to 9.2.0.5 as simple as loading the first 9.2.0.5 patch??? I'm on metalink and looking at Doc ID: Note:161549.1 as I'm writing this. Am I in the correct area to download the 9.2.0.5 patch? Thanks! Adam Sandler wrote: > Hello, > > I hope this is an easy question. At any rate I need to upgrade from > 9.2.0.4 to 9.2.0.5. I'm asking becuase I've intalled patches before > but never changed release numbers and I don't want to screw anything > up. Is upgrading to 9.2.0.5 as simple as loading the first 9.2.0.5 > patch??? I'm on metalink and looking at Doc ID: Note:161549.1 as I'm > writing this. Am I in the correct area to download the 9.2.0.5 patch? > > Thanks! Upgrades are trivial as long as you: 1. Run a test first on a test server 2. Have a good backup 3. Read and follow Oracle documentation on how to do it. But why 9.2.0.5? Why not 9.2.0.6? -- Daniel A. Morgan Relational theory is not something that is simply a nice-to-have. http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) Maybe I wasn't clear in my first post... is going from one version to another in Oracle accomplished by loading the first patch of the next version? In MS Windo...

oracle 9.2.0.4.0 red hat 9
Hi, I'm having problems installing Oracle 9.2.0.4.0 on Red Hat 9. During runInstaller, I get numerous errors about something wrong with the target of makefile in various directories. Also, many of the assistants, like the Database Configuration Assistant don't get installed. I can start sqlplus. But then I can't mount the starter database I created during the installation. Also, when I try to run dbca, I get this error: /hutch/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so) Unable to initialize threads: cannot find class java/lang/Thread Could not create Java VM The strange thing about this is that I've installed Java 1.4.2. Why is it looking for Java 1.1.8? I did notice in the Oracle installer interface that it was installing Java 1.1.8. Is Java 1.1.8 a permananet part of the Oracle installer? Thanks for any advice, tglahn17 wrote: > Hi, > > I'm having problems installing Oracle 9.2.0.4.0 on Red Hat 9. During > runInstaller, I get numerous errors about something wrong with the > target of makefile in various directories. Also, many of the > assistants, like the Database Configuration Assistant don't get > installed. I can start sqlplus. But then I can't mount the starter > database I created during the installation. Also, when I try to run > dbca, I get this error: > > /hutch/oracle/jre...

restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... > > Thank you No, you don't want to do that. You want to solve some problem, for which you believe that to be the solution. What is the problem you are trying to solve? In answer to your question -- yes, I'd think there would be disasterous problems. So, again -- what is the problem you are trying to solve? nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... That really describes a usual step in applying the 9.2.0.7 patchset. The database files are still at ( whatever ) the old patch level was .... say 9.2.0.6. You have to use the patched oracle binaries to open the database. But then the next step should be to follow the steps in the 9.2.0.7 for patching existing databases ... startup migrate and run the script to move the database files up to 9.2.0.7 ... Is that what you are attempting to do? Have you read the readme ( installation instructions ) for the 9.2.0.7 patchset? ...

Solaris 9 patches for Oracle 9.2.0.5
Hello, I am unable to find the list of required patches on Solaris 9 (64 bit) for Oracle 9.2.0.5 Installation guide on OTN seems to be carrying quite old info. could someone help me with the list or the location where I can find this. Thanks in advance, Gautrak Well Solaris 9 has been out for a long time now so probably the "bare minimum" patches needed for 9i rel 2 or specifically 9.2.0.5 hasn't really changed for a while. Recommended patches from sun are diff from what oracle needs. If it's a dev system then why not go for latest sun patchset then apply 9.2.0.5 which of course relinks. But 9.2.0.5 isn't exactly squeaky clean. johnbhurley@sbcglobal.net (John Hurley) wrote in message news:<d4d6f278.0406291402.65370bbd@posting.google.com>... > Well Solaris 9 has been out for a long time now so probably the "bare > minimum" patches needed for 9i rel 2 or specifically 9.2.0.5 hasn't > really changed for a while. Recommended patches from sun are diff > from what oracle needs. > > If it's a dev system then why not go for latest sun patchset then > apply 9.2.0.5 which of course relinks. But 9.2.0.5 isn't exactly > squeaky clean. Yes, but 9.2.0.6 will fix all of those issues ... that are identified in time, maybe. No wait, :bug_number will be fixed in 10.1.0.3 ... perhaps 10.1.0.4. Pd This will be a production database (non-RAC) upgraded from existing 8.1.7 db of approx 120 GB. which version of 9...

optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?
Hi, All, I noticed for this parameter optimizer_features_enable , oracle document says: Syntax OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | 9.2.0} I noticed when I keep it default to 9.2.0 in init.ora, in version 9.2.0.3 and 9.2.0.5 with exact same database and exact same init.ora, oracle CBO did choose different plan. So there is some difference between 9.2.0.X versioin for the CBO. Where can we get such information about the difference? Thanks On 12 Jul 2005 23:37:28 -0700, "chao_ping" <zhuchao@gmail.com> wrote: > So there is some difference between 9.2.0.X versioin for the CBO. >Where can we get such information about the difference? Usually such things are outlined either in the release notes or in the new features documents. Documents that obviously no one reads. -- Sybrand Bakker, Senior Oracle DBA "chao_ping" <zhuchao@gmail.com> wrote in message news:1121236648.759298.79320@g44g2000cwa.googlegroups.com... > Hi, All, > I noticed for this parameter optimizer_features_enable , oracle > document says: > Syntax > OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | > 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | > 9.2.0} > > > I noticed when I keep it default to 9.2.0 in init.ora, in version > 9.2.0.3 and 9.2.0.5 with exact same database and...

Oracle 9.2.0.5, RedHat 7.3 (2.4.27) and SGA size 2.7GB
Hello all, My problem : I'm trying to increase the SGA to 2.7 GB. What have I done so far : 1) I have succesfully installed the above mentioned database following the HOWTO http://www.puschitz.com/InstallingOracle9i.shtml#RunningOracleInstallation. The database is working without problems, but uses only 1.7GB of memory for SGA. 2) I have followed the excelent HOWTO from Werner Puschitz located on http://www.puschitz.com/TuningLinuxForOracle.shtml#IncreasingSpaceForLargerSGA, but when I come to the point for changing the mapped base on Linux OS level, I'm unable to locate the file /proc/<pid>/mapped_base, and my /proc only says (5390 is the PID of oracle shell): [root@server root]# ls -al /proc/5390/ total 0 dr-xr-xr-x 3 oracle dba 0 Mar 8 10:14 . dr-xr-xr-x 69 root root 0 Mar 7 15:29 .. -r--r--r-- 1 oracle dba 0 Mar 8 10:14 cmdline -r--r--r-- 1 oracle dba 0 Mar 8 10:14 cpu lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 cwd -> /home/oracle -r-------- 1 oracle dba 0 Mar 8 10:14 environ lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 exe -> /bin/bash dr-x------ 2 oracle dba 0 Mar 8 10:14 fd -r--r--r-- 1 oracle dba 0 Mar 8 10:14 maps -rw------- 1 oracle dba 0 Mar 8 10:14 mem -r--r--r-- 1 oracle dba 0 Mar 8 10:14 mounts lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 root...

Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment #2
HI, I have the following situation: We have Veritas cluster setup , and there are 2 solaris servers on which VCS is set up. On this set up we have about 8 databases all of which are 9.2.0.6 version. Now we have one stand alone solaris server, and it has a 9.2.0.7 database. This database is for a third party application -Clear Case & Clear Quest. Now it is required to move the single instance database to clustered environment. Since in the clustered environment we have 9.2.0.6 version, is it AT ALL POSSIBLE to move this database, which is 9.2.0.7 to that enviroment? I guess not, and in that case, what are the options? - since this is a packaged application , so should be contact the vendor and ask them whether we can downgrade the database to 9.2.0.6? - is that a valid option? Are there other options? (upgrading the existing 9.2.0.6 database to make all of them 9.2.0.7 is not allowed.) With thanks, Nirav ...

Bind Errors
Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer working -- I am getting an ORA-01006 Bind Variable does not exist. Has anybody had any success running reports developed in 2.5 to run against 9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - don't really have the resources to upgrade this and all the instances on it so quickly. ManChild wrote: > Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer > working -- I am getting an ORA-01006 Bind Variable does not exist. Has > anybody had any success running reports developed in 2.5 to run against > 9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - > don't really have the resources to upgrade this and all the instances > on it so quickly. Apparently the concept of testing evaded your management. Did you check metalink? -- Daniel Morgan Puget Sound Oracle Users Group On 12 Sep 2006 14:48:48 -0700, "ManChild" <starritt@gmail.com> wrote: > >Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer >working -- I am getting an ORA-01006 Bind Variable does not exist. Has >anybody had any success running reports developed in 2.5 to run against >9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - >don't really have the resources to upgrade this and all the instances >on it so quickly. Please answer the question when Reports 2....

Differences 9.2.0.1.0 to 9.2.0.5 with field types
We encounter following problem: Normally we are using 9.2.0.1.0 and we also have several views with union-statements. In these views the origing fields has been Integer type. We accepted that with creating of this views, the field types changed to float and we adjusted the end user program for that. Now a customer is using 9.2.0.5 and here the behaviour does not exists. The field type keeps Integer, And now we hve some problems again with the end user program. Of cause we have a solution in rewriting the view code, but we would like to test it on our side first. Therefore we checked on metalink for an update, but after downloading it tells us, that no update is necessary. This may be true, because we let run it on Windows 2000 or on Linux and the patches are for different OS. As I remeber for some Unix and Windows 2003 and cluster systems, what we do not have. Is it nevertheless possible to let run the patch on our machines, so that we can find out the incompatibilities? Thanks for any hint, Regards Nicolas ...

Copy Oracle 10.2.0.4 Database from Sun Sparc 5.9 to Sun Sparc 5.10?
Hi, We would like to copy a cold backup of an Oracle 10.2.0.4 database running on Sun Sparc 5.9 to a Sun Sparc 5.10 server. We intend to use a standard copy procedure (Copy datafiles, use "Create controlfile..." etc..). Will this work? Any links to Oracle documentation on this will be appreciated. Thanks, QZ ...

upgrate from 9.2.0.1.0 to 9.2.0.7.0
how to upgrade.... storm pixie wrote: > how to upgrade.... You grab the upgrade download and install it. Or you re-install from a complete base version. No rocket science, just follow the instructions. On 17 May 2006 17:55:59 -0700, "storm pixie" <amit.dba@gmail.com> wrote: >how to upgrade.... go to metalink download patch. find readme.html in the patch dowloaded follow test on non-production system first when it doubt, re-read the readme. ........ We run Oracle 9iR2,10gR1/2 on RH4/RH3 remove NSPAM to email Download patch or request a cd from oracle supp check the current installation. follow the instruction as the readme file. install the latest jvm patches for OEM. Please take note Oracle Workspace is only 9.2.0.5. You can always log a tar in metalink for support Download patch or request a cd from oracle supp check the current installation. follow the instruction as the readme file. install the latest jvm patches for OEM. Please take note Oracle Workspace is only 9.2.0.5. You can always log a tar in metalink for support ...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

9.2.0.5 seems does not have the same statistics as 9.2.0.3?
trace file from 10046 level 8: 9.2.0.5: select /*+index_combine(a)*/ count(*) from kana_admin.kc_message a where state<:"SYS_B_0" and type=:"SYS_B_1" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.92 0.89 0 3212 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.92 0.89 0 3212 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 1 BITMAP CONVERSION COUNT 1 BITMAP AND 1 BITMAP CONVERSION FROM ROWIDS 6901 SORT ORDER BY 6901 INDEX RANGE SCAN OBJ#(14132) (object id 14132) 16 BITMAP CONVERSION FROM ROWIDS 1543070 INDEX RANGE SCAN OBJ#(14140) (object id 14140) 9.2.0.3: Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=11088 r=0 w=0 time=5093329 us) 2 BITMAP CONVERSION COUNT (cr=11088 r=0 w=0 time=5093309 us) 2 BITMAP AND (cr=11088 r=0 w=0 time=5092618 us) ...

Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment
HI, I have the following situation: We have Veritas cluster setup , and there are 2 solaris servers on which VCS is set up. On this set up we have about 8 databases all of which are 9.2.0.6 version. Now we have one stand alone solaris server, and it has a 9.2.0.7 database. This database is for a third party application -Clear Case & Clear Quest. Now it is required to move the single instance database to clustered environment. Since in the clustered environment we have 9.2.0.6 version, is it AT ALL POSSIBLE to move this database, which is 9.2.0.7 to that enviroment? I guess not, and in that case, what are the options? - since this is a packaged application , so should be contact the vendor and ask them whether we can downgrade the database to 9.2.0.6? - is that a valid option? Are there other options? (upgrading the existing 9.2.0.6 database to make all of them 9.2.0.7 is not allowed.) Again thanks a lot for the kind help.. Nirav nirav wrote: > HI, > > I have the following situation: > > We have Veritas cluster setup , and there are 2 solaris servers on > which VCS is set up. On this set up we have about 8 databases all of > which are 9.2.0.6 version. > > Now we have one stand alone solaris server, and it has a 9.2.0.7 > database. This database is for a third party application -Clear Case & > Clear Quest. > > Now it is required to move the single instance database to clustered > environment. > > Since in the cl...

apply patch 9.2.0.6 on 9.2.0.1.
To apply patch 9.2.0.6 on 9.2.0.1. Do we have to apply all patches between them means 1st 9.2.0.2 then 9.2.0.3 then 9.2.0.4 then 9.2.0.5 and then 9.2.0.6. Or can I do it directly. on windows XP "aman.oracle.dba" <aman.oracle.dba@gmail.com> a �crit dans le message de news: 1167974188.705052.140810@s34g2000cwa.googlegroups.com... | To apply patch 9.2.0.6 on 9.2.0.1. | Do we have to apply all patches between them means 1st 9.2.0.2 then | 9.2.0.3 then 9.2.0.4 then 9.2.0.5 and then 9.2.0.6. Or can I do it | directly. on windows XP | Each patch/patchset comes with a readme file. Please read it before posting. Regards Michel Cadot Michel Cadot wrote: > "aman.oracle.dba" <aman.oracle.dba@gmail.com> a =E9crit dans le message d= e news: > 1167974188.705052.140810@s34g2000cwa.googlegroups.com... > | To apply patch 9.2.0.6 on 9.2.0.1. > | Do we have to apply all patches between them means 1st 9.2.0.2 then > | 9.2.0.3 then 9.2.0.4 then 9.2.0.5 and then 9.2.0.6. Or can I do it > | directly. on windows XP > | > > Each patch/patchset comes with a readme file. > Please read it before posting. > > Regards > Michel Cadot Please tell me the patch number to be applied on 9.2.0.1 to upgrade it to 9.2.0.4 aman.oracle.dba wrote: > Michel Cadot wrote: > > "aman.oracle.dba" <aman.oracle.dba@gmail.com> a =E9crit dans le message= de news: > > 1167974188.705052.140810@s34g2000cwa.googlegrou...

Which OS patches to install on HP-UX 11i (11.11) for Oracle 9i R2 (9.2.0.4.0)?
Hi! I'd like to install Oracle 9iR2 (9.2.0.4.0) on a HP-UX 11.11 machine. Which operating system patches should I install? The documentation at <http://oracleheva1.oracle.com/docs/html/A96167_01/pre.htm#sthref108> only lists 11.00 patches. Sept. 2001 Quality Pack, PHCO_23792, PHCO_24148, PHKL_24268, PHKL_24729, PHKL_ 25475, PHKL_25525, PHNE_24715, PHSS_23670, PHSS_24301, PHSS_24303, PHSS_24627, PHSS_22868 Is there somewhere a more recent listing? Thanks a lot, Alexander Skwar -- He that bringeth a present, findeth the door open. -- Scottish proverb. You can install the latest gold maintenance patch from hp and you should be all set. hpuxrac <johnbhurley@sbcglobal.net>: > You can install the latest gold maintenance patch from hp and you > should be all set. Thanks! In the meantime, I found Doc ID: Note:169706.1 Subject: Oracle RDBMS on AIX,HP-UX,Solaris,Tru64,Linux,MacOSX: Versions, Sizes, Requirements Quick Reference And installed, what was listed there: PHCO_24402 s/b PHCO_25569 PHCO_28427 s/b PHCO_29029 s/b PHCO_31903 PHKL_25506 PHNE_27745 s/b PHNE_30580 (For RAC systems) PHNE_28568 s/b PHNE_30378 PHSS_26560 s/b PHSS_30966 PHSS_26946 PHSS_28849 Alexander Skwar -- The older a man gets, the farther he had to walk to school as a boy. ...

Oracle 9.2.0.4.0 and Fedora
Hello DBA I have Fedora Core 1 Linux and I new instalation of Oracle 9.2.0.4. Instalation on database, database initalization omca creation and database initialization was ok. But I have one big problem with Inteligent Agent. agtctl falling down, because of dbsnmp [oracle@hipcio bin]$ ldd dbsnmp /etc/libcwait.so => /etc/libcwait.so (0x40002000) libvppdc.so => not found libclntsh.so.9.0 => not found libwtc9.so => not found libdl.so.2 => /lib/libdl.so.2 (0x0099a000) libm.so.6 => /lib/i686/libm.so.6 (0x4001a000) libpthread.so.0 => /lib/i686/libpthread.so.0 (0x4003c000) libnsl.so.1 => /lib/libnsl.so.1 (0x00792000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x00cfe000) libcxa.so.3 => not found libc.so.6 => /lib/i686/libc.so.6 (0x4008d000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x00823000) but [oracle@hipcio bin]$ env | grep LD_LIBRARY_PATH LD_LIBRARY_PATH=/u01/product/9.2.0/lib::/usr/local/lib using /etc/ld.so.conf (hard way to solve this problem) [oracle@hipcio bin]$ ldd dbsnmp /etc/libcwait.so => /etc/libcwait.so (0x40002000) libvppdc.so => /u01/product/9.2.0/lib/libvppdc.so (0x4001b000) libclntsh.so.9.0 => /u01/product/9.2.0/lib/libclntsh.so.9.0 (0x4009a000) libwtc9.so => /u01/product/9.2.0/lib/libwtc9.so (0x40a6c000) libdl.so.2 => /lib/libdl.so.2 (0x0099a000) libm.so.6 => /li...

Web resources about - Where to get oracle patch 9.2.0.4 and 9.2.0.5 - comp.databases.oracle.server

Oracle - Wikipedia, the free encyclopedia
This article is about the classical medium. For the software company, see Oracle Corporation . For other uses, see Oracle (disambiguation) . ...

Oracle - Wikipedia, the free encyclopedia
This article is about the classical medium. For the software company, see Oracle Corporation . For other uses, see Oracle (disambiguation) . ...

News Oracle
The News Oracle is an online news outlet. The Oracle covers the most relevant stories from around the globe.

Oracle Acquires Facebook Data Partner Datalogix
One of Facebook’s data partners has a new owner, as Datalogix was acquired by Oracle , the two companies announced Tuesday. (more…) New Career ...

Google, Oracle setting up jurors to fail in API copyright retrial, judge says
(credit: Seabamirum ) One of the tech sector's biggest upcoming trials— Oracle v. Google —careened Tuesday away from the hot-button topic of ...

Oracle Rising: Past the Trough in Cloud Transition, Say Bulls
Shares of database giant Oracle ( ORCL ) are up $1.26, over 3%, at $40, in early trading, continuing last night’s gains, after the company yesterday ...

Larry Ellison shrugs off Amazon, Microsoft play for Oracle database business
Businesses that aren't worried when Amazon starts gunning for their customers need only give Borders Books and Music a call. That said, Oracle's ...

Riley Curry Made a Special Appearance on the Dance Cam at Oracle Arena - Bleacher Report
Riley Curry...back at it again with the heart-stealing. The young phenom gave her dad, Golden State Warriors star Stephen Curry , a run for his ...

Here's the email Larry Ellison just sent to employees about a big change at Oracle
Oracle CEO Safra Catz made some interesting and cryptic comments about big changes coming to the company when talking to analysts after reporting ...

Oracle earnings beat estimates
Analysts had expected Oracle to report earnings of about 62 cents a share on $9.12 billion in revenue.

Resources last updated: 3/20/2016 1:50:27 AM