gini pak sultan, di server IBM AIX saya ada 2 oracle database dan 1 application server 10g R3 yg saya install dgn user oracle group oinstall environment variable saya, di set sbg berikut : *********environment variabel user oracle*********************************** PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # periodically. umask 022 AIXTHREAD_SCOPE=S; export AIXTHREAD_SCOPE ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ******************************************************************************* lalu bila saya ingin running database 10g, saya set ORACLE_HOME=/u01/app/oracle/10.2/db_1 ORACLE_SID=SID kemudian ketik command sqlplus /nolog pada prompt, dia langsung masuk sql prompt, kemudian saya startup. $sqlplus /nolog SQL> startup database 10g running kemudian jalankan listener (apakah listener di jalankan setelah yg 8i running atau tidak perlu, karena biar ada 2 db tp listener yg aktif hanya satu ?)
kemudian, saya jalankan oracle 8i, saya set ORACLE_HOME=/u01/app/oracle/product/8.1.7 ORACLE_SID=SID1 kemudian ketik command sqlplus /nolog pada prompt, muncul eror seperti berikut : exec(): 0509-036 Cannot load program > /u01/app/oracle/product/8.1.7/bin/sqlplus because of the following errors: > 0509-130 Symbol resolution failed for sqlplus because: > 0509-136 Symbol pw_post (number 278) is not exported from > dependent module /unix. > 0509-136 Symbol pw_wait (number 279) is not exported from > dependent module /unix. > 0509-136 Symbol pw_config (number 280) is not exported from > dependent module /unix. > 0509-136 Symbol aix_ora_pw_version3_required (number 281) is not > exported from > dependent module /unix. > 0509-192 Examine .loader section symbols with the > 'dump -Tv' command. terima kasih atas responnya, mohon bantuannya :) 2008/2/27 Sulthan Hakim <[EMAIL PROTECTED]>: > bisa jelasin lebih detail lagi? Di dalam server IBM machine anda ada 2 > oracle db yang aktif yaitu Oracle8i dan Oracle 10g,right > So Apakah benar asumsi saya, anda membuat 2 mountpoint yang berbeda > untuk masing2 oracle? > > > Andes Febrian wrote: > > > > Dear all, > > > > mohon pencerahannya, ketika saya ketik $ sqlplus /nolog pada oracle 8i > di > > server IBM AIX 5L, muncul eror : > > > > exec(): 0509-036 Cannot load program > > /u01/app/oracle/product/8.1.7/bin/sqlplus because of the following > errors: > > 0509-130 Symbol resolution failed for sqlplus because: > > 0509-136 Symbol pw_post (number 278) is not exported from > > dependent module /unix. > > 0509-136 Symbol pw_wait (number 279) is not exported from > > dependent module /unix. > > 0509-136 Symbol pw_config (number 280) is not exported from > > dependent module /unix. > > 0509-136 Symbol aix_ora_pw_version3_required (number 281) is not > > exported from > > dependent module /unix. > > 0509-192 Examine .loader section symbols with the > > 'dump -Tv' command. > > > > mgkn ada teman2 yg punya pengalaman seperti ini dan sudah punya > solusinya, > > googling gak nemu, account metalink gak punya :( terima kasih. > > > > nb : envi di IBM AIX saya, > > sebelum menjalankan sqlplus /nolog, saya lakukan langkah2 berikut, > > karena di > > .profile blm di set oracle home. > > $ ORACLE_HOME=/u01/app/oracle/product/8.1.7 > > $ export ORACLE_HOME > > $ sqlplus /nolog > > diserver IBM AIX ini jg terdapat 10g database dan sudah running, > > ketika saya > > jalankan. (tidak ada masalah) > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > > > Send instant messages to your online friends > http://asia.messenger.yahoo.com > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
