PLSQL Developer

1 intall oracle11gex

start OracleXEClrAgent

start  OracleXETNSListener

2 install C:\Dev Tool\instantclient_11_2

3 config PLSQL developer:

4 config oracle server side:

add following to tnsnames.ora

impactbac2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lsdbacdbmq.lbps.ibm.lab)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = impactbac2)
    )
  )
change following sqlnet.ora

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (NONE)

#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
automatic_ipc = off

 

listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle11gex\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle11gex\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
  )

 
 

DEFAULT_SERVICE_LISTENER = (XE)

 

5 open vpn then connect