Home » Infrastructure » Unix » migrate 81600 to 9203 on hpux 11.11
migrate 81600 to 9203 on hpux 11.11 [message #97949] Tue, 08 July 2003 08:50 Go to next message
Ambrose Oberdorf
Messages: 3
Registered: October 2001
Junior Member
I have an Oracle 81600 (32 bit) database on HPUX 11.11 server. Trying to upgrade to 9.2.0.3 (64 bit). Oracle documentation says this can be done indirectly with an intermediate upgrade to 817 then 9203. So, I installed a home with 81700 (32 bit) and a home with 9201 (64 bit) then applied 9203 (64 bit) to the 9201 home. I added 100MB to the system tablespace, increased the size of the rollback segments and enlarged the next_extent of the system rolllback to 1M,
changed init.ora parameters as instructed (200M shared pool, job_queue_processes = 0, aq_tm_processes = 0, removed job_queue_interval. I am not the unix admin, but he has assured me that all the recommended unix patches have been applied, and the kernel parameters increased to recommended or better. The 81700 upgrade works fine, then I tried the 9203 upgrade.
I "sqlplus /nolog" then "connect / as sysdba" then
"startup migrate". Each insert,update,delete takes an ORA-600 [[17069]] (cannot pin something in memory) waits 5 minutes (50 attempts) then tells me the count of rows affected and commits. Finally kills itself when it cannot access STANDARD package in utlip.sql. Anyone else see anything like this?
I can start one session as startup migrate, then start another session and actually run the u0801070.sql migrate script successfully. Also, can STARTUP MIGRATE run utlip.sql, take the STANDARD not accessible error, then run u0801070.sql successfully.
Extremely weird, but Oracle doesn't seem to have a clue.
Re: migrate 81600 to 9203 on hpux 11.11 [message #97950 is a reply to message #97949] Tue, 08 July 2003 10:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
from 8.1.6 you directly upgrade to 9i.
Use ODMA .
or just export and import!!
it works...we do this every week( in fact this process is automated)!!!.
(for our ERP upgrade, we do the upgrade of 8.0.5 in HP
to 9.2.0 in sun RAC's )

Re: migrate 81600 to 9203 on hpux 11.11 [message #97952 is a reply to message #97950] Thu, 10 July 2003 10:09 Go to previous messageGo to next message
ambrose
Messages: 2
Registered: December 1999
Junior Member
Oracle received the answer to my specific problem from another customer. You cannot have "set serveroutput on" set when you do a migration, at least on HPUX 11.11 going from 8.1.7 to 9.2.0.3.
Don't know anything about Sun or others.
Re: migrate 81600 to 9203 on hpux 11.11 [message #98282 is a reply to message #97952] Fri, 18 June 2004 23:56 Go to previous message
Subhasini
Messages: 2
Registered: June 2004
Junior Member
Hi!

I am looking for an upgrade of existing 8i database to 9i and the requirement is to do this upgrade in the Installshield along with my Product upgrade (as a silent database upgrade). Please suggest the best approach to do this out of the below 3:

1. Using export/import of dump from 8i to 9i.
- How can I verify if the silent upgrade was successful?
- Is there any data/schema comparison to be done to verify this?

2. Using ODMA
- Can I supress the wizard that comes up? Since the upgrade should happen in the background, the screen for ODMA should be supressed.
- What exactly happens during ODMA? Do we need to verify / compare the data in this case too?

3. Startup Migrate
- Can someone explain what this process actually does?
- Will there be a separate 9i DB created in this case also? How different is this process from the import/export process?
- What is the verification required in this case to confirm successful migration.

Thanks in advance for your help!

regards,
Subhasini.
Previous Topic: Intermittent Async I/O issues on AIX and Oracle 8i
Next Topic: Internal or external disk for the Oracle binaries
Goto Forum:
  


Current Time: Fri Mar 29 09:03:57 CDT 2024