All about REMOTE_LISTENER...
Good day!
We experienced a problem yesterday morning about REMOTE_LISTENER. My teammate did alteration on this because it was a prerequisite for a PCI-DSS implementation. Anyhoo, below is the BEFORE implem:
REMOTE_LISTENER=test-scan-name:1521
Now the AFTER implem:
REMOTE_LISTENER=TEST_TNS_ENTRY
<tnsnames.ora>
TEST_TNS_ENTRY =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =test-scan-name)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)) <-- This is proxy
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521)) <-- This is proxy
)
Now, here is the questions.
1. Is this safe/correct/the best practice? I saw the documentation, it should be like below, right?
REMOTE_LISTENER="test-scan-name:1521,TEST_TNS_ENTRY"