linux下启动oracle步骤 是不是应该倒过来? lsnrctl 放到2前面; 另外,连接加上 @sid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你一个shell用的时候再修改一下#!/bin/bash## Run-level Startup script for the Oracle Instance and Listener## chkconfig: 345 91 19# description: Startup/Shutdown Oracle listener and instanceORA_HOME="/opt/u01/app/oracle/product/9.2.0"ORA_OWNR="oracle"# if the executables do not exist -- display errorif [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]then echo "Oracle startup: cannot start" exit 1fi# depending on parameter -- startup, shutdown, restart # of the instance and listener or usage display case "$1" in start) # Oracle listener and instance startup echo -n "Starting Oracle: " su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start" su - $ORA_OWNR -c $ORA_HOME/bin/dbstart touch /var/lock/subsys/oracle echo "OK" ;; stop) # Oracle listener and instance shutdown echo -n "Shutdown Oracle: " su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop" su - $ORA_OWNR -c $ORA_HOME/bin/dbshut rm -f /var/lock/subsys/oracle echo "OK" ;; reload|restart) $0 stop $0 start ;; *) echo "Usage: $0 start|stop|restart|reload" exit 1esacexit 0 跪求在线等候 前端java與调用后台sql问题 oracle10gTNS-12545:因目标主机或对象不存在,连接失败 请问如何查询ORACLE的历史操作记录!!!!! Update语句怎样一次完成一一对应的数据更新??? insert into values select 关于oracle上在两个不同机器上的数据库数据的导入问题 求一SQL,怎么算出库中所有表记录不为空的表 >>>>>>>如何让8i和9i并存的问题 oracle中无from的select问题 access数据库怎么导入到oracle指定用户下呢 求一个高效率的小算法!
#!/bin/bash
#
# Run-level Startup script for the Oracle Instance and Listener
#
# chkconfig: 345 91 19
# description: Startup/Shutdown Oracle listener and instanceORA_HOME="/opt/u01/app/oracle/product/9.2.0"
ORA_OWNR="oracle"# if the executables do not exist -- display errorif [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi# depending on parameter -- startup, shutdown, restart
# of the instance and listener or usage display case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNR -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNR -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: $0 start|stop|restart|reload"
exit 1
esac
exit 0