안녕들 하신지요.
1주만에 리눅스에 오라클 8.1.6을 setting 하였습니다.php와 함께요.
간단한 테스트는 다 다되는데.
php와 연동이되지 않군요....
에러내용과 소스를 올립니다.
Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12545 in /home/httpd/html/oracle/serverversion.php on line 6
Warning: Supplied argument is not a valid OCI8-Connection resource in /home/httpd/html/oracle/serverversion.php on line 7
Server version :
PHP Version 4.0.3pl1
System Linux oracle.linux 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown
Build Date Jan 17 2001
Configure Command './configure' '--with-oci8=/u01/app/oracle/products/8.1.6' '--with-oracle=/u01/app/oracle/products/8.1.6' '--with-mysql=/usr/local/mysql' '--with-apache=/parksh/apache_1.3.14' '--with-gd=/usr/local/gd' '--with-imap=/usr/local/imap' '--with-libpng=/usr/local/libpng' '--with-informix=/home/informix' '--enable-sigchild' '--with-language=korean' '--with-charset=euc_kr' '--with-config-file=/usr/local/lib' '--enable-track-vars' '--disable-debug'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/lib
ZEND_DEBUG disabled
Thread Safety disabled
oracle
Oracle Support enabled
Oracle Version 8.1
Compile-time ORACLE_HOME /u01/app/oracle/products/8.1.6
Libraries Used
oci8
OCI8 Support enabled
Revision $Revision: 1.97 $
Oracle Version 8.1
Compile-time ORACLE_HOME /u01/app/oracle/products/8.1.6
Libraries Used
이렇게는 나오는 것 같고 그리고 slqplus가 되고 있습니다...
다음은
oracle .bash_profile 설정 내용입니다..
export display=localhost:0.0
export USERNAME BASH_ENV PATH
export ORACLE_OWNER=oracle;export ORACLE_OWNER
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/products/8.1.6
export ORACLE_SID=ORCL
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/jre/bin:$ORACLE_HOME:/usr/local:/usr/local/jdk/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
export CLASSPATH=/usr/local/jre/bin:$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib:/usr/local/jre:/usr/local/jdk/lib/classes.zip:/usr/l
ocal/jre/bin
umask 022
mesg n
그럼 수고 하시구요
저는
20000
1 <html>
2 <body>
3
4 <?php
5
6 $conn = OCILogon("php","oracle");
7 print "Server version : " .OCIServerVersion($conn);
8 OCILogOff($conn);
9
10 ?>
11
12 </body>
13 </html>
14
15
|