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

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

2.設定或修改主機名稱,IP Address
   修改了主機名稱或IP Address之後可以一併修改/etc/hosts檔

   /etc/hosts localhost.localdomain localhost server1.example.com server1

   NETWORKING=yes HOSTNAME=server1.example.com GATEWAY=


 [root@rhel01 root]# cp /etc/hosts /etc/hosts.old

 [root@rhel01 root]# vi /etc/hosts

 [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
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;

select * from v$version;
Oracle 8i

Oracle 10g client not connecting to Oracle 8i server

再research發現p2376472_8174_WINNT.zip Oracle is a patchset for
並且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

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

Download: Visual C++ 2008 SP1 Redistributable Package (x64) - Microsoft Download Center - Confirmation
或是直接安裝Visual Studio 2008 SP1

Microsoft® Connectors v1.2 for Oracle and Teradata

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

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

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

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

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"

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


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

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

 先用命令列測試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


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 and, 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.


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


  (2)將p8350262_10204_Generic.zip解壓縮到目錄,執行opatch apply
       c:\Temp\p8350262\opatch apply

       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

2.安裝Oracle 10g R2,就可以順利安裝
3.安裝完成後確認Oracle Enterprise Manager database control服務已經正常啟動且使用瀏覽器可以連線到Enterprise Manager Database Control
4.將Oracle Enterprise Manager database control服務停止,依照上面的[解決方法]開始套用patch 8350262

5.再將Oracle Enterprise Manager database control服務啟動,確認可以正常啟動
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