ORACLE10G异常关闭后的启动-优快云博客

本文链接：https://blog.youkuaiyun.com/shellfish007/article/details/83525644

本文演示了如何设置环境变量并启动Oracle10g监听器和服务，包括使用sqlplus工具连接到数据库的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@server ~]$ export ORACLE_HOME="/opt/app/product/10.2.0/baandb"

[oracle@server ~]$ export ORACLE_SID="BAANDB"

[oracle@server ~]$/opt/app/product/10.2.0/baandb/bin/ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 04-JUN-2008 12:27:17

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

Starting /opt/app/product/10.2.0.3/oracle/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /~~/network/admin/listener.o ra
Log messages written to /~~/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date                04-JUN-2008 12:27:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /~~/network/admin/listener.ora
Listener Log File         /~~/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erp)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@server ~]$ /opt/app/product/10.2.0/baandb/bin/ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 4 12:28:38 2008

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

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size                  2072288 bytes
Variable Size             738197792 bytes
Database Buffers          436207616 bytes
Redo Buffers               31481856 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64 bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@server ~]$ /opt/app/product/10.2.0/baandb/bin/ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 4 12:29:39 2008

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

Enter user-name: birt
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options