Database Administration (MOSC)

MOSC Banner

All about REMOTE_LISTENER...

edited Feb 23, 2017 4:55PM in Database Administration (MOSC) 11 commentsAnswered ✓

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center