SYSOPER in ORACLE8I

From: <dimitri_labutin_at_my-deja.com>
Date: Fri, 19 Nov 1999 09:48:43 GMT
Message-ID: <8136dr$bhi$1@nnrp1.deja.com>

Hello

I wonder why I cannot open or even mount database when connected as
SYSOPER(Oracle 8I windows NT SP5). It works very well on Oracle 7, no
problem at all.

C:\>set oracle_sid=XX8I

C:\>sqlplus /NOLOG

SQL*Plus: Release 8.1.5.0.0 - Production on Thu Nov 18 15:57:36 1999

SQL> connect starter/xxx as SYSOPER
Connected to an idle instance.
SQL> STARTUP
PFILE=C:\WORK\DATABASE\XX8I_DB\INITXX8I.ORA ORACLE instance started.
ORA-01034: ORACLE not available

SQL> alter database mount
2 ;
alter database mount
*

ERROR at line 1:
ORA-01034: ORACLE not available

SQL>

I CAN startup database when connect as SYSDBA.

SQL> connect starter/xxx as SYSDBA
Connected to an idle instance.
SQL> STARTUP
PFILE=C:\WORK\DATABASE\XX8I_DB\INITXX8I.ORA ORACLE instance started.

Total System Global Area 30310348 bytes

Fixed Size                    65484 bytes
Variable Size              13787136 bytes
Database Buffers           16384000 bytes
Redo Buffers                  73728 bytes

Database mounted.
Database opened.
SQL>

Can anybody explain such strange behavior?

Cheers,
Dimitri

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 03:48:43 CST