Home » RDBMS Server » Networking and Gateways » ORA-01034
ORA-01034 [message #66205] Tue, 29 January 2002 10:32 Go to next message
Sharon Padgett
Messages: 1
Registered: January 2002
Junior Member
Enter user-name: internal
Connected to an idle instance.

SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available

I am new at this and I can't seem to find the problem.

Thanks
Re: ORA-01034 [message #66206 is a reply to message #66205] Tue, 29 January 2002 10:39 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
You need to first start the instance:

1. start server manager (svrmgrl)
2. connect internal
3. startup pfile=<init.ora file path>
4. Now run the select statement you were running

Balaji
Previous Topic: urgent .......ERROR: ORA-12545: TNS:name lookup failure
Next Topic: Re: Can't Install 8i Client on Pentium 4 , NT 4 machine workaround
Goto Forum:
  


Current Time: Wed Nov 27 16:15:47 CST 2024