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
2. Set the oracle home to new upgraded version and fire the following command:
--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.
5. Verify the component is updated.
select comp_name,version from dba_registry where status = 'VALID';