Oracle数据库在Linux 中的安装与启动动(二)

2014-11-24 17:55:53 · 作者: · 浏览: 1
on 10-DEC-2010 11:05:02


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


Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 11.2.0.1.0 - Production


System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora


Log messages written to /home/oracle/app/oracle/diag/tnslsnr/DBServer/listener/alert/log.xml


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


Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DBServer)(PORT=2484)))




Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DBServer)(PORT=1521)))


STATUS of the LISTENER


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


Alias LISTENER


Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production


Start Date 10-DEC-2010 11:05:02


Uptime 0 days 0 hr. 0 min. 0 sec


Trace Level off


Security ON: Local OS Authentication


SNMP OFF


Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora


Listener Log File /home/oracle/app/oracle/diag/tnslsnr/DBServer/listener/alert/log.xml


Listening Endpoints Summary...


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


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DBServer)(PORT=2484)))


The listener supports no services


The command completed successfully


[oracle@DBServer ~]$ dbstart注:启动数据库


ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener


Usage: /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME


Processing Database instance "orcl": log file /home/oracle/app/oracle/product/11.2.0/dbhome_1/startup.log


以下steps关闭db:


[oracle@DBServer ~]$ dbshut注:关闭数据库


ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener


Usage: /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbshut ORACLE_HOME


Processing Database instance "orcl": log file /home/oracle/app/oracle/product/11.2.0/dbhome_1/shutdown.log


[oracle@DBServer ~]$ lsnrctl stop注:关闭监听


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-DEC-2010 11:06:50


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DBServer)(PORT=1521)))


The command completed successfully


[oracle@DBServer ~]$


不幸的是如果是第一次这么做,我们可能会失败,原因我们可以在dbstart脚本中发现。我把有用的内容摘录如下:


# This script will start all databases listed in the oratab file


# whose third field is a "Y". If the third field is set to "Y" and


# there is no ORACLE_SID for an entry (the first field is a *),


# then this script will ignore that entry.


看完这段内容我想你已经明白该如何做了,没错修改/etc/oratab中的内容:


orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N


把其中的‘N’改为‘Y’


到此数据库启动的问题都解决了,以后我们可以放心使用我们的db了。GOOK LUCK