oracle19c安装向导未响应_[ORACLE]ORACLE19 client 安装

1. 安装oracle client:

注意oracle 的安装目录中不能包含空格

https://download.oracle.com/otn_software/nt/instantclient/19600/instantclient-basic-windows.x64-19.6.0.0.0dbru.zip

2.在Oracle client 安装目录 建立network\admin,并将ORACLE服务器上tnsnames.ora 和sqlnet.ora 的文件放入此文件夹

tnsnames.ora 内容如下所示:

D4CDB =(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP)(HOST = d4cdb.doufupi.com)(PORT = 1521))

(CONNECT_DATA=(SERVER=DEDICATED)

(SERVICE_NAME=D4CDB.doufupi.com)

)

)

sqlnet.ora内容如下所示:

SQLNET.AUTHENTICATION_SERVICES=(NTS)#注意:如果Oracle安装在linux 系统上,此参数不要在linux系统上设置.否则无法连接

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

oracle client 语言设定

SQL> select userenv('language') nls_lang fromdual;

NLS_LANG----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

设定plsqldev OCI 环境变量