安装oci8拓展支持oracle数据库

279 阅读1分钟
  1. php.ini

打开extension=php_oci8.dll

打开extension=php_pdo_oci.dll

  1. 下载安装oracle 注意区分版本32位和64位

database 是数据库,你安装到本机上,可以在本机上创建数据库。client是客户端,你只能通过client连接上别人机器上的数据库。database 包含client的功能。 instant client是轻量级的client

下载一个instant client就行

3.配置环境变量

路径D:...\Oracle\Instant Client\bin添加到系统变量中

  1. 修改Instant Client的配置

Oracle服务器的配置地址:D:...\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File.
# Generated by Oracle configuration tools.

# Sample:
#DatabaseName =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = ServiceName)
#      (INSTANCE_NAME = InstanceName)
#    )
#  )

# Modify the following content to fit your own needs.
ORCL=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL
    )
  )

localhost 替换成你真实的oracle数据库ip

  1. 去pcel下载正确的php_oci_8.dll

pecl.php.net/package/oci…

根据php版本号(5.x/7.x),x64和x86,NTS和TS来选择正确的文件,放入对应php/ext文件夹中