Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can not connect oracle database

eric tangApr 19 2023

I use oracle 12c , it is old , I will upgrade it soon.

I seems not sure which user have ora_dba permission , I tried this user “as” but got the below error.

Now , I can't access the oracle database , it seems the archiver log is full , I want to access the oracle database but I can not login it.

error

=====

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

Could you please suggest how can I fix the Archiver error ? I am new to oracle , how can I find which user have ora_dba permission ?

thanks

Added on Apr 19 2023

#database-installation, #general-database-discussions, #server

1 comment

527 views