How to Allow Remote Database Connection on Oracle 11G
March 18 2015
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
Comments (0)