SQL> startup nomount pfile= E:oracletestdb9.2.0dbsinitTEST.ora SQL>@e:test.sqlBy doing this I created the control file. Then from Service Manager I opened the listener and Oracle service. But if I connect using SQL*Plus, it's giving me this error: "ORA-01033: ORACLE initialization or shutdown in progress." Please help me out.
alter database openThat should make the database available for general use.
Dig Deeper on Oracle error messages
Related Q&A from Mike Ault
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to... Continue Reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists. Continue Reading
I want to find the length of a numeric datatype field in my table. How can I find it? Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.