Weird error !! An error occurred while connecting to oracle in adodb but PLSQl can be normally connected & lt; B & gt; Warning & lt; B & gt;: ocilogon () & nbsp; adodbdriversadodb-oci8.inc.php & lt; B & gt; online & lt; B & gt; 244 & lt; B & gt; & lt; br & gt; 172.17.6 strange error !! An error occurred while connecting adodb to oracle. However, PL/SQL can be used for normal connection.
Warning: Ocilogon ()
\ Adodb \ drivers \ adodb-oci8.inc.phpOn line
244
172.17.66.11: 1521: ORA-12505: TNS: the listener cannot currently recognize the SID given in the connection descriptor
The configuration of tnsnames. ora is as follows:
KFDBRAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.17.66.11) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = kfdbrac)
)
)
The listener. ora configuration is as follows:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = admin-PC) (PORT = 1521 ))
)
)
Self: $ conn = & ADONewConnection ("oci8 ");
Self: $ conn-> Connect ('192. 17.66.11: 100', 'tyyy', 'tyyy', 'fdbrac ');
A data cluster is created on 172.17.66.11.
------ Solution --------------------
Kfdbrac
------ Solution --------------------
Try ocr instead.
I have not connected to oracle in the adodb + oci8 mode
The value has been in the PDO + ocr mode.
------ Solution --------------------
Ado + oracle is high.