Help Needed Regarding Oracle Migration

From: Azhar Bilgrami (azhar_at_weblinx.com.pk)
Date: 12/31/03 

Date: 31 Dec 2003 01:21:14 -0800

Dear
Hi:
Hope to see u in good health.
I was surfing Internet for some Oracle resources, and I found that you are
a Guru in Oracle, so here Iam looking for some help, and following is my
set of Problem,

           " I want to migrate a database which is currently running
             Unix as Operating System and Oracle ver 6 as
             Database, it is also using oracle froms version 3 (text base)
as Front End"
Now here is what I want to do
           " I want to migrate that database from Oracle for Unix to
Oracle for Linux With retaining all the Forms, in other words all I want
is to change the Operating System!, nothing else, no change in Oracle or
Certainly no change is Forms"

    I read other discussion forums and gathered the
 following, i.e. the steps to migrate a Database from Unix to Linux.
 1. Export the database from source machine,i.e. Export all the Databse
 files using Oracle 7 Database Utility.
 2. Install Oracle 8i on Linux Machine and Import that Database into Oracle
 8i using Oracle 8i Database Utility.
 3. Just Copy the Source Files of Oracle forms 3.3 from Unix Machine and
 Paste then onto my Linux Machine.
 4. Recompile those files.
 5. The system is ready!.

 Now kindly correct me if iam wrong in these steps, also I have few
 questions in my mind.
 1. How to Export an database in Oracle 6 for Unix.
 2. How to Import an Database in Oracle 8i for Linux.
 3. How to recompile the Forms 3.3 Files.
 4. Do I have to follow the same directory structure as Unix, i.e. if the
 form files are located at /usr/oracle/home on UNIX then should I follow
 the same directory structure?

 Thanks for your help in Advance.
           Take care of ure self.
                            Azhar Bilgrami

Relevant Pages

  • RE: connect to oracle database as sysdba form windows
    ... Is the Unix user in the dba group? ... Is the Oracle server local on Unix but remote from Windows, or vice versa, ... Is the Windows user in the ORA_DBA group if it's local? ... the remote_password_file parameter on the database is the one to look at, ...
    (perl.dbi.users)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • Re: Lots of Oracle10g Audit Log Files, Created every one or two second(s)
    ... I think that kind of connect can only come from the Linux database ... processes owned by oracle and trying to match it with the pid in the ... And it would be dangerous as well -- the reason SYSDBA logins are ...
    (comp.databases.oracle.server)
  • Re: Lots of Oracle10g Audit Log Files, Created every one or two second(s)
    ... This looks like it is is a connect / as sysdba which is always audited. ... I think that kind of connect can only come from the Linux database ... processes owned by oracle and trying to match it with the pid in the ...
    (comp.databases.oracle.server)
  • Do Linux and UNUX jobs pay that well?
    ... Lead (Oracle 10g) THIS IS A FULL TIME POSITION ... Creates logical and physical database designs. ... oriented environment. ... Solaris and Linux environment 3rd level ...
    (alt.os.linux)