一、啟動監聽與資料庫
[[email protected] oracle]# su oraclebash-4.1$ lsnrctl start
結果如下，則啟動成功：
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 16:15:25
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /home/oracle/product/11.2/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /home/oracle/product/11.2/db_1/network/admin/listener.ora
Log messages written to /home/oracle/diag/tnslsnr/JTWF/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JTWF)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JTWF)(PORT=1521)))
STATUS of the LISTENER------------------------Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 04-APR-2014 16:15:25Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/11.2/db_1/network/admin/listener.ora
Listener Log File /home/oracle/diag/tnslsnr/JTWF/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JTWF)(PORT=1521)))
The listener supports no services
The command completed successfully
2、啟動資料庫：
su oracle
bash-4.1$ sqlplus /nolog
結果如下：
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 4 16:15:52 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
以sysdba登陸，并執行指令startup
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
結果如下：
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2217992 bytes
Variable Size 578815992 bytes
Database Buffers 251658240 bytes
Redo Buffers 6590464 bytes
Database mounted.
Database opened.SQL>
1、關閉資料庫
su oracle
[[email protected] oracle]# su oraclebash-4.1$ sqlplus /nolog
登陸sqlplus，結果如下：
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 4 15:10:59 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
SQL>conn /as sysdba
Connected.
關閉資料庫：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
關閉資料庫後，若執行查詢指令， 則會報如下錯誤：
SQL> select * from vio_business_request;select * from vio_business_request
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 14138Session ID: 75 Serial number: 503SQL>
退出sqlplus：
SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-4.1$ lsnrctl stop // oracle使用者下執行LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 15:17:00Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JTWF)(PORT=1521)))
The command completed successfullybash-4.1$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 15:17:00Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JTWF)(PORT=1521)))
The command completed successfully