Re: Standby Database.. Error in password file..
Date: Thu, 01 Jan 2004 05:48:24 -0800
Cherrish Vaidiyan wrote:
> A Warm and Smart 2004 greetings to all.
> I have a problem with standby database.I have been posting queries but
> no response .....
> I am using 2 system running on Red Hat Linux9 and Oracle9i. I name the
> 2 system and DB for convenience.
> SYSTEM01 & DB NAME= APPLE (Primary)
> SYSTEM02 & DB NAME=INTEL (Standby)
> I did follow the steps available on oracle documentation (
> )and almost 80% percent of the steps involved are correct. On the
> standby database,the following command in the standby database is used
> SQL> STARTUP NOMOUNT;
> SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
> When i give this it says old passwod file is corrupt and something
> that its not vaild.so I deleted the passwword file and tried to
> recreate it using
> orapwd file=<path>/PWDintel.ora password=sys entires=5;
> The command executes and password file is created. i took sqlplus
> /nolog in a terminal. when i try to connect to the database as any
> user like sys,system,scott,hr etc the error i am getting is '
> INSUFFICIENT PRIVILEGES'.For sys and system i tried with sysdba
> privilege also still the same result.
> Kindly, Could anyone please tell me Why I am getting this error ?
> Is there any remedy for this error ?
> Cherrish Vaidiyan
Try the following before accessing the database unset TWO_TASK Received on Thu Jan 01 2004 - 14:48:24 CET