[HELP] oci_connect() errorrrrr!!!

Pertanyaan umum seputar distribusi Ubuntu yang menjadi distro wajib members ubuntu-indonesia.com
User avatar
dansmuser
Posts: 4
Joined: 29 Mar 2010, 10:17
Location: Bandung

[HELP] oci_connect() errorrrrr!!!

Postby dansmuser » 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
Posts: 4458
Joined: 01 Jan 2010, 13:28
Location: Jombang, Indonesia
Contact:

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

Postby thrvers » 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
Posts: 2336
Joined: 02 Jan 2010, 17:00
Location: Solo dan Kebumen
Contact:

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

Postby blackshirt » 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
Posts: 61
Joined: 04 Feb 2010, 14:59
Location: Padang, Indonesia
Contact:

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

Postby privatearun » 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
Posts: 4
Joined: 29 Mar 2010, 10:17
Location: Bandung

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

Postby dansmuser » 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
Posts: 4
Joined: 29 Mar 2010, 10:17
Location: Bandung

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

Postby dansmuser » 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
Posts: 4
Joined: 29 Mar 2010, 10:17
Location: Bandung

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

Postby dansmuser » 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
Posts: 2
Joined: 21 Nov 2010, 21:50

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

Postby alib » 12 Oct 2011, 17:32

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

Return to “Pertanyaan Umum”

Who is online

Users browsing this forum: No registered users and 7 guests