Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: Migration from oracle 8.1.6 to 9.0.1.1

    hi all,
    we are trying to upgrade oracle 8.1.6 to oracle 9.0.1.1 on solaris 8 using oracle database migration assistant (odma)

    During the process of migration ,i.e while running odma,
    after few minutes we r getting error:

    'ORA-01034: ORACLE not available.'

    Then we found the "odma" is shutting down the db with 'immediate' option but unable to startup automatically.

    we attempt to startup the database manully while "odma" is running.
    it we are getting the same error ..as it is restarting the db several times.

    Can anyone please suggest to resolve this.

    Thanks & Regards,
    Sridhar

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Why are you upgrading to an outdated, unsupported version of Oracle? At least consider 9.2.

    The error makes me think you're on Windows. Is the Windows thread space initialized / is the Windows service started?

    Sometimes you will get this error if the registry key for the pfile has extra quotes (two single quotes is a bad thing) or hidden characters. Under the hive for your Oracle Home (the one used to start database, not the one used by odma) check the value of ORA_<SID>_PFILE. I would delete the value and rekey it.

    When you attempt to start the database make sure you are using the Oracle Home that owns the database, not the new 901 Oracle Home until you get to the appropriate step in the upgrade process. Otherwisee the registry keys won't be available to you.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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