We have already discussed about Oracle 11G version installation steps, this post describes how to give  remote access to Oracle 11.2g,

Execute command,

# sqlplus sys/password  as sysdba


​SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);



PL/SQL procedure successfully completed.

If you may received above output permission granted, can test yourself  just execute command,


SQL> CONNECT sys/password@192.168.1.117:1521 as SYSDBA



Connected.


Oracle Database connection in SQL developer tool:


User Name : sys

Password  : password

Role      : sysdba

Host name : 192.168.1.117

Port      : 1521

SID       : XE


How to get SID name :
 
# cat /etc/oratab


XE:/u01/app/oracle/product/11.2.0/xe:N