Hi All,
While connecting as SYS user through TNS Alias, I get "ORA-01031: insufficient privileges" error, when I issue give "sqlplus / as sysdba", it works fine.
[oracle@rac2 admin]$ sqlplus sys@testdb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 1 18:11:44 2020
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
When I connect to other users through TNS Alias, it works fine,I face this issue only with SYS account. I get this issue in SQL Developer as well only for SYS user, here I'm using the BASIC connect method, giving the host name, port and SID, not through TNS Alias, still get the "ORA-01031" error.
[oracle@rac2 admin]$ sqlplus test/test@testdb
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 1 18:15:07 2020
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
TEST@testdb >
In Linux, the "oracle" user is already a part of "dba" group, could you please let me know, what could be the issue and what I'm missing? Thank you so much!!
[oracle@rac2 etc]$ groups
oinstall dba asmdba asmadmin
[oracle@rac2 etc]$ id
uid=500(oracle) gid=501(oinstall) groups=500(dba),501(oinstall),502(asmdba),503(asmadmin)