shutdown 했는데, 정상적인 셧다운이 안되서 강제로 오라클 프로세스들 kill
시스템 재부팅! 요거 클러스터에 오라클 HA구성이란걸 몰라서 한시간 헤맸다.
암튼, 도움을 받아 겨우겨우 부팅해서 오라클 실행(startup)시키니
ora-01081 에러
shutdown abort; 한후 다시 startup
일단 된다… ㅠㅠ
9월 12
ora-01081
9월 08
AIX clone (링크)
찾는 HP-UX는 안나오고…
원래 제목은
Cloning a rootvg using alternate disk installation
없어질지도 모르니(IBM)에서 운영하니 그럴리야 없겠지만..
Using this scenario, you can clone AIX® running on rootvg to an alternate disk on the same system, install a user-defined software bundle, and run a user-defined script to customize the AIX image on the alternate disk.
Things to Consider
| The information in this how-to scenario was tested using specific versions of AIX. The results you obtain might vary significantly depending on your version and level of AIX. |
Because the alternate disk installation process involves cloning an existing rootvg to a target alternate disk, the target alternate disk must not be already assigned to a volume group.
In this scenario you will do the following:
- Prepare for the alternate disk installation
- Perform the alternate disk installation and customization
- Boot off the alternate disk
- Verify the operation
For information about alternate disk installation, see Installing to an alternate disk. Also, refer to thealt_disk_copy man page.
Step 1. Prepare for the alternate disk installation
- Check the status of physical disks on your system. Type:
# lspv
Output similar to the following displays:
hdisk0 0009710fa9c79877 rootvg active hdisk1 0009710f0b90db93 None
We can use hdisk1 as our alternate disk because no volume group is assigned to this physical disk.
- Check to see if the alt_disk_copy fileset has been installed by running the following:
# lslpp -L bos.alt_disk_copy.rte
Output similar to the following displays if the alt_disk_copy fileset is not installed:
lslpp: 0504-132 Fileset bos.alt_disk_copy.rte not installed.
- Using volume 1 of the AIX installation media, install the alt_disk_copy fileset by running the following:
# geninstall -d/dev/cd0 bos.alt_disk_copy.rte
Output similar to the following displays:
+-----------------------------------------------------------------------------+ Summaries: +-----------------------------------------------------------------------------+ Installation Summary -------------------- Name Level Part Event Result ------------------------------------------------------------------------------- bos.alt_disk_copy.rte 5.3.0.0 USR APPLY SUCCESS - Create a user-defined bundle called /usr/sys/inst.data/user_bundles/MyBundle.bnd that contains the following filesets:
I:bos.content_list I:bos.games
For more information on how to create a user-defined software bundle, refer to Creating and installing a software bundle.
- Create the /home/scripts directory:
mkdir /home/scripts
- Create a user-defined customization script called AddUsers.sh in the /home/scripts directory:
touch /home/scripts/AddUsers.sh chmod 755 /home/scripts/AddUsers.sh
- Edit /home/scripts/AddUsers.sh to contain the following lines:
mkuser johndoe touch /home/johndoe/abc.txt touch /home/johndoe/xyz.txt
Step 2. Perform the alternate disk installation and customization
- To clone the rootvg to an alternate disk, type the following at the command line to open the SMIT menu :
# smit alt_clone
- Select hdisk1 in the Target Disk to Install field.
- Select the MyBundle bundle in the Bundle to Install field.
- Insert volume one of the installation media.
- Type /dev/cd0 in the Directory or Device with images field.
- Type /home/scripts/AddUsers.sh in the Customization script field.
- Press Enter to start the alternate disk installation.
- Check that the alternate disk was created, by running the following:
# lspv
Output similar to the following displays:hdisk0 0009710fa9c79877 rootvg hdisk1 0009710f0b90db93 altinst_rootvg
Step 3. Boot from the alternate disk
- By default, the alternate-disk-installation process changes the boot list to the alternate disk. To check this run the following:
# bootlist -m normal -o
Output similar to the following displays:
hdisk1
- Reboot the system. Type:
# shutdown -r
The system boots from the boot image on the alternate disk (hdisk1).
Step 4. Verify the operation
- When the system reboots, it will be running off the alternate disk. To check this, type the following:
# lspv
Output similar to the following displays:
hdisk0 0009710fa9c79877 old_rootvg hdisk1 0009710f0b90db93 rootvg
- Verify that the customization script ran correctly, by typing the following:
# find /home/johndoe -print
Output similar to the following displays:
/home/johndoe /home/johndoe/.profile /home/johndoe/abc.txt /home/johndoe/xyz.txt
- Verify that the contents of your software bundle was installed, by typing the following:
# lslpp -Lb MyBundle
Output similar to the following displays:
Fileset Level State Description ---------------------------------------------------------------------------- bos.content_list 5.3.0.0 C AIX Release Content List bos.games 5.3.0.0 C Games
Parent topic: How-To’s for AIX Installation Tasks
9월 06
DNS 점검 사이트
http://202.30.50.200/information/inspection_2.0.jsp
위에서 점검하면 수정 가이드라인이 나옴.
별게 다 있어.. ;^^
8월 22
AIX disk mirror -링크
AIX에서 미러디스크 교체하는 방법.
http://www.unix.com/aix/30039-replace-failed-root-disk-aix.html
8월 12
반드시 알아둘 AIX 명령
“반드시 알아둘 AIX 명령” 이란 제목의 글.
링크: http://www.ibm.com/developerworks/kr/library/au-dutta_cmds.html
아래는 “필수 AIX 명령어”
링크 : http://www.ibm.com/developerworks/kr/library/dutta_cmds.html
8월 05
oracle 패치후 에러..
오라클 잘 설치하고 패치까지 했는데,
ora-01092 에러 발생.
찾아보니, 오라클 엔진만 패치되고 데이타베이스가 패치되지 않아서 그렇다고 한다.
해결책은?
$sqlplus /nolog
SQL> conn /as sysdba
SQL> startup upgrade;
SQL>@$ORACLE_HOME/rdbms/admin/catupgrd.sql
…..
한시간 이상 걸림.. …
아무튼 끝나고나면 shutdown immediate;
이후 startup 했는데 ora-16038발생
처리후,
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> exit
$ORACLE_HOME/install/changePerm.sh 실행
7월 28
v480 디스크 교체.
운영중인 sun v480 서버의 디스크가 고장났을때, 아래와 같은 절차로 교체.
디스크는 내부 FCAL 디스크 2개이며, mirror 구성되어 있다. 때문에, 디스크 교체후 mirror를 구성해 주어야 한다.
1. 디스크의 교체(핫스왑)
먼저, iostat -en 으로 고장 디스크 확인.
—- errors —-
s/w h/w trn tot
…
1 0 0 0 c1t0d0
0 13 126 139 c1t1d0
luxadm으로 디스크 제거.
luxadm -e remove_device -F /dev/rdsk/c1t1d0s2
WARNING!! please ensure that no filesystem are mounted on these device(s).
All data on these devices should have been backed up.
Error: SCSI failure. – /dev/rdsk/c1t1d0s2
luxadm -e offline /dev/rdsk/c1t1d0s2
devctl: I/O error
디스크가 이미 고장이므로 luxadm이 정상작동 하지 않았다.
그래서, 그냥 디스크 빼고 새 디스크로 교체.
바로 online 메시지 나오면서 인식.
이후 mirror작업수행.
2. 미러작업 완료후, Resync 중에 시스템을 종료해야만 했다. 이후 재 부팅과정에서 문제가 발생했다.
stale databases …
single user모드로 부팅이 되며, fsck 로도 해결되지 않았음. single모드에서 아래 커맨드 수행
metadb
metadb -d /dev/dsk/c1t1d0s7
s7이 메타디바이스영역.
이후 정상 부팅후,
metadb -a /dev/dsk/c1t1d0s7
이후 metastat 로 확인해보면, resyncing되는것을 확인.
혹시나해서 검색해보니,
http://download.oracle.com/docs/cd/E19455-01/806-3205/troubleshoottasks-38/index.html
6월 24
ubuntu10.10 에러 메시지
메일로 자꾸 아래와 같은 메시지가 전송되어 왔다.
PHP Deprecated: Comments starting with ‘#’ are deprecated in /etc/php5/cli/conf.d/idn.ini on line 1 in Unknown on line 0
PHP Deprecated: Comments starting with ‘#’ are deprecated in /etc/php5/cli/conf.d/ming.ini on line 1 in Unknown on line 0
결론은 각각의 ini화일의 주석처리 # 이 되지 않는다는 내용. #을 ;로 바꾸니 모두 해결.
영어만 잘 해석하면 됨 ^^
6월 23
solaris lvm mirror – 스크랩
구성…
http://blog.naver.com/comki/100024647947
복구
http://www.brandonhutchinson.com/Replacing_a_disk_with_different_geometry_in_DiskSuite.html
내가 해본것.
원본디스크: c0t0d0s2 대상디스크: c0t1d0s2
원본디스크의 파티션 (7번 슬라이스는 md를 위한 공간으로 16MB잡았음)
partition> p
Current partition table (original):
Total disk cylinders available: 47994 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 root wm 352 – 27391 38.47GB (27040/0/0) 80687360
1 swap wu 0 – 351 512.88MB (352/0/0) 1050368
2 backup wm 0 – 47993 68.29GB (47994/0/0) 143214096
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 27392 – 34255 9.77GB (6864/0/0) 20482176
6 unassigned wm 34256 – 47982 19.53GB (13727/0/0) 40961368
7 unassigned wm 47983 – 47993 16.03MB (11/0/0) 32824
1. 디스크 미러 만들기
prtvtoc /dev/rdsk/c0t0d0s2 | fmthard -s – /dev/rdsk/c0t1d0s2
여기서 두 디스크의 모델이 서로 달라서 에러 발생. 이것은 두번째 문서를 참조하여, 같은 모델로 설정함.
format -> disk -> 1 -> type -> …..
디스크 파티션은 아래와 같음
/dev/dsk/c0t0d0s1 – – swap – no –
/dev/dsk/c0t0d0s0 /dev/rdsk/c0t0d0s0 / ufs 1 no –
/dev/dsk/c0t0d0s5 /dev/rdsk/c0t0d0s5 /oracle ufs 2 yes –
/dev/dsk/c0t0d0s6 /dev/rdsk/c0t0d0s6 /oradata ufs 2 yes –
swap – /tmp tmpfs – yes –
작업내용
metadb -a -f -c 2 /dev/dsk/c0t0d0s7 /dev/dsk/c0t1d0s7
metainit -f d10 1 1 c0t0d0s0
metainit -f d20 1 1 c0t1d0s0
metainit d0 -m d10
metaroot d0
lockfs -fa
metainit -f d11 1 1 c0t0d0s1
metainit -f d21 1 1 c0t1d0s1
metainit d1 -m d11
metainit -f d 15 1 1 c0t0d0s5
metainit -f d15 1 1 c0t0d0s5
metainit -f d25 1 1 c0t1d0s5
metainit d5 -m d15
metainit -f d16 1 1 c0t0d0s6
metainit -f d26 1 1 c0t1d0s6
metainit d6 -m d16
/etc/vfstab 을 편집
/dev/md/dsk/d1 – – swap – no –
/dev/md/dsk/d0 /dev/md/rdsk/d0 / ufs 1 no –
/dev/md/dsk/d5 /dev/md/rdsk/d5 /oracle ufs 2 yes –
/dev/md/dsk/d6 /dev/md/rdsk/d6 /oradata ufs 2 yes –
swap – /tmp tmpfs – yes –
그리고 재부팅 후 나머지 슬라이스를 메타디바이스에 추가해준다.
metattach d0 d20
metattach d1 d21
metattach d5 d25
metattach d6 d26
# metastat
d6: Mirror
Submirror 0: d16
State: Okay
Submirror 1: d26
State: Resyncing
Resync in progress: 17 % done
Pass: 1
Read option: roundrobin (default)
Write option: parallel (default)
Size: 40961368 blocks (19 GB)
d16: Submirror of d6
State: Okay
Size: 40961368 blocks (19 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t0d0s6 0 No Okay Yes
d26: Submirror of d6
State: Resyncing
Size: 40961368 blocks (19 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t1d0s6 0 No Okay Yes
d5: Mirror
Submirror 0: d15
State: Okay
Submirror 1: d25
State: Resyncing
Resync in progress: 79 % done
Pass: 1
Read option: roundrobin (default)
Write option: parallel (default)
Size: 20482176 blocks (9.8 GB)
d15: Submirror of d5
State: Okay
Size: 20482176 blocks (9.8 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t0d0s5 0 No Okay Yes
d25: Submirror of d5
State: Resyncing
Size: 20489378 blocks (9.8 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t1d0s5 0 No Resyncing Yes
d1: Mirror
Submirror 0: d11
State: Okay
Submirror 1: d21
State: Okay
Pass: 1
Read option: roundrobin (default)
Write option: parallel (default)
Size: 1050368 blocks (512 MB)
d11: Submirror of d1
State: Okay
Size: 1050368 blocks (512 MB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t0d0s1 0 No Okay Yes
d21: Submirror of d1
State: Okay
Size: 1051466 blocks (513 MB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t1d0s1 0 No Okay Yes
d0: Mirror
Submirror 0: d10
State: Okay
Submirror 1: d20
State: Resyncing
Resync in progress: 0 % done
Pass: 1
Read option: roundrobin (default)
Write option: parallel (default)
Size: 80687360 blocks (38 GB)
d10: Submirror of d0
State: Okay
Size: 80687360 blocks (38 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t0d0s0 0 No Okay Yes
d20: Submirror of d0
State: Resyncing
Size: 80687360 blocks (38 GB)
Stripe 0:
Device Start Block Dbase State Reloc Hot Spare
c0t1d0s0 0 No Okay Yes
2. dd로 두번째 디스크 에러 유발
dd if=/dev/zero of=/dev/dsk/c0t1d0s2
이후, prtvtoc로 두번째 디스크의 파티션을 재 설정하고, 각각의 서브미러를 replace해준다.
metareplace -e d5 c0t1d0s5
metareplace -e d6 c0t1d0s6
metareplace -e d0 c0t1d0s0
metareplace -e d1 c0t1d0s1
만약 제대로 수행이 안된다면, 메타디바이스에서 분리(metadetach)후, 삭제(metaclear)하고, 다시 만들어줌(metainit)
metadetach -f d0 d20
metaclear d20
metainit -f d20 1 1 c0t1d0s0