Pake spfile mas bowo...scope=spfilenya emang harus disertakan, udah solved mas...makasih.
----- Original Message ----- From: "Yulius Wibowo" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, April 06, 2006 4:44 PM Subject: [indo-oracle] Re: Thread 1 cannot allocate new log ???...help pliz. > Pakai init<SID>.ora or spfile<SID>.ora Mas? > > SQL> show parameter spfile > kalau nilainya blank, artinya menggunakan init<SID>.ora > berarti anda harus edit file init<SID>.ora tsb dng system editor. > kemudian restart database instancenya. > > Kalau menggunakan SPFILE > SQL> ALTER SYSTEM SET log_archive_start=TRUE SCOPE=SPFILE; > SQL> startup force > SQL> ARCHIVE LOG LIST > > Bowo > > > --- In [email protected], "Toni Iskandar" <[EMAIL PROTECTED]> wrote: >> >> Dear members.... >> >> ----- Original Message ----- >> From: "Yulius Wibowo" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Wednesday, April 05, 2006 3:24 PM >> Subject: [indo-oracle] Re: Thread 1 cannot allocate new > log ???...help pliz. >> >> >> > Coba parameter LOG_ARCHIVE_START nya di set TRUE >> > >> > SQL> conn / as sysdba >> > SQL> show parameter log_archive_start >> > >> >> hasil eksekusi perintah ini : >> log_archive_start = FALSE >> >> > SQL> ALTER SYSTEM SET log_archive_start = TRUE; >> >> Pada saat perintah ini di execute ada error sbb: >> ORA-02095 : specified initialization parameter cannot be modified. >> >> kenapa ya....gimana solusinya ???? >> >> > >> > atau >> > >> > SQL> ARCHIVE LOG START >> > >> >> Perintah ini berhasil di eksekusi, Tetapi apabila komputer di > restart >> maka parameter Automatic Archival menjadi disable kembali karena > waktu >> perintah show parameter log_archive_start di eksekusi lagi maka > nilai >> log_archive_start = FALSE >> >> SQL> archive log list; >> Database log mode Archive Mode >> Automatic Archived Enabled >> Archive Destination C:\oracle\oradata\dbspmp\archivelog >> >> SQL> show parameter log_archive_start; >> >> log_archive_start = FALSE >> >> apakah kalau nilai Automatic Archival Enable maka nilai >> log_archive_start = TRUE ??? >> >> Mohon bantuannya lagi nih...rekan2. >> >> Thanks a lot >> >> > CMIIW; >> > >> > Bowo; >> > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.385 / Virus Database: 268.3.5/302 - Release Date: 4/5/2006 > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
