[十万火急]求助我的Oracle不能备份

ihhvqu

进入Oracle用户后,输入  exp出现下面的提示:
Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
stty: : Inappropriate ioctl for device

Export: Release 9.2.0.1.0 - Production on Tue Jun 12 16:35:23 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully

不知道怎么解决?
Oracle运行正常,就是不能备份,其他一切正常
出问题前,Oracle备份指定的目录满了,当Oracle不能备份后,就删除了一些文件,就又有了空间,再次备份,发现还是不能备..不知道咋个解决..   望高手指点...  在线等....!!!

fyuansheng

看看你ORACLE数据库现在的状态是否是OPEN

doni

当前用户有没有设置ORACLE_SID等

ihhvqu

前几天都还能备份的..

ORACLE数据库现在的状态是否是OPEN ?  这个怎么看?

joyw

看看你的数据库是否可用!

ihhvqu

可用,可以使用,  基于数据库的其他业务都能用..  
就只是不能备份...

gongzidong

把命令和 环境变量贴上来看看。

ihhvqu

root@dgnc1 #  su - oracle
Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
$ exp

Export: Release 9.2.0.1.0 - Production on Wed Jun 13 09:46:30 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Username: bbd1
Password:

EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
$ exp

Export: Release 9.2.0.1.0 - Production on Wed Jun 13 09:46:47 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Username: bbd2
Password:

EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
$ exit
root@dgnc1 # exit

主要是这两个用户都不能登陆...

numenhuang

1. ps -ef|grep ora
2. su - oracle
    sqlplus "/ as sysdba"
    sql>select open_mode from v$database

beking1627

我看多半是ORACLE_SID的问题，echo $ORACLE_SID看看。