Page 1 of 1

[HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 20:20
by dansmuser
sy sdh install oracle xe 10g, apache, php mengikuti ebook Underground Oracle-PHP-manual. namun ketika mencoba running koneksi oracle-PHP muncul error :
Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories in /usr/local/apache/htdocs/con_oracle.php on line 2

HELP please !!!

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 20:32
by thrvers
'
Dansmuser wrote:.......
check that ORACLE_HOME and LD_LIBRARY_PATH
.......
/usr/local/apache/htdocs/con_oracle.php on line 2
......

dari error na dah kliatan kek na :D cobain dolo

- maap q hanya tau sgitu -

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 22:25
by blackshirt
pastikan variabel environtment yang dimaksud sudah di set..
gunakan printenv untuk melihat apakah variabel dah diset,

dalam hal diatas, umumnya

Code: Select all

ORACLE_HOME=/path/ke/oracle; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
ORACLE_HOME merupakan variable environtmen yang digunakan oleh Oracle server untuk menset dan mendefinisikan path direktory server.

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 22:49
by privatearun
Dansmuser wrote:sy sdh install oracle xe 10g, apache, php mengikuti ebook Underground Oracle-PHP-manual. namun ketika mencoba running koneksi oracle-PHP muncul error :
Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories in /usr/local/apache/htdocs/con_oracle.php on line 2

HELP please !!!


topic bagus nih..,btw ntar kl sdh sukses, bikin tutor ya bro, trus share lg dsini... :D

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 23:48
by dansmuser
blackshirt wrote:pastikan variabel environtment yang dimaksud sudah di set..
gunakan printenv untuk melihat apakah variabel dah diset,

dalam hal diatas, umumnya

Code: Select all

ORACLE_HOME=/path/ke/oracle; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
ORACLE_HOME merupakan variable environtmen yang digunakan oleh Oracle server untuk menset dan mendefinisikan path direktory server.

kode yang dr kang blackshirt, sebelum sdh beberapa kali sy coba, dan for make sure saya pun export lagi :

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH

dan sy echo :
echo $ORACLE_HOME :==> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
echo $LD_LIBRARY_PATH :==> #/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib

begitupun sy cek dengan "printenv", ada dalam list

tp tetap errornya msh sama!!

dan sy cek di phpinfo(), dibagian OCI8 :
Compile-time ORACLE_HOME :==> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
namun di :
Libraries Used :==> no value


any other suggestion ??

trims

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 18 Aug 2010, 23:53
by dansmuser
blackshirt wrote:pastikan variabel environtment yang dimaksud sudah di set..
gunakan printenv untuk melihat apakah variabel dah diset,

dalam hal diatas, umumnya

Code: Select all

ORACLE_HOME=/path/ke/oracle; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
ORACLE_HOME merupakan variable environtmen yang digunakan oleh Oracle server untuk menset dan mendefinisikan path direktory server.
hehehe tq mamennn...

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 19 Aug 2010, 00:05
by dansmuser
privatearun wrote:
Dansmuser wrote:sy sdh install oracle xe 10g, apache, php mengikuti ebook Underground Oracle-PHP-manual. namun ketika mencoba running koneksi oracle-PHP muncul error :
Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories in /usr/local/apache/htdocs/con_oracle.php on line 2

HELP please !!!


topic bagus nih..,btw ntar kl sdh sukses, bikin tutor ya bro, trus share lg dsini... :D
hehehe insyallah :)

Re: [HELP] oci_connect() errorrrrr!!!

Posted: 12 Oct 2011, 17:32
by alib
Mungkin sudah ketemu jawabannya yah, cuma mo share aja, kebetulan pake apache2, dbs oracle 10gR2, php5. Mudah2-an membantu