Malcolm's Tech Tips

Run the “catexp.sql” as SYS. The file is located in $ORACLE_HOME/rdbms/admin.

SQL> @?/rdbms/admin/catexp.sql

Moving a database to a new oracle home, owned by a different user and running a newer version.

NOTE : This is how is worked in my environment. It might not work the same in your environment. This is meant as a guide only.

Check what character set you are using at the moment.
SQL> select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’;

Shutdown the database.
SQL> shutdown immediate;

Startup in mount mode.
SQL> startup mount;

Restrict the database.
SQL> alter system enable restricted session;

Check the current job_queue_processes setting.
SQL> show parameter job_queue_processes;

Set it to 0 for now.
SQL> alter system set job_queue_processes=0;

Open the database.
SQL> alter database open;

Change the character [...]