Wednesday, May 11, 2011

EMS SQL Manager configure for connect to Oracle

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = x.x.x.x )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = ipc)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)




sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

USE_DEDICATED_SERVER = ON

USE_CMAN = TRUE

No comments:

OS Emulation on Ubuntu 20

    sudo apt update && sudo apt install qemu-system-x86   # Create a 1GB disk image   qemu-img create -f qcow2 win95.qcow2 1G qemu-i...