cmdref.net - Command Reference

This site is command references for system engineers.

User Tools

Site Tools


Top     SiteMap

Sidebar

Top     SiteMap








Etc


Reference











.

middleware:db:oracle:index.html



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



middleware/db/oracle/index.html.txt ยท Last modified: 2017/05/06 by admin