972576 wrote:This error simply means that the archive log destination ran full. In simple terms, all transactions are recorded in the redo log files. When a redo log is full, a copy is made of these transactions and written to the archive log. This provides for backup and recovery - where you can restore a hot database backup of a few days ago and use these backed up transactions to replay and get the database back to a consistent state as it was when the database was lost.
The SDE service, Oracle database, and all services associated with all clients were working up until I started getting the ORA-00257 archiver error when trying to open the database from Oracle SQL Developer earlier this month.
Once I was back in we started getting the ORA-01033 “Oracle initialization or shutdown in progress” and I haven’t seen the archiver error since.Have you confirmed that the database is actually up?
What kind of changes would need to be made to the database to create these problems?None so far IMO. I have not seen anything posted that points to this being a database problem. Assuming the database is up and running, the ORA-1033 error that the client is running into, points to the client's connection being unsuccessful in joining a working and available database. Which would seem that the client is doing something funky and wrong.
joeller wrote:Good to hear the problem has been identified and addressed.
John successfully deleted the Archive log and ran a backup. The database successfully started. All connections through the clients were successful.
BTW I have another thread going on about the failure of the OEM database control. It is located at weird window on starting OEMI'm also a CLI kind-of-guy. Most of my db servers are one or two ssh hops away, so using a OEM not a feasible option. I have used OEM just a handful of times through the years and am very much a newbie when it comes resolving OEM problems and issues. Sorry.
No one seems to want anything to do with it. (Possibly because they frown upon the use of the GUI?) Do you think you could take a look at it?