ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier

ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier

After version change from 12101 to 12201 database, during startup got the following 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

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


1. Start the database in Upgrade Mode.

sqlplus / as sysdba
shu immediate
Startup upgrade

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 oracle_sid=ORCL

cd %ORACLE_HOME%\rdbms\admin

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

--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:


4. Shutdown and start the database again.

shutdown immediate;

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 )

Google photo

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

Twitter picture

You are commenting using your Twitter 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.