没 SID 就这样配置

$hostname = 'localhost';
$username = 'user';
$password = 'pass';
$database = 'db';

$datastr = "(description=(address=(protocol=tcp)
(host=".$hostname.")(port=1521))
(connect_data=(service_name=".$database.")))";

if(!$link = oci_connect($username,$password,$datastr)) {
die('Can not connect to Oracle server');
}

$sql = "select * from uset_tabs";
$result = oci_parse($link,$sql);
oci_execute($result);
$res = oci_fetch_array($result, OCI_ASSOC);
print_r($res);