Standby Database.. Error in password file..

[Cherrish Vaidiyan]

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...e_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

[Ana C. Dent]

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...e_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

[Cherrish Vaidiyan]

"Ana C. Dent" <an*******@hotmail.com> wrote in message

Try the following before accessing the database
unset TWO_TASK

Hai,

I am still getting the same result. I gave the command
$ unset TWO_TASK

still when i try to connect as
$ sqlplus /nolog
SQL> connect sys/sys@intel as sysdba

But I am getting the same error...

ERROR:
ORA-01031: insufficient privileges

What else should i do...???

regards
Cherrish Vaidiyan

[sybrandb]

un***************@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0**************************@posting.google. com>...

"Ana C. Dent" <an*******@hotmail.com> wrote in message

Try the following before accessing the database
unset TWO_TASK

Hai,

I am still getting the same result. I gave the command
$ unset TWO_TASK

still when i try to connect as
$ sqlplus /nolog
SQL> connect sys/sys@intel as sysdba

But I am getting the same error...

ERROR:
ORA-01031: insufficient privileges

What else should i do...???

regards
Cherrish Vaidiyan

The database must be down prior to recreating the
passwordfile,otherwise it won't pick up you changed it.
On Unixes you will be also getting this error if
- your Unix account is not in the dba group
- The ownership and protection of the Oracle files and executables is
incorrect. The setuid bit should be set for the oracle executable and
the tnslistener executable.

Note : try using
set oracle_sid=intel
sqlplus /nolog
connect sys/sys as sysdba

(leaving out the @intel)
In this scenario sql*net will be bypassed. If it works in this
configuration you know sqlnet is the source of trouble.

Regards and happy new year,

Sybrand Bakker
Senior Oracle DBA