心所嚮往的部落格

how to retrieve serial number of HP Proliant server by command line

The OS of HP Porliant Server is RHEL 6

(1) display the serial number of Oracle Sun's machine

root@XXX:/ > /usr/sbin/sneep
BEF1043XXX

(2) display the hardware spec. of Oracle Sun's machine

root@XXX:/ > /usr/sbin/prtdiag
System Configuration: Sun Microsystems sun4u SPARC Enterprise M5000 Server
System clock frequency: 1012 MHz
Memory size: 65536 Megabytes

==================================== CPUs ====================================

CPU CPU Run L2$ CPU CPU
LSB Chip ID MHz MB Impl. Mask
--- ---- ---------------------------------------- ---- --- ----- ----
00 0 0, 1, 2, 3, 4, 5, 6, 7 2530 5.5 7 161
00 1 8, 9, 10, 11, 12, 13, 14, 15 2530 5.5 7 161
01 0 32, 33, 34, 35, 36, 37, 38, 39 2530 5.5 7 161
01 1 40, 41, 42, 43, 44, 45, 46, 47 2530 5.5 7 161

============================ Memory Configuration ============================

Memory Available Memory DIMM # of Mirror Interleave
LSB Group Size Status Size DIMMs Mode Factor
--- ------ ------------------ ------- ------ ----- ------- ----------
00 A 16384MB okay 4096MB 4 no 2-way
00 B 16384MB okay 4096MB 4 no 2-way
01 A 16384MB okay 4096MB 4 no 2-way
01 B 16384MB okay 4096MB 4 no 2-way

========================= IO Cards =========================

LSB Name Model
--- -------------- ------------
00 scsi LSI,1064
00 network N/A
00 network N/A
00 network SUNW,pcie-qg
00 network SUNW,pcie-qg
00 network SUNW,pcie-qg
00 network SUNW,pcie-qg
00 SUNW,qlc QLE2462
00 SUNW,qlc QLE2462
01 scsi LSI,1064
01 network N/A
01 network N/A
01 SUNW,qlc QLE2462
01 SUNW,qlc QLE2462

==================== Hardware Revisions ====================

System PROM revisions:
----------------------

OBP 4.24.15 2010/09/29 10:16

=================== Environmental Status ===================

Mode switch is in UNLOCK mode

=================== System Processor Mode ===================

SPARC64-VII mode

Free GUI Tool to access sybase database

(1) downloading the jTDS driver from http://sourceforge.net/projects/jtds/?source=dlp

(2) launch SQL Developer and choose Tools -> Preferences -> Database -> Third Party JDBC driver -> Add Entry

(3) Add Sybase DB connection

(3) Display the content of Sybase table

Oracle Complains ORA-01157 and ORA-01110 errors.

# /etc/init.d/dbstart

Sun Microsystems Inc.   SunOS 5.8       Generic Patch   February 2004

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 5 15:46:33 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 1259835096 bytes

Fixed Size                   732888 bytes

Variable Size             486539264 bytes

Database Buffers          771751936 bytes

Redo Buffers                 811008 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file

ORA-01110: data file 2: '/oracle/oradata/XXX/undotbs01.dbf'

(1) Determining Which Datafiles got lost

COL df# FORMAT 999
COL df_name FORMAT a40
COL tbsp_name FORMAT a10
COL status FORMAT a7
COL error FORMAT a15

SQL> SELECT r.FILE# AS df#, d.NAME AS df_name, t.NAME AS tbsp_name, d.STATUS, r.ERROR, r.CHANGE#, r.TIME
2 FROM V$RECOVER_FILE r, V$DATAFILE d, V$TABLESPACE t WHERE t.TS# = d.TS# AND d.FILE# = r.FILE#;

DF# DF_NAME                                                     TBSP_NAME  STATUS  ERROR         CHANGE# TIME

---- --------------------                                                    ---------- ------- ---------- ---------- ---------

   2 /oracle/oradata/XXX/undotbs01.dbf    UNDOTBS1   ONLINE  FILE NOT FOUND            0

(2) Re-Creating Datafiles When Backups Are Not Available

### create temp tablespace then switch to this tablespace

SQL> CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/oracle/oradata/XXX/undotbs03.dbf' SIZE 25M REUSE AUTOEXTEND ON;

Tablespace created.

SQL> ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS3';

System altered.

### drop lost undo datafile 

SQL> alter database datafile '/oracle/oradata/XXX/undotbs01.dbf' offline drop;

Database altered.

SQL> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

### re-create undo tablespace

SQL> CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oracle/oradata/XXX/undotbs01.dbf' SIZE 25M REUSE AUTOEXTEND ON;

Tablespace created.

### switch back to original undo tablespace

SQL> ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS1';

System altered.

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 300
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1

金瓜石 白帶魚米粉湯 真情咖啡館 半日遊

跟隨三立電視台"青春好7淘"的二位可愛風趣的主持人，到這靜謐的小山城來一趟文化美食之旅。

耶~ 到了,讓老爺碎碎念的夢幻米粉湯,薑將將將~ 出場囉,炸過的白帶魚煮米粉湯,我還第一次看到,吃到 , 湯頭真是鮮甜阿那個芋頭也很搭~ 讓湯頭有飽足感

老爺說要是白帶魚季節再去吃的話,就完美了.

每碗 60 新台幣

青到爆的 酥炸透抽@@ 一開始想跟老闆商量,既然夠青就川燙好了,沒想到老闆堅持只有酥炸的, 一入口,天兒啊,撒花瓣(我怎麼會被阿松上身??),好像回到70.80年代的台灣,魂牽夢縈的古早味酥炸粉,我敢肯定不是毒澱粉喔!! 下次要自己帶醬油跟碟子去,請老闆給來一盤川燙的,一盤酥炸的,(握拳)

一份250新台幣,果然要付出代價滴@@ 

吃飽上路,走下階梯往金瓜石老街方向前進,我跟老爺就是那種行腳節目介紹的景,我們一定要找到的個性,不管日頭有多大,也曬不死我們的恆心與毅力. 天好熱喔@@.首先會先看到一家古老柑仔店,沒錯再往你的右手邊看,就是那個開小門的人家,勇敢的走進去就可以.

真情咖啡館 到了~

 我喜歡這片窗,一進門往裏頭看就是了

由館內往大門口的景 很有日式小屋的fu~(明明網友都說是南歐風,我不管~)

舒適大方桌餐廳(可惜偶爾會飄來廚房的油煙味)

回到勸濟堂前的階梯底,回頭眺望金瓜石,微風徐徐,讓人忘記日頭赤炎炎的酷暑當頭呢!!

台灣真是一個好所在XDDD

月河民宿(真情咖啡館)官方網站 http://moonriver.okgo.tw/

如何去呢?

※北向國道一號→瑞芳、暖暖交流道→62號快速道路→走台2線→右轉洞頂路→沿著金水公路前行→左轉勸濟堂→車可停在堂前空地→面對勸濟堂往邊看就會看到漂流木的裝飾小屋(對,不要還疑那就是到了)

無油無煙料理:鹽麴烤五花

觀看鹽麴這東西已經好幾年了,一直不懂日本人食用醃漬品那麼多,為何還是有那麼多壽村?另一方面,老是在家想說那個小黃瓜我弄一定不好吃,那個肉我弄一定不會入味之類的懶惰之詞,昨天晚上突然熱血沸騰,把冰箱好不容易收藏的一罐鹽麴拿出來當小黃瓜的夜間乳液,導致今天中午得已享用這麼輕鬆又好吃的午餐ㄋ,在炎熱的中午,吃上一碟冰鎮的小黃瓜片 真是透心涼阿

• 漬小黃瓜

1.主角小黃瓜一條

2.用家用鹽先揉搓一下

3.用水洗淨

4.拿出保鮮袋

5.把小黃瓜放進袋內再把二湯匙的鹽麴放進去

6.開始做黃瓜spa(時間隨性喔,都有閣到就行)

7.密封保鮮袋後 放進冰箱 冰鎮8小時以上

8.吃飯前先把小黃瓜拿出來洗澡,就可以切片上桌

•  鹽麴五花肉

1幾乎所有的流程 都跟小黃瓜一樣,除了2省略以外還有7時間改為一小時

(不要想揍我,就是懶惰才會活到現在才開始用blog記錄我的生活)

2.從小黃瓜的8開始接,洗完澡後擦乾,放進平底鍋乾煎,煎到鼻子聞到一股香氣就可以翻面

3.熟成取出後切片,再放進鍋子撒上芝麻跟紫蘇葉,拌勻即可.

4.想要吃辣的朋友 也可以在3這階段把辣椒加進去喔~  

test