By Allen, on February 6th, 2010%
#!/bin/bash
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo “Oracle startup: cannot start”
exit 1
fi
case “$1″ in
start)
# Oracle listener and instance startup
echo -n “Starting Oracle: ”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/lsnrctl start”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/dbstart $ORACLE_HOME”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/emctl start dbconsole”
su oracle -c “/u01/app/oracle/product/11.1.0/db_1/bin/emctl start dbconsole”
touch /var/lock/oracle
echo “OK”
;;
stop)
# Oracle listener and instance shutdown
echo . . . → Read More: ORACLE Startup and Shutdown Script
By Allen, on January 16th, 2010%
其實sqldeveloper是一個好物…在不用錢的狀況下:P
如果需要把他改變成english的話…只需要按照下面的方式修改…
~/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
把下列的設定加入到裏面去…
AddVMOption . . . → Read More: 更改sql developer 語系設定….
By Allen, on January 16th, 2010%
從11g開始…AlertLog開始變成了XML的格式,目的是方便其他軟體來分析LOG File…
for 10G
$oracle_home\admin\SID\bdump\alert.log
for 11G
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name . . . → Read More: Alert Log for 11G
By Allen, on December 17th, 2009%
在有些Linux下會發生RMAN就給你錯誤訊息….rman: can’t open . . . → Read More: rman error
By Allen, on December 17th, 2009%
這幾天苦惱於如何將Oracle Client裝在Win7上…
在Google大神的幫助下,終於找到方法可以安裝,不過….
這個方法只是pass他的檢查機制…並不是原廠所出的軟體…
作法如下…
修改refhost.xml檔案
<!–Microsoft Windows . . . → Read More: Oracle Client for Win7 64bit
