Migrating Database - Exp And Logminer

Jun 22, 2012

I have to migrate a 9i DATABASE from one platform (HP-UX V1 PARISC) to another platform (HP-UX V3 Itanium) and to upgrade it to 11Gr2. I know that multiple scenario exist (Ex:Exp/Imp,DataGuard,GoldenGate,Dblink/Direct Load,etc)

Scenario:

1-Activate force logging and suplemental logging in the source database.
2-Export the source database SCHEMA in consistent mode and import them in the 11gr2 database.
3-Record the scn of le last user transaction applied before the export.
4-Use LOGMINER to capture all the transaction applied after the export.
5-Stop the source database, applie the captured transaction by logminer and then switch the user to the new database.

I thought that the down time will be minimal, it will take only the time of reapplication the committed transaction captured by logminer.

It's feasible to do that or logminer have some limitation ? It's recomended or difficult to do that ?

PS: I'm not familiar with oracle LOGMINER

View 1 Replies


ADVERTISEMENT

Migrating From One Database To Another (Table Structures Slightly Changed)

Aug 20, 2008

We have a requirement where we need to migrate data from a legacy system (Oracle 10g) to our database (Oracle 10g again).

The thing is that the table structures will be slightly different between the two. Our current structure has some fields added/removed as well as some tables added/removed. But by and large the databases would be similar (about 75%).

While migrating I would need to map the fields in the source and destination manually. I would also need to populate some data to the fields that have been newly added.

Is there any way to do this? I was checking out Oracle SQL developer but could not proceed much.

View 4 Replies View Related

JDeveloper, Java & XML :: Migrating Database From Oracle 9i To 10g - Parsing Failed

May 2, 2011

We are in process of Migrating our database from Oracle 9i to Oracle 10g.

I am getting below error while parsing XML in 10g.

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//soap:Envelope/soap:Header/coHeader/company/text()'

Same code works fine in Oracle 9i database with same XML. Is there any difference in XML TYPE functionality in Oracle 9i and 10g?

View 4 Replies View Related

Export/Import/SQL Loader :: Migrating Data From Solid Database To Oracle - Flat Files

Aug 14, 2012

I am migrating data from a Solid Database to Oracle, I am using Flat Files to do that.

1.- I download the data to flat files from Solid
2.- I move the files to Oracle server
3.- I upload the data to Oracle

Now, I have done the 90% of the data base, but I have found some tables that has description columns and in this description the users writes enters, so when I try to upload the data to Oracle SQL loader cannot recognize this characters.

Example:

'25','0.','5.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'26','0.','2.','0.','0.','0.','0.','3.','0.','0.','0.','0.','0.','',''
'27','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'28','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'29','0.','38.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'30','0.','13.','0.','0.','0.','0.','0.','6.','0.','6.','0.','0.','|SE RECHAZA B20CS50SNW ^M
^M
SE RECHAZAN CINCO PZAS ^M
DOS MOD. HSC15I41EH,DOS MOD. HSK15I41EH |Agregó: 06/06/2009 12:22:50
|','DEV. A PROV.'
'31','0.','50.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'32','0.','9.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'33','0.','2.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''

How can I solve this ?

View 3 Replies View Related

Security :: Logminer And Password Change?

Oct 15, 2010

Is it possible to track the password changes made by some user using the logminer with the archived logs?

View 1 Replies View Related

Security :: Error At Adding Logfile In Logminer Process?

Aug 20, 2010

1): In logminer logfile analyzing, I had added all the online redo log files in the below procedure:
EXECUTE dbms_logmnr.add_logfile(.....
Options => dbms_logmnr.addfile).

Then
2):I mentioned 3 days at the STARTTIME & ENDTIME in the procedure of LOGMNR.START_LOGMNR(...)

But it shows the below error msg:Ora-01291: missing logfile.

View 2 Replies View Related

Server Administration :: Significance / Removal Of Logminer Dictionary File

Feb 12, 2011

There is a offline_dictionary.ir file created by Logminer which is like 13G in our "DIAG" directory. What is the significance of this file and can it be removed?

I tried to search about this file, but couldn't get much on this. This is what I got from metalink doc id 755838.1

Quote:2. HM_CREATE_OFFLINE_DICTIONARY

The job is created by the 11g script catmwin.sql which mentions that this is a job for creation of offline dictionary for Database Repair Advisor.

From unpublished Note 602459.1 - 'What Is OFFLINE_DICTIONARY': 'The system job SYS.HM_CREATE_OFFLINE_DICTIONARY executes the dbms_hm.create_offline_dictionary package which creates a LogMiner offline dictionary in the ADR for DRA name translation service. The job for generating the logminer dictionary is scheduled during the maintenance window. This job can be disabled. '

View 3 Replies View Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related

Migrating To SQL?

Apr 15, 2007

I have been working on Oracle for the past 1 year and using it as a backend for my project. We are planning to move to SQL2005. I have never done this before and i;m keen on learning and understnding the proccess to have a smooth migration. if there some tools that do this.

View 1 Replies View Related

Forms :: Migrating From 6i To 10G Or 11i

Mar 8, 2013

I am currently posted in a project where the application is using Forms 6i as front end and Oracle 10g as a backend. The basic requirement of the project is to migrate the froms from 6i to 10g (or) 11i.

whether there are any tools available in the market for migrating from forms 6i to 10g, if it is then how effective the tool will be. i.e. how much manual intervention we need and what are the common problems we will face during migration.

View 1 Replies View Related

Forms :: Migrating 6i To 10g?

May 23, 2013

While migrating Forms 6i to 10g i have come across one unique behavior

1. In Forms 6i- Suppose we have a text item of datatype char and length 5.
Now copy a text of 10 characters 1234567890 and paste it in the text box and it will automatically trim and take
1st 5 characters(12345) and show in text box.

2. In Forms 10g- Suppose we have a text item of datatype char and length 5.
Now copy a text of 10 characters 1234567890 and paste it in the text box and it nothing happens. Character length
is more than 5 then it does nothing.

I need to implement the 6i behavior in 10g.(apart from validation trigger).

View 4 Replies View Related

Forms :: Migrating From 6i To 10g?

Jun 2, 2009

We have a large application consisting of almost 100 forms(forms 6i). We need to convert it into 10g. Keeping in mind that this is our first exposure to such migration

View 11 Replies View Related

Migrating To Newer System

Dec 21, 2011

My manager has a couple of 2-proc dual-core Opteron servers with 8GB of RAM and RAID controllers. These servers currently run Solaris 8, but he wants to migrate them to a newer Linux systems.

View 4 Replies View Related

Forms :: Migrating 6i Into Oracle 11g?

Jan 31, 2012

It is possible to migrating oracle(Forms& Reports) 6i into Oracle 11g?

View 2 Replies View Related

Server Utilities :: Migrating From 10g To 11g?

May 31, 2012

For migrating the database version 10.2.0.3 on Windows to version 11.2.0.3 on Linux i am using the transportable tablespace option.After the import of metadata and copy of tablespace datafiles to destination the sequences and functions are not available. Does it work if i later export and import the sequences and functions separately ?

View 1 Replies View Related

Server Administration :: Migrating Oracle 9i To 10g?

Feb 23, 2011

I'm trying to migrate an Oracle Enterprise Server database v9.2.0.1.0 deployed on Windows 2000 Server 32-bit to v10.2.0.5.0 on Windows 2008 R2 64-bit.Basically, I'm following instructions provided by this document:[URL],,,

1) Updated v9.2.0.1.0 to v9.2.0.6.0 on the old server
2) Backed up the database as follow:
SQLPLUS /NOLOG
CONNECT / AS SYSDBA
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
SHUTDOWN IMMEDIATE;

3) Installed Oracle Enterprise Server 10.2.0.4 on the new server and updated to v10.2.0.5

4) Copied trace files, data files, control files, archive logs and init.ora to the new server. Redo logs have been not copied since the ARCHIVELOGMODE is enabled on the old server.

5) Created an Oracle service on the new server as follow:

[code]....

Database dismounted.
ORACLE instance shut down.
SQL> STARTUP NOMOUNT
ORACLE instance started.

[code]..\

View 5 Replies View Related

Server Utilities :: Migrating Using Transportable Tablespace?

Jun 3, 2012

I am using transportable tablespace to migrate from 10g to 11g from Windows to Linux System.

The steps are as follow On 10g make the tablespace read only mode and export the metadata information and copy the tablespace datafiles to the 11g server. Now on 11g when i am importing the exported metadata it says that the user does not exist and if i create the user and tablespace it does not work as it says tablespace already exist.

For transportable tablespace do i have to create the user already on 11g ? If yes then i also need to create the tablespace which i need to assign to the user.

View 2 Replies View Related

Forms :: Migrating From Oracle 8i To 10g - Update Required?

Jul 1, 2010

I am using oracle 8i (8.1.7) with forms 5 and reports 3 on a windows 2000 platform. Now I want to migrate from 8i to 10 g. Will the applications in form 5 and reports 3 work or should I have to upgrade the forms and reports as well.

View 4 Replies View Related

Migrating MySQL Queries To Oracle (sqlplus)

Jun 10, 2010

I am migrating MySQL query's to oracle (sqlplus). Tell me what is the below code doing and equivalent for this code in oracle.

declare @start_date datetime
select @start_date='$first_date'
declare @end_date datetime
select @end_date='$end_date'
This is followed by
select distinct ' ', column from my_table;

I tried a lot of ways (set @start_date etc)but nothing really works.

View 6 Replies View Related

Reported When Migrating Oracle 11g From Solaris To Linux?

Oct 25, 2013

What are reported issues when migratin Oracle 11g from Solairs to Linux? 

View 1 Replies View Related

Forms :: Migrating From Oracle 8i To 10g - How To Get Result In Ascending Order

Aug 31, 2010

I have migrated from Oracle 8i (8.1.7) to Oracle 10g, but when I execute a query in 8i without any order by clause, I get a result in ascending order. The same query when executed in 10g gives a result which is not ordered. How to get an order result in 10g. There are many forms and reports which use lov which are not ordered. Can I set the ordering at the database, so that I do not have to alter all the forms and reports.

I have also migrated my forms from 5 to 6, but the combo box in some forms in 6i do not appear at run time. How I can solve this problem. I have attached an forms5 .fmb file/.

View 7 Replies View Related

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Server Administration :: Access Redo Generation After Migrating From 9.2.0 To 10.2.0.4

Sep 14, 2010

We had our production database hosted on Oracle 9.2.0. Few months back we have migrated it to Oracle 10.2.0.4.0. After Migration I have noticed that redo generation has become very very high. In earlier case no. of log files generating in production hours were around 30 where as after migration it become around 200 files per day. I have run statspack report on this database. Report is saying that db block change & disk write is become very high. Parameter timed_statistics has also been set to FALSE. Even then there is not any reduction on no. of log file generation. I had used import export for upgrading the databases.

View 13 Replies View Related

Application Express :: Error When Migrating Supporting Objects

Nov 16, 2012

We're migrating our first APEX application from one server to another. The export and import are done, but we're having problems with supporting objects (we get a login prompt but no images). Okay, so I figured out how to get the supporting objects into a script.

When I run it I get:

declare
*
ERROR at line 1:
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_040100.WWV_FLOW_IMAGE_API", line 12
ORA-06512: at "APEX_040100.WWV_FLOW_IMAGE_API", line 32
ORA-06512: at "APEX_040100.WWV_FLOW_API", line 10508
ORA-06512: at line 6

connecting as the parsing_schema user to run the script. I did that but still get the same error.

View 2 Replies View Related

Globalization :: Migrating Character Data Using A Full Export And Import

Jul 23, 2013

I have a database in my local machine that doesn't support Turkish characters. My NLS_CHARACTERSET is WE8ISO8859P1, It must be changed to WE8ISO8859P9 , since it supports full Turkish characters. I would like to migrate character data using a full export and import and my strategy is as follows:

1- create a full export to a location in network,

2- create a new database in local machine that it's NLS_CHARACTERSET is WE8ISO8859P9 (I would like to change NLS_LANGUAGE and NLS_TERRITORY by the way)

3- and implement full import to newly created database. I 've implemented first step, but I couldn't implement the second step. I 've created the second step by using toad editor by clicking Create -> New Database but I can not connect the new database. I must connect new database in order to perform full import.

DetailsNLS_LANGUAGE.....................AMERICANNLS_TERRITORY.....................AMERICANLS_CURRENCY..

View 8 Replies View Related

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

Reports & Discoverer :: Generating Dos Reports In 10g While Migrating 6i To 10g?

May 14, 2013

i am migrating 6i to 10g forms and reports.while migrating i am facing a problem with reports only.

i am trying to call reports from menu itself but it is not working fine..so, i'm using intermediate form to call report.

i am calling dos report which actually generate an output in a '.lst ' file,i don't know how to generate it in oracle 10g...

View 12 Replies View Related

Forms :: Migrating 6i With 11i Template To R12 Template

Apr 20, 2010

We have many customized forms built on 6i (11i Template) and deployed to EBS 11i, We want to Upgrade to R12, what shall i do with the customized form which already applied to 11i Template ?I know i have to migrate 6i to 10g then deploy, but my problem in the Template, shall i remove 11i Template and apply R12 Template from the beggining?

View 4 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related







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