Re: password file on rac

"SP" <spantgroup@xxxxxxxxx> wrote in message
news:1133912393.691994.10070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I am on 9i RAC. I had to go and run the alter statement in each
> instance to change the password file otherwise it wouldn't change. I
> went exactly through the same process...
>
>

Wow!

I found this in the 9i RAC Setup and Configuration guide. Take note of
"Changing the Password".

Database Password and Role Management in Real Application Clusters
If you did not enable operating system authentication for the database
server, then Oracle uses a password file for each instance of a Real
Application Clusters database to authenticate user access to the database.
Because these password files are private to each instance, you must
administer passwords and roles in Real Application Clusters as follows:

a.. Changing the Password--If you alter the password for an existing user,
then you must execute the same ALTER USER SQL statement on all instances of
your cluster database.
b.. Granting or Revoking the SYSDBA or SYSOPER Roles--If you grant or
revoke the SYSDBA or SYSOPER roles to a user, then you must execute the same
GRANT ROLE or REVOKE ROLE SQL statement on all instances of the cluster
database.
--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup



.

Relevant Pages

  • Re: Clustering for Performance
    ... Clusters), but the improvements over 2000 seem to be mostly for failover ... > have 40K concurrent users especially since SQL Server only allows 32,767. ... > database since it resides on only one disk resource. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering for Performance
    ... Richard, I don't know where you are based, but Google around for a Dallas ... > Clusters), but the improvements over 2000 seem to be mostly for failover ... >> database since it resides on only one disk resource. ... >>> for failover and not for performance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Returning from an included script while inside a function ?
    ... I am fixing someone elses work, and it's a mess. ... switch statement. ... If I alter the main file - I alter ... database calls is scattered all over a mess of 'ifthen we ...
    (comp.lang.php)
  • Re: Clustering for Performance
    ... Oracle RAC, while it provide lad balancing, doesn't automatically give you ... longer than they would if it was a single Oracle server, ... > Clusters), but the improvements over 2000 seem to be mostly for failover ... >> database since it resides on only one disk resource. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Restoring database with different COLLATION
    ... > How I can modify the COLLATION of the database after restoring it? ... as SQL Server 2000 supports different collations and sort orders for each ... ALTER DATABASE db_name ... ALTER COLUMN VARCHAR ...
    (microsoft.public.sqlserver.msde)