A friend found me, said he did the wrong operation of the production library, resulting in database anomalies, please I help processing, the/U01 directory modified users and permissions, resulting in the database can not log on, but the business continues
Error Operation command
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
Try Sqlplus Login Database ORA-12547
[Oracle@www.xifenfei. COM admin]$ sqlplus/as SYSDBA
Sql*plus:release 11.2.0.3.0 Production on Wed June 1 17:40:42 2015
Copyright (c) 1982, 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
Database Alert Log Error
Wed 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 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 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 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], [], [], [], [], [ ], [], [], [], []
View Related directory file permissions
[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 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. 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 Java
Drwxrwxr-x. 8 grid oinstall 4096 Mar 1 16:41 Apex
Drwxrwxr-x. 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. 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. Grid oinstall 4096 Mar 1 16:41 LDAP
Drwxrwxr-x. 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. Ten 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. One 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. Grid oinstall 4096 Mar 1 16:42 RDBMS
Drwxrwxr-x. 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 June 22:31 DBS
Processing methods
Root user
Chown-r oracle:oinstall/u01
Chown oracle:oinstall/u01/app/oracle
Oracle Users
chmod 6751 $ORACLE _home/bin/oracle
Here to modify the permissions, in order to ensure that the business operation is normal, is as far as possible in the direction of modification, if conditions allow, in the case of late conditions, it is recommended to reinstall Oracle software
Contact: Mobile Phone (13429648788) QQ (107644445)
Link: http://www.xifenfei.com/5965.html