[HELP] oci_connect() errorrrrr!!!

Pertanyaan umum seputar distribusi Ubuntu yang menjadi distro wajib members ubuntu-indonesia.com
Post Reply
User avatar
dansmuser

[HELP] oci_connect() errorrrrr!!!

Post 18 Aug 2010, 20:20

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 !!!


User avatar
thrvers
Contact:

Post 18 Aug 2010, 20:32

'
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 -


User avatar
blackshirt
Contact:

Post 18 Aug 2010, 22:25

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.


User avatar
privatearun
Contact:

Post 18 Aug 2010, 22:49

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


User avatar
dansmuser

Post 18 Aug 2010, 23:48

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


User avatar
dansmuser

Post 18 Aug 2010, 23:53

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...


User avatar
dansmuser

Post 19 Aug 2010, 00:05

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 :)


User avatar
alib

Post 12 Oct 2011, 17:32

Mungkin sudah ketemu jawabannya yah, cuma mo share aja, kebetulan pake apache2, dbs oracle 10gR2, php5. Mudah2-an membantu


Post Reply

Who is online

Users browsing this forum: No registered users and 65 guests