I am using oracle 11G
I have this the mentioned error in the subject title above when trying to log in using "sys as sysdba"
This error occurred as a result of attempting to connect sqlplus in order to restore DB in the new server.
I have created user "oracle" that is different than the owner of the source database from which the backup.
So I have took the time to change the ownership of the related oracle file system and changed the config.c values
to match the new created user.
The following is what I tried to check and fix accordingly. Here is the output:
$ echo $ORACLE_SID
TEST3
$ echo $ORACLE_HOME
/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3
$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oracle 232399441 Jul 13 2016 oracle
$ cat $ORACLE_HOME/rdbms/lib/config.c
/* $Header: config_ux.tmp 120.0 2005/10/13 10:30:15 ssuraj noship $ */
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
#define SS_DBA_GRP "oracle"
#define SS_OPER_GRP "oracle"
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};
$ echo $LD_LIBRARY_PATH
/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib:/usr/X11R6/lib:/usr/openwin/lib:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib:/usr/dt/lib:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/ctx/lib
$ echo $PATH
/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/perl/bin:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/perl/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oratest3/bin:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/bin:.:.
....But i am still getting the same error:
$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 18 12:54:08 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysdba
ERROR:
ORA-01031: insufficient privileges
Any idea what i am missing?