Re: EMERGENCY! HELP!

How do I "Did you check permission's on your directory does Oracle user have access to read/write on /users/oracle/logs"?

Frederic DEBRUS wrote:

> # oerr ora 270
> 00270, 00000, "error creating archive log %s"
> // *Cause: An error was encountered when either creating or opening the
> destination file for archiving.
> // *Action: Check that the archive destination is valid and that there is
> sufficient space on the destination device.
>
> Did you check permission's on your directory does Oracle user have access
> to read/write on /users/oracle/logs
>
> also
>
> define the log as following
> LOG_ARCHIVE_DEST should only define the destination directory
> LOG_ARCHIVE_FORMAT there you can define the file name
>
> LOG_ARCHIVE_DEST = /users/oracle/logs
> LOG_ARCHIVE_FORMAT = gte_%S.arc
>
> Hope this help
>
> Brian Howard <bh_at_creditwatch-inc.com> wrote in article
> <37E64248.F168BE93_at_creditwatch-inc.com>...
> > I have a critical problem. I currently have twelve people sitting unable
> > to work. Here is what happened. I had to totally duplicate a server and
> > database from one server to another to split the database into two
> > pieces. I bought a new server, installed A/UX on it, installed Oracle
> > 7.0 on it and after many nights got it up and semi working. I copied
> > relevant files over to the new server and made a full export on the old
> > server's database. As I read in the manual, what I believe I needed to
> > do is get the instance up and running, create all tablespaces and users
> > and then import the full export. Everything was done: I got the instance
> > to work and I created all tablespaces and users successfully; however, I
> > noticed that the archive log destination in the initgte.ora was not
> > being saved to a directory with adequate space. I changed the directory
> > to a better location in the initgte.ora file but now when I try to log
> > in as internal and issue the startup command to bring up the database, I
> > get the following message:
> >
> > SQLDBA> startup
> > reached here /users/oracle/logs/gte_
> > ORA-00256: error occurred in translating archive text string
> > '/users/oracle/logs/gte_'
> > ORA-00270: error creating archive log
> > Macintosh A/UX Error: 13: Permission denied
> >
> > It was working before I made this change in the log_archive_dest in the
> > initgte.ora file.
> >
> > This is the way those lines look now:
> > LOG_ARCHIVE_DEST = /users/oracle/logs/gte_
> > LOG_ARCHIVE_FORMAT = %S.arc
> >
> > Please help. This is critical. Thanks.
> >
> >
> >
Received on Mon Sep 20 1999 - 09:59:08 CDT