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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply