2016年9月18日 星期日

Asus external Blu-Ray/DVD external drive not working in Windows 10

Solution from
SOLVED: Asus external Blu-Ray/DVD external drive not working in Windows 10
https://mightbeuseful.wordpress.com/2015/12/05/solved-asus-external-blu-raydvd-external-drive-not-working-in-windows-10/


1.Plug external drive into USB Port.
2.In the Device Manager, find Initio Default Controller and disable it under Intio Combo Device Class
3.Now right-click on it again and click ‘Properties’, in "Driver" tab,  Click on "Uninstall"
4.Unplug the external drive from the USB port.
5.Shut down your computer (be sure to shut it down fully, don’t just restart it).
6.plug in the external drive to the USB ports.
7.Power-on the computer

2013年4月10日 星期三

Red Hat Linux常用設定工具與命令



1.Red Hat Text Mode Setup Utility
 Red Hat Linux自家的系統參數設定工具setup,可以協助設定/etc/sysconfig裡面的系統檔。
 可以設定以下項目
 Authentication configuration
 Firewall configuration
 Mouse configuration
 Network configuration
 Printer configuration
 System services
 Timezone configuration
 輸入setup就可以叫出這個工具


2.設定或修改主機名稱,IP Address
   直接編輯/etc/sysconfig/network檔可以修改電腦名稱
   修改了主機名稱或IP Address之後可以一併修改/etc/hosts檔

   /etc/hosts

   127.0.0.1 localhost.localdomain localhost
   192.168.0.254 server1.example.com server1

   /etc/sysconfig/network
   NETWORKING=yes HOSTNAME=server1.example.com GATEWAY=192.168.0.1

   /etc/sysconfig/network-scripts/ifcfg-eth0
   DEVICE=eth0 BOOTPROTO=static IPADDR=192.168.0.254 NETMASK=255.255.255.0 ONBOOT=yes



3.常用命令
 修改檔案之前先複製一個檔案來當作備份
 [root@rhel01 root]# cp /etc/hosts /etc/hosts.old

 使用vi來修改檔案
 [root@rhel01 root]# vi /etc/hosts
 按下INSERT鍵來輸入與修改檔案內容
 按下Esc鍵再輸入:qw來儲存並退出vi

4.關機與重新開機
 關機
 [root@rhel01 root]# shutdown -h now

 重新開機

 [root@rhel01 root]# reboot


2012年12月6日 星期四

Oracle 8i R2 8.1.6 Install on Windows 2003 R2 sp2

1.Oracle 8i安裝在Windows 2003 R2上沒有問題
2.安裝之後必須使用Configuration Assistant設定一個repository user
3.啟動OracleOraHome81ManagmentServer服務
4.啟動OracleOraHome81Agnet服務
5.使用sysman/oem_temp登入Oracle Enterprise Manager Console,步驟4啟動後,discovery才不會失敗
6.之後就可以使用system/manger登入Enterprise manager console來管理Oracle

後記
Oracle 11g R2 Client無法連線到Oracle 8i 8.1.6

ORA-03134: Connections to this server version are no longer supported.
Cause: An attempt was made to connect to an Oracle server of older version.
Action: Please refer to documentation for more details.



select * from v$version;



research之後,發現需要上patch 8.1.7.4
select * from v$version;
Oracle 8i 8.1.7.4

Oracle 10g client not connecting to Oracle 8i server
https://community.oracle.com/thread/245332?start=0&tstart=0

再research發現p2376472_8174_WINNT.zip Oracle 8.1.7.4 is a patchset for 8.1.7.0
並且Oracle也不提供沒有support帳戶可以下載patch file,所以暫時只能找其他方法了

2012年12月5日 星期三

SSIS Oracle Source and Destination

SQL Server Integration Service可以透過內建的OLE DB Source連線到Oracle匯出資料,但無法寫入資料到Oracle,Attunity公司針對這個功能提供了SSIS的連結Source,並且聽說資料傳送效率非常好,本人沒有測試過效能,有興趣的朋友可以試試。

Microsoft® Connectors v1.2 for Oracle and Teradata
for SQL Server 2008 Integration Service

Microsoft Connectors v2.0 for Oracle and Teradata
For SQL Server 2012 Integration Service

Installation
In summary, if you want both to develop and to run SSIS packages on a 64-bit computer:
1.Install the Attunity Oracle 64 bit connector.(the 64 bit connector installs both 32-bit and 64-bit versions)
2.Install the Oracle 11G 64 Bit client.
3.Install the Oracle 11G 32 Bit client.
4.Restart the computer after the Oracle installations are complete.
5.You should be able to develop and run SSIS packages.


Install Microsoft® Connectors v1.2 for Oracle with Error message cannot retistry AttunitySSISOraAdapters.dll and the AttunitySSISOraConnections.dll
http://www.attunity.com/forums/microsoft-ssis-connectors-attunity/installation-issues-1735.html

[solution]
Download: Visual C++ 2008 SP1 Redistributable Package (x64) - Microsoft Download Center - Confirmation
或是直接安裝Visual Studio 2008 SP1
http://www.microsoft.com/en-us/download/details.aspx?id=13276


========================================================================
Microsoft® Connectors v1.2 for Oracle and Teradata
http://www.microsoft.com/en-us/download/details.aspx?id=29284

Download the SSIS Connectors Version 1.2 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS).

Quick details

Version:1.2Date published:7/9/2012
Language:English

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.
File nameSize
AttunitySSISOraAdaptersSetup.msi2.1 MBDownload
AttunitySSISOraAdaptersSetupX64.msi3.8 MBDownload
AttunitySSISTeraAdaptersSetup.msi2.7 MBDownload
AttunitySSISTeraAdaptersSetupX64.msi4.9 MBDownload


========================================================================
Microsoft Connectors v2.0 for Oracle and Teradata
http://www.microsoft.com/en-us/download/details.aspx?id=29283

Download the SSIS Connectors v2.0 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2012.

Quick details

Version:2.0Date published:4/3/2012
Language:English

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.
File nameSize
AttunitySSISOraAdaptersSetup.msi2.3 MBDownload
AttunitySSISOraAdaptersSetupX64.msi3.9 MBDownload
AttunitySSISTeraAdaptersSetup.msi2.8 MBDownload
AttunitySSISTeraAdaptersSetupX64.msi5.0 MBDownload
參考
Microsoft Connectors v2.0 for Oracle and Teradata – Now Available
http://blogs.msdn.com/b/mattm/archive/2012/04/04/microsoft-connectors-v2-0-for-oracle-and-teradata-now-available.aspx


Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services

2012年12月3日 星期一

Oracle 11g R2 installation Warning "Enterprise manager configuration succeeded with the following warning"


[symptom]
1.安裝Oracle 11g R2到最後倒數第二個步驟18/19,出現一個警告
資料庫組態輔助程式
Enterprise manager configuration succeeded with the following warning -
 Error starting database control. Please execute the following command(s)
 1) Set the environment variable ORACLE_UNQNAME to database unique name
 2) c:\app\Administrator\product\11.2.0\dbhome_1\bin\emctl start dbconsole

[解決方法]
1.不用解決
 因為安裝還是會完成

 服務還是可以正常啟動,使用[服務]管理員也是可以正常停止啟動DB control服務,並且DB control URL網站還是可以正常使用

 但是如果想用Oracle的啟動命令啟動db control則會失敗

2.解決這個問題
 依照警告訊息的畫面所說明的方法,增加一個環境變數ORACLE_UNQNAME
 先用命令列測試SET ORACLE_UNQNAME=orcl,再用Oracle的啟動db control,果然成功了

 接下來就直接在Windows系統環境變數加上這個變數ORACLE_UNQNAME=orcl,以後再用Oracle的啟動命令來啟動db control就不會有問題了

Oracle 10g R2中文字亂碼

最近安裝的Oracle 10g R2卻會出現輸入或查詢中文字會有亂碼的問題(例如使用sqlplus在直接執行INSERT中文字,再用SELECT查詢中文字會出現亂碼),以下提供的解決方法不一定能所有的中文字亂碼問題,但在我的環境是可以解決的。

[我的環境]
Windows 2003 R2 Enterprise Edition with SP2 Traditional Chinese繁體中文版
Oracle 10g R2 10.2.0.4
Oracle安裝時選擇預設的字元集AL32UTF8

[解決方法]
1.開始>執行>regedit
2.在以下機碼設定這個值
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb01g_home1
將此機碼NLS_LANG的值改成TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950

==============================================================
update:
Oracle 11g R2安裝時預設的字元集就是ZHT16MSWIN950,所以不會出現亂碼

安裝Oracle 10g R2最後Database Control(Web EM)配置失敗的解決方式2

因為客戶的資料庫通常也有Oracle,當我們在support SQL Server的問題就需要有Oracle的LAB來進行測試,最近重新安裝了一台Oracle 10g R2發生了一些問題是安裝Oracle 11g沒有出現的,所以只要想辦法解決,以下是問題說明與解決方法,希望能幫助到遇到相同問題的朋友。

官方網站的解釋是憑證到期,導致EM(Enterprise Manager Database Control)配置失敗且無法啟動

In Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00. The certificate expiration will cause errors if you attempt to configure Database Control on or after 31-Dec-2010. Existing Database Control configurations are not affected by this issue.

If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply Patch 8350262 to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.


[解決方法]
1.下載p8350262_10204_Generic.zip

2.使用Opatch安裝Patch 8350262
  (1)Set the ORACLE_HOME and ORACLE_SID environment variables.
      預設

      ORACLE_HOME=c:\oracle\product\10.2.0\db_1
      ORACLE_SID=orcl

  (2)將p8350262_10204_Generic.zip解壓縮到目錄,執行opatch apply
       例如
       c:\Temp\p8350262\opatch apply
       PS.c:\oracle\product\10.2.0\db_1\OPatch必須在path的環境變數裡
       或

       c:\Temp\p8350262\>c:\oracle\product\10.2.0\db_1\OPatch\opatch apply


      PS.如果遇到Java could not be located. OPatch cannot proceed錯誤,則加上這個參數
       c:\Temp\p8350262\opatch apply -jre c:\oracle\product\10.2.0\db_1\jdk
   

3. Re-secure Database Control with the following command:
      /bin/emctl secure dbconsole -reset

4. Re-start Database Control with the following command:
      /bin/emctl start dbconsole

[由於我是安裝一台新的Oracle所以我的作法是]
1.將Windows系統時間調整到31-Dec-2010之前,例如2009-10-10
2.安裝Oracle 10g R2 10.2.0.4,就可以順利安裝
3.安裝完成後確認Oracle Enterprise Manager database control服務已經正常啟動且使用瀏覽器可以連線到Enterprise Manager Database Control
 https://hostname:1158/em
4.將Oracle Enterprise Manager database control服務停止,依照上面的[解決方法]開始套用patch 8350262

5.再將Oracle Enterprise Manager database control服務啟動,確認可以正常啟動
6.將Windows系統時間調整回正常時間,並重新開機
7.此時Oracle Enterprise Manager database control服務已經可以正常啟動了
8.如果此時Oracle Enterprise Manager database control服務還是無法正常啟動,則使用命令將DB control移除重建
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

可以參考這篇
http://www.aixchina.net/home/space.php?uid=20260&do=blog&id=28358