cmdref.net - Cheat Sheet and Example

cmdref.net is command references/cheat sheets/examples for system engineers.

User Tools

Site Tools


Sidebar








Cloud



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

Page Tools