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:

Algorithms

  [1]  Introduction to Algorithms 3rd Edition  Cormen https://fun4yo.xyz/book/introduction-to-algorithms-3rd-edition/   [2]