这篇博客展示了如何在Linux环境下关闭和启动Oracle数据库监听，并通过sqlplus进行数据库的关闭、重启操作。首先使用lsnrctl stop命令关闭监听，接着以sysdba身份登录sqlplus，执行shutdown immediate和startup命令关闭并重启数据库。最后，使用lsnrctl start重新开启监听。
[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, has 1 handler(s) for this service...
The command completed successfully
[oracle@dbOracle9i ~]$
扫一扫
3778
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
