Error faced while Database Cloning from 64 bit to 32 bit version

Few days back, I faced this issue when I was performing a task of cloning from Higher Version to Lower Version.

I was cloning a production database which runs on 64 bit platform to a 32 bit platform. Cloning completed successfully without any error. But i found 2 issues

1. First , When I tired logging into the cloned database as non sys user Credentials , I faced some error.

2. When i tried to do ALTER TABLESPACE TEMP ADD TEMPFILE i encountered the below error

ORA-00604: error occurred at recursive SQL level 1

ORA-06553: PLS-801: internal error [56319]

Solution:

Whenever you change the platform between 32 bit and 64 bit you should run the script ‘utlirp.sql’ which is located in (Oracle_Home/rdbms/admin  directory)

For this, you need to open your database in ‘Upgrade’ Mode .

Follow Below steps.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade;                                                  //open in Upgrade Mode

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 155190164 bytes

Database Buffers 373293056 bytes

Redo Buffers 5844992 bytes

Database mounted.

Database opened.

SQL> @/$ORACLE_HOME/RDBMS/ADMIN/utlirp.sql

SQL> shutdown immediate;

SQL> startup;

Database was back again, to normal operations :)