George Kahler wrote:
Hi, I'm setting up an 840 filer for our DBA group to run about 4-to-5 Oracle OLT databases and 4-to-5 Oracle DSS databases being served from about 1/2 a dozen Unix servers. This is something new to the DBAs in that they are not experienced with NFS or anything like a filer; a common disk storage. Their databases are married to specific Unix servers. The project mandates that the environment needs to be set up in such a way that if any Unix server fails, the database service that it was providing could easily be brought up on any other available Unix server. (So far no problem)
I have created and mapped out a quota tree into which I installed the Oracle distribution. It looks something like: /softwr/oracle/product/7.3.4 /7.3.5 this is then exported to all of the Unix servers.
The problem I have with is the Unix Oracle home directory that I also created in /softwr/oracle/home, ie. oracle:x:600:211:Oracle user:/softwr/oracle/home:/bin/ksh but the DBAs are telling me that the oracle home directory needs to be unique for each Unix server and Database running on that server because the home directory is the place where they keep their environment.
How do other people deal with this? Do you create specific Unix accounts for each Oracle database running on a server?
I'd create an oracle user:
oracle:x:600:211:Oracle User:/local/oracle/home:/bin/ksh
where /local is a local filesystem.
Then, on each server box make /local/oracle/home a symbolic link to /softwr/server/oracle/home. That way, you have one oracle account that can have a different home directory on each server.
barry