내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.4 (64bit)
DB 환경 : Oracle Database 18.3.0.0
에러 : ORA-32010: cannot find entry to delete in SPFILE
alter system reset ~ 명령 이용시 발생하는 메세지
1 2 3 4 5 6 | SQL> alter system reset db_recovery_file_dest scope=spfile; alter system reset db_recovery_file_dest scope=spfile * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE |
spfile 사용확인
1 2 3 4 5 | SQL> show parameter spfile NAME TYPE VALUE ------------------- ----------- ------------------------------ spfile string /oracle/app/oracle/product/18.0.0/dbhome_1/dbs/spfileORCL18.ora |
spfile 사용중
해결 방법 : spfile에 존재하는 파라미터에 대해서만 reset 명령을 사용해야함
해당 파라미터 조회
1 2 3 4 5 6 | SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string db_recovery_file_dest_size big integer 0 |
현재 미사용중인 파라미터임
pfile 생성 후 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | SQL> create pfile from spfile; File created. $ cat $ORACLE_HOME/dbs/initORCL18.ora ORCL18.__data_transfer_cache_size=0 ORCL18.__db_cache_size=1811939328 ORCL18.__inmemory_ext_roarea=0 ORCL18.__inmemory_ext_rwarea=0 ORCL18.__java_pool_size=16777216 ORCL18.__large_pool_size=33554432 ORCL18.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment ORCL18.__pga_aggregate_target=838860800 ORCL18.__sga_target=2516582400 ORCL18.__shared_io_pool_size=134217728 ORCL18.__shared_pool_size=503316480 ORCL18.__streams_pool_size=0 *.audit_file_dest='/oracle/app/oracle/admin/ORCL18/adump' *.audit_trail='db' *.compatible='18.0.0' *.control_files='/oracle/app/oracle/oradata/ORCL18/control01.ctl','/oracle/app/oracle/oradata/ORCL18/control02.ctl' *.db_block_size=8192 *.db_name='ORCL18' *.diagnostic_dest='/oracle/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL18XDB)' *.local_listener='LISTENER_ORCL18' *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.pga_aggregate_target=797m *.processes=300 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=2388m *.undo_tablespace='UNDOTBS1' |
spfile을 pfile로 변환한뒤 확인해봐도
현재 미사용중인 파라미터임
원인 : spfile에 존재하지 않는 파라미터를 reset 하려고 해서 발생한 메세지
spfile에 존재하지 않는 파라미터를 reset 하려고 해서 발생한 메세지
참조 :