##启动oracle数据库
[oracle@its-db-102-160 ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-MAY-2013 03:35:47 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /itsdb/ora11gR2/product/11.2.0/db_1/bin/tnslsnr: please wait… TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /itsdb/ora11gR2/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /itsdb/ora11gR2/diag/tnslsnr/its-db-102-160/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.102.160)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.102.160)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 18-MAY-2013 03:35:47 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /itsdb/ora11gR2/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /itsdb/ora11gR2/diag/tnslsnr/its-db-102-160/listener/alert/log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.102.160)(PORT=1521))) The listener supports no services The command completed successfully
[oracle@its-db-102-160 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Tue May 7 16:38:47 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba Connected to an idle instance.
SQL> startup ORACLE instance started. Total System Global Area 2622255104 bytes Fixed Size 2216224 bytes Variable Size 1593839328 bytes Database Buffers 1006632960 bytes Redo Buffers 19566592 bytes Database mounted. Database opened.
SQL> quit 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 [oracle@its-db-102-160 ~]$
停止oracle数据库
[oracle@its-db-102-160 ~]$ lsnrctl stop [oracle@its-db-102-160 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Tue May 7 16:38:47 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba Connected.
SQL> shutdown immediate SQL> quit [oracle@its-db-102-160 ~]$