Converting 32bit to 64bit /Oracle 8172

Hello Gerado,
At our site our machine was a new fresh install. We installed Solaris 2.8 64bit and Oracle 8172 64bit We have then received from our supplier a compressed database on tape. This database came from a tar of a cold copy of their system validation department.
They have Solaris 2.8 64bit and Oracle 8172 32bit installed on their machine.

So directories are not an issue.

So when I de-tar their 32 bit db it needs utlirp run on it. OK After having run that I had 51 invalid packages. Migation steps:
startup restrict
@utlirp
catalog,
catproc
shutdown immediate
startup
=>Packages invalid

I have read up on metalink and their was an issue with Java packages. I was wondering whether anyone had this problem/symptons previously Regards
Peter
-----Message d'origine-----
De : Molina, Gerardo [mailto:Gerardo.Molina_at_schwab.com] Envoyé : vendredi 1 février 2002 01:35
À : Multiple recipients of list ORACLE-L Objet : RE: Boom => Solaris 2.8 Oracle 8172 => Converting 32bit to 64bit

Can you tell us more on how you installed the 64-bit Oracle binaries?

Did you install them in a separate directory from 32-bit binaries?

Please list all the your migration steps (briefly) and then maybe we can help.

What you've given below seems incomplete.

One approach is to install 64-bit Oracle in a different directory.

I put together a short step-by-step which was for 8.1.6 on Solaris 2.7 but should also work for 8.1.7.2 on 2.8

Here it is:

Switching from 32-bit 8.1.6 to 64-bit 8.1.6     

Check to see if 64-bit is enabled:

-> isainfo -v

If 64-bit is enabled, you should see:

    64-bit sparcv9 applications

    32-bit sparc applications

NOTE: You can have Solaris 2.7 installed, but if 64-bit is not enabled, you will not be able to successfully install 64-bit Oracle. Check with your system administrator if you do not have 64-bit enabled.

NOTE: You should be at 8.1.6.0 32-bit Oracle before attempting the following procedure.

Shutdown database:

-> svrmgrl

    SVRMGR> connect internal

    SVRMGR> shutdown immediate

    SVRMGR> startup restrict

    SVRMGR> shutdown normal

Perform full off-line backup.

Install 64-bit Oracle

Modify /var/opt/oracle/oratab entry so that ORACLE_HOME points to 64-bit binaries

invoke oraenv

-> . oraenv

Verify that $ORACLE_HOME is pointing to 64-bit binaries.

-> echo $ORACLE_HOME

Create link for init.ora

-> cd $ORACLE_HOME/dbs

-> ln -s <location of initSID.ora> <initSID.ora>

Execute recompilation script

-> cd $ORACLE_HOME/rdbms/admin

-> svrmgrl

    SVRMGR> connect internal

   SVRMGR> startup restrict

    SVRMGR> spool catoutw.log

    SVRMGR> @utlirp.sql

    SVRMGR> spool off

    SVRMGR> alter system disable restricted session;

    SVRMGR> exit   

HTH
Gerardo

-----Original Message-----
Sent: Thursday, January 31, 2002 9:29 AM To: Multiple recipients of list ORACLE-L

Gday All,
I have a db delivered for the application Atlys. CVG have Solaris 2.8 64bit Oracle 8172 32 bit   I have Solaris 2.8 64bit Oracle 8172 64bit

At startup the database spat the following: ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-801: internal error [56319]

The conversion script
@utlirp + catalog, catproc have been run I have shutdown the database and then it wouldn't open. So I have placed _SYSTEM_TRIG_ENABLED=FALSE in the init.ora and it opens. The dictionary has 58 invalid packages + invalid java packages.

Has anyone ever gone thru this sort of a migration. Your comments are truly welcome
Regards
Peter

--
Peter Lomax (Oracle DBA)
Expertise Oracle
ORANGE/DSI/SIMBAD/AT&P
OrangeFrance
Bureau:
email:  peter.lomax_at_ftms.fr
tel:    (+33) (0)1 55 22 59 13
fax:    (+33) (0)1 55 22 39 69
Simbad sailing through UMTS.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: peter.lomax_at_ftms.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: peter.lomax_at_ftms.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).