DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle apps 11 using 8i database

  1. 02-03-2010, 10:21 PM #1
    hanselrl
    hanselrl is offline Junior Member
    Join Date
    Mar 2001
    Posts
    41

    Oracle apps 11 using 8i database

    Hello people,

    Can someone help me or enlighten me with these?

    I have an existing apps 11 using 8.0.5 database. I want to upgrade the existing database to 8i to use the partitioning option of it. I have read this "Interoperability Notes Oracle Applications Release 11.0 with Release 8.1.7 [ID 148902.1" showing how to upgrade the existing database to 8i. Is this the only way? Can I just export the 8.0.5 then import it on 8i?

    thanks
    hanselrl
    Reply With Quote Reply With Quote
  2. 02-04-2010, 06:02 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by hanselrl View Post
    ...showing how to upgrade the existing database to 8i. Is this the only way?
    A proper upgrade requires to upgrade.

    Quote Originally Posted by hanselrl View Post
    Can I just export the 8.0.5 then import it on 8i?
    Provided you pre-create target database on Ora8i, yes - you can rely on exp/imp to move metadata, data and code; this is more of a migration rather than an upgrade.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 02-04-2010, 08:21 PM #3
    hanselrl
    hanselrl is offline Junior Member
    Join Date
    Mar 2001
    Posts
    41
    Quote Originally Posted by PAVB View Post
    A proper upgrade requires to upgrade.


    Provided you pre-create target database on Ora8i, yes - you can rely on exp/imp to move metadata, data and code; this is more of a migration rather than an upgrade.
    Is there any other things to consider or to be done after the export/import? If I will use the same database name do i need to configure it on the apps side?

    Thanks for the reply

    hanselrl
    Reply With Quote Reply With Quote
  4. 02-05-2010, 09:43 AM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by hanselrl View Post
    If I will use the same database name do i need to configure it on the apps side?
    TNSNAMES.ora changes may be needed.
    Will DNS -or IP address- and port remain the same?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  5. 02-07-2010, 11:21 PM #5
    hanselrl
    hanselrl is offline Junior Member
    Join Date
    Mar 2001
    Posts
    41
    Quote Originally Posted by PAVB View Post
    TNSNAMES.ora changes may be needed.
    Will DNS -or IP address- and port remain the same?
    IP and port will not changed. On the apps server, do I need to configure anything? Please check step below if its correct.
    1. Install Oracle 8i
    2. Create 8i database
    3. export oracle 8 database
    4. import oracle 8 to oracle 8i database
    5. what's next?

    thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width