我刚在FEDORA 上装了oracle9.2 ,刚开始很正常的,添加oracle用户,建新表等操作都可以的. 但,当我重启linux 后,问题就出来了. $ lsnrctl start error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory $ sqlplus /nolog error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory 都无法把oracle启动起来~~~~~
by law7890 - Oracle - 2006-03-10 16:52:34 阅读(1328) 回复(9)
我使用的是linux6.2+oraclei8.1.6每次在启动linux后要手动启动oracle数据库服务,很麻烦。怎样在启动linux时自动启动oracle??!! 还有如果我要新建一个库应该怎样作呀!!??oracle有没有菜单操作呀(其它一些数据库在服务器端都提供菜单操作如informix的dbaccess)!!!??
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 # ...
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 请问各位高手怎么解决,谢谢!
按照网上的说法先添加以下脚本: 下面是init/etc/init.d下ora文件脚本 --------------------------- OPT_=$1 case "$OPT_" in start) /bin/echo "$0 : (start)" # # Your service startup command goes here. # su - oracle -c "/opt/oracle/product/9.2.0/bin/lsnrctl start" su - oracle -c "/opt/oracle/product/9.2.0/bin/dbstart" # NOTE: Must exit with zero unless error is severe. exit 0 ;; stop) /bi...
参照oracle的帮助配置oracle自动启动,以下是出错log的一段。 连接被拒绝,什么原因?该怎么解决? ...... May 24 00:56:38 localhost dbora: + oracle_HOME=/usr/ora10g/oracle May 24 00:56:38 localhost dbora: + oracle=oracle May 24 00:56:38 localhost dbora: + PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/ora10g/oracle/bin May 24 00:56:38 localhost dbora: ++ hostname May 24 00:56:38 localhost dbora...
参照oracle的帮助配置oracle自动启动,以下是出错log的一段。 连接被拒绝,什么原因?该怎么解决? ...... May 24 00:56:38 localhost dbora: + oracle_HOME=/usr/ora10g/oracle May 24 00:56:38 localhost dbora: + oracle=oracle May 24 00:56:38 localhost dbora: + PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/ora10g/oracle/bin May 24 00:56:38 localhost dbora: ++ hostname May 24 00:56:38 localhost dbora...