萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> oracle教程 >> oracle教程:linux下啟動服務與監聽命令

oracle教程:linux下啟動服務與監聽命令

   在linux操作系統下,如何啟動服務與監聽命令?首先必須以oracle用戶登陸:

  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
copyright © 萬盛學電腦網 all rights reserved