Linux下oracle重启实践

最新推荐文章于 2026-05-29 12:25:22 发布

原创最新推荐文章于 2026-05-29 12:25:22 发布 · 3.8k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#linux #oracle #file #tcp #command

本文记录了在Linux环境下重启Oracle数据库的过程，包括使用su命令切换到oracle用户、通过sqlplus连接数据库并启动服务、以及使用lsnrctl启动监听器等关键步骤。

1. linux下oracle重启
/home/xsmfms/>su -oracle
su：无效选项 -- o
请尝试执行‘su --help’来获取更多信息。
/home/xsmfms/>su - oracle
/home/oracle/>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 10 01:57:43 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn /as sysdba
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

/opt/oracle/product/10.2.0/db_1/bin/>lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JUN-2009 01:59:59

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=qnsoftweb)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=qnsoftweb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date                10-JUN-2009 01:59:59
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=qnsoftweb)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ccpbs" has 1 instance(s).
Instance "ccpbs", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully