首先我启动了监听程序[code] LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 01-DEC-2011 05:06:48 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...
by lysddp - Linux系统管理 - 2011-12-02 11:23:24 阅读(2651) 回复(5)
linux下系统开机oracle自启动
以root身份登录:
$su - root
1、linux下oracle自带的dbstart和dbshut没反应:
修改Oracle系统配置文件/etc/oratab文件: #vi /etc/oratab
/etc/oratab 格式为: SID:ORACLE_HOME:AUTO
把AUTO域设置为Y(大写),我的为:
oradb:/opt/u01/app/oracle/product/9.2.0.4:Y
&n...
请教linux下oarcle的问题,现象是这样的 启动的时候抱错: Database mounted. ORA-01113: file 2 needs media recovery ORA-01110: data file 2: '/app/oracle/oradata/ARL/undotbs01.dbf' 上网一搜,执行了 SQL> alter database datafile '/app/oracle/oradata/ARL/undotbs01.dbf' offline drop; Database altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 5 needs media recovery...
首先在/etc/rc.d/init.d/目录下配置Oracle的服务文件。 touch oracle10g chmod a+x oracle10g 然后编辑此oracle10g文件。内容如下。 # !/bin/bash # whoami # root # chkconfig: 345 51 49 # description: starts the oracle dabase deamons # ORA_HOME=/opt/oracle ORA_OWNER=oracle case "$1" in 'start') echo -n "Starting oracle10g: " su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" & su - $ORA_OWNER -c "$ORA_HOME/bin/ls...
1、 修改Oracle系统配置文件/etc/oratab /etc/oratab 格式为: SID:ORACLE_HOME:AUTO 把AUTO域设置为Y(大写),只有这样,oracle 自带的dbstart和dbshut才能够发挥作用。我的为: ora9i:/home/oracle/ora/products/9.2.0:Y 2、 编写服务脚本: 如下 #!/bin/bash # #################FUNCTION############# # # Auto Start Oracle and listener # AutoStop Oracle and listener # ...
linux下系统开机oracle自启动 以root身份登录: $su - root 1、linux下oracle自带的dbstart和dbshut没反应: 修改Oracle系统配置文件/etc/oratab文件: #vi /etc/oratab /etc/oratab 格式为: SID:ORACLE_HOME:AUTO 把AUTO域设置为Y(大写),我的为: oradb:/opt/u01/app/oracle/product/9.2.0.4:Y 只有这样,oracle 自带的dbstart和dbshut才能够发挥作用。 2、修改/etc/rc.d/rc.local配置文件 在/etc/rc.d/rc...
linux下oracle启动和关闭脚本 自己写的,很简单,可以看看: 1)启动脚本(dbstart.sh) lsnrctl start sqlplus /nolog connect / as sysdba startup; exit EOF $sh dbstart.sh 即可 2)关闭脚本(dbstop.sh) lsnrctl stop sqlplus /nolog connect / as sysdba shutdown immediate; exit EOF $sh dbstop.sh 即可 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinau...
SQL>; connect / as sysdba ERROR: ORA-09817: Write to audit file failed. Linux Error: 28: No space left on device ORA-09945: Unable to initialize the audit trail file Linux Error: 28: No space left on device 请问各位高手怎么解决,谢谢!