Posts

Showing posts with the label ORACLE

Oracle database not starting

I have an Oracle database(Oracle 9.2.0.1.0) running on RedHat Linux 7.2. The server has 1GB ram. The service was running in Archivelog mode.Service is set to autostart. Recently I found on restarting the server the listener started by the service did not. I started the service using STARTUP MOUNT and using ALTER DATABASE I stopped the archivelogs. I have posted my next few commands, kindly help me.... SQL> startup mount ORACLE instance started. Total System Global Area  426316116 bytes Fixed Size                  450900 bytes Variable Size            268435456 bytes Database Buffers          157286400 bytes Redo Buffers                143360 bytes Database mounted. SQL> alter database open resetlogs; alter database open resetlogs *