Table of Contents

Middleware

Oracle

Web Site

Commands

Startup, Shutdown

Instance

# su - oracle
$ echo $ORACLE_SID $ORACLE_HOME
ora1 /usr/local/oracle/oracle/product/10.2.0/db_1
$ sqlplus / as sysdba
SQL> startup

# su - oracle
$ sqlplus / as sysdba
SQL> shutdown

Listener

# su - oracle
$ lsnrctl status  LISTENERNAME
$ lsnrctl start   LISTENERNAME
$ lsnrctl stop    LISTENERNAME 

or

# su - oracle
LSNRCTL> set current LISTENERNAME
LSNRCTL> status
LSNRCTL> start
LSNRCTL> stop


Oracle Client

SQLPlus

$ export NLS_LANG=Japanese_Japan.AL32UTF8    <- if LANG="ja_JP.UTF-8"
$ export NLS_LANG=Japanese_Japan.JA16SJIS    <- if LANG="ja_JP.SJIS"
$ export NLS_LANG=Japanese_Japan.JA16EUC     <- if LANG="ja_JP.eucJP"

$ sqlplus hoge/hoge