Database Administration (MOSC)

MOSC Banner

ORA-00604 at Startup

edited Apr 30, 2019 7:57AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi,

On 12c on Linux red hat when startup:

SQL> startup

ORACLE instance started.

Total System Global Area 1610612736 bytes

Fixed Size                  2924928 bytes

Variable Size             436211328 bytes

Database Buffers         1157627904 bytes

Redo Buffers               13848576 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 1

ORA-01406: fetched column value was truncated

the solutions I saw on google :

like:

https://stackoverflow.com/questions/30478070/how-to-solve-sql-error-ora-00604-error-occurred-at-recursive-sql-level-1

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:4018285967344

need to be able to connect. But Database can not even be started.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center