ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier

ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier

After version change from 12101 to 12201 database, during startup got the following error:
Error

ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "ACDRROWTSINTCOL#": invalid identifier

Cause
If we change the version of the database, we must need to upgrade the database date dictionary with catupgrde.sql

Solution

1. Start the database in Upgrade Mode.

sqlplus / as sysdba
shu immediate
Startup upgrade
exit

2. Set the oracle home to new upgraded version and fire the following command:

SET ORACLE_HOME=C:\oracle\12.2.0\dbhome_1
SET PATH=%ORACLE_HOME%\bin;%PATH%
set oracle_sid=ORCL
SET PATH=%ORACLE_HOME%\perl\bin;%PATH%

cd %ORACLE_HOME%\rdbms\admin

--Simple run the command
perl catctl.pl -n 4 catupgrd.sql

OR
--Specefiy the log location with command(make sure folder is available)
perl catctl.pl –n 4 –l E:\upgradelogs catupgrd.sql

3. Compile all the objects:

@?/rdbms/admin/utlrp.sql

4. Shutdown and start the database again.

shutdown immediate;
startup;

5. Verify the component is updated.

select comp_name,version from dba_registry where status = 'VALID';

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.