联系：手机(17813235971) QQ(107644445)
链接：http://www.xifenfei.com/5965.html
作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
有朋友找到我，说他对生产库做了误操作，导致数据库异常，请我帮忙处理,对/u01目录修改了用户和权限,导致数据库无法登录,但是业务还在继续
误操作命令
mkdir -p /u01/app/grid mkdir -p /u01/app/11.2.0/grid chown -R grid:oinstall /u01 mkdir -p /u01/app/oracle chown oracle:oinstall /u01/app/oracle chmod -R 775 /u01
尝试sqlplus登录数据库报ORA-12547
[oracle@www.xifenfei.com admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 1 17:40:42 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact Enter user-name: ERROR: ORA-12547: TNS:lost contact Enter user-name: ERROR: ORA-12547: TNS:lost contact SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
数据库alert日志报错
Wed Jul 01 18:03:22 2015 Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_28977.trc (incident=129553): ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129553/xifenfei_ora_28977_i129553.trc Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129553/xifenfei_ora_28977_i129553.trc: ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Wed Jul 01 18:03:22 2015 Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_28979.trc (incident=129561): ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129561/xifenfei_ora_28979_i129561.trc Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129561/xifenfei_ora_28979_i129561.trc: ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Wed Jul 01 18:03:22 2015 Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_28985.trc (incident=129569): ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129569/xifenfei_ora_28985_i129569.trc Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129569/xifenfei_ora_28985_i129569.trc: ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Wed Jul 01 18:03:22 2015 Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_28983.trc (incident=129577): ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129577/xifenfei_ora_28983_i129577.trc Errors in file /u01/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_129577/xifenfei_ora_28983_i129577.trc: ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], []
查看相关目录文件权限
[oracle@www.xifenfei.com ~]$ env|grep ORA ORACLE_SID=xifenfei ORACLE_BASE=/u01/app/oracle ORACLE_TERM=xterm ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 [oracle@www.xifenfei.com ~]$ cd /u01/app/oracle/product/11.2.0/db_1 [oracle@www.xifenfei.com db_1]$ ls -ltr total 308 -rwxrwxr-x. 1 grid oinstall 63 Mar 1 16:39 oraInst.loc drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:40 assistants drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:40 crs drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 csmig drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:40 cv drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 demo drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 diagnostics drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 has drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 emcli drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 dv drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:40 ide drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:40 javavm drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 jdev drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:40 md drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:40 nls drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:40 odbc drwxrwxr-x. 5 grid oinstall 4096 Mar 1 16:40 olap drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 oracore drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:40 ord drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 owm drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:40 precomp drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 scheduler drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 relnotes drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 slax drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 sqlj drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 wwg drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:40 usm drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:40 uix drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:40 plsql drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:40 utl drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:40 xdk drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:40 instantclient drwxrwxr-x. 20 grid oinstall 4096 Mar 1 16:40 oc4j drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:40 timingframework drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:41 clone drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:41 j2ee drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:41 apex drwxrwxr-x. 13 grid oinstall 4096 Mar 1 16:41 sqldeveloper drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:41 jlib drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:41 dc_ocm drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:41 jdk drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:41 jdbc drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:41 ucp drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:41 OPatch drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:41 ccr drwxrwxr-x. 26 grid oinstall 4096 Mar 1 16:41 owb drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:41 mgw drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:41 opmn drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:41 cdata drwxrwxr-x. 6 grid oinstall 4096 Mar 1 16:41 css drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:41 mesg drwxrwxr-x. 2 grid oinstall 4096 Mar 1 16:41 config drwxrwxr-x. 3 grid oinstall 4096 Mar 1 16:41 EMStage drwxrwxr-x. 12 grid oinstall 4096 Mar 1 16:41 ldap drwxrwxr-x. 15 grid oinstall 4096 Mar 1 16:41 sysman drwxrwxr-x. 9 grid oinstall 4096 Mar 1 16:41 srvm drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:41 racg drwxrwxr-x. 10 grid oinstall 4096 Mar 1 16:41 ctx drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:42 sqlplus drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:42 oui drwxrwxr-x. 4 grid oinstall 12288 Mar 1 16:42 lib drwxrwxr-x. 5 grid oinstall 4096 Mar 1 16:42 perl drwxrwxr-x. 11 grid oinstall 4096 Mar 1 16:42 network drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:42 deinstall drwxrwxr-x. 5 grid oinstall 4096 Mar 1 16:42 hs -rwxrwxr-x. 1 grid oinstall 494 Mar 1 16:42 root.sh drwxrwxr-x. 13 grid oinstall 4096 Mar 1 16:42 rdbms drwxrwxr-x. 13 grid oinstall 4096 Mar 1 16:42 inventory drwxrwxr-x. 4 grid oinstall 4096 Mar 1 16:42 cfgtoollogs drwxrwxr-x. 7 grid oinstall 4096 Mar 1 16:44 install drwxrwxr-x. 2 grid oinstall 12288 Mar 1 16:44 bin drwxrwxr-x. 4 grid oinstall 4096 Mar 4 18:49 log drwxrwxr-x. 2 grid oinstall 4096 Jun 30 22:31 dbs
处理方法
root用户 chown -R oracle:oinstall /u01 chown oracle:oinstall /u01/app/oracle oracle用户 chmod 6751 $ORACLE_HOME/bin/oracle
这里的修改权限,为了保证业务运行正常,是尽量往大的方向修改的,如果条件允许,在后期有条件的情况下,建议重新安装oracle软件
