Re: Problems w/auto archiving - UNIX

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/12/19
Message-ID: <Pine.SUN.3.91.951219101033.20482A-100000-100000_at_seatimes>#1/1

Don't know if this will help, but I had a problem using environemntal variables in the init.ora file. From the info below, it sounds like you are using a link between the two directories. While I have soft links working here under 7.2.2, I have had Oracle support insist that all paths in the init.ora must be "physical".

The other problem I've seen involves permission differences between the parents to the two directories involved. In your case, it looks like the /u/g/oracle/7.1 permissions for all directories in the path is set up correctly. However, you haven't shown us the permissions looking at /amd /amd/oracle and /amd/oracle/7.1 (the last should be the same by virtue of being the same inode). The problem may be permissions at the /amd or /amd/oracle level rather than the path you have shown. This problem has bitten me in the past (and probably will again in the future)!

--Steve

On 18 Dec 1995, Ken Johnson wrote:

> In article <4anoc4$m3r_at_lionfish.rdatasys.com>, kjohn_at_rdatasys.com says...
> >
> >I have just installed Oracle 7.1.6 on our Sparc20 running Solaris 2.4
> >and am having a problem with starting up automatic archiving.
> >
> >SQLDBA> startup
> >ORA-00443: background process "ARCH" did not start
> >ORA-07274: spdcr: access error, access to oracle denied.
> >SVR4 Error: 2: No such file or director
 .
> >log_archive_dest = /amd/oracle/admin/db71/archive/db71
> >log_archive_format = _%s.arc
> >db_name = db71
 

> >/amd/oracle/7.1 (a link to /u/g/oracle/7.1).
>
> The directory /u/g/oracle permissions are:
> drwxr-xr-x 27 oracle 512 Dec 12 13:55 7.1/
> drwxrwxr-x 4 oracle 512 Nov 27 11:06 admin/
>
> /u/g/oracle/admin permissions are:
> drwxrwxrwx 9 oracle 512 Dec 15 15:11 db71/
>
> /u/g/oracle/admin/db71 permissions are:
> drwxrwxrwx 2 oracle 512 Dec 18 10:58 archive/

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue Dec 19 1995 - 00:00:00 CET