Re: Export and backup fails - Oracle 8 / WinNT

Zorglub wrote:

> Hello,
>
> Using Oracle Enterprise Manager (connected under SYSMAN) I can't export or
> backup my database.
>
> Each time I submit a new task it fails.
> Looking at the Windows NT event viewer I can see a message coming from the
> SYSTEM user : bad user or password.
>
> I've given to the SYSTEM user (with NT user manager utility) the same
> password as under Oracle.
> I've given to the SYSTEM user the right to "Logon as Batch Job"
>
> Exports & backups still fails...
>
> What is wrong ?? Please help me I'm never been able to backup anything since
> the beginning of my project. This is a very dangerous situation !!
>
> Note : I'm under Windows NT4 / SP6 - Using Oracle 8i personnal Edition - The
> server is a Domain Controller.
>

spawn a command prompt, type

C:\> exp help=y

and use the command line tool %ORACLE_HOME\bin\exp.exe with a parfile in a batch jobs. Use the schedule service to regularly execute your export job. If this will be used in a production situation, you do not want to use exports for recovery purposes.

Go to Technet and read the Backup and Recovery guide. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76993/toc.htm

Paul Received on Wed Jan 16 2002 - 08:23:42 CST