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