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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Feb 1, 2013
I need to migrate data from oracle server to MySql.
View 14 Replies
View Related
Jun 13, 2013
how to migrate sql server database to oracle database?
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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