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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
