We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.
I was planning to ask the following questions.
1. Specifications of the current server and the new one. 2. Operation system (I think they will use same OS, just an updated one) 3. Can the business afford full downtime on current servers? 4. Size of the DB, because it can take hours to move large files.
And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything,
We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp / impdp. Is there any other way to do it as well?
Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?
Recently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.
Is there is any way that we can migrate oracle jobs from 10g to 11g?
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.
We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )
I do have two queries :
1) how to connect from Sql server 2008 R2 to different Oracle databases
2) How will other oracle databases connect to Sql server 2008 R2 database
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?
I have migrated from postgres to oracle entire databases however some tables have spaces how can they be removed and how can i found out all the tables in a schema with spaces?
Migrating the LIVE server to a NEW virtual machine.2 databases reside on the LIVE server, one runs in archivelog mode &other no archivelog modeOld server-Windows 2003 32 bit, oracle databases 11.1.0.7.0New-Windows 2008 64 bit,Oracle databases should be 11.2.0.3.0Just want to clarify the following1)When installing oracle, what would be the best option-create and configure a database / install software only(later create database using dbca) ?why? Just want to know if there will be a difference at all in these 2 methods.2)What is the best way to migrate the data in the database, datapump or rman (rman takes full backup in the present "live" so this can be moved to "new live" and can be recovered)? What would be the method with least downtime?(Once the data is transferred, the database in the "old server"will be deleted)3)The structure of the data files (folder path) are going to be different in the old and new servers, so I have to precreate the tablespaces, so will the impdp fail in this case?
"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"
Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
im trying to migrate Sybase 12.5 to oracle 11G R2 on linux all tables are fine expect one which fails with error
"SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0" *Cause: Illegal year entered *Action: Input year in the specified range"
i have change the data type from CHAR to VARCHAR2 etc as for the datatype date shows as date on the tool - I'm using sqldeveloper from oracle.
i have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?
i have following steps me know if i am wrong? 1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE 2) shutdown oracle 9i database on server A 3) copy database file, controlfile, redolog, and other files to new server B 4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations 5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS -STARTMODE AUTO -PFILE ORACLE_HOMEDATABASEINITSID.ORA 6) start dabase in upgrade mode 7) run catpat.sql and util102.sql take backup 9) open database for users
I want to migrate our production database from 9.2.0.8.0 to 10.2.0.4.0 through startup migrate ,so request you to kindly provide me a step by step doc or some reference link pertaining with same.
I am planning to move the databases in multi master replication from HP-Ux to AIX server. I am planning to use export/import to moving the database. But do I need to drop the replication administrator user before I do export/import?
currently holding 9i database on win2000 and front end is dev4.5 so the thing is want to upgrade by win2008 pn 32bit with 10gdatabase want to keep the front end application as it is 4.5...
will it be compiatble 10g database on 32bit 2008 and front end 4.5developer forms and reports?
can i migrate 9i database to 10g database, what are the steps for full import??
Our 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 ?
Am 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.
Currently our application running with Database - oracle 10.2 and front-end SAP11.5. We are going to upgrade our database (oracle 10.2) to 11g (version not sure) and upgrading application from SAP 11.5 to 12.2. As part of it i want to know what are all things i want to take care while migration (oracle upgradation) as I'm oracle developer.
1) Is it possible to access objects in 8i database from 11g database using DB link?. (as like 10g to 8i). 2) Is it possible to access objects in DB2 database from 11g database using DB link?. (as like 10g to DB2).
I got an assignment to create Oracle 11g db. I will be provided the full datapump export dump of an Oracle 10g db in linux. I need to import it to 11g Database in Windows. I have no information about the tablespaces, users etc I have created db with system,sysaux,undotbs temp and users tablespaces.
We are planning to migrate data from an application called clintrace to another application called argus safety. Both the applications are related to pharmacovigilence safety operation. Both the applications functionality are similar. So both the database are having the same data though the table structures might be different. Both the database are oracle clintrace db is 9i and argus db is 11g.
I have a database on Mysql which consists on 40 tables interrelated. My issue is to migrate that DB to Oracle 11g by keeping the same structure (I mean the relation between the differents tables).
In my project, fmb's were written using oracle 9i and now we planned to move them to oracle 10g. The consequences of using oracle 10g to modify the oracle 9i fmb's.
Also will there be any diff in terms of visual if i use oracle 10g to open oracle 9i fmb's.
I wanted to migrate my database from one of the Solaris machine to other solaris(High performance) machine.We are using oracle 9i database.
I wanted to take RMAN backup with oracle 9i database.and wanted to restore that database to other machine and perform recovery.This process will be on production database and requirenement is to reduce downtime.
let me know RMAN backup procedure which will have less downtime of the database.