Re: Standby Database.. Error in password file..

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 01 Jan 2004 05:48:24 -0800
Message-ID: <JyVIb.45101$BQ5.4071_at_fed1read03>


Cherrish Vaidiyan wrote:
> Sir,
>
> 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 (
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#66206
> )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 ?
>
> regards,
> Cherrish Vaidiyan

Try the following before accessing the database unset TWO_TASK Received on Thu Jan 01 2004 - 14:48:24 CET

Original text of this message