"ORA-00257: archiver error" indicates some disk issue at your Oracle Database end. This is basically a DB side error your Database admin can help it easily.
- Please make sure your Oracle server has enough disk space or the disk volume used by archive has enough space.
- Also please check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in the initialization parameter archive_log_dest is set up properly for archiving.
@Jay This is our lab environment, we do not have a DBA for this. I also checked the url you provided, all the options requires you to login to sqlplus which is I am not able to with the same exact error as above.
A lab environment or Dev should NEVER be in archive log mode !!!
What version is your Oracle database maybe some old hacks could still work.
Do you have command line access to the oracle server.? If so can you locate the initxxx.ora or spfile? usually in $ORACLE_HOME\dbs and check your db name to ensure you log on the correct database Linux boxes usually have many databases.
Check if you can switch user to the user running the database process ! This should give you the oracle user
$ ps -ef | grep oracle or ps -ef | grep pmon
Run the below to set the correct variable from values you get from above