Senin, 26 Desember 2022

Troubleshoot Oracle Machine Off (fmadm faulty)

Tekan tombol # + tombol . untuk masuk ke dalam Server Oracle


-> show /

-> show /HOST

-> show /SYS

-> show /STORAGE

-> show /SYSTEM

-> show /SP

-> show faulty


-> start /SYS

Are you sure you want to start /SYS (y/n)? y

start: System faults or hardware configuration prevents power on.


-> start /SP/faultmgmt/shell

Are you sure you want to start /SP/faultmgmt/shell (y/n)? y


faultmgmtsp> fmadm faulty


faultmgmtsp> fmadm faulty -s


faultmgmtsp> exit


-> set /SYS/MB clear_fault_action=true

Are you sure you want to clear /SYS/MB (y/n)? y

Set 'clear_fault_action' to 'true'


-> start /SP/faultmgmt/shell

Are you sure you want to start /SP/faultmgmt/shell (y/n)? y


faultmgmtsp> fmadm repair /SYS/MB


faultmgmtsp> fmadm faulty

No problems found


faultmgmtsp> exit


-> start /SYS

Are you sure you want to start /SYS (y/n)? y

Starting /SYS


=========Command Masuk OS====================================

-> start /HOST/console

Are you sure you want to start /HOST/console (y/n)? y

Serial console started.  To stop, type #.

console login: abc

Password:


-bash-3.2$ su -

Password:

# bash


Atau 


->start /SP/console


=========Command Collect Data Explorer pertama kali===========

->explorer -g


=========Command Masuk Bash===================================

# su - oracle

-bash-3.2$ pwd

-bash-3.2$ ls

-bash-3.2$ ps -ef

-bash-3.2$ ps -ef | grep xfile

-bash-3.2$ status

-bash-3.2$ exit

logout


Terima kasih banyak untuk rekan kerja saya yang sudah berbaik hati mengajarkan ilmu ini.


Command Check Hardware HP

#hostname

#date

#uname -a

#ps -aux

#cat /etc/*release

#cat /etc/SuSE-release


#cd /opt/ahs/AHSdownload

#hpasmcli

>show server

>show powersupply

>show temp

>show iml

>exit


#cd /patch

#ls -lrth

#hplog -v

Command SAN Switch

alishow

bcastshow

cfgactvshow

cfgshow

chassisshow

configshow

datatypeshow

dbgshow

diagshow

errmoduleshow

fabricshow

fabstatsshow

fanshow

fdmishow

firmwarekeyshow

fspfshow

historylastshow

historyshow

ifmodeshow

ipaddrshow

licenseidshow

licenseshow

memshow

minispropshow

mscapabilityshow

nbrstateshow

nsaliasshow

nsallshow

nsshow

portbuffershow

portcfgshow

portenccompshow

porterrshow

portflagsshow

portlogconfigshow

portlogeventshow

portswapshow

porttestshow

psshow

secglobalshow

secstatsshow

sensorshow

sfpshow

supportshowcfgshow 

switchshow

switchstatuspolicyshow 

switchstatusshow 

syslogdipshow 

tempshow

topologyshow

trackchangesshow 

urouteshow

zoneshow

supportshow

=================================

ipaddrshow 

licenseidshow 

licenseshow 

memshow 

sensorshow 

sfpshow 

switchstatuspolicyshow

syslogdipshow

tempshow

topologyshow

trackchangesshow

urouteshow 

zoneshow 

psshow 

=============================

porterrshow : Cek CRC Error

switchshow : Cek Status Port

portperfshow [No. Port] : Cek Performa Port, Sample: portperfshow 3

portstatsshow 3 [No. Port] : Cek Status Port, portstatsshow 3

chassisshow : Cek Serial Number Perangkat

licenseshow : Cek Lisensi 

portstatsclear (No. Port: 12) : clear CRC Error status

Version : Cek Model Perangkat

uptime 

firmwareshow

portstatsshow

switchstatusshow

portcfgshow

portshow

switchname

supportshow: collect all log


How to Collect Explorer Data on Oracle Solaris

-bash-3.2$ bash

bash-3.2$ su -

Password:

# bash

# explorer

# ls /opt/SUNWexplo/bin/explorer

#ls /opt/SUNWexplo/output/

# exit

-> set /SP/diag/snapshot/ dump_uri=ftp://abc:abc@10.X.X.X/.

Set 'dump_uri' to 'ftp://abc:abc@10.X.X.X/.'

->

ORACLESP-abc login: root

Password:

-> show /SP/diag/snapshot/



Shutdown Server (Oracle) via Serial Console

>showdomainstatus -a : lihat status

>console -d 0 : Masuk OS

# init 6

#. kalau mau keluar dari OS

Poweroff di Solaris #init 6

Ganti disk dari A ke B buat dicek


Setelah ganti disk:

Cek lewat console server Oracle

#format : cek disk

#mount /dev/dsk/nama_disk_tambahs0_dibelakang

#vi /etc/system : edit filesystem


Linux Command for Checking a Server Performance

ifconfig

uname -a

ifconfig

ip addr

ip route

cat /etc/*release -

cat /etc/fstab

date

top

lscpu

df -h 

df -ih

vmstat -S M

lsblk

dmidecode -s system-serial-number

dmidecode | grep -i serial

dmidecode | grep -A3 '^System Information'

grep -i "hardware error" /var/log/mcelog

lvm pvscan

tail -f /var/adm/messages

tail -f /var/log/messages 

tail -f /var/log

tail -f /var/log/syslog

ls –al /var/crash/`hostname`/*

uptime

last | grep reboot

more /sys/class/fc_host/host?/port_state

free -h : check swap

HP-UX

uname -a

cat /etc/fstab

machinfo

ls -l /dev/rdsk | wc -l

diskinfo /dev/rdsk/namadisk

cat /etc/rc.config.d/netconf


command cari file berdasarkan tanggal

find . -printf "%T@ %Tc %p\n" | sort -n


===================================================

Tambahan untuk command Oracle OS


df -o i

prtdiag -v

zpool status

luxadm -e port

metastat

zoneadm list -icv

zpool list

zpool status

explorer -k -w default,smfextended,localzones,ldom

kdmrc

mpstat -P ALL