Re: Just a very simple question - ORA-01034

Hi,

The solution is to telnet to Solaris and to open Server Manager. You have to login as the oracle user in Solaris and run svrmgrl. The output from our Linux server here is this, but this is the same as with Solaris ***
oracle_at_salonika:~$ svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
***
and the database should be mounted and open. Then, you are done.

Of course, to follow the procedure above, you must know the password for the oracle account in Solaris. I use Windows 2000 here to connect to Oracle in our Linux server, but the Windows Oracle client does not seem to have Server Manager, so you must use the one in Solaris.

Thanks,
Vasilis

cpchan wrote:
>
> 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 Fri Apr 11 2003 - 09:50:59 CEST