On any HPUX (11:31) system where grid infrastructure has been applied with 2 software owners – in our case grid and oracle – oracle’s best practise for GI implementations – RAC or standalone systems.
The standard unix account we are using is , testuser (although in this case he is in the DBA group).
This user is a member of the following groups :
uid=664(testuser) gid=500(dba)
Test Server = server
Test database = dbatest
Login to the testuser user
- setsid to set Oracle environment to dbatest
The ASM luns are owned by the grid user as below :
[testuser@server][dbatest]/dev/grid $ls -ltr total 0 crw-rw---- 1 grid asmdba 13 0x00000a Apr 27 12:38 disk002 crw-rw---- 1 grid asmdba 13 0x000009 Apr 27 22:00 disk001 crw-rw---- 1 grid asmdba 13 0x00000b Apr 28 12:44 disk003
logon onto unix server as testuser
Login into the database as “sqlplus / as sysdba”
Set database environment variables as appropriate (OH, SID,PATH)
Database bounced to clear cache out (shared pool flush would also work) Read the rest of this entry »
