Upgrade :: Migration From 10g To 11g?
Nov 2, 2012my current database version is 10.2.0.3.0 and we are going to migrate our database to 11.2.0.3 .
Can we directly migrate database to 11.2.0.3 or will i require to apply any patch before this ?
ADVERTISEMENT
Upgrade :: Migration / Upgrade 10g / R2 To 11g / 2
Jul 6, 2012I am looking for for exact steps for migration. The important question ist:
-- If we migrate from 10g to 11g, do we need addition (more) CPU's as currently we have?
-- Do wee need more powerful HW.
Upgrade :: Non-updatable View After Migration
Apr 24, 2013DBA's are recently migrated oracle 10g to oracle 11g, we got some problem in views after it has been migrated to oracle 11g.
A view which is there in oracle 10g is updatable and the same view currently is not updatable in oracle 11g after migration
view is like
CREATE OR REPLACE FORCE VIEW t3_v
(A1,A2,A3)
AS
select aa.a, aa.b, bb.c
form t1_v aa, t2_v bb
[Code]...
t3_v is updatable in oracle 10g, but after migration to oracle 11g, t3_v is not updatable in oracle 11g,
we have checked underlying views t1_v and t2_v both are insertable, updatable and deletable in both oracle 10g and oracle 11g.
we checked constraints also in oracle 11g, everything is same as in oracle 10g.
Upgrade :: Migration Without Downtime - Goldengate Approach
Mar 24, 2013We are facing a project where it is mandatory that the migration (from 9i to 11g) happens without any downtime. We thought about using Goldengate do to this migration. But i would like to listen to somebody who already did such kind of migration (i never used goldengate before). The basic steps to do such migration would be:
1) Install the Goldengate client on both source and target
2) Export only the metadata (structure of the table, for example) from source to target (here is one point of doubt of mine. This export can be only done using exp/imp?)
3) Perform the initial load from source to target (here i have another doubt: It it possible to perform an initial load from a whole database?)
4) Configure manager, export and replicat to perform the migration with the source database open in read-write
With the steps above, would i be able to perform a migration without downtime? What other considerations do you have?
Upgrade :: Cross Platform Upgrade From Single Instance To RAC
Jun 26, 2013I'm planning to upgrade a small database (~150GB) from 10.2.0.3 on windows 2003 23bit to 11.2.0.3 RAC on Linux 5.8.The database contains oracle spatial too. A suitable method and link to document to be followed.
View 2 Replies View RelatedUpgrade :: ORA-00904 / OBJ$EDITION / Invalid Identifier After Upgrade To 11.2.0.3
Nov 19, 2012I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).
I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.
But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:
SQL> conn scott/tiger
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "OBJ$EDITION": invalid identifier
I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .But I want my auditing to be enabled as per y requirements.
Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1
Sep 22, 2012is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?
View 5 Replies View RelatedUpgrade :: Reference Note IDs For Database Upgrade From 11.2.0.2. To 11.2.0.3.2
Oct 22, 2012find reference note IDs for DB upgrade from 11.2.0.2 to 11.2.0.3.2, as I am finding only Exadata which I don't want but I want to find for Ebiz database, on OS - Solaris 10 9/10 s10s_u9wos_14a SPARC.
View 1 Replies View RelatedUpgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR
Jun 6, 2012Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
Upgrade :: SYS Table Very Slow After 11g Database Upgrade?
Nov 7, 2012All my sys tables are very slow after my database upgrade from 10.2.0.4 to 11.2.0.3 on AIX 6.1
For example
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 11.2.0.3 and few millisec in 10.2.0.4
I have deleted and updated fixed and dictionary table statistics , till I facing this issue
Upgrade :: Patchset Number To Upgrade Oracle
Jun 14, 2012Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies View RelatedUpgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible
Jul 19, 2013I am going to upgrade database from 11.1.0.7 to 11.2.0.3
1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?
Upgrade :: Oracle Database Upgrade
Mar 13, 2013We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1
No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.
can we upgrade the oracle database from enterprise edition to latest standard edition?
Upgrade :: Database Upgrade From 9.2.0 To 11gr2
Aug 6, 2012Iam doing some oracle database upgrade from 9.2.0 to 11gr2 . is it possible to upgrade directly from this 9i version to 11gr2 .
Version : 9.2.0 to 11gr2
Upgrade :: Compatible Parameter During Upgrade
May 21, 2013Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?
View 2 Replies View RelatedUpgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?
Mar 23, 2013I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.
however I got following conflict:
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
Conflicts/Supersets for each patch are:
Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o
Following patches have conflicts: [ 12827726 12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.
I checked above oracle note, and did not say any resolution.
Upgrade :: 10.2.0.1 To 10.2.0.4 Upgrade 32bit
Jun 24, 2012I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in lunux 32 bit . I faced the version incompatibilty error during patchset installation and hence ran the patchset installation with -ignoresysprereqs option.Now during the patchset installation i encountered the below error in in the install logfile.
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
[code]....
Need certified os and versions for oracle db 10gr2
Upgrade :: Database Upgrade From 11.2.0.1 To 11.2.0.3
Jan 2, 2013After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 11.2.0.1 and install 11.2.0.3 to recover db. Unfortunately I am not sure how should I perform restoration.I backed up data by calling RMAN> backup database include current controlfile;
After that I moved files from fast_recovery_area and cleared my machine from current oracle release.I also did a copy of directories:
ORACLE_HOMEdbs
ORACLE_HOME
etworkadmin
ORACLE_HOMEowbinadmin
ORACLE_HOMEhostname_dbname
ORACLE_HOMEoc4jj2eeOC4J_DBConsole_hostname_dbname
Upgrade :: Oracle 10g To 11g Upgrade
Feb 21, 2013I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.
My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.
The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.
So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.
Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?
Jun 29, 2012I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.
So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM
upgrade to 11.2.0.3 GI - standalone
upgrade DB to 11.2.0.3
install 11.2.0.3 GI, configure ASM and run against 10.2.0.5
DB upgrade DB to 11.2.0.3
The DB upgrade has to come last I've been told.
Migration Of Whole Database?
Dec 20, 2010we are planning to do the migration from 10g to 11g and from old servers to new servers.
View 1 Replies View RelatedMigration From Oracle 10g To 11g?
Apr 26, 2011Our Application is on Oracle 10g and we are going to migrate to Oracle 11g.
1) As of now we are using ojdbc14.jar. So if we migrate can we use the same jar or is it mandatory with 11g to use either ojdbc5.jar or ojdbc6.jar. I guess these jar version depends on the version of jdk we are using. But we are using jdk1.5 and still we use ojdbc14.jar which is working fine. So is it like , Oracle 11g can support only jdk1.5 or jdk1.6 ?
2) Is there any effect on the coding part if we change ojdbc14.jar to ojdbc6.jar ?I have seen there are some extra classes used in ojdbc6.jar.
3) Also we are going to migrate the Oracle database from Solaris to AIX. Our application lies on Solaris.So is there any compatibility problem , if our application lies on Solaris and database on AIX ?
ASM Migration From One Storage To Another
Oct 4, 2011we are moving datacenter from one place to another where existing datacenter has got ASM(RAC env) with HP storage which needs to be moved into target datacenter for EMC storage.basically How ASM can be disassociate from source HP storage then associate target EMC storage with very minimal down time.
what are all the ways and all step by steps required for the same.
DB Migration From Oracle 10g To 11g?
Sep 1, 2013Am going to migrate my databases from 10g to 11g.and am unaware of the performance issues in this and how can i increase the performance at database level and what are the possible bottlenecks.
View 1 Replies View RelatedIBM AIX Server - Migration From 10g To 11g?
Dec 23, 2011tell the steps for migration from 10g to 11g on IBM AIX SERVER?
View 1 Replies View RelatedSQL & PL/SQL :: Migration Of Three Tables
Aug 29, 2013Data migration for three tables. I have three table which are
1.npi_p_mig contain four fields (pr_id,mi_id,qty,sl_dt,fac_code)
2.np_detail(pr_id,mil_id,qty,sl_dt,facility)
3.np_ref_tab(facility,fac_code),
I need to migrated the data from based on two tables (np_detail,np_ref_tab) to new table npi_P_mig(pr_id,mi_id,qty,sl_dt,fac_code) table. i need sql script to migrate above two table to new table (npi_P_mig) .
Forms :: Migration 5i To 6i
Dec 23, 2010I am migrate to forms 5i to 6i. , compile are complete but following error are generate when running the form
[12/23/10 12:29:14 India Standard Time]::Client Status [ConnId=0, PID=2052]
>> ERROR: Abnormal termination, Error C0000005 ACCESS_VIOLATION
Forms :: Migration From 6i To 11g
Oct 25, 2012Is the oracle migration assistant a utility with the oracle forms 6i distribution? Or do I need to download it from somewhere else? Is there a license required? Is there a disadvantage of using Oracle Application Express for the migration from oracle forms 6i to 11g.
View 1 Replies View RelatedForms :: Migration To 6i?
Apr 20, 2012We have an application running on Forms 5.0.6.8.0 and Reports 3.0.5.8.0 for the past 10 years... I have two main issues from the begining could not sort to-date... Issues are:
1. I use host() to call reports,for ex:
a) I run a report works fine
b) Now I goto any other master screen and just query some data
c) Now I want to run any of the reports, nothing works..
To generate the report I have to open another instance of application then I can run the report... In this instance again same story repeats... I dont know what is the problem...
2. We are financial company, lot of dependancy on excel ... I want export reports to excel but there is no option...
RAC & Failsafe :: DB Migration To New SAN?
Apr 30, 2012We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.
But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.
So is there will be any way to rename this disk path for disk group..