Oracle database 11.2.0.1
oracle@dub-ImrORA2 ~]$ echo $ORACLE_HOSTNAME
dub-ImrORA2.dub-ImrORA2.americas.epicor.net
This is incorrect. Should be:
dub-ImrORA2.americas.epicor.net
Listener file:
listener.ora
LISTENER=(ADDRESS=
(PROTOCOL=TCP)
(HOST=dub-ImrORA2.americas.epicor.net)
(PORT=1521)
)
ADR_BASE_LISTENER = /u01/app/oracle/product/11.2.0
/etc/hosts
10.20.0.88 dub-ImrORA2.americas.epicor.net dub-ImrORA2
[oracle@dub-ImrORA2 ~]$ hostname
dub-ImrORA2
When I try to change the value of $ORACLE_HOSTNAME to the correct value it gets reverted back to the original value. This is causing problem with OEM.
[oracle@dub-ImrORA2 ~]$ export ORACLE_HOSTNAME=dub-ImrORA1.americas.epicor.net
[oracle@dub-ImrORA2 ~]$ echo $ORACLE_HOSTNAME
dub-ImrORA1.americas.epicor.net
[oracle@dub-ImrORA2 ~]$ exit
[root@dub-ImrORA2 ~]#
[root@dub-ImrORA2 ~]# su - oracle
[oracle@dub-ImrORA2 ~]$ echo $ORACLE_HOSTNAME
dub-ImrORA2.dub-ImrORA2.americas.epicor.net