oracle教程:linux下啟動(dòng)服務(wù)與監(jiān)聽命令

字號(hào):


    在linux操作系統(tǒng)下,如何啟動(dòng)服務(wù)與監(jiān)聽命令?首先必須以oracle用戶登陸:
    1、啟動(dòng)數(shù)據(jù)庫:
    以下為引用的內(nèi)容:
    oracle@suse92:~> sqlplus /nolog
    SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006
    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    SQL> connect /as sysdba
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.
    Total System Global Area 135352820 bytes
    Fixed Size 455156 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 679936 bytes
    Database mounted.
    2、關(guān)閉數(shù)據(jù)庫:
    以下為引用的內(nèi)容:
    oracle@suse92:~> sqlplus /nolog
    SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006
    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    SQL> connect /as sysdba
    Connected to an idle instance.
    SQL> shutdwon abort;
    3、啟動(dòng)監(jiān)聽器
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl start
    4、停止監(jiān)聽器
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl stop
    5、查看監(jiān)聽器狀態(tài)
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl
    LSNRCTL> status
    LSNRCTL> exit