Re: Problems w/auto archiving - UNIX
Date: 1995/12/18
Message-ID: <4b4t7o$l77_at_lionfish.rdatasys.com>#1/1
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
. . .
># ?/rdbms/admin/expvew.sql)
>background_dump_dest = /amd/oracle/admin/db71/bdump
>core_dump_dest = /amd/oracle/admin/db71/cdump
>user_dump_dest = /amd/oracle/admin/db71/udump
>log_archive_dest = /amd/oracle/admin/db71/archive/db71
>log_archive_format = _%s.arc
>#db_block_size = <blocksize>
>
>db_name = db71
. . .
>/amd/oracle/7.1 (a link to /u/g/oracle/7.1).
>
Following up on this problem. I have changed the oracle user account to being
solely on this particular machine (no Yellow Pages acct) and the home
directory
no longer points to the amd (auto mounting software) directory. It is
actually
on that directory. For example in the /etc/passwd file the entry is:
oracle:x:31:31:Oracle DBA acct:/u/g/oracle:/usr/lbin/tcsh
The directory /u/g/oracle permissions are: drwxr-xr-x 27 oracle 512 Dec 12 13:55 7.1/ drwxr-xr-x 2 oracle 512 Nov 22 10:42 7.2/ drwxrwxr-x 2 oracle 512 Dec 7 13:53 TAR/ drwxrwxr-x 4 oracle 512 Nov 27 11:06 admin/ drwxr-xr-x 4 oracle 512 Nov 27 11:08 data/ drwxrwxr-x 2 oracle 512 Dec 7 13:53 local/ drwxrwxr-x 2 oracle 512 Dec 7 13:53 product/ /u/g/oracle/admin permissions are: drwxrwxrwx 9 oracle 512 Dec 15 15:11 db71/ drwxrwx--- 9 oracle 512 Nov 22 10:45 db72/ /u/g/oracle/admin/db71 permissions are: drwxrwxrwx 2 oracle 512 Dec 18 10:58 archive/ drwxrwx--- 2 oracle 512 Dec 18 14:20 bdump/ drwxrwx--- 2 oracle 512 Nov 22 10:44 cdump/ drwxrwx--- 2 oracle 512 Dec 15 15:52 create/ drwxrwx--- 2 oracle 512 Dec 14 16:38 pfile/ drwxrwx--- 2 oracle 512 Nov 22 10:44 tar/ drwxrwx--- 2 oracle 512 Dec 15 16:24 udump/
/u/g/oracle/admin/db71/archive permissions are:
-rw-rw---- 1 oracle 2097664 Dec 8 14:13 db71_%s.arc1_1.dbf -rw-rw---- 1 oracle 2097664 Dec 8 14:25 db71_%s.arc1_2.dbf -rw-rw---- 1 oracle 2097664 Dec 8 14:50 db71_%s.arc1_3.dbf -rw-rw---- 1 oracle 2097664 Dec 8 15:36 db71_%s.arc1_4.dbf -rw-rw---- 1 oracle 2097664 Dec 15 15:32 db71_1.arc -rw-rw---- 1 oracle 2097664 Dec 15 15:39 db71_2.arc -rw-rw---- 1 oracle 2097664 Dec 15 15:50 db71_3.arc
As you can see there are some archive files in this directory. This is
because
I have been able to archive the logs manually with the "alter system logs all"
command from SQLDBA.
I'm about ready to scream.
P.S. Thanks for all of the responses. I really do appreciate all your ideas!
Ken Received on Mon Dec 18 1995 - 00:00:00 CET