Cluster user creation - Help needed

[Rudi Martin]

Hi there guys

We've got two servers working in a cluster , S001 and S002. I have two DB's on S001 and 3 DB's on S002. I've setup users on S001 and S002 , but the UID's are different now. Is there any fix to this ? Maybe setup the users just on S001 and have the same info on S002 ?

Thanks

[Sanjiv Sharma_1]

Hi Rudi,

In a cluster environment, it is recommended to create the users in one server and then copy the information ( /etc/passwd, home directory, /etc/group etc..) to the other server.

In your case you can modify the userid with a new userid.

Keep a record of permission
# ls -lR > ll.txt

Check it after modification that all the files permissions has moved to new user id.

[Mark Grant]

To fix you current problem, you need to resolve the contention and probably have to change the ownership on all of the DBA's files where you have had to change the uid.

IN future, you can either copy the /etc/passwd and /etc/group files around or look at implementing NIS to keep them in synch. It is possible for both machines to be NIS servers and slaves.