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';