PDO_OCI-DSN(3) 1 PDO_OCI-DSN(3)
PDO_OCI DSN - Connecting to Oracle databases
The PDO_OCI Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is oci:.
o dbname (Oracle Instant Client) - The URI for the Oracle Instant Client connection takes the form of dbname=//$hostname:$port-num-
ber/$database. If you are connecting to a database defined in tnsnames.ora, use only the name of the database: dbname=$database.
o charset - The client-side character set for the current environment handle.
Example #1
PDO_OCI DSN examples
The following examples show a PDO_OCI DSN for connecting to Oracle databases:
// Connect to a database defined in tnsnames.ora
oci:dbname=mydb
// Connect using the Oracle Instant Client
oci:dbname=//localhost:1521/mydb
PHP Documentation Group PDO_OCI-DSN(3)