好用免費的備份軟體--Cobian Backup
連結 cobiansoft官網 可定時備份,網路備份,增量備份..... 介紹請參考以下網址 Cobian Backup備份軟體(1)：下載與安裝 Cobian Backup備份軟體(2)：設定增量備份功能
發表文章
EXCEL2010撰寫VBA操作相關步驟
1.開啟巨集功能,請參考 http://hank20.blogspot.tw/2012/08/excel2007.html 2.將[開發人員]功能表啟用 檔案-->選項-->自訂功能表 確定後就可在功能表看到下圖畫面 3.開始撰寫巨集程式(點功能表上的[巨集]) 4.將巨集的執行功能放到工具列上,方法執行 檔案-->選項-->自訂功能表 下圖的[修改]步驟,是選取要在功能表SHOW出來的圖案,按確定後就可在功能表列看到巨集的按鈕了
oracle 11g更新SID步驟
1.進入SQLPLUS確認SID [root@localhost oracle]# sqlplus sys as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 10 13:51:11 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter password: ==>這裡KEY入密碼 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select instance from v$thread; INSTANCE -------------------------------------------------------------------------------- orcl ==>舊的名稱 SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [root@localhost oracle]# service oracle stop Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. https://localhost:1158/em/console/aboutApplication Stopping Oracle
oracle11g在linux中自動執行
1.確認/etc/oratab檔案,如下圖: 2.在/home/oracle下增加scripts的目錄(#mkdir scripts),用VI增加2個檔案 3.# su – oracle 4. # vi /home/oracle/scripts/ora_start.sh #!/bin/bash # script to start the Oracle database, listener and dbconsole . ~/.bash_profile # start the listener and the database $ORACLE_HOME/bin/dbstart $ORACLE_HOME # start the Enterprise Manager db console $ORACLE_HOME/bin/emctl start dbconsole exit 0 5.# vi /home/oracle/scripts/ora_stop.sh #!/bin/bash # script to stop the Oracle database, listener and dbconsole . ~/.bash_profile # stop the Enterprise Manager db console $ORACLE_HOME/bin/emctl stop dbconsole # stop the listener and the database $ORACLE_HOME/bin/dbshut $ORACLE_HOME exit 0 6.# chmod u+x ora_start.sh ora_stop.sh 7.用root權限進入\etc\init.d 8.增加檔案 # vi /etc/init.d/oracle #!/bin/bash # chkconfig: 345 99 10 # description: Oracle auto start-stop script. # Set ORA_OWNER to the user id of