启动数据库的命令

060410_启动数据库的命令

[root@localhost root]# su - oracle

[oracle@localhost oracle]$ sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on 星期一 4月 10 10:41:53 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1294539092 bytes

Fixed Size                   452948 bytes

Variable Size             553648128 bytes

Database Buffers          738197504 bytes

Redo Buffers                2240512 bytes

Database mounted.

Database opened.

SQL> quit

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@localhost oracle]$ su root

Password:

[root@localhost oracle]# ls

[root@localhost oracle]# pwd

/home/oracle

[root@localhost oracle]# lsnrctl start       //必须以oracle用户执行此命令，所以需先执行su oracle

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-4月 -2006 10:45:02

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /opt/ora9/product/9.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production

NL-00280: error creating log stream /opt/ora9/product/9.2/network/log/listener.log

 NL-00278: cannot open log file

  SNL-00016: snlfohd: error opening file

   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...   //用户为非oracle用户而被拒绝

[root@localhost oracle]# su oracle

[oracle@localhost oracle]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-4月 -2006 10:46:16

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /opt/ora9/product/9.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production

System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora

Log messages written to /opt/ora9/product/9.2/network/log/listener.log

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.88.89)(PORT=1521)))

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-4月 -2006 10:46:16

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /opt/ora9/product/9.2/network/admin/listener.ora

Listener Log File         /opt/ora9/product/9.2/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.88.89)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "test2" has 1 instance(s).

  Instance "test2", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

<script type="text/javascript"></script>