Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

when I switch over oracle via hagui; oracle home owner changes

Created: 26 Apr 2012 • Updated: 04 May 2012 | 6 comments
This issue has been solved. See solution.

Dear All,

I have a solaris cluster installed oracle db and version 5 VCS. Once I switch-over oracle (actually group of services including oracle) oracle db is not able to up on the other node.

when I have a look I see that oracle home directory owner changed, I manually changes the owner and manually bring up via hagui once everything is OK I do again a switch over and on the other node the owner seems to be changed again.

what would be the reason veritas or oracle? Can you please help?

2012/04/26 09:39:29 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_pmon_QIPDB, PID = /proc/1107/psinfo
2012/04/26 09:39:29 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_lgwr_QIPDB, PID = /proc/1116/psinfo
2012/04/26 09:39:29 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_dbw0_QIPDB, PID = /proc/1114/psinfo
2012/04/26 09:39:29 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_smon_QIPDB, PID = /proc/1120/psinfo
2012/04/26 09:41:22 VCS WARNING V-16-20002-207 Oracle:qipdb:monitor:Open for ora_pmon failed, setting cookie to null
2012/04/26 10:15:37 VCS ERROR V-16-2-13066 Thread(3) Agent is calling clean for resource(qipdb) because the resource is not up even after online completed.
2012/04/26 10:15:38 VCS ERROR V-16-2-13068 Thread(3) Resource(qipdb) - clean completed successfully.
2012/04/26 10:15:38 VCS ERROR V-16-2-13071 Thread(3) Resource(qipdb): reached OnlineRetryLimit(0).
 

thanks,

Halit

Comments 6 CommentsJump to latest comment

mikebounds's picture

Is the Oracle user id the same in /etc/passwd on both nodes.  Group id in /etc/group should also be the same.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

halit.sakca's picture

hi mike,

thanks for help I cleaned some unnecessary entries from /etc/passwd and group files and aligned both node.

now I am able to start database manually SQL>startup => OK

butwhen I try to bring oracle onlive via hagui engine_A.log says;

2012/04/27 09:31:15 VCS INFO V-16-20002-104 (impdnepgam1) Oracle:qipdb:online:The IPC library is not from Veritas.
2012/04/27 09:31:16 VCS NOTICE V-16-20002-21 (impdnepgam1) Oracle:qipdb:online:Oracle startup returned the output
+--------------------------------------------------------------------+
LD_LIBRARY_PATH - /usr/lib:/opt/oracle/lib:/opt/oracle/lib:/opt/oracle/lib32:
ERROR:
ORA-01031: insufficient privileges

ORA-01031: insufficient privileges
+====================================================================+
 

can someone help?

thanks,

Halit

mikebounds's picture

Supposing you created Oracle with userid of 100 on node1 and 101 on node2 and you have now changed Oracle user id to 100 on both nodes.  You now probably have some files owned by user 101 on node2 which now don't belong to Oracle (user 100).  So you probably need to run a "chown -R oracle" on Oracle directories.  If this doesn't work, then onlline mounts and IPs in VCS and then try starting Oracle manually, if Oracle doesn't start manually, then issue is not with VCS and you need to find out what issue Oracle has.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

halit.sakca's picture

I was able to start oracle manually...

I can not start oracle via hagui...

and engine log says

2012/04/27 09:31:15 VCS INFO V-16-20002-104 (impdnepgam1) Oracle:qipdb:online:The IPC library is not from Veritas.
2012/04/27 09:31:16 VCS NOTICE V-16-20002-21 (impdnepgam1) Oracle:qipdb:online:Oracle startup returned the output
+--------------------------------------------------------------------+
LD_LIBRARY_PATH - /usr/lib:/opt/oracle/lib:/opt/oracle/lib:/opt/oracle/lib32:
ERROR:
ORA-01031: insufficient privileges

ORA-01031: insufficient privileges
+====================================================================+

mikebounds's picture

When you start manually, if you then probe Oracle resource in VCS, does it show as online.

How are you starting Oracle manually.  The VCS oracle agent (extract from manual):

"Starts the Oracle database by using the following svrmgrl or sqlplus command:
startup force pfile=$PFile"
 
If this is not the same way you started it, then try the above method manually.
 
Can you provide extract from /etc/VRTSvcs/conf/config/main.cf that shows Oracle resource.
 
Mike
 

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

halit.sakca's picture

hi,

found out the problem (had to check what script does for bringing oracle up);

- VCS oracle uses OS authentication for connecting database lets say on oracle itself;

sqlplus '/as sysdba' should work -> this was not working in my case and throwing "ORA-01031: insufficient privileges"

I solved problem with adding in /opt/oracle/network/admin/sqlnet.ora following line

SQLNET.AUTHENTICATION_SERVICES = (ALL)

If it does not work following link might be helpful;

http://www.orafaq.com/wiki/Oracle_database_Securit...

thanks,

Halit

SOLUTION