- php.ini
打开extension=php_oci8.dll
打开extension=php_pdo_oci.dll
- 下载安装oracle 注意区分版本32位和64位
database 是数据库,你安装到本机上,可以在本机上创建数据库。client是客户端,你只能通过client连接上别人机器上的数据库。database 包含client的功能。 instant client是轻量级的client
下载一个instant client就行
3.配置环境变量
路径D:...\Oracle\Instant Client\bin添加到系统变量中
- 修改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
- 去pcel下载正确的php_oci_8.dll
根据php版本号(5.x/7.x),x64和x86,NTS和TS来选择正确的文件,放入对应php/ext文件夹中