08-05-2013 11:05 AM
Not sure if this is Oracle or HPUX issue.
On a DR box running hpux 11.31, oracle v10.2.0.5. A hostname change is part of our DR test. After changing the system hostname (but not the IP address), Oracle listener will not start. Errors with TNS-12545: Connect failed because target host or object does not exist. The tnsping also fails wit the same message. As the oracle user - I can ping the system with its new hostname without a problem. If I edit the tnsnames and listener files to have the host's IP address - the listener starts, but with the hostname it does not. The hostname was changed by: editing the /etc/hosts file, editing the hostname in netconf to be the new hostname, doing set_parms hostname. I tried doing /sbin/init.d/hostname start - this did NOT work, so I used set_parms hostname. Any ideas? Thanks
Solved! Go to Solution.
08-07-2013 07:33 AM
Are you perhaps using a custom "umask 077" for root?
I've been burned by this at least once before: some Oracle security patches did not consider that the oracle user might have a non-default umask, and relied on the default umask (022) instead of explicitly setting the permissions for new Oracle binaries and libraries. After the update, the applications could not access the Oracle libraries they needed, until the permissions issue was noticed and fixed.
Perhaps the set_parms script has a similar built-in assumption that the root's umask is 022, as is the HP-UX default?