Server Administration :: Migrate Two Different Databases To Oracle?

Jul 11, 2012

I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.

View 3 Replies


ADVERTISEMENT

Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Server Administration :: Migrate And Upgrade Oracle 9i Database To 10g?

Mar 10, 2011

I am looking to migrate and upgrade an Oracle 9i database to 10g.

Would there be any fallout if the characterset were changed from US7ASCII to UTF8?

View 2 Replies View Related

Server Administration :: Change Character Set For Oracle 8i Databases?

Aug 15, 2013

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

View 11 Replies View Related

Server Administration :: How To Install Oracle 8i And 9i Databases On Same Server

Feb 20, 2011

How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.

View 7 Replies View Related

Server Administration :: Create Two Databases With Different Sides On One Oracle Home?

Jun 8, 2010

i want to create two databases with different sids on one oracle home.

how can ı handle it?

View 2 Replies View Related

Server Administration :: Migrate From 8.1.7.0.0 To 9.2?

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

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

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

Server Administration :: Multiple 11g Databases

Dec 5, 2010

I have Oracle 11g installed on AIX and I want to install another 11gR2 single instance in a different oracle home, will it be possible?

View 3 Replies View Related

Server Administration :: How To Know Currently Running Databases In Single Server

Jul 30, 2010

I have installed three database in MY Linux server. I have started Instance for all database and started database also .

No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?

View 2 Replies View Related

Server Administration :: Identifying Two Databases Involved In Distributed Transaction?

Oct 24, 2013

I am on Oracle 11.2.0.3 on Linux. In my production database, I am getting this alert, in the alert log:

--the below two lines are from alert log.
Error 604
trapped in 2PC on transaction 50.73.546578. Cleaning up.

--query from a data dictionary view
SQL> select count(*) from DBA_2PC_PENDING;
COUNT(*)
----------
1

When I query the production database I see that there is one row in the DBA_2PC_PENDING view. But I dont' know how to identify which are the databases that are involved in this distributed transaction. That is my first issue - how to identify which are the two databases that are involved in the distributed transaction?

View 10 Replies View Related

Server Administration :: Modified Objects - Compare Two Users On Different Databases

Oct 2, 2012

I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.

a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.

View 2 Replies View Related

SQL & PL/SQL :: Migrate Oracle DB To MS/Sql Server?

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

PL/SQL :: How To Migrate From Sql Server To Oracle

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

Server Utilities :: Migrate Table From 10g Xe To Oracle 9i?

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

SQL & PL/SQL :: Migrate Data From Oracle Server To MySql?

Feb 1, 2013

I need to migrate data from oracle server to MySql.

View 14 Replies View Related

Client Tools :: How To Migrate Data From SQL Server To Oracle Database

Jun 13, 2013

how to migrate sql server database to oracle database?

View 2 Replies View Related

List Exiting Databases In Oracle Server Using SQL Plus Command?

Feb 14, 2013

I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?

View 1 Replies View Related

PL/SQL :: How To Migrate Files From Collaboration Plum Tree Server To Oracle Database

Jul 4, 2012

I need to write a procedure to migrate files from Collaboration plum tree server to oracle database server into a table using a BLOB column .

View 2 Replies View Related

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 View Related

Application Express :: Migrate From One Server To Newer Server

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

Migrate Application Server To Weblogic Server?

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

Same Server Two Databases

Oct 3, 2012

I have a windows 2008 server.

I already installled oracle software for oracle_home C:/oracle/product/11.2.0/dbhome_1 for database DEV.

Now, I want to create new database with different oracle_home on same server with oracle_home as C:/oracle/product/11.2.0/dbhome_2 and SID as TEST.

Do I have to istall oracle software again ? if yes, what about inventoryfiles in C:\Program Files\Oracle\Inventory ? wont they be overwritten ?

View 3 Replies View Related

Server Utilities :: Using The Datapump Tool To Migrate 10g DB To 11g?

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

Migrate From Oracle To Postgres

May 4, 2011

I want to migrate my database from oracle to postgres.There is a lot of compatibility issues. I heard about the tool ora2pr. have been trying to use it but not able to achieve my goal.Has any one used this tool?

View 1 Replies View Related

How To Migrate Database From Windows 2003 To 2008 Server

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 1 Replies View Related

Multiple Databases In Linux Server?

Jun 16, 2013

while using top command it shows multiple processes usage.Actually we have 3 databases in the same server.how to find out which database process and user session hogging the cpu resources

View 2 Replies View Related

Moving Databases To New Host Server?

Oct 7, 2012

I have a requirement to move the databases to a new server.

Existing set up:

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3

New Server (setup):

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1

My query is what is the best way to move the database to new server(UNIX AIX 6.1)?

a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?

b)is export and import of database can work for moving this?

c) RMAN backup and restoration can be done for moving databases?

d)simply moving all the related files to new server and start upgrading it from there?

View 8 Replies View Related

Created Two Databases On Same Server With Same Schema

Apr 21, 2011

Using suppress triggers options in golden gate. I was trying to work on the same but it doesn't seem to work at least for me.

Scenario:
Database Version 11.2.0.2
GoldenGate v11
OS Windows

Created two databases on the same server with same schmea idea was to replicate change from one database to other. One of the tables in the source database had trigger(every insertion in the table would cause a row to be inserted into a diff table). if row was inserted in table A it will insert a new row in table B . the same records will pass on target but the trigger defined on table A should not trigger on target as it has already fired on Source .

I tried using suppresstriggers but it doesnt seem to work everytime the trigger is getting fired on target database.

CODEReplicat process
replicat repname
assumetargetdefs
userid gguser@bbb password Oracle
dboptions suppresstriggers
map x.* ,target x.* (since same schema)

The extract files,pump files and replication are working fine.I also used the dbms_goldengate_auth.grant_admin_privilege for gguser.

Also I noticed when I give the dboptions suppresstriggers replication process doesnt startup with unrecognised word message when i give dboptions suppress triggers the replicat process does start is this the way it should be.i have gone through the docs and it should be supresstriggers.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved