启动oracle的步骤
Linux下启动oracle分为以下两步：
- 1.1、启动lsnrctl监听。
- 1.2、启动数据库实例。
启动oracle监听
首先登陆服务器，切换到oracle用户。
[admin@dataserver ~]$ su - oracle密码：[oracle@dataserver ~]
执行lsnrctl start
[oracle@dataserver admin]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-4月 -2016 15:09:15Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/dataserver/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=30.85.227.28)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=30.85.227.23)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 15-4月 -2016 15:09:15Uptime 0 days 0 hr. 0 min. 5 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/dataserver/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=30.85.227.28)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=30.85.227.23)(PORT=1521)))Services Summary...Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully[oracle@dataserver admin]$
启动oracle实例
以system用户身份登陆oracle
[oracle@dataserver admin]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期五 4月 15 15:23:04 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn as sysdbaEnter user-name: systemEn
然后启动实例，通过startup命令：
SQL> startupORACLE instance started.Total System Global Area 4.0620E+10 bytesFixed Size 2216024 bytesVariable Size 2.3354E+10 bytesDatabase Buffers 1.7180E+10 bytesRedo Buffers 84054016 bytesDatabase mounted.Database opened.SQL>