By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 974 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

Standby Database.. Error in password file..

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
"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
Jul 19 '05 #3

P: n/a
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.