This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Apr 5, 2013 4:25 AM by 1001257 RSS

databas enot open; must use reset logs

1001257 Newbie
Currently Being Moderated

I am novice to pl/sql, can you please help with this problem

SQL> create table man(name varchar2(20));
create table man(name varchar2(20))
ERROR at line 1:
ORA-01109: database not open

SQL> shut immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

I dont know how to reset logs. I also dont know why it is saying database not open

Thank you.
1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points