Oracle database exception due to missing x permission for Bdump directory

Source: Internet
Author: User

rhel6.3 x64bit, Oracle 11.2.0.4 x64bit

[Email protected] test]$ pwd/u01/app/oracle/diag/rdbms/test/test[[email protected] test]$ chmod u-x trace[[email  Protected] test]$ lltotal 100drwxr-x---.  2 Oracle Oinstall 4096 alertdrwxr-x---.  2 Oracle Oinstall 4096 cdumpdrwxr-x---. 2 Oracle Oinstall 4096 hmdrwxr-x---.  Oracle Oinstall 4096 Jan 8 20:58 incidentdrwxr-x---.  2 Oracle Oinstall 4096 incpkgdrwxr-x---.  2 Oracle Oinstall 4096 irdrwxr-x---.  2 Oracle Oinstall 4096 Jan 8 20:58 lckdrwxr-x---.  2 Oracle Oinstall 4096 metadatadrwxr-x---.  2 Oracle Oinstall 4096 metadata_dgifdrwxr-x---.  2 Oracle Oinstall 4096 metadata_pvdrwxr-x---.  2 Oracle Oinstall 4096 Jan 8 20:58 stagedrwxr-x---. 2 Oracle Oinstall 4096 Jan 8 20:58 sweepdrw-r-x---. Oracle Oinstall 49152 Jan 8 20:58 Trace---> Missing x permission, the directory is the Bdump directory (the directory specified by Background_dump_dest)


Here's what happens to DB server's native login sqlplus:

[Email protected] ~]$ sqlplus  /As Sysdbsql*plus:release 11.2.0.4.0 Production on Thu Jan 8 21:04:16 2015Copyright ( c) 1982, Oracle.  All rights reserved. Error:ora-12547:tns:lost Contactenter User-name:  

3 minutes or so before the above error is reported.
The DB is connected from the Oracle DB Client (PL/SQL Developer) and is reported:

Ora-12537:tns:connection closed

At this point, the trace directory is not going to go in:

[Email protected] test]$ CD trace-bash:cd:trace:permission denied


The solution to this problem is actually simple:

[Email protected] test]$ chmod u+x Trace



Oracle database exception due to missing x permission for Bdump directory

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.