Oracle 配置过程:
Oracle 客户端连接配置:
1. 配置文件:
$Oracle/network/admin/sqlnet.ora
$Oracle/network/admin/tnsnames.ora
2.配置内容:
$Oracle/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
配置客户端连接的方式。
$Oracle/network/admin/tnsnames.ora
newdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xxx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devdb1.xxxxx.com)
)
)
使用tnsping测试。
tnsping newdb.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = xx.xx.xxx.xx)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVI
CE_NAME = devdb1.xxxxx.com)))
OK (5990 msec)
Oracle 客户端连接配置:
1. 配置文件:
$Oracle/network/admin/sqlnet.ora
$Oracle/network/admin/tnsnames.ora
2.配置内容:
$Oracle/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
配置客户端连接的方式。
$Oracle/network/admin/tnsnames.ora
newdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xxx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devdb1.xxxxx.com)
)
)
使用tnsping测试。
tnsping newdb.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = xx.xx.xxx.xx)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVI
CE_NAME = devdb1.xxxxx.com)))
OK (5990 msec)