OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ORA-01034

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 03:29:30 CDT 2025