ORA-00257: archiver error. Connect internal only, until freed

Pagi ini, server mainan saya mengalami error
1. ORA-00257: archiver error. Connect internal only, until freed
2. ORA-03113: end-of-file on communication channel

Saya pikir karena space harddisk-nya habis, setelah saya cek space harddisknya masih banyak.
tetapi ternyata karena saya melakukan update sebuah table yang jumlahnya ribuan.

Berikut kronologinya :
1. Gagal login
[oracle@test42 ~]$ sqlplus scott/TIGER
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 7 08:45:49 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

2. Shutdown instance
[oracle@test42 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 7 08:46:00 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SHUTDOWN immediate;
ORA-01013: user requested cancel of current operation

Dashboard dengan PHP-Oracle-Fusion Charts- Fusion Widgets – 5

Dashboard dengan PHP-Oracle-Fusion Charts- Fusion Widgets – 4

Dashboard dengan PHP-Oracle-Fusion Charts- Fusion Widgets – 3

Dashboard dengan PHP-Oracle-Fusion Charts- Fusion Widgets – 2

Dashboard dengan PHP-Oracle-Fusion Charts- Fusion Widgets – 1

MOVE UNDO TABLESPACE

1. periksa parameter UNDO
SQL> show parameter undo
NAME                                 TYPE        VALUE
———————————— ———– ——————————
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS4

MOVE TABLESPACE TEMP

1. periksa besaran TABLESPACE TEMP
SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
TABLESPACE_NAME                BYTES_USED BYTES_FREE
—————————— ———- ———-
TEMP                           3.4193E+10  165675008

screen linux

screen linux

ntp client beda zone waktu dengan ntp server

ntp client beda zone waktu dengan ntp server

kasus :
ntp server berada di indonesia bagian WIB
ntp client berada di indonesia bagian WIT

================================
setup pada sisi client
================================
1. cek ikut wilayah mana ?
[root@orcl6 ~]# date
Tue Dec 20 10:15:47 WIT 2011