1 Reply Latest reply: Jun 28, 2013 6:49 PM by Hussein Sawwan-Oracle RSS

    Migration of R12.1.3 from RHEL linux 32 bit to 64 bit.

    User517853-OC

      Hi

       

      My environment having RHEL 5.4 (32 bit) running R12.1.3 database 11.1.0.7.0

       

      Metalink ID : 471566.1

       

      I did the following steps on source system (32 bit)

       

      1. Exported all the OLAP workspaces.

      2. Remove OLAP from the 32bit database

      3. Compile invalid objects.

      4. Copy the database (.dbf) files from the source machine to the target machine

      5. Copy the database configuration files init.ora and ifilecbo.ora

       

      I did the following steps on target system (64 bit)

       

      1. Install database software 11.1.7.0

      2. Recreate the database control files

      3. As per ID : 802875.1, i checked and need to apply 20 patches.

      For that i applied patches

      p6880880_111000_Linux-x86-64.zip

      8833297

      After i applied patch : 8833297, in post installation steps, i have to run utlrp.sql.

      While running utlrp.sql, It hangs on 1718 invalid objects remaining to compile. In alert log,

       

      Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x7D406F5, ptg_tx()+617]

      Errors in file /sr12/d02/oracle/sr12/db/tech_st/11.1.0/admin/sr12_server/diag/rdbms/sr12/sr12/trace/sr12_j000_23785.trc  (incident=70887):

      ORA-07445: exception encountered: core dump [ptg_tx()+617] [SIGSEGV] [ADDR:0x0] [PC:0x7D406F5] [SI_KERNEL(general_protection)] []

      ORA-06553: PLS-707: unsupported construct or internal error [2603]

      ORA-06553: PLS-707: unsupported construct or internal error [2603]

      Incident details in: /sr12/d02/oracle/sr12/db/tech_st/11.1.0/admin/sr12_server/diag/rdbms/sr12/sr12/incident/incdir_70887/sr12_j000_23785_i70887.trc

      Wed Jun 26 11:08:04 2013

      Trace dumping is performing id=[cdmp_20130626110804]

      Wed Jun 26 11:08:06 2013

      Sweep Incident[70887]: completed

      Errors in file /sr12/d02/oracle/sr12/db/tech_st/11.1.0/admin/sr12_server/diag/rdbms/sr12/sr12/trace/sr12_j001_23803.trc  (incident=70975):

      ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

      Incident details in: /sr12/d02/oracle/sr12/db/tech_st/11.1.0/admin/sr12_server/diag/rdbms/sr12/sr12/incident/incdir_70975/sr12_j001_23803_i70975.trc

      Wed Jun 26 11:08:19 2013

      Trace dumping is performing id=[cdmp_20130626110819]

      Wed Jun 26 11:08:19 2013

      Sweep Incident[70975]: completed

      Errors in file /sr12/d02/oracle/sr12/db/tech_st/11.1.0/admin/sr12_server/diag/rdbms/sr12/sr12/trace/sr12_j001_23803.trc  (incident=70976):

       

      What could be reason for this issue.

       

      Any helpful answers would be appreciated.

       

      Thanks

      Guna