Just a very simple question - ORA-01034

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 10 Apr 2003 16:50:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70389C44A@lnewton.leeds.lfs.co.uk>

Afternoon,

telnet to the server and login as a member of the dba group.

Either :

svrmgrl
connect internal
startup
exit

or

sqlplus /nolog
/ as sysdba
startup
exit

Either will get you running but you'll have to have the dba group membership for the user you login to.

The second manner is best as svrmgrl and internal are no more at Oracle 9, so you are just as well getting used to it now :o)

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: cpchan [mailto:cpchaney_at_netvigator.com] Posted At: Thursday, April 10, 2003 4:13 PM Posted To: server
Conversation: Just a very simple question - ORA-01034 Subject: Just a very simple question - ORA-01034

The following problem is very simple for those experienced Oracle users :

(1) Basic configuration : Oracle 8i running on SUN Solaris 9, my PC :
Windows 98
(2) I ran this command for backup an Oracle database's data records only
:

        tar -cvf /dev/rmt/0 <the directory of the data record of the Oracle
database>
(3) And then ran this command for restore :

        tar -xvf /dev/rmt/0 <the same directory>
(4) Then I tried to login the Oracle through the SQL Plus on my Windows
98
machine and got the message : ORA-01034 : Oracle not available.
(5) Now, can you tell me how to start my Oracle 8i through SQL Plus
(either

Windows version or Telnet or on the UNIX machine directly )
(6) I think this command is very simple for those experienced ones but I
need the answer now, please give me instructions, thanks. Received on Thu Apr 10 2003 - 10:50:30 CDT