How to connect to Oracle 11g database remotely

The Solution to How to connect to Oracle 11g database remotely is


You will need to run the lsnrctl utility on server A to start the listener. You would then connect from computer B using the following syntax:

sqlplus username/[email protected]:1521 /XE

The port information is optional if the default of 1521 is used.

Listener configuration documentation here. Remote connection documentation here.

~ Answered on 2011-11-12 23:58:45


Most Viewed Questions: