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