SG with NFS toolkit and Oracle9i RAC

[J.D._3]

Here's the environment. 4 RX4640 runining HP-UX 11.23 with Oracle9.2.0.6 RAC. All datafiles are on raw devices except for the archived log filesystem. We orignially have 2 NICs, one 100BT for public, another GigE for interconnect. The NFS package's VIP is riding on the public network. We went ahead and isolated this by activating another GigE interface on its own private network away from the public network and away from the interconnect. The problem is that except for the node running the NFS package, oracle cannot do a log switch the 2nd time. It merely hangs. We got around it by bringing up the old VIP on the public network while the NFS package is still riding on the private network. Why did bringing up the old VIP along with the new VIP work while with just the new VIP on the private network did not? Thanks, in advance.

[Steven E. Protter]

Did you reconfigure SG and packages after adding the NIC cards?

That might deal with the hanging issue.

SEP

[J.D._3]

Hi Steven,

I changed the IP address in the nfs control file and I did a cmcheckconf and cmapplyconf. Then I brought the pacakge up. I could touch a file on all 4 systems as the oracle userid. Once oracle is up, each instance can do a log switch once. After that the 2nd, 3rd & 4th nodes cannot do it. The 1st instance can still do a log switch, its also the nfs server mounting the nfs filesystem to itself, then to the other 3 in question. Thanks.

[Alan Meyer_4]

What about name/IP resolution and the listener name/IP resolution? Have anything been changed there?

[J.D._3]

Hi Alan,

We're using NIS but the nsswitch.conf file looks at the hosts file first. Both were addressed to change the NFS package's IP address. You mentioned listener name/IP resoulution. I'm not sure what you mean by that? The listener.ora file was not changed because the servers' names were not changed. The service_names was not change in the database either. Thanks.

[Alan Meyer_4]

I was just suggesting places where name resolution is done that could be in conflict with changed information.

[J.D._3]

Hi Alan,
Yes, in our listener.ora and tnsnames.ora, we use the alias noted in our /etc/hosts file. We don't normally use IP addresses. In our host.equiv and .rhost file we reference the alias in our NIS. We do not use DNS in our environment.