Migration From Oracle 10g To 11g?

Apr 26, 2011

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 ?

View 1 Replies


ADVERTISEMENT

DB Migration From Oracle 10g To 11g?

Sep 1, 2013

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.

View 1 Replies View Related

SQL & PL/SQL :: Migration From Oracle 10.2 To 11

May 7, 2012

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).

View 7 Replies View Related

Migration From Oracle 10.2.0.3.0 To 11.2 On AIX 5.2 Server

Jan 26, 2012

Detail step by step description for Migration of ORACLE from 10.2.0.3.0 to 11.2 on AIX 5.2 Server.

View 2 Replies View Related

Migration Of DB From MySQL5 To Oracle 11g?

Jun 1, 2012

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).

View 1 Replies View Related

Oracle Migration From 9i To 10G Tips

Jul 27, 2011

I want to migrate my database to 10G. Like code change require(e.g. if hints are used previously) table structure changes required.

View 5 Replies View Related

Forms :: Migration From Oracle 9i To 10g

Jan 4, 2011

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.

View 4 Replies View Related

Migration From SQL Server To Oracle

Oct 10, 2011

I created some materialized view in Oracle database from SQL Server using Db Link.

When I selected the materialized view in Oracle database with where clause it is giving me following error.

SELECT * FROM COUNTRY_MV where country_code ='AWB';
ORA-00904: "COUNTRY_CODE": invalid identifier.

But when I write the column name inside quotes it works fine.

SELECT * FROM COUNTRY_MV where "country_code" ='AWB';

View 3 Replies View Related

Ingres To Oracle Migration?

Nov 30, 2012

I need to migrate Ingres database version 6.0 to oracle 10G.Is there any feasible procedure/tools/process available.

View 2 Replies View Related

PL/SQL :: Oracle Data Migration

Nov 9, 2013

Send me sample data migration scripts to get knowledge on Data migration. 

View 10 Replies View Related

Database Migration With Oracle 9i?

Mar 18, 2013

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.

View 4 Replies View Related

Data Migration From WORD To ORACLE?

Sep 20, 2011

I have a long file in WORD as I try to load it in ORACLE quotes become periods, ex:

insert into mytab values ('myname, 26);

when i copy this and paste it in oRACLE (UNIX environment), it translates as insert into mytab values (.myname.,26)..does not recognize the quotes.

I tried copying from word to notepad to ORACLE same problem..

View 5 Replies View Related

Forms :: Migration Of Oracle Form 10g To 6i?

Apr 19, 2011

Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.

View 1 Replies View Related

SQL & PL/SQL :: Database Migration Project To Oracle

Nov 8, 2010

I am working on database migration project SQL server to oracle, convert this query sql server to oracle basic thing i change but i still getting following error: ORA-01799: A column may not be outer joined to a subquery.


SELECT
h.unique_id,
h.customer_id, h.sequence_id, h.name_first, h.name_last, h.email,
h.tn_work, h.tn_home, h.tn_cell, h.tn_work_do, h.tn_home_do, h.tn_cell_do, h.primary_contact_id,h.ssn, h.created, h.customer_status_id, h.doi, h.dod,
NVL(CASE WHEN h.primary_contact_id = 1 THEN tn_home WHEN h.primary_contact_id = 2 THEN tn_cell
WHEN h.primary_contact_id = 3 THEN tn_work END, '') AS ext_primary_contact, ext_customer_status_desc FROM customer c
INNER JOIN customer_history h
[code]...

View 4 Replies View Related

Forms :: Migration Jobs Oracle 4.5 INp To 10G

May 6, 2011

I work an migration jobs Oracle Forms 4.5 INp to 10G.Have any sentence that i havent idea:

DEFINE TRIGGER
NAME = xxxxx
TRIGGER_TYPE = V2
DEFINE STEP
TEXT = <<<
#EXEMACRO NOFAIL NULL;
>>>
REVERSE = ON
ENDDEFINE STEP

special with REVERSE = ON...I need replace this en PL/SQL Oracle Forms 10G

View 6 Replies View Related

Forms :: Migration Part From Oracle 6i To 10g?

Jun 14, 2012

i am working on sql server developer in on of the organization. i got requirement from client that migration part from oracle 6i forms to oracle 10g and i got existing forms backup from client that is have .fmb, .mmb, .rdf and some of libraries having .pll files, but am new to oracle which form need to open from form builder first?

i tried to open .fmb file given database connection also but it is showing some libraries are missing. what should be the solution for my problem.

View 1 Replies View Related

Zero Downtime Migration From Oracle To Sybase

Aug 3, 2012

Is there any way/ tool to migrate from oracle to sybase with Zero Downtime?

View 2 Replies View Related

Client Tools :: Migration From Postgresql To Oracle

May 31, 2010

I cant find any tools that can generate the DDL for all objects in Postgressql to migrate to oracle, I did sql developer however does not support postgresql, does any tool that can migrate postgresql to Oracle?

View 3 Replies View Related

Performance Tuning :: Oracle Row Chaining And Migration

Nov 13, 2010

Recently i have been working analyzing Oracle Row Chaining and Migration in the database. Is their any way to track the chaining & migration of rows as part of database health checkup.

Else we have analyze the table for detecting row Chaining and Migration.

View 4 Replies View Related

Server Administration :: Migration Of Oracle From AIX To Solaris

Jan 4, 2013

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?

View 8 Replies View Related

Server Administration :: Migration Of Oracle Jobs

Nov 22, 2010

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?

View 6 Replies View Related

Performance Tuning :: Oracle Data Migration

Jun 7, 2011

We have a data migration scripts written for oracle. Data is not huge but we are observing that the migration is faster in the development labs but is 5x slower in the production site.

The development Oracle setup is on Windows and Production setup on Solaris. I have attached the AWR generated for a period where migration was run for 3 hours and stopped due to slow performance.

Here is my initial analysis.

1) The first timed events is the DB CPU. Hence I feel the migration scripts can be modified to run in parallel so that they can finish faster. However here the question arises why it should run faster in development env if this is an issue.
2) I tried increasing the
a.large_pool_size set to 512M
b.sga_max_size set to 8G
c.sga_target set to 8G
from 0, 4G and 4G respectively.

I have attached the AWR and below are the etc/system contents for solaris settings.

* Begin MDD root info (do not edit)
rootdev:/pseudo/md@0:0,1,blk
* End MDD root info (do not edit)
set noexec_user_stack=1
set noexec_user_stack_log=1
* IBMdpo vpath_START (do not remove)
* default SCSI timeout is 60 seconds
* uncomment to change SCSI timeout * set sd:sd_io_time=0x1e
forceload: drv/vpathdd
* IBMdpo vpath_END (do not remove)

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

P.S. The awr report is renamed to .txt from .html to be able to upload the file.

View 6 Replies View Related

Server Utilities :: Oracle Migration From 8 To 11gR2?

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

Data Migration From Oracle To SQL Server 2005

Oct 25, 2012

How to migrate Data from oracle to MS SQL Server or Vice Versa.

I came to know about 2 methods:

1) Using SQL Developer
2) USing ODBC.

View 2 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

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

Networking And Gateways :: Oracle 9i To Sql Server 2008 R2 Migration?

Apr 2, 2013

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

View 2 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

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

Forms :: Migration From Oracle 10g 32 Bit Windows To 11g Linux Platform

Oct 25, 2013

Migration of oracle forms 10g 32 bit windows platform to 11g 64bit Linux platform . I have about 500 fmb on my 10g environment which are currently working fine but when i go to compile it on 11g an error file is generated. All my path is set in proper manner .

I have a object library which has multiple tabs and every tab has its own object. While compiling, the forms are not inheriting the object values only few values from the object are considered.

View 5 Replies View Related

Oracle Standalone Database To (RAC) Real Application Cluster Migration

May 16, 2011

How to migrate Oracle Standalone Database to Oracle Real Application Cluster?

View 1 Replies View Related

Client Tools :: Migration From Windows Mssql To Linux Oracle

Dec 10, 2012

Env destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760

I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.

After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :

MD_COLUMNS
MD_GROUPS
etc...

View 10 Replies View Related







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