In Oracle : TKPROF Utility in Oracle

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Errors (ORA-NNNNN)

-> ORA-27041: unable to open file

 

 ORA-27041: unable to open file

 

This error is a generic one. If you get this error take a look at the other error as well.

 

The other error will give you more information about the file you are unable to open it.

 

Don't forget: unable to open a file = unable to see a file on the disk generally (It's rare a file get other rights for writting/ reading !!!!).

 

Here is an example:

 

SQL> shutdown immediate;
Database closed.
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u02/oracle/oradata/control02.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

 

In this case the message is simple: "unable to open file" ... and the file is a control file !!!

 

However the causes of this error are many.

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Errors (ORA-NNNNN)

-> ORA-27041: unable to open file

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.