Micro Focus Authorized Instructor

2017年2月12日 尚無評論

分享

自從 Novell 被 Micro Focus 併購後,我也好一陣子沒再針對 Novell 的產品與認證進行深究,前幾天收到 Micro Focus 寄來的新版講師證照,相關權益基本上與之前的 Novell CNI 相同,不過台灣現在很少 SUSE Linux課程了,所以發文紀念一下 ^^

 

修復 Oracle VM Manager DB 錯誤

2017年1月4日 尚無評論

分享

如果你的 Oracle VM Manager 控制中心檢視 Jobs List 時都出現空的畫面,或者是升級 Oracle VM Manager 時出現 “GEN_000000:An exception occurred during processing: No such object (level 1)” 錯誤訊息,那麼這可能告訴你目前的 MySQL Database 已經出錯了。Oracle VM Manager 有提供一個修復工具,讓你簡易的排除 ( 雖然是簡易,但實際上操作前最好記得備份 ),操作步驟如下所示 :

  1. 關閉你的 OVMM 服務 :  service ovmm stop
  2. 切換路徑到 /u01/app/oracle/ovm-manager-3/bin
  3. 執行下列修復語法 :  ./ovm_upgrade.sh –fixup –dbuser=ovs –dbpass=XXXXX –dbhost=localhost –dbsid=ovs –dbport=49500 –fromversion=3.4.1 –toversion=3.4.1
  4. 重新啟動 OVMM 服務 : service ovmm start
  5. 再次登入你的 Oracle VM Manager 控制中心檢查 Jobs List 是否正常,也可以再次執行升級作業看是否會有其他錯誤

升級 Oracle VM 3.3.3 到 3.4.1

2016年6月27日 尚無評論

分享

Oracle VM 在 3 月左右釋放出新版的 3.4.1 更新版本,這個版本修正與強化許多功能,有興趣的朋友可以參考 Oracle VM 3.4 正式釋出了 這篇文章,接著,我將說明怎樣從舊版的 3.3.3 升級到最新版的 3.4.1  ( 升級前,請各位先前往 edelivery.oracle.com 下載最新版的 OVM-Manager 與 OVM-Server ISO 光碟 )

  1.  首先你可以將 Oracle VM Manager 3.4.1 的 ISO 光碟放置到 Oracle VM Manager 主機中,並且透過 mount 指令工具將 ISO 光碟檔案掛載起來
    [root@OracleVM-Mgmt1 ~]# mkdir /mnt/OVM
    [root@OracleVM-Mgmt1 ~]# mount -o loop OVM-3.4.1.iso /mnt/OVM/
  2. 接著,切換路徑到 /mnt/OVM 中,執行 ./runInstaller.sh 腳本程式
    [root@OracleVM-Mgmt1 ~]# cd /mnt/OVM/
    [root@OracleVM-Mgmt1 OVM]# ./runInstaller.shOracle VM Manager Release 3.4.1 Installer

    Oracle VM Manager Installer log file:
    /var/log/ovmm/ovm-manager-3-install-2016-06-27-002357.log

    Please select an installation type:
    1: Install
    2: Upgrade
    3: Uninstall
    4: Help

    Select Number (1-4):  請選擇 2: Upgrade

  3. 升級過程會需要一些時間,因此務必要有耐心,相關過程如下:
    Verifying upgrading prerequisites …
    *** WARNING: Ensure that each Oracle VM Server for x86 has at least 200MB of available space for the /boot partition and 3GB of available space for the / partition.Starting Upgrade …

    Reading database parameters from config …

    ==========================
    Typically the current Oracle VM Manager database password will be the same as the Oracle VM Manager application password.

    ==========================
    Database Repository
    ==========================
    Please enter the current Oracle VM Manager database password for user ovs: 輸入目前 OVM 的資料庫管理密碼

    Oracle VM Manager application
    =============================
    Please enter the current Oracle VM Manager application password for user admin:輸入目前 OVM 的管理者密碼

    Oracle Weblogic Server 12c
    ==========================
    Please enter the current password for the WebLogic domain administrator: 輸入目前 WebLogic 的管理者密碼

    Please enter your fully qualified domain name, e.g. ovs123.us.oracle.com, (or IP address) of your management server for SSL certification generation, more than one IP address are detected: 192.168.1.100  [OracleVM-Mgmt1.server]: 敲下 Enter 直接使用偵測到的主機名稱

    Verifying configuration …
    Verifying 3.3.3 meets the minimum version for upgrade …

    Upgrading from version 3.3.3.1085 to version 3.4.1.1369

    Start upgrading Oracle VM Manager:
    1: Continue
    2: Abort

    Select Number (1-2): 輸入 1 進行升級作業

    接著系統便會開始進行升級作業, 這個升級作業會需要 10 – 20 分鐘, 請耐心等候

  4. 升級完畢後,系統會自動重新啟動 OVM Manager 相關服務,接著我們需要進行 Oracle VM Server 的升級,這個升級過程需要將運轉中的 VM 停止,操作方式如下:
    [root@OracleVM-Mgmt1 OVM]# mkdir /mnt/OVM-Server
    [root@OracleVM-Mgmt1 ~]# mount -o loop OVM-Server341.iso /mnt/OVM-Server/
    [root@OracleVM-Mgmt1 ~]# mkdir -p /var/www/repos
    [root@OracleVM-Mgmt1 ~]# cp -rp /mnt/OVM-Server/* /var/www/repos/上面的動作是將 OracleVM Server ISO 內容複製到一個 /var/www/repos 目錄內,當作 Local Repos 使用

    [root@OracleVM-Mgmt1 ~]# cd /var/www/
    [root@OracleVM-Mgmt1 www]# python -m SimpleHTTPServer 80
    Serving HTTP on 0.0.0.0 port 80 …

    接著,切換到這個目錄內透過 python 啟動一個 SimpleHTTPServer服務

  5. 接著,請用 admin 帳號登入到 Oracle VM Manager 介面,如下圖所示,切換到 Reports and Resources 分頁中OVM-1
  6. 切換到 Server Update Groups 項目內OVM-2
  7. 接著在 GlobalX86ServerUpdateConfiguration 建立一個新的更新套件庫 ( Repository ),內容如下:

    URL : http://IP/repos/Server  ( 放置剛才啟動 SimpleHTTPServer 的 IP 位址 )
    Enabled : 打勾
    Package Signature Type : 選擇 GPG
    Package Signature Key : http://IP/repos/RPM-GPG-KEY-oracle

    OVM-3

  8. 設定完畢後返回 Server and VMs 分頁, 你會發現每一台 Oracle VM Server 都會變成驚嘆號,直接在 Server 上按下滑鼠右鍵,選擇 Update,系統便會開始進行更新
    OVM-4

    更新時要注意,由於 Oracle VM Server 在更新完畢後會自動重新啟動,因此執行中的 VM 要記得先關閉喔。

  9. 最後,每一台更新好的 Oracle VM Server 你會發現原本的 Console 資訊不見了,這時候你可以到 /etc/sysconfig/init,找到 ACTIVE_CONSOLES=/dev/tty[1-6] 這行,將值改為/dev/tty[2-6],重新開機便可以恢復原本的 Console 資訊。
Categories: IT 雜工日誌, Oracle, Oracle_VM Tags: ,

Mantis 統計圖表無法顯示排除

2016年6月27日 尚無評論

分享

Mantis 可以透過統計資訊繪製一些圖表讓專案成員知道目前的修復狀態與變化,如果你在執行時出現 “unable to read/find font” 或者是 X燒包 時可以透過下列方式修復:

  • X燒包修復方式:主要是缺少 php-dom 套件,可以透過 yum -y install php-dom將套件安裝後,重啟 httpd 服務
  • unable to read/find font:這個主要是缺少 truetype 字型,你可以安裝 msttcorefonts ( http://corefonts.sourceforge.net/ ) 套件後,執行
    ln -s /usr/share/fonts/msttcorefonts /usr/share/fonts/truetype
    便可以解決

Win 9X 存取 Samba 問題

2016年6月16日 尚無評論

分享

Win9X 在存取 Samba Service 時若有出現要輸入 IPC$ 的密碼時, 如

ipc_dollar

解決方式如下 :

  1. 編輯 /etc/samba/smb.conf , 添加下列描述到 [Global] 內

    lanman auth = Yes
    client lanman auth = Yes
    client plaintext auth = Yes
    client ntlmv2 auth = no

  2. 確認你 Win9X 登入的使用者帳號在 Samba 上面也有一樣的帳號名稱
  3. 重新啟動你的 Samba 服務

 

GitLab 重設系統管理員 root 密碼

2016年6月13日 尚無評論

分享

GitLab 如果忘掉了系統管理員 root 密碼時, 可以透過下列方式進行重建 :

  • sudo gitlab-rails console production
    irb(main):001:0>
  • 接著在 irb(main):002:0 > 後方輸入 u = User.where(id:1).first
    底下會撈出這個使用者帳號的資訊
  • irb(main):002:0> u.password=’Password’ 輸入新的密碼
  • irb(main):003:0> u.password_confirmation=’Password’ 再一次輸入新的密碼
  • 最後儲存剛才的設定 irb(main):004:0> u.save!
Categories: IT 雜工日誌 Tags: ,

Windows 檔案/目錄 權限消失解決方式

2016年6月7日 尚無評論

分享

Windows 系統中的檔案與目錄有時候會突然發生連 Administrator 都沒有存取權限, 要刪除也不是, 放著也不是, 底下為簡易排除方式:

  1. 以系統管理員身分開啟 命令提示字元 視窗
  2. 透過下列指令將檔案或目錄改變擁有者為 Administrator
    takeown /f “檔案或者是目錄的位置” /r /d y
  3. 最後再透過 icacls 指令將檔案或者是目錄賦予 Administrator 權限, 這時候你的檔案圖案上會出現一個鎖頭符號
    icacls “檔案或者是目錄的位置” /grant administrators:F /t
  4. 此時你已經重新拿回檔案擁有權限, 可以刪除或者是搬移檔案
Categories: IT 雜工日誌 Tags: ,

Oracle VM 3.4 正式釋出了

2016年5月27日 尚無評論

分享

Oracle VM 有一段時間沒新的版本釋出了, 這次正式釋出 3.4.1 的版本, 用戶可以從 3.3 直接升級到 3.4.1 ( 之後再來補一篇升級的方式 ), 也可以從 Oracle Software Delivery Cloud 上面取得最新的安裝光碟

底下為原廠在三月釋出線上更新版本時的相關訊息 :

原文 : https://blogs.oracle.com/virtualization/entry/oracle_vm_3_4_1

Infrastructure

  • Updated Xen hypervisor – Xen hypervisor updated to deliver greater scalability of up to 256 vCPUs per guest VM.
  • Modern Dom0 kernel – Dom0 kernel updated to Oracle Unbreakable Enterprise Kernel (UEK) Release 4, based on the 4.1 mainline kernel, to bring performance improvements; and rapid driver availability and streamlined partner certifications with Oracle Linux.
  • Enhanced Virtual Appliance support – Improved VM portability across different cloud infrastructure by enhancing OVF based virtual appliance support. Oracle VM Manager now provides the ability to import and export Oracle VM Virtual Appliances as a single .ova (Open Virtualization Format Archive) file or a set of .ovf (Open Virtualization Format) and .img (disk image) files.
  • Storage live migration – Oracle VM uses features built into the OCFS2 file system on x86 platforms to provide live migration capabilities for virtual machines that have virtual disks on local storage.
  • Fiber Channel over Ethernet (FCoE) support – Oracle VM provides support for installing Oracle VM Server into FCoE Storage Area Networks (SAN) over selected Host Bus Adapters (HBA) or Converged Network Adapters (CNA).
  • Booting from UEFI – Oracle VM Server can now boot from systems that use the Unified Extensible Firmware Interface (UEFI).
  • Automated installation of VNC and Serial Console software – The Oracle VM Manager installer also manages the installation of the VNC and Serial Console software packages which reduces administrative overhead during a deployment of the environment.

Security and serviceability

  • Dom0 kernel update on live systems – Oracle Ksplice updates the Dom0 Oracle UEK with all of the important security patches without needing to reboot.
  • FIPS 140-2 Validation – This release supports enabling FIPS mode for OpenSSL to be compliant with Federal Information Processing Standard (FIPS) Publication 140-2.
  • Improved character handling for filters – Improvements to Oracle VM Manager allow for better handling of characters used in filter fields to improve matching capabilities and to provide improved protection against attempted SQL injection attacks.
  • Enabling Kdump during Oracle VM Server installationDuring installation of Oracle VM Server, you can now choose to enable the Kdump service that captures a memory dump from dom0 and stores it on the filesystem to help you debug and diagnose issues in the event of a system crash.
  • OSWatcher Utility Available on Oracle VM Server –  the OSWatcher utility is installed on Oracle VM Server by default and is enabled to run at boot. OSWatcher is a collection of shell scripts that collect and archive operating system and network metrics to diagnose performance issues.

Performance

  • Improved PerformanceThis release of Oracle VM includes several enhancements to overall performance and scalability, including the time it takes to discover a large number of servers.

The following table highlights performance improvements for the Oracle VM Manager Web Interface from Release 3.3.1 to Release 3.4.1:

Action in the Oracle VM Manager Web Interface First time Subsequent times
Logging in 85% 80%
Switching from Status Overview to Statistics on theHealth tab 23% faster response time 1 second
Expanding the Server Pools folder on the Servers and VMs tab 66% faster response time 0 seconds
Switching from the Servers and VMs tab to the Health tab 62% faster response time 73% faster response time

Usability and manageability

  • Device mappingsVirtual machine configuration details under the Servers and VMs tab in the Oracle VM Manager Web Interface display device mappings that allow you to easily identify which physical resources, such as disks in the repository, correspond to virtual resources, such as virtual disks assigned to virtual machines.
  • Object topology view – You can view graphical representations, and generate reports, of virtual machine object nodes and attributes to quickly locate resources and view information about those resources.
  • Generating XML reports – Oracle VM Manager lets you generate XML reports on objects, the object attributes, and direct sub-objects. You can generate reports for virtual machines, Oracle VM Servers, server pools, and storage.
  • User preferences – Oracle VM Manager stores certain user preferences across sessions.
  • Simple names for repository objects – Oracle VM Manager persists simple names for repository objects as metadata. As a result, the simple names are retained when the repository is transferred to a different instance of Oracle VM Manager or easily recovered in cases where Oracle VM Manager is manually restored without a database backup.
  • Configuring management database backups – The Preferences tab in the Oracle VM Manager Web Interface lets you set the interval for backing up the management MySQL database and number of backups to keep.
  • Listing the locations of virtual machine disks – Oracle VM Manager provides detailed information on the location of virtual machine disks to facilitate backup tasks.
  • Monitoring Oracle VM Server through SNMP – This release provides an SNMP shared object module that lets you retrieve details about Oracle VM Server, monitor Oracle VM Server health, and return a list of running virtual machines.
  • Viewing virtual machine configuration files – Oracle VM lets you easily retrieve the configuration files for virtual machines (vm.cfg) from the Oracle VM Manager Web Interface or the command line interface (CLI).
  • Avoiding multiple physical disk allocation – Oracle VM provides detailed information about how physical disks are in use to avoid multiple physical disk allocation.
  • Context sensitive help – Online help for Oracle VM now launches directly from elements in the Oracle VM Manager Web Interface to the relevant help topics. This online help system eliminates the need to navigate through help topics to find information.

Visit the following resources for additional details:

Categories: Oracle, Oracle_VM Tags: , ,

Linux 下的 RDP 連線工具

2015年9月29日 尚無評論

分享

一直以來在 Linux 底下我在使用 RDP 連線的工具通常是透過 Terminal Server Client,但詭異的是今天要嘗試透過 Terminal Server Client 連線到 Windows Server 2012 的 RDP 時卻發現一直無法連線,原本以為是主機掛點,後來才發現似乎是 Client 工具支援的問題。

於是改用 rdesktop 這個計畫所分支出來的另外一個軟體 Remmina 來進行 RDP 連線的管理,安裝方式十分簡單:

# zypper in remmina remmina-plugin*

要注意,預設若是直接安裝 remmina 套件是不支援除了 SSH/SFTP 以後的協定,所以要記得將 Plugin 套件安裝起來才可以在協定選擇中使用其他連線協定

查詢最近下過的 MS SQL 語法紀錄

2015年8月13日 尚無評論

分享

由於當我們透過程式去呼叫 SQL 語法執行作業時,若是不知道所下達的語法為何時,我們可以透過下列語法在 SQL Server Management Studio 中執行,可以查詢出相關紀錄:

SELECT  SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END – qs.statement_start_offset)/2)+1),
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
qs.last_elapsed_time/1000000 last_elapsed_time_in_S,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY qs.last_execution_time DESC