有谁知道如何让oracle8.17在linux9下,随系统的开机、关机自动启动或是关闭数据库?
谢谢!
谢谢!
解决方案 »
- 删除重复数据包括BLOB类型
- 关于oracle数据表中字符串排序的问题
- exp整个数据库时出现4031错误,show parameter java_pool报同样错误!
- oracle biee 用户访问权限问题
- 如何测试我的oracle客户端能连上服务器?
- oracle datafile 问题 急急
- oracle老是出现一段时间的死机现象(大家讨论都给分)
- 请问哪儿有oracle8.0.5服务器下载?
- select 语句中group by 子项中的分析顺序是怎么样的??
- 100分求助!不使用游标,在Oracle的过程中如何才能返回多条记录!????
- 触发器中是不是可以定义变量,我这个触发器有什么错,请高手指教!!!
- 有关Logminer与对象被使用的问题?
Database entries in the oratab file appear in the following format:
ORACLE_SID:ORACLE_HOME:{Y|N}
where Y or N specifies whether you want the dbstart and dbshut scripts to
start up and shut down the database. Find the entries for all the databases that
you want to start up. They are identified by the sid in the first field. Change
the last field for each to Y.
2. Create a file named dbora in the /etc/init.d directory (if it does not already
exist).
3. Create entries similar to the following at the end of the dbora file (if they do
not already exist). Be sure to give the full path of the dbstart utility.
#!/bin/sh
# Set ORA_HOME to be equivalent to the ORACLE_HOME
# from which you wish to execute dbstart and
# dbshut
# set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME
ORA_HOME=/u01/app/oracle/product/8.1.7
ORA_OWNER=oracle
if [! -f $ORA_HOME/bin/dbstart]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
’start’)
# Start the Oracle databases:
# The following command assumes that the oracle login will not prompt the
# user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
;;
’stop’)
# Stop the Oracle databases:
# The following command assumes that the oracle login will not prompt the
# user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
;;
esac
4. Link dbora by entering:
# ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
# ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora
加入
LSNRCTL START
SVRMGR
CONNECT INTERNAL
STARTUP;