SQL>conn sys/sys@orcle
ERROR:
ORA-28009:connection as SYS should be as SYSDBA or SYSOPER
SQL>conn sys/sys@orcl as sysdba
ERROR:
ORA-01031:insufficient privileges怎么办呢?
ERROR:
ORA-28009:connection as SYS should be as SYSDBA or SYSOPER
SQL>conn sys/sys@orcl as sysdba
ERROR:
ORA-01031:insufficient privileges怎么办呢?
redhat5conn test/test@orcl 可以通过
conn / @orcl 不能通过
conn / @orcl 不用指定实例名吧
好难
grant sysdba to sys;
SQL>conn sys/sys@orcle
ERROR:
ORA-28009:connection as SYS should be as SYSDBA or SYSOPER
SQL>conn sys/sys@orcl as sysdba
ERROR:
ORA-01031:insufficient privileges
$ORACLE_HOME/rdbms/lib/config.c
看看里面是什么
#definedSS_OPER_GRP "dba"
char *ss_dba_grp[]={SS_DBA_GRP,SS_OPER_GRP};
#define SS_OPER_GRP "dba"不是以上那样的话改成 上面那样 :wq 之后 relink all一下、
ERROR:
ORA-01031:insufficient privileges
=========================================
服务器本地登录 sys 的话,会转换为操作系统管理员(DBA 成员)。可能是你操作系统登录用户没有权限。
好像用户sys的SYSDBA没了,怎么搞过来呢?