Server Utilities :: Migrate 10gR2 To 11gR2 On Different Server
Jul 11, 2011
Here are the cards I've been dealt:
I've inherited a 10.2.0.1.0 instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".
I've installed 11.2.0.1 on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".
Now to move the data and views, objects, everything.
I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...
In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.
1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts
I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?
View 9 Replies
ADVERTISEMENT
Jun 22, 2012
Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:
1. need to expdp all schemas/users from oracle 10gR2 in Windows,
2. then impdp each schema/user into oracle 10gR2 in Linux first,
3. then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4. Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?
Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?
View 5 Replies
View Related
Jun 23, 2010
I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.
For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?
OS; solaris sparc 10
Oracle 10g: 10.2.0.1.0
oracle 11g: 11.2.0.1.0
View 1 Replies
View Related
Apr 14, 2010
At my current organization there are two instances are running one is at 8i and another one is 10g. I want to migrate all the data from 8i to 10g. I have already taken the export from 8i with the below command:-
exp file=<<PATH>> full=y logfile=<<PATH>> compress=y
Now I want to import it to 10g DB. Can I do the import with that below command?
imp file=<<PATH>> full=y logfile=<<PATH>> ignore=y compile=y
View 3 Replies
View Related
Dec 1, 2011
how to migrate a table from 10g xe database to a oracle9i database.Both the database are stand alone and we cannot create a dblink.
View 2 Replies
View Related
Jan 3, 2012
I am trying to use the datapump tool to migrate a 10g db to 11g. Everything works fine except for the "nameless" check constraints.
View 7 Replies
View Related
Aug 4, 2011
I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.
View 13 Replies
View Related
Sep 13, 2010
I have Windows server working Oracle 8.0.5.I have to migrate to another server that is Oracle 11gR2 on Windows 2008.Some say I can't do Export and Import directly.And some say DBlink is not working from 11Gr2 to 8.
What can be fewest step to migrate?Somebody try to use 'Oracle directory' and VB and Powerbuilder program to send data and DDL from 8 to 11Gr2.
migrating from Oracle 8.0.5 to 11Gr2 machine.
View 6 Replies
View Related
Jan 28, 2012
In oracle 11g R2 , I face a problem when I export/import xml records in the tables . Everytime it takes huge time (like 2 or 3 days) to import or export the data . But the dump size is very small (4gb) and this dump comes from a vendor so that I dont understand that is it a data structure problem or it the normal behaviour to import xml records.
I am not used to with xml record with oracle database before. Here I am using datapump feature . I also mention that when I delete the schema (where I imported the xml data) , it also takes 2/3 days to delete.The import script will hang in the following stage :
=========================
bash-3.2$ impdp system/sys123 DIRECTORY=isb_dir DUMPFILE=jblbld_20110301_01.dmp,jblbld_20110301_02.dmp,jblbld_20110301_03.dmp logfile=JBLBLD_28Jan2012.log schemas=TBLD;date
Import: Release 11.2.0.1.0 - Production on Sun Jan 29 11:10:38 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
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
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02": system/******** DIRECTORY=isb_dir DUMPFILE=jblbld_20110301_01.dmp,jblbld_20110301_02.dmp,jblbld_20110301_03.dmp logfile=JBLBLD_28Jan2012.log schemas=TBLD
Processing object type SCHEMA_EXPORT/USER
[code]...
The machine has 16 cpu , 32 gb RAM and during export/import most of the time maximum memory will free.
View 1 Replies
View Related
Dec 2, 2010
From some day I have this error during export data pump:
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
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.
This error is random, if I retry after few minutes the expdp work correctly.
View 8 Replies
View Related
Sep 24, 2012
I need to migrate a 10gR2 Ent Ed. from SPARC 5.9 to SunOS 5.10 x86_64 and then upgrade the database to 11gR2 on the target platform. With the below output I would like know if I have any other option besides the imp/exp.
SQL> /
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
4 HP-UX IA (64-bit) Big
9 IBM zSeries Based Linux Big
16 Apple Mac OS Big
18 IBM Power Based Linux Big
8 rows selected.
SQL> !uname -a
SunOS moloto 5.9 Generic_122300-17 sun4u sparc SUNW,Sun-Fire
SQL>
View -1 Replies
View Related
Oct 31, 2012
I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .
View 22 Replies
View Related
Jun 7, 2013
I'm trying to migrate an Apex Application from one server to a newer server . My custom app I used the theme from Go Live CheckList samples....
Well, when trying to install that application I get 'Insufficient space to install application ' with a BIG red X... I was able to install other Package Application except for the one I need and now my application errors out because of some shared Themes. At first I thought it was a DB thing so I downgraded back to 10g from 11....but that didn't work... Apex works fine...
Other samples work fine...Version Apex 4.2.2 and Oracle XE 10g...
View 3 Replies
View Related
Aug 3, 2012
upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.
View 3 Replies
View Related
Apr 22, 2013
Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.
Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No
Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes
View 2 Replies
View Related
Mar 7, 2011
I have a database running on 10205 version. It is a RAC database with ASM storage.
I want to migrate this database to other server and upgrade this database to 11202 version .
View 1 Replies
View Related
Oct 23, 2011
In My Organization we are using Oracle Application server now we want to introduce Weblogic server.
Here we have 2 web servers and 3 application servers.
Now we want migrate to weblogic server.. Ho can we migrate to Weblogic server.
View 2 Replies
View Related
Feb 21, 2013
I am receiving a SYS.DBMS_METADATA error after migrating to 11gr2 RAC from 10gr2 RAC. its worked well in 10g but now throwing error.
onnected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select object_name,object_type from dba_objects where object_name='STUDENT';
OBJECT_NAME OBJECT_TYPE
-------------------- -------------------
STUDENT SYNONYM
STUDENT MATERIALIZED VIEW
STUDENT TABLE
[code]....
ORA-06512: at line 1How could we resolve this error. I have already given select_catalog_role to SCOTT but id did not work.
View 5 Replies
View Related
Oct 28, 2010
ORACLE DBA
EXPERTS
�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?
View 6 Replies
View Related
Jun 27, 2012
I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?
View 2 Replies
View Related
Jan 26, 2010
My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.
View 20 Replies
View Related
May 25, 2010
We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.
View 1 Replies
View Related
May 20, 2013
I did the following to migrate.
1. After the installtion of Oracle 9.2 I created the service using oradim.
2. Should I need to copy my old datafiles to 9.2 before using the migrate option?
3. Should I need to startup the database before migrate?
View 1 Replies
View Related
Mar 5, 2010
We have and oracle 8i database that has an application that has part of it developed by PL/SQL and the other part on portal 309,is it possible to convert to MS/Sql Database,what tool can we use or what steps do we have to go through to achieve this.
View 1 Replies
View Related
Aug 8, 2012
My requirement is we are planning to migrate the sql server data to oracle. what is the way to do migration from sql server to oracle. if any tools are there for migration.Previous we used sql developer( which is provided by oracle i.e. freeware ) tool but it was created only table structures not ported any data.
View 3 Replies
View Related
Feb 23, 2012
how to find the versions of exp and imp utilities of database server from windows command prompt?
Note: Currently i have 10.2.0.10 oracle software installed on my local machine.
View 4 Replies
View Related
Apr 11, 2007
I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
View 12 Replies
View Related
Nov 8, 2011
Provide automated shell script for renaming oracle DB 10gR2. Now it is a daily manual job for us.
View 4 Replies
View Related
May 17, 2012
I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but failed. When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.
View 3 Replies
View Related
Feb 1, 2013
I need to migrate data from oracle server to MySql.
View 14 Replies
View Related