我有一个测试数据库.每天晚上脚本都会丢弃并重新创建一些可插入的数据库,这些数据库用于我们的自动化测试运行.最近,我开始在create pluggable database命令中获得’ORA-00059:超出文件的最大数量’错误.我必须遗漏一些东西,因为据我所知,我不在最接近的地方(这个剧本在一个月前工作).
SQL> select value from v$parameter where name = 'db_files';
VALUE
-----------------------------------------------------------
200
SQL> select count(*) from v$datafile;
COUNT(*)
----------
24
SQL> create pluggable database testdb FROM DB_SEED
2 FILE_NAME_CONVERT = ('/home/ora12c1/app/ora12c1/oradata/ora12c1/testdb_seed/', '/home/ora12c1/app/ora12c1/oradata/ora12c1/testdb/')
3 PATH_PREFIX = '/home/ora12c1/app/ora12c1/oradata/ora12c1/testdb';
create pluggable database testdb FROM DB_SEED
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
看起来以下解决了这个问题:
错误18522516 12.1.1.4(2014年7月)数据库补丁集更新(PSU)
但需要注意的是,在创建新的可插拔数据库之前,我不得不退回数据库.至于,我执行了我在doc中看到的所有步骤:
使用opatch apply应用补丁
启动/打开所有pdbs
运行datapatch -verbose
然后我不得不退回数据库来解决我的问题.
解决方法:
答案是作为问题的更新发布的:
It looks like the following resolves the issue: Bug 18522516 12.1.0.1.4 (Jul 2014) Database Patch Set Update (PSU)
One note though, I had to bounce the database before I could create a new pluggable database. As, I preformed all the steps that I saw in the doc:
Apply the patch using opatch apply Startup/Open all pdbs Run datapatch -verbose
Then I had to bounce the database to resolve my issue.
标签:linux,oracle,oracle-12c
来源: https://codeday.me/bug/20190806/1595351.html