dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Can't restart a database - Oracle Errors

This is a discussion on Can't restart a database - Oracle Errors ; Hi there, I am trying to shutdown and startup an Oracle 10g database thats running on XP Pro. I connect to oracle via SQLPlus with the following command, "Connect sys as as sysdba". I connect fine. Then I try to ...


Home > Database Forum > Oracle Database > Oracle Errors > Can't restart a database

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 08-09-2008, 06:04 AM
Database Newbie
 
Join Date: Aug 2008
Posts: 1
GavMan13 is on a distinguished road
Default Can't restart a database

Hi there,

I am trying to shutdown and startup an Oracle 10g database thats running on XP Pro.

I connect to oracle via SQLPlus with the following command, "Connect sys as as sysdba". I connect fine.

Then I try to used the shutdown immediate command and i get the following output:
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.



I then try and run the startup command and i receive the following output:
SQL> startup
ORACLE instance started.

Total System Global Area 373293056 bytes
Fixed Size 789288 bytes
Variable Size 187430104 bytes
Database Buffers 184549376 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-16038: log 1 sequence# 1039 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\ACUITY\TABLESPACES\REDO01.LOG'



This has me at a loss. I've tried a few solutions i've found on other sites but I can't resolve this.

Any thoughts?
Thanks in advance.
Reply With Quote
  #2  
Old 02-23-2010, 03:55 AM
Database Expert
 
Join Date: Feb 2010
Posts: 42
HENARRY JAYA is on a distinguished road
Default Re: Can't restart a database

The PS2 is worth no more than $20. so if you want to keep playing PS2 games, keep it because it is VERY difficult to find a backwards compatible PS3 since NONE of the new systems (the 120GB/250GB slims) play PS2 games.

as far as backwards compatibility goes, I have a much longer explanation that makes it perfectly clear as to which PS3s will and won't play PS2 games.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 09:31 AM.