Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Newbie question(ORA-01034)
I have a slight problem. How do I open up a previous instance of a database. I have created a database and it worked fine but when I created another database, I could not log into the first one because it give me an Oracle not available error. (ORA-01034) The instance of the newely created database works fine. I get this error as well when I try to test it throuh Net8 administration assistant. I changed the SID_ORACLE in the registry as well as through DOS : SET ORACLE_SID=XXX Is there some setting somewhere that tell Oracle to ONLY start that one instance and no other ones?