doufeikuang7724 2016-01-20 07:56
浏览 80

oci connect():ORA-12154

I'm having trouble with Oracle connection , I'm facing the error message : oci connect(): ORA-12154 I'm using Xampp port:80 oracle g11 express PHP 5.5.30

package installed is:

OCI8 Support enabled OCI8 DTrace Support disabled OCI8 Version 2.0.8

Oracle Run-time Client Library Version 11.2.0.4.0 Oracle Compile-time Instant Client Version 11.2

my app\oracle\product\11.2.0\server etwork\ADMIN

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = GLORY-PC)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 

the test code is:

$conn = oci_connect('hr', 'hr123', 'XE');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e\['message'\] , ENT_QUOTES), E_USER_ERROR);
}
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
echo "
<table border='1'>

";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
    echo "
<tr>

";
    foreach ($row as $item) {
        echo "
<td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>

";
    }
    echo "
</tr>

";
}
echo "
</table>

";

thank you

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 outlook无法配置成功
    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题