cancel
Showing results for 
Search instead for 
Did you mean: 

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

halit_sakca
Level 3

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

1 ACCEPTED SOLUTION

Accepted Solutions

halit_sakca
Level 3

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

View solution in original post

6 REPLIES 6

mikebounds
Level 6
Partner Accredited

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

Mike

halit_sakca
Level 3

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
Level 6
Partner Accredited

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

halit_sakca
Level 3

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
Level 6
Partner Accredited

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
 

halit_sakca
Level 3

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

View solution in original post