1. periksa parameter UNDO
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS4
Continue reading
Tags: MOVE UNDO TABLESPACE, RENAME UNDO TABLESPACE, UNDO, UNDO TABLESPACE
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
Continue reading
Tags: MOVE TABLESPACE TEMP, RENAME TABLESPACE TEMP, TABLESPACE TEMP, TEMP
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
Continue reading
Tags: How to Change the Timezone in Linux, ntp, ntp client, ntp server, Setting the system clock, Setting your timezone, zone waktu
Gagal Mount pada card qla yang connect pada SAN
1. gagal mount
[root@test1 ~]# mount -t ocfs2 /dev/sdf1 /t03
mount.ocfs2: Device name specified was not found while opening device /dev/sde1
2. jika diperiksa dengan fdisk, partisi sebenarnya ada
[root@test1 ~]# fdisk -l
Disk /dev/sdf: 574.2 GB, 574228529152 bytes
255 heads, 63 sectors/track, 69812 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdf1 1 69812 560764858+ 83 Linux
3. periksa apakah module sudah di-load
[root@test1 ~]# lsmod | grep qla
qla2xxx 1080481 0
scsi_transport_fc 73673 2 qla2xxx,lpfc
scsi_mod 188665 7 qla2xxx,sg,lpfc,scsi_transport_fc,libata,aacraid,sd_mod
4. reload module qla2xx
[root@test1 ~]# modprobe -r qla2xxx
[root@test1 ~]# modprobe qla2xxx
[root@test1 ~]# lsmod | grep qla
qla2xxx 1080481 0
scsi_transport_fc 73673 2 qla2xxx,lpfc
scsi_mod 188665 7 qla2xxx,sg,lpfc,scsi_transport_fc,libata,aacraid,sd_mod
5. mount ulang
[root@test1 ~]# mount -t ocfs2 /dev/sdf1 /t03
Tags: Configuring QLogic adapter on Linux, Fibre Channel LUN rescan, Fibre Channel LUN rescan and QLogic, qla, qla2xxx, QLogic
Memanfaatkan HP iLO (Intergrated Light Out)
Dengan menggunakan HP iLO (Intergrated Light Out) kita dapat meremote server sejak booting BIOS pertama.
caranya ikuti langkah – langkah pada gambar di bawah ini :
1. pada saatHP server booting tekan F8
Tags: HP iLO, HP iLO (Intergrated Light Out), iLO, Intergrated Light Out, Remote
smbd[15529]: nss_ldap: reconnecting to LDAP server (sleeping ……)
error nss_ldap: reconnecting to LDAP server
mengatasinya cukup “mbulet” sampai server 2 hari “sakit parah” , karena jika dicek dengan menggunakan id nama_user kadang benar kadang salah jawabannya.
ternyata oh ternyata solusinya cukup “sadis” dengan cara :
A. BACKUP DULU DALAM FORMAT LDIF
[root@linux ~]# service ldap stop
[root@linux ~]# slapcat -l ldap_asli.ldif
B. RESTORE untuk recereate database baru
[root@linux ~]# rm /var/lib/ldap/* -f
[root@linux ~]# cp /etc/openldap/DB_CONFIG.example /var/lib/ldap/DB_CONFIG
[root@linux ~]# slapadd -l ldap_asli.ldif -f /etc/openldap/slapd.conf
[root@linux ~]# chown ldap.ldap /var/lib/ldap/*
Tags: nss_ldap, smbd[15529], smbd[15529]: nss_ldap:, smbd[15529]: nss_ldap: reconnecting to LDAP server, smbd[15529]: nss_ldap: reconnecting to LDAP server (sleeping ......)
oracleasm : change disk discovery path
dengan menambahkan / mengganti : /dev/oracleasm/disks/*
Tags: /dev/oracleasm/disks/*, change disk discovery path, oracleasm
solusi error pada oracle redo log
[oracle@orcl5 orcl5]$ sqlplus / as sysdba
SQL> startup;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2144944 bytes
Variable Size 1174406480 bytes
Database Buffers 469762048 bytes
Redo Buffers 7204864 bytes
Database mounted.
ORA-16014: log 2 sequence# 671 not archived, no available destinations
ORA-00312: online log 2 thread 1: ‘/u01/orcl5/redo02.log’
cara mengatasinya :
1. shutdown immediate
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Continue reading
Tags: error redo log, ORA-00312, ORA-16014, redo log, solusi error pada oracle redo log
setijoagus