[oracle] 오라클 apache 연동 설정

*tnsname.ora 내용

$user_name = "php";

$password = "php";

$server = "oracle";

$conn=oci_connect($user_name, $password, $server);

*conn.php

# 우리는 conn.php 으로 만든다.

<?

$server = "(DESCRIPTION =

            (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.10.155)(port = 1521))

            (CONNECT_DATA = (SID = DB12))

            )";

$user_name = "php";

$password = "php";

$conn=@oci_connect($user_name, $password, $server) or die('Could not connect:');

echo("Oracle 12c \$conn : $conn<br>");

$st=oci_server_version($conn);

echo("$st<br>");

echo("<hr>");

show_source(__FILE__);

?>

유저를 만들어준다.

php / php

CREATE USER php

IDENTIFIED BY php

DEFAULT TABLESPACE users

TEMPORARY TABLESPACE temp

QUOTA UNLIMITED ON users;

GRANT connect, resource, create view to php;

*확인