04-26-2012 01:44 AM
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
Solved! Go to Solution.
05-02-2012 07:14 AM
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_Security_FAQ#How_does_one_create.2C_manage_and_drop_database_users.3F
thanks,
Halit
04-26-2012 01:53 AM
Is the Oracle user id the same in /etc/passwd on both nodes. Group id in /etc/group should also be the same.
Mike
04-27-2012 12:35 AM
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
04-27-2012 01:13 AM
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
05-02-2012 12:44 AM
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
+====================================================================+
05-02-2012 03:20 AM
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):
05-02-2012 07:14 AM
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_Security_FAQ#How_does_one_create.2C_manage_and_drop_database_users.3F
thanks,
Halit