BBED-00303: unable to open file '/u01/app/oracle/oradata/vrh9i/'

来源：互联网发布：淘宝运营简历范文编辑：程序博客网时间：2024/06/06 15:51

今天学习bbed,设置了相应的参数:

SQL> select file#||''||name||''||bytes from v$datafile;

FILE#||''||NAME||''||BYTES
------------------------------------------------------------------------------
1/u01/app/oracle/oradata/vrh9i/system01.dbf340787200
2/u01/app/oracle/oradata/vrh9i/undotbs01.dbf209715200
3/u01/app/oracle/oradata/vrh9i/cls01.dbf524288000
4/u01/app/oracle/oradata/vrh9i/indx01.dbf26214400

5/u01/app/oracle/oradata/vrh9i/perfstat.dbf524288000

[oracle@Centos42 bbed]$ cat /home/oracle/bbed/filelist.txt
1 /u01/app/oracle/oradata/vrh9i/system01.dbf 340787200
2 /u01/app/oracle/oradata/vrh9i/undotbs01.dbf 209715200
3 /u01/app/oracle/oradata/vrh9i/cls01.dbf 524288000
4 /u01/app/oracle/oradata/vrh9i/indx01.dbf 26214400
5 /u01/app/oracle/oradata/vrh9i/perfstat.dbf 524288000

[oracle@Centos42 bbed]$ cat /home/oracle/bbed/bbed.par
blocksize=8192
listfile=/home/oracle/bbed/filelist.txt
mode=edit

[oracle@Centos42 bbed]$ bbed parfile=/home/oracle/bbed/bbed.par
BBED-00303: unable to open file '/u01/app/oracle/oradata/vrh9i/'

发现原来是“select file#||''||name||''||bytes from v$datafile;”’‘ 之间忘了空格...粗心啊！

修改：

SQL> select file#||' '||name||' '||bytes from v$datafile;

FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/vrh9i/system01.dbf 340787200
2 /u01/app/oracle/oradata/vrh9i/undotbs01.dbf 209715200
3 /u01/app/oracle/oradata/vrh9i/cls01.dbf 524288000
4 /u01/app/oracle/oradata/vrh9i/indx01.dbf 26214400
5 /u01/app/oracle/oradata/vrh9i/perfstat.dbf 524288000

‘ ’之间加了空格就OK了

[oracle@Centos42 bbed]$ bbed parfile=/home/oracle/bbed/bbed.par
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Sun Jul 22 10:03:03 2012

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

************* !!! For Oracle Internal Use only !!! ***************

BBED>