Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Problem Resolved, Here's what I did...
For those interested here is what I did to resolve this problem. First, there was the suggestion of using the Server Manager, but I do not have this installed on my system and the box I am using is stand-alone. What I had to do is as follows:
Start Oracle
Start SQLPlus
Disconnect
Connect as sys/oracle as sysdba
shutdown
startup mount
alter database archivelog
-- ++++++++++ Gary Gealy Sarasota, FL The next thing I say will be true. The last thing I said was false. Gary M. Gealy <gsquared_at_home.com> wrote in message news:PwlX4.18134$a36.301589_at_news1.rdc1.fl.home.com...Received on Fri May 26 2000 - 00:00:00 CDT
> I am using Oracle8i Personal Edition Release 8.1.5.0.0 - Productionon on
a
> Win98 machine and would like to turn on redo log archiving on. I have
> uncommented the appropriate lines in init.ora, but I am having trouble
> getting the database exclusively mounted so that I can issue the command:
> Alter database archivelog. Here is my secession from SQL*Plus What am I
> forgetting to do or doing wrong???
>
> I am initially logging in as 'sys' and here is the output from SQL*Plus
for
> the rest of the secession.
>
> ************************
> Connected to:
> Oracle8i Personal Edition
> With the Java option
> PL/SQL Release 8.1.5.0.0
>
> SQL> disconnect
> Disconnected from Oracle8
> With the Java option
> PL/SQL Release 8.1.5.0.0
> SQL> shutdown
> Not connected
> Database closed.
> Not connected
> Database dismounted.
> ORA-01012: not logged on
> SQL> connect sys/sys
> connected.
> SQL> startup mount exclusive
> ORA-01031: insufficient privileges
> ****************************
>
> I am using the standard "sys" login that is setup at install time. I
tried
> to give the "sys" login SYSOPER and SYSDBA privalges from the Oracle 8i
> Navigator, but I was also getting error message ORA-01031 insufficient
> priviliges.
> --
> ++++++++++
> Gary Gealy
> Sarasota, FL
>
> The next thing I say will be true.
> The last thing I said was false.
>
>
![]() |
![]() |