ORA-01031 connecting as sysoper.
Hi,
Im using oracle 10g on AIX 5.3, I have created admin user (os level) & added it to oper group
also created admin db level user & granted sysoper privileges,
I'm running dbstartup & dbshutdown script to startup & shutdown the databases through admin user
but while connecting admin user as sysoper it shows ORA-01031 insufficient privileges
details are as follows:
admin@mumsa001212:/home/admin> id
uid=224(admin) gid=205(oper)
12:46:59 SYS:INTBPO > select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
ADMIN FALSE TRUE
admin@mumsa001212:/home/admin> export ORACLE_SID=INTO
admin@mumsa001212:/home/admin>
admin@mumsa001212:/home/admin>
admin@mumsa001212:/home/admin>
admin@mumsa001212:/home/admin> sqlplus "admin/iO987 as sysoper"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 6 12:52:28 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
On Oracle 11g & im able to connect but oracle 10g it is showing ORA-01031.