oracle 重新启动及恢复

-------linux oracle 重新启动

 

linux下重启oracle

[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 ~]$

----------------------