[oracle@dbOracle9i ~]$lsnrctl stop ?? ? ? ? ?? ----------关闭监听
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-OCT-2011 16:19:02
?
Copyright (c) 1991, 2002, Oracle Corporation. ?All rights reserved.
?
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
[oracle@dbOracle9i ~]$ sqlplus "/as sysdba" ?? ? ??------sqlplus?? ? ? ? ? ? ? ? ??
?
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Oct 10 16:19:08 2011
?
Copyright (c) 1982, 2002, Oracle Corporation. ?All rights reserved.
?
?
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
?
SQL> shutdown immediate; ? ? ? ? ? ?-------关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> start up;
SP2-0310: unable to open file "up.sql"
SQL> startup; ? ? ? ? ? ? ? ? -------重启数据库
ORACLE instance started.
?
Total System Global Area ?974198740 bytes
Fixed Size ? ? ? ? ? ? ? ? ? 452564 bytes
Variable Size ? ? ? ? ? ? 402653184 bytes
Database Buffers ? ? ? ? ?570425344 bytes
Redo Buffers ? ? ? ? ? ? ? ? 667648 bytes
Database mounted.
Database opened.
SQL> exit ? ? ? ? ? ? ? ? ? ? ? ?-------退出sqlplus
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@dbOracle9i ~]$ lsnrctl start ? ? ? ? ? ? ? ?---------打开监听
?
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-OCT-2011 16:20:08
?
Copyright (c) 1991, 2002, Oracle Corporation. ?All rights reserved.
?
Starting /home/oracle/product/9.2.0/bin/tnslsnr: please wait...
?
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /home/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /home/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbOracle9i)(PORT=1522)))
?
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias ? ? ? ? ? ? ? ? ? ? LISTENER
Version ? ? ? ? ? ? ? ? ? TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date ? ? ? ? ? ? ? ?10-OCT-2011 16:20:08
Uptime ? ? ? ? ? ? ? ? ? ?0 days 0 hr. 0 min. 0 sec
Trace Level ? ? ? ? ? ? ? off
Security ? ? ? ? ? ? ? ? ?OFF
SNMP ? ? ? ? ? ? ? ? ? ? ?OFF
Listener Parameter File ? /home/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File ? ? ? ? /home/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
??(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
??(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbOracle9i)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
??Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "lin" has 1 instance(s).
??Instance "oravas", status UNKNOWN, has 1 handler(s) for this service...
Service "oravas" has 1 instance(s).
??Instance "oravas", status UNKNOWN
