Coba dicek satu persatu sbb: <Pada apps server> A1. Test koneksi ke listener menggunakan tnsping $> tnsping $TWO_TASK
Apakah OK? Kalau OK lanjut ke no.A2 kalau tidak lanjut ke B1. A2. Gunakan sqlplus $> sqlplus <appsusername/appspassword> Apakah OK? Kalau tidak OK, coba cek apakah password yg anda masukkan sudah betul. Kalau anda yakin password yg dimasukkan adalah betul atau tidak pernah anda rubah, coba lanjut ke B2. <Pada DB server> B1. Cek status dari listenernya. $> lsnrctl status $ORACLE_SID $> ps -ef | grep lsnr B2.Login sbg SYS, lalu ceck account status dari apps usernya. pastikan OPEN. Dari pengalaman, saya pernah mendapatkan problem yang sama, penyebabnya karena password dari apps-nya di lock. Ini terjadi setelah upgrade dari 9i ke 10g dan settingan failed login attempts nya masih diset DEFAULT (= 10x salah password-> account di locked) bw --- In [email protected], Mohammad Arief Pradipto <arief.pradi...@...> wrote: > > Apakah listener statusnya READY? > > lihat status listener ($> lsnrctl services) di server database yang > bersangkutan, apakah statusnya READY apa UNKNOWN? > coba restart listener, kemudian coba nyalakan ulang aplikasi > > regards, > > adipt > > ----- Original Message ----- > From: OL?<mailto:stikom.bo...@...> > To: [email protected]<mailto:[email protected]> > Sent: Wednesday, September 02, 2009 9:26 AM > Subject: Re: [indo-oracle] adstrtal.sh: exiting with status 1 > > > > Berat bangeut pertanyaannya > > OLA > > ----- Original Message ----- > From: Julisar Putra > To: [email protected]<mailto:[email protected]> > Sent: Tuesday, September 01, 2009 1:06 AM > Subject: [indo-oracle] adstrtal.sh: exiting with status 1 > > Halo rekan2, > > perkenalkan nama saya Yulisar, > > Saya menggunakan oracle application EBS R 12 (OS Oracle Enterprise Linux > 5.3), pagi ini saya mendapat kan error ketika saya mau coba Starting > Applications, errornya demikian : > ==================== STARTING APPLICATIONS ... ================== > > You are running adstrtal.sh version 120.13.12000000.3 > > adstrtal.sh: Database connection could not be established. Either the > database is down or the APPS credentials supplied are wrong. > > USAGE: adstrtal.sh <appsusername/appspassword> > > saya sudah mengecek script untuk eksekusi adstrtal.sh username/password => > apps/apps > > # > # Starting Application > # > > echo > echo ==================== STARTING APPLICATIONS ... ================== > echo > > DIRAPP=/u0/oracle/VIS/inst/apps/VIS_vision/admin/scripts > $DIRAPP/adstrtal.sh apps/apps > > untuk Database dan Listenernya Up, tetapi untuk aplikasinya ga bisa. > > mungkin rekan-rekan pernah mengalami hal yang sama, mohon informasinya, > atas perhatiannya saya ucapkan terima kasih > > Regards, > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > > > ________________________________ > This e-mail and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. If > you have received this email by mistake please notify the sender by return > e-mail and delete this message from your system. Any unauthorized use or > dissemination of this e-mail in whole or in part is strictly prohibited. PT > Federal International Finance, which has its seat at North of Jakarta, > Indonesia, including its affiliated companies, shall not be liable for the > improper or incomplete transmission of the information contained in this > e-mail nor for any delay in its receipt or damage to your system. PT Federal > International Finance (or its affiliated companies) does not guarantee that > the integrity of this communication has been maintained nor that this > communication is free of viruses, interceptions or interference. > > > [Non-text portions of this message have been removed] >
