oracle数据库备份常遇问题
(2012-04-13 15:39:45)
标签:
oracle
exp
杂谈
分类:
数据库
1、/home/oracle/product/10.2.0/db_1/bin目录下执行./exp报错:
[root@test216 bin]# ./exp
Message 206 not found; No message file for product=RDBMS,
facility=EXP: Release 10.2.0.1.0 - Production on Fri Apr 13
11:57:40 2012
Copyright (c) 1982, 2005, Orac
Invalid format of Export utility name
Verify that ORACLE_HOME is properly set
Export terminated unsuccessfully
EXP-00000: Message 0 not found; No message file for product=RDBMS,
facility=EXP
解决方法:
报上述错误是因为找不到环境变量,添加临时环境变量,问题解决:
[root@test216 bin]# export
ORACLE_HOME="/home/oracle/product/10.2.0/db_1"
[root@test216 bin]# export ORACLE_SID=test
[root&