在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 |