Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle user can't see all files in a folder. Why?

sridhartempalleMay 8 2013 — edited May 9 2013

I've installed oracle 10g (32 bit) in Oracle EL (32 bit). When I attempt to start the database from the oracle user, it throws the following error:

ORA-01078:failure in processing system parameters
LRM-00109:could not open parameter file '/u01/app/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora'

As an oracle user I checked the $ORACLE_HOME/dbs and found these two files visible:
initdw.ora & init.ora

But as root user i found the following files existing in the directory:
hc_orcl.dat, initdw.ora, init.ora, lkORCL.ora, orapworcl & spfileorcl.ora

echo $ORACLE_SID returns the value as "orcl".

I followed the possible issues from the following thread:
2231820

and

http://mohamedazar.com/2010/04/27/ora-01078-failure-in-processing-system-parameters/

but since the files are not visible for the user, but available to the root, what are the possible solutions that I should try for?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2013

Added on May 8 2013

#database, #general-database-discussions, #installation

9 comments

563 views