SYSOPER

[7280]

I have assigned a user the sysoper privilege in order to be able to shutdown and start oracle database but that user is getting : "ORA-01031: insufficient privileges"
This is what i'm doing:

aix-train> sqlplus '/ as sysdba'

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Sep 29 16:37:27 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> grant sysoper to ghaddart;

Grant succeeded.

SQL> show parameter remote_login

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> host ls -lart $ORACLE_HOME/dbs/orapw$ORACLE_SID
-rwSr----- 1 oracle dba 1536 Sep 29 16:37 /OraBin/product/8.1.7/dbs/orapwtrain

SQL> host date
Mon Sep 29 16:38:05 DFT 2003

SQL> conn ghaddart as sysoper
Enter password:
Connected.
SQL> shutdown immediate
ORA-01031: insufficient privileges

What's wrong? What did i forget?
I'm using oracle 8.1.7.4 on aix 4.3.3

 

[sem]

Did you restart database after those changes?

Regards, Dima