Re: SQL1326N : file or directory cannot be accessed

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Oct 2006 16:39:13 -0700
Message-ID: <1160350753.863288.173850@i42g2000cwa.googlegroups.com>

Bruno Costacurta wrote:
> Hello,
>
> using 10g I'm trying to create a database in the instance 'bruno' but
> receive error code :
>
> SQL1326N The file or directory "/home/bruno/" cannot be accessed
>
> Platform is Linux and I tried :
> chmod 777 /home/bruno
> chmod -R 777 /home/bruno/sqllib/
>
> but without success.
> Thanks for any clue.

Usually you create a unix user to own the oracle software and executables ( often the unix user created is "oracle" ) and then some groups such as oinstall and dba.

Did you do that? Do an ll ( or ls -la perhaps on linux ) on the oracle executable ... what does it look like?

Typically you create datatabases in different directories than /home ... such as /u02/oradata etc. Received on Sun Oct 08 2006 - 18:39:13 CDT