bisa dicoba lakukan grant restricted session to <user>; ALTER SYSTEM ENABLE RESTRICTED SESSION; dari dokumentasi oracle : Do not enable both concurrent usage licensing and user licensing. Set either LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.
2010/5/3 Teguh Susanto <[email protected]> > > > ini saya kasih result dari query SELECT name,value FROM v$parameter WHERE > upper(name) like upper('%license%')license_max_sessions, > 200license_sessions_warning, 195license_max_users, 200 > --- Pada Sen, 3/5/10, I Nyoman Sukaryawan > <[email protected]<komang108%40gmail.com>> > menulis: > > Dari: I Nyoman Sukaryawan <[email protected] <komang108%40gmail.com>> > Judul: Re: [indo-oracle] OOT:Error ORA-00019: maximum number of session > licenses exceeded > Kepada: [email protected] <indo-oracle%40yahoogroups.com> > Tanggal: Senin, 3 Mei, 2010, 2:27 AM > > > tambahan lagi, > pastikan bila LICENSE_MAX_SESSIONS > 0 maka LICENSE_MAX_USERS harus = 0 > intinya, antara LICENSE_MAX_SESSIONS dan LICENSE_MAX_USERS salah satunya > harus 0 (CMIIW) > > utk kasus Teguh ini , mungkin lbh baik tambahkan privilege RESTRICTED > SESSION untuk user aplikasi. > > mungkin ada rekan lain pernah mengalami hal yg sama , boleh di share disini > > 2010/5/3 I Nyoman Sukaryawan <[email protected] <komang108%40gmail.com>> > > > coba check apakah parameter LICENSE_SESSIONS_WARNING nilainya > 0 ? > > LICENSE_MAX_SESSIONS baru di pakai bila parameter > LICENSE_SESSIONS_WARNING > > nilainya > 0 . > > > > bila tidak ingin muncul error tsb , maka set kedua parameter diatas > menjadi > > 0 > > atau tambahkan privilige RESTRICTED SESSION kepada user yg masih boleh > > connect walaupun session sudah melebihi nilai parameter > > LICENSE_MAX_SESSIONS. > > > > lebih lengkapnya silakan baca di dokumentasi mengenai kedua parameter ini > > > > > > 2010/5/3 Teguh Susanto <[email protected] <teguh4milis%40yahoo.com>> > > > >> > >> > >> kepada miliser&senior DBA oraclesaya kebetulan buat aplikasi connect dgn > >> oracle 9i, pernah terjadi erorr ORA-00019: maximum number of session > >> licenses exceeded akhirnya bisa saya atasi dengan meng > >> alter license_max_sessions=450 yang sebelumnya 200, tapi akhir2 ini > muncul > >> lagi error yang sama, kadang2 aplikasinya bisa connect tapi kadang2 > muncul > >> error itu lagiyang ingin saya tanyakan1.kenapa bisa terjadi error > >> ORA-000192.berapa settingan license_max_sessions yang ideal dan berapa > >> maximalnyaterima kasih > >> > >> [Non-text portions of this message have been removed] > >> > >> > >> > > > > > > [Non-text portions of this message have been removed] > > ------------------------------------ > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo <http://indo-thin.blogspot.comyahoo/>! > Groups Links > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
