sqlplus as sysdba无法登陆的情况

常规情况：

$ORACLE_HOME/network/admin/sqlnet.ora

在linux下

#sqlnet.authentication_services=(beq, kerberos5)

需要注释该行

 

在windows

sqlnet.authentication_services=(NTS)

需要设置为NTS，受windows的系统用户、域用户影响，改密码会失效，重启恢复

 

 

特殊情况，这个ORACLE_HOME是直接拷贝其他地方的

cd /home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/lib

[oracle@NZXPVL-JGBX-D01 lib]$ cat config.c

 

/*  SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access.  */

/*  Refer to the Installation and User's Guide for further information.  */

 

/* IMPORTANT: this file needs to be in sync with

              rdbms/src/server/osds/config.c, specifically regarding the

              number of elements in the ss_dba_grp array.

 */

 

#define SS_DBA_GRP "dba"

#define SS_OPER_GRP "oinstall"

#define SS_ASM_GRP ""

 

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP};  

[oracle@NZXPVL-JGBX-D01 lib]$ pwd

/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/lib

 

 

系统认证的组为SS_OPER_GRP，你要保证oracle用户有该组

修改组的话，需要做relink