登录oracle后进入idle模式,解决Linux 下oracle 报错 Connected to an idle instance. Linux启动Oracle实例...

启动数据库实例，分为两步：第一步，启动监听；第二步，启动数据库实例。

一、如何启动数据库实例

1.进入到sqlplus启动实例

[oracle@redhat ~]$ su - oracle --“切换到oracle用户”

Password:

[oracle@redhat ~]$ lsnrctl start --“打开监听”

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2009 19:06:40

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

Starting /home/oracle/product/10g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /home/oracle/product/10g/network/admin/listener.ora

Log messages written to /home/oracle/product/10g/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=I