Different timezone setup in listener.
Hi All,
I am trying to create a listeners in different timezone. I am following the metalink note 399448.1. I followed the same steps as mentioned in the document.
But the time is not changing when I give "select sysdate from dual". I pasted the steps changes done in the server and client. Please let me any mistake I made.
In server listener.ora file
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = E:\Ora10gDB)
(SID_NAME = ORCL)
(ENVS='TZ=CST6CDT')
)
)
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1522))
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = E:\Ora10gDB)
(SID_NAME = ORCL)
(ENVS='TZ=EST5EDT')
)
)
Restarted the both listeners.
In the client tnsnames.ora file
local =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)
local1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)
let me is any mistake in the steps.
Regards,
Prasanna