Oracle Upgrade from Solaris 8 to 10....? Why?

I'm currently running 9.2.0.7 RAC on Solaris 8.I'm upgrading to Oracle 10gR2.I'd like to do upgrade to Solaris 10 as well (Solaris 10 first then after 2 weeks Oracle 10gR2).Some are saying why bother with the Solaris upgrade - 8 works...I know that Sol10 offers better security, performance etc are t ...

Oracle Upgrade the OEM Agent from 10.1.0.3 to OEM 10.2.0.1

I have to upgrade the OEM Agent from 10.1.0.3 to OEM 10.2.0.1. Can anyone please tell me how to do it. ...

Oracle Upgrade 11gR1 (RHEL 64Bit) from 10.2.0.3 (RHEL 64 Bit)

What is the patch# for Upgrade 11gR1 (RHEL 64Bit) from 10.2.0.3 (RHEL 64 Bit)? ANy metalink note for upgrade on 11g. ...

Oracle Upgrade from 9.2. to 10.2.0.1

I have an oracle 9.2.0.7 database, I want to upgarde this DB to 10.2.0.1. I got the DB as a cold backup. Can someone guide me on how to upgrade this to 10.2.0.1 ...

Oracle upgrade from 9i 1to 10g(10.2.0.3)

Solaris 9upgrade from 9i(9.2.0.8) to 10g(10.2.0.3)Hi all,After upgrade I ran this script and it only shows the following.I do not see other components such as jserver JAVA vertual machineOracle XDK validOracle Database Java packagesOracle XML databaseOracle workspace managerOracle data miningMessage ...

Oracle Upgrade path and docs from 10.2.0.1 to 10.2.0.4?

Can someone point me what's the upgrade path from 10.2.0.1 to 10.2.0.4 and related docs? I did search in my metalink for upgrade patch from 10.2.0.1 above ... but it doesn't show anything for my Oracle version and platform (Linux x86). Where should I look? ...

Oracle Upgrade from 9.2 to 10.2

all during upgradtion from 9.2 to 10.2 through dbua oracle_server.log show this -- set the acl of xdbconfig.xml to all_owner_acl.xml-- no need to modify migrate status since setacl is an idempotent opernDECLARE2 acl_abspath VARCHAR2(200);3 b_abspath VARCHAR(20) := '/xdbconfig.xml';4 BEGIN5 acl_abspa ...

Oracle upgrade from 10.1.0.4 -> 10.1.0.5 seems to break ArcIMS/ArcSDE

We were recently obliged to upgrade to 10.1.0.5 to address a replication bug, and doing this seems to have re-introduced a problem w/ ArcIMS/ArcSDE. The problem is w/ geodetic areas larger than 1/2 surface of earth, not all of the expected data are returned. Once you zoom in, all the data are correc ...

Oracle Upgrade RAC from 10.1.0.3 to 10.2.0.2

I need to upgrade my RAC DB from 10 1 0 3 to 10 2 0 2.I first need to install 10 2 0 1 software.. in different oracle home.. doubt clusterware in diffent home.??Upgarde Database and Clusterware to 10 2 0 1Install patchset 10 2 0 2upgrade database and clusterware Am I correct..Can some one guide with ...

Easiest method to upgrade Oracle 8.1.7.0 to 10.2.0.2.0

what is the esiest method to upgrade Oracle 8.1.7.0 to 10.2.0.2.0 ? ...

Oracle Upgrade from 10.1.0.2 to 10.2.0.4

Can someone point me in the direction to download the Oracle upgrade 10.2.0.4 for Windows 32-bit? BTW, is there a simple webpage I can go to for Oracle's available upgrades? ...

Oracle Upgrade 10.2.0.1.0 to ???????? on Linux

I am goint to upgrade my Oracle 10g Database.My current database version is: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for Linux: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - Production OS:Linux f ...

Upgrade DB-Schema from Oracle 9.2.0.7 to 10.2.1

we want to upgrade from ORACLE 9.2.0.7 to 10.2.1. The machine is also a new one. First of all our admins installed a new Oracle 10.2.1. Then they created new empty tablespaces for the import. Then they exported from the 9.2.0.7 machine and imported the file via import to the 10.2.1 machine. On the s ...

upgrade oracle 10.2.0.1 to 10.2.0.3/10.2.0.4 for AIX6.1

I the previous discussions i have found that for installing oracle 10 in AIX6.1 , i have to install 10.2.0.1 first and then upgrade it to 10.2.0.3/10.2.0.4 .. so could anyone tell me the silent installation steps for upgrading that .. I have installed 10.2.0.1 in aix 6.1 SILENTLY , and i have to run ...

Upgrade a Oracle grid control and agent from 10.2.0.3 to 10.2.0.5

I want to upgrade the Grid control from 10.2.0.3 to 10.2.0.5?i want to upgrade the oracle agent from 10.2.0.3 to 10.2.0.5?repository database is 10.1.0.4Edited by: user10375608 on Jan 25, 2010 8:08 PM ...

Upgrade Oracle DB from 10.2.03 to 10.2.04

I found the following steps to upgrade my Oracle DB from 10.2.03 to 10.2.04:Shutdown all Oracle Windows servicesInstall 10.2.04 patchset (run setup)Startup all Oracle Windows servicesfrom CMD prompt: sqlplus /nologfrom SQL prompt: connect sys/sys@db as sysdbaafter connect:shutdown immediateafter shu ...

Oracle Upgrade 10.1.0.5 to 10.2.0.4 on Solaris SPARC 64bit (on VCS) Hangs

HiIm in progress of upgrading a 10.1.0.5 Database to 10.2.0.4 on Solaris SPARC 64bit with VCS installed.I installed the base 10.2.0.1 and then 10.2.0.4 and then CPUJAN2010 without failure. I began the upgrade as per the b14238.pdf (Oracle® Database Upgrade Guide 10g Release 2 (10.2) B14238-02 Janua ...

Oracle Upgrade from 10.2.0.1 SE to 10.2.0.4 EE -- What way to follow?

I have a Database (10.2.0.1 SE) on Solaris 10 os. I need to upgrade the database to 10.2.0.4 EE.As of now I have planed the upgrade procedure in the below manner ....1)Take the database full backup (online backup with rman in archivelog mode) +archivelogs.2)Install 10.2.0.1 EE software in a saperate ...

Upgrade Oracle database 10.2.3 to 10.2.4

I want to upgrade Oracle database 10.2.3 to 10.2.4 . I have DataGuard on 10.2.3. My question is can i install 10.2.4 on top of 10.2.3? If i do what will happen the data in the dataguard because the data version of dataguard will remain as 10.2.3? In this context, will the upgrade work? If not what i ...

Oracle Upgrade guide to 10.2.0.4

I am looking for the Oracle Upgrade Guide from the 10.2.0.3 to 10.2.0.4. I searched it all over Metalink and otn.oracle.com, but could not locate it anywhere. Could anyone please help me with the link for the same? ...

Upgrade Oracle database 10.2.3 to 10.2.4

What patch i need to download to upgrade database 10.2.3 to 10.2.4? Can someone give me the patch id number? I will appreciate it.Thanks,ajPlatform SOLARIS 64 bit x86Oracle database 10gR2 ...

Solved -Upgrade: Oracle 9.2.0.7 to 10.2.0.2 - dbua "ORA-01507" but Database

i have a Test-System on AIX 5L (5.3 ML3) with Oracle 9.2.0.7. (SAP R/3)I try to Upgrade to Oracle 10.2.0.2.Oracle 9.2.0.7 /oracle/<SAP-SID>/920_64Oracle 10.2.0.2 /oracle/<SAP-SID>/1020_64I Installed the Oracle 10.2.0.1 and the PatchSet 10.2.0.2.I did the Upgrade with dbua one Time on thi ...

Oracle Upgrade 9.2.0.5 to 10.2.0.4

HiMe againWe are migrating from Oracle 9.2.0.5 to 10.2.0.4, the steps executed and we are on the run catupgrd.sql but the script stops with the following message: (Please help) (S.O. AIX) (The upgrade is manually)SQL> / * register schema statisticsSQL> / * ----------------------------*/SQL> ...

Oracle Upgrade 10.1.3 to 10.2.2 and ApEx

I need to upgrade from 10.1.3 to 10.2.2. There is also an ApEx installation in my database and it makes the whole thing a bit tricky. Is there a simmilar experience arrond? What would be the best strategy to get the thing going? ...

Oracle Upgrade from 10.1.0.4 to 10.2.0.1 files

AIX5I'd like to upgrade the repository database to 10.2.0.1(from 10.1.0.4) as a part of EM Grid CR3 upgrade.I'm having difficulties to locate the files.I'd appreciate a pointing to the correct download location or just to the file name.Thx,Dobby ...

Oracle Upgrade 10.2.0.1 to 10.2.0.3 Solaris 10 SPARC Patch Number ??

I have restored a database from Server S1 to S2. What would be the patch number to upgrade the database on Solaris 10 SPARC from 10.2.0.1 to 10.2.0.3 ...

Oracle Upgrade 10.1.4.0 to 10.2.0.3 directly

Can I patch directly from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 to 10.2.0.3 using patch p5337014? ...

Oracle upgrade 10.2.0.1 to 10.2.0.3

I upgraded from 10.2.0.1 to 10.2.0.3 W2k3 with patchset 5337014 with no errors.However when I query dba_registry "Oracle Workspace Manager" version is still 10.2.0.1.0.What do I need to do ? Is there another patch to be applied ? Tks ...

Oracle Upgrade from 10.1.0.5 to 10.2.0.3 in RAC system / What about ASM ?

I have trouble finding this information but answer may be simple.We have customers running 10gR1 and we would like to upgrade them to 10gR2 (10.1.0.5 -> 10.2.0.3)These are cluster configurations with ASM.I've found interesting documents about 10gR2 upgrade but most of them are about a non RAC dat ...

Oracle upgrade 10 databases at a time without OEM

I have ten databases in 10.2.0.2. standard edition on Linux platform. I want to upgrade all of them to 10.2.0.4 without using OEM.Is there any simple way to upgrade all of them to 10.2.0.4 instead of login to each and every server and upgrade. ...

Oracle Upgrade 10.2.0.3 to 11g in E-business Suite

We have applications 11.5.10.2 with database 10.2.0.3 (64-bit) running solaris sparc (64 bit) version 10 in our environment. I have been asked to upgrade just database from 10.2.0.3 to 11gR2. I am not sure upgrade for 11gr2 with applications 11.5.10.2 is certified on solaris! If not can i upgrade to ...

Oracle ORA-04045/ORA-06545/ORA-06508 10.2.0.3 -> 10.2.0.4 upgrade

My customer is working on an upgrade from 10.2.0.3 -> 10.2.0.4 on an R12 environment.Instead of downloading the 10.2.0.4 upgrade patch, doing the runInstaller.sh and running dbua, they just pointed the 10.2.0.3 db to one of the many 10.2.0.4 OH's they have and then run catupgrd.sql (attempting to ...

Oracle Upgrade from 10.2.0.1 to 10.2.0.4

After I've upgraded 10.2.0.1 to 10.2.0.4 on SuSE Linux 9 SP2, I encountered the following issue.Version difference between v$version and version in Enterprise Manager.v$version using sqlplus:SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 23 20:56:52 2010Copyright (c) 1982, 2007, Oracle. All Ri ...

Oracle Upgrade from 10.2.0.3 to 10.2.0.5

I wanna upgrade my Database SE from 10.2.0.3 to 10.2.0.5.The only thing I need to do is download a patch? Are there any limitation?OS: HP-UX ...

Oracle upgrade 10 databases at a time without OEM

I have ten databases in 10.2.0.2. standard edition on Linux platform. I want to upgrade all of them to 10.2.0.4 without using OEM.Is there any simple way to upgrade all of them to 10.2.0.4 instead of login to each and every server and upgrade. ...

Oracle Upgrade to 10.2.0.3 from 9.2.0.8 causes statement to use excessive temp

I upgraded a database from 9.2.0.8 to 10.2.0.2. 10.2.0.2 stats with histograms are being run per standard 10g setup.There is a statement that never used temp tablespace under 9i and now uses close to 38GB every night when it runs:UPDATE message_hist_t currowSET currow.record_expired =(SELECT MIN (mi ...

Oracle Couldn't connect 11.5.10 using BSC 5.1

I'm trying to connect to oracle application new release 11.5.10 using balanced scorecard architecture version 5.1.0.0. i followd all the installation steps in the installation guide (A95234-08) for windows XP users. i'm also upgrade my odbc drivers to 9.2.0.6.2. my problem appears when i tried to do ...

Going from Oracle 9.2.0.7 To 10.2.0.3

I am in the process of upgrading our 9.2.0.7 databases to 10g and the question is to which patchset, will it be 10.2.0.3 or 10.2.0.2.As recommended by Oracle I downloaded the latest patchset 10.2.0.3 and applied it the base 10g install (10.2.0.1)Before running the upgrade, I ran the pre-upgrade info ...

Oracle wierd issue with emca in 10.2.0.4

I am trying to install the OEM in redhat 5. Well you have to start with 10.2.0.1 and upgrade to 10.2.0.5. 10.2.01 is not certified in redhat 5, but 10.2.0.5 is. so I am following these instructions:http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_10.shtml#Pre-Installation%20R ...

Oracle Downloads for Database 10.2.0.3/10.2.0.4 for Windows 32-bit

Has Oracle removed the downloads for Oracle Database 10.2.0.3 & 10.2.0.4 for Windows 32-bit? As I see on the download site, there is only a download for the base version (10.2.0.1) for Windows 32-bit and thus to upgrade to 10.2.0.3/4, you need to patch it. Why this change? ...

Oracle 10.2.0.4 --> 10.2.0.4.2 64bit.

I updated my test database from 10.2.0.4 toPatch 8833280 - 10.2.0.4.2 Patch Set Update Release 10.2.0.4.2 for UNIXsingle instance.I followed the README without any errors occcured.Alter the update prozress v$version shows old version numberSQL> select * from v$version;BANNER Oracle Database 10g E ...

Oracle Liveupgrade on Mixed FS - Solaris 10 update 6 to Solaris 10 update 8.

I need help from you .My requirement is, I need to upgrade my exisiting solaris 10 u6 to solaris 10 u8 from a mixed filesystem enviornment. My current enviornment details are below.We are having UFS and ZFS filesystem in one of the solaris 10 u6 Box.OS is configured with UFS and User data is configu ...

Page not found for Oracle Application Server 10g Release 2 (10.1.2.0.2) doc

Receiving page not found when trying to access the documentation for Oracle Application Server 10g Release 2 (10.1.2.0.2)We're sorry, the page you requested was not found. We have recorded this error (404) to help us fix the problem.You may wish to try again using one of the tools below. ...

Oracle HTTP Server (Apache 2.0) (10.1.3.3.0) for Linux

i my question is related to Oracle HTTP Server.I found on this link http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxsoft.htmlthe version OHS for linux 32-bit "Oracle HTTP Server (Apache 2.0) (10.1.3.3.0) for Linux x86"i was looking for 64-bit version of it but when ...

Ubuntu Update Manager: "Could not calculate the upgrade" after updating to 9.10

A friend of mine upgraded his copy of Ubuntu from 9.04 to 9.10. As far as I know things went pretty smoothly. After the upgrade was done, update manager reported that there were more package updates available. Upon trying to apply them, it says that not all updates can be applied and offers the opti ...

8i Install: missing component oracle.swd.jre.1.1.8.10.0.

When I install 8i on W2k, at the installation type screen I got a message:Not all the dependencies Oracle Enterprise manager Common Files 2.2.0.0.0 are found. missing component oracle.swd.jre.1.1.8.10.0.How to fix this? ...

workflow client install: Missing Component oracle.swd.jre 1.1.8.10.0

I am trying to install the Oracle Workflow Builder on a machine that has 8.1.7, 9i, and 9iAS. The installation kicks off, but I keep getting this error:Not all the dependencies for the component Assistant Common Files 8.1.6.0.0 are found. Missing Component oracle.swd.jre 1.1.8.10.0Once this error sh ...

Installation problem of Oracle 8.1.7 on solaris 10 x86

I tried to install the Oracle 8.1.7 on solaris 10 x86 and I got an error message shows: "cannot write to /opt/oracle/product/8.1.7/jar/classes2.jar".checking the log it shows:Exception: IOException2and exception: copyGroupFromJar. I ignored the error but the installation failed.By the way, I was not ...

Oracle Problem encountered applying patch set 10.1.0.4 on Solaris-64

I'm getting the following error when I attempt to run catpatch.sql:SQL> @?/rdbms/admin/catpatch.sql TIMESTAMP BEGIN dbms_registry.check_server_instance; END; * ERROR at line 1: ORA-06550: line 1, column 21: PLS-00302: component 'CHECK_SERVER_INSTANCE' must be declared ORA-06550: line 1, column 7: ...

Uninstall Oracle 10 G on Solaris 10

I need to reinstall oracle 10G on my machine with same specifications. Can anybody please tell me how to uninstall oracle 10 G on solaris 10.important point is that i should be able to use the earlier sid. ...