操作环境:
[oracle@NJ ~]$ lsb_release -a
LSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5.2 (Tikanga)
Release: 5.2
Codename: Tikanga
[oracle@NJ ~]$ arch
i686
linux :RHEL 5.2 32bit
oracle :10g
问题描述:
执行sqlplus /as sysdba和rman target /命令无反应
[oracle@NJ bin]$ rman target /
[oracle@NJ ~]$ sqlplus / as sysdba
[oracle@NJ ~]$ sqlplus /nolog
[oracle@NJ ~]$ sqlplus "/as sysdba"
[oracle@NJ ~]$
[oracle@NJ ~]$
分析排查:
[root@NJ ~]# su - oracle
[oracle@NJ ~]$ echo $ORACLE_HOME
/oracle/ora10/product
[oracle@NJ ~]$ cd /oracle/ora10/product/bin
[oracle@NJ bin]$ ll
total 53348
-rwxr-xr-x 1 oracle oinstall 13093 Oct 20 2005 adapters
-rw-r----- 1 oracle oinstall 1524 Jul 20 06:40 aqxmlctl
-rw-r----- 1 oracle oinstall 6768 Nov 4 2004 aqxmlctl.pl
该目录下没有找到一名字为oracle的文件,200多M的二进制程序 ,oracle依靠这个程序来启动其它所有进程、
该文件丢失,无法启动其他重要进程,故该命令无法启动数据库软件
解决办法:
重装软件
正常情况下,在DBCA安装完数据库软件后(建库前),已经能够使用sqlplus和rman命令
[oracle@NJ ~]$ cd /oracle/ora10/product/bin
[oracle@bj bin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 20 17:37:17 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
[oracle@bj bin]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 20 17:37:30 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN>