Oracle database incorrectly modifies/U01 permissions/owner Recovery

Source: Internet
Author: User
Tags chmod error code mkdir file permissions oracle database sqlplus


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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.