1.配置database.php
'oracle' => [
// 服务名
'instance_name' => 'xe',
// 数据库类型
'type' => 'oracle',
// 服务器地址
'hostname' => '192.168.3.134',
// 数据库名
'database' => 'LCJZ',
// 用户名
'username' => 'LCJZ',
// 密码
'password' => 'a123456',
// 端口
'hostport' => '1521',
// 数据库编码默认采用utf8
'charset' => 'utf8',
// 数据库表前缀
'prefix' => '',
],
- 修改Thinkphp6 连接配置
原来
$dsn = 'oci:dbname=';
if (!empty($config['hostname'])) {
// Oracle Instant Client
$dsn .= '//' . $config['hostname'] . ($config['hostport'] ? ':' . $config['hostport'] : '') . '/'.$config['instance_name'];
}
$dsn .= $config['database'];
if (!empty($config['charset'])) {
$dsn .= ';charset=' . $config['charset'];
}
return $dsn;
改成
$dbstr = 'oci:dbname=';
$dbstr .="(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =".$config['hostname'].")(PORT = ".$config['hostport']."))(CONNECT_DATA =
(SERVICE_NAME = ".$config['instance_name'].")))"; //SERVICE_NAME连接类型,这里是用SID的方式连接
if (!empty($config['charset'])) {
$dbstr .= ';charset=' . $config['charset'];
}
return $dbstr;