oracle 10g 客户端安装

    技术2022-05-11  71

    1. 从http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html下载几个压缩包,解压到一个目录, d:/oracleclient

    instantclient-basic-win32-10.1.0.2.zip : 这是最核心的包instantclient-jdbc-win32-10.1.0.2.zip: 包含JDBC Driver的包instantclient-sqlplus-win32-10.1.0.2.zip: 最简单的SQLPLUS包 2.配置tnsnames.ora 如下格式(必须在主目录如D:/oracleclient下network/admin下)oracledata =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.58)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = oracledata)    )  )3.下载并安装PL.SQL.Developer配置应用  配置tools->preferences->connection  Oracle Home=D:/oracleclient  OCI library=D:/oracleclient/oci.dll4.再次打开plsql则会在database中有oracledata 选项输入用户名密码就可以登陆

                                                                                                                           oseica 


    最新回复(0)