启动监听器

# Start the Oracle databases:

echo "-------------------------------------------------" >> /var/log/oracle

3. 改变文件权限
date +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle
esac
echo "Oracle startup: cannot start"
echo "Done."

另外停止数据库的指令如下：

然后输入密码，sys以sysdba身份登入数据库。

SQL> shutdown immediate

2. 在 /etc/init.d/ 下创建文件oracle，内容如下：

$ lsnrctl start

在CentOS 6.3下安装完Oracle 10g R2，重开机之后，你会发现Oracle没有自行启动，这是正常的，因为在Linux下安装Oracle的确不会自行启动，必须要自行设定相关参数，首先先介绍一般而言如何启动oracle。

echo "-------------------------------------------------" >> /var/log/oracle

1. 修改Oracle系统配置文件：/etc/oratab，只有这样，Oracle 自带的dbstart和dbshut才能够发挥作用。

'start')
# service oracle restart //重启oracle

echo "-------------------------------------------------" >> /var/log/oracle

接着请输入

6. 使用方法

date +" %T %a %D : Finished." >> /var/log/oracle

手动启动Oracle数据库完毕，下面创建系统自行启动Oracle的脚本。

5. 需要在关机或重启机器之前停止数据库，做一下操作
rm -f /var/lock/subsys/oracle

检查看看监听器是否有启动
echo "-------------------------------------------------" >> /var/log/oracle

$ emctl start dbconsole

echo "-------------------------------------------------" >> /var/log/oracle

7. 测试

# service oracle stop //关闭oracle
# Set ORA_OWNER to the user id of the owner of the
'restart')

复制代码 代码如下:

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >>/var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
echo "Done."

复制代码 代码如下:

三、启动emctl

# Set ORA_HOME to be equivalent to the $ORACLE_HOME
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" >>/var/log/oracle

a. 开机自启动

# ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle //重启

su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" >>/var/log/oracle
ORA_OWNER=oracle

# service oracle start //启动oracle

SQL> conn sys@orcl as sysdba

登录到CentOS，切换到oracle用户权限

#
ORA_HOME=/opt/oracle/102

原本的画面会变为
then

# Entries are of the form:

回到终端机模式，输入：

$ sqlplus "/as sysdba"

# $ORACLE_SID:$ORACLE_HOME:<N|Y>:

4. 添加服务
date +" %T %a %D : Finished." >> /var/log/oracle
# description: Oracle auto start-stop script.

if [ ! -f $ORA_HOME/bin/dbstart ]

echo "Starting Oracle Listeners ... "

# chkconfig: 35 80 10
echo "Starting Oracle Databases ... "
exit

date +" %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle

四、Oracle启动&停止脚本

touch /var/lock/subsys/oracle

这个指令运行时间较长，执行完的画面如下：

echo "-------------------------------------------------" >> /var/log/oracle

case "$1" in
echo "Stoping Oracle Databases ... "

接着输入：

# vi /etc/oratab

$ lsnrctl status

date +" %T %a %D : Starting Oracle Listeners as part of system up." >> /var/log/oracle
# Stop the Oracle Database:

# chmod 755 /etc/init.d/oracle

'stop')
# from which you wish to execute dbstart and dbshut;

二、检查Oracle DB监听器是否正常

$0 stop
echo "-------------------------------------------------" >> /var/log/oracle
orcl:/opt/oracle/102:Y
# Stop the Oracle Listener:

就可以正常的启动数据库了。

echo "-------------------------------------------------" >> /var/log/oracle

一、在Linux下启动Oracle

#!/bin/sh

如果没有启动，可以输入：
$0 start

SQL> startup

echo "-------------------------------------------------" >> /var/log/oracle

echo "Done"
#
echo "-------------------------------------------------" >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle

另外也可以发现:1158/em 目前是没有反应的，这边要另外启动，启动的指令如下：

SQL>

echo "Done."
# Oracle database in ORA_HOME.
fi
# ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle //关机
# chkconfig --level 35 oracle on

# su – oracle

# Start the Listener:
date +" %T %a %D : Stoping Oracle Listener as part of system down." >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" >>/var/log/oracle
echo ""
echo "Stoping Oracle Listeners ... "