(3)查看参数文件内容
[oracle@oracle dbs]$ cat inittest.ora
test.__db_cache_size=184549376
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__shared_pool_size=88080384
test.__streams_pool_size=0
audit_file_dest='/u01/oracle/admin/test/adump'
background_dump_dest='/u01/oracle/admin/test/bdump'
compatible='11.2.0'
control_files='/dev/raw/raw2','/dev/raw/raw3','/dev/raw/raw4'
core_dump_dest='/u01/oracle/admin/test/cdump'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='TEST'
db_recovery_file_dest='/u01/oracle/flash_recovery_area'
dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=94371840
processes=150
remote_login_passwordfile='EXCLUSIVE'
sga_target=285212672
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_dump_dest='/u01/oracle/admin/test/udump'
db_recovery_file_dest_size=2G
(4)将参数文件中的background_dump_dest和user_dump_dest注释掉
(5)验证问题是否解决:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile;
File created.
SQL>startup;
ORACLE instance started.
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 100666652 bytes
Database Buffers 176160768 bytes
Redo Buffers 6402048 bytes
Database mounted.
Database opened.
报错消失!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23898243/viewspace-687092/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23898243/viewspace-687092/