1、啟動資料庫：
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、關閉資料庫：
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、啟動監聽器
oracle@suse92:~> lsnrctl start


 

4、停止監聽器
oracle@suse92:~> lsnrctl stop


 

5、查看監聽器狀態
oracle@suse92:~> lsnrctl
LSNRCTL> status
LSNRCTL> exit
arrow
arrow
    全站熱搜

    戮克 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄