Re: Just a very simple question - ORA-01034

Thanks.

cpchan, Hong Kong 2003-04-11 12:43AM

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70389C44A_at_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 - 11:43:56 CDT