Chuan-Shun Wang’s BLOG

#!/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

Share on Facebook

其實sqldeveloper是一個好物…在不用錢的狀況下:P

如果需要把他改變成english的話…只需要按照下面的方式修改…

~/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
把下列的設定加入到裏面去…
AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
下次開sqldeveloper就會是english的了….

Share . . . → Read More: 更改sql developer 語系設定….

Share on Facebook

從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 =’Diag Trace’;

VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/trace

Share . . . → Read More: Alert Log for 11G

Share on Facebook