ORA-01034 [message #66205] |
Tue, 29 January 2002 10:32 |
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 |
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
|
|
|