sqlplus as sysdb登入報ora-01017

darren__chan發表於2021-07-28

1.報錯資訊:

cnsh281177:t3fxqdb > sqlplus '/as sysdba'

 

SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 14 09:28:15 2021

 

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

ERROR:

ORA-01017: invalid username/password; logon denied

 

 

Enter user-name: ^C

 

2.修改config.c為正確屬組並重編譯:

cd $ORACLE_HOME/rdbms/lib

 

cp config.c config.c.bak

 

 

vi  config.c

.section .rodata.str1.4, "aMS",@progbits,1

 .align 4

.Ldba_string:     .string "dba"

.Loper_string:    .string "oinstall"

.Lasm_string:     .string ""

.Lbkp_string:     .string "dba"

.Ldgd_string:     .string "dba"

.Lkmt_string:     .string "dba"

 

 

 

#define SS_DBA_GRP "dba"

#define SS_OPER_GRP "oinstall"

#define SS_ASM_GRP ""

#define SS_BKP_GRP "dba"

#define SS_DGD_GRP "dba"

#define SS_KMT_GRP "dba"

 

 rm config.o

 make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/config.o

 relink all

 

 

 3.確認oracle二進位制檔案許可權

 ls -al /paic/stg/oracle/rdbms/12c/12.1.0.2.170418_p32667073/bin/oracle

 

 chown toracle:asmadmin /paic/stg/oracle/rdbms/12c/12.1.0.2.170418_p32667073/bin/oracle


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29863023/viewspace-2783933/,如需轉載,請註明出處,否則將追究法律責任。

相關文章