ORA-01078: failure in processing system parameters 에러 해결

현스·2024년 8월 21일

ORACLE STUDY

목록 보기
1/14
post-thumbnail

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/19c/db_home/dbs/initjhs1.ora'
SQL> exit

ORA-01078: failure in processing system parameters
에러 발생

[oracle@test ~]$ cd /oracle/app/oracle/product/19c/db_home/dbs
[oracle@test dbs]$ ls
hc_orcl.dat  init.ora  lkORCL  orapworcl  spfileorcl.ora

-> cd /oracle/app/oracle/admin/orcl/pfile
들어가서 ls

[oracle@test ~]$ cd /oracle/app/oracle/admin/
[oracle@test admin]$ ls
orcl
[oracle@test admin]$ cd orcl
[oracle@test orcl]$ ls
adump  dpdump  pfile  xdb_wallet


[oracle@test orcl]$ cd pfile
[oracle@test pfile]$ ls
init.ora.7212024105334

-> 카피해서 LRM-00109: could not open parameter file '/oracle/app/oracle/product/19c/db_home/dbs/initjhs1.ora'
이 위치로.
cp /oracle/app/oracle/admin/orcl/pfile/init.ora.7212024105334 /oracle/app/oracle/product/19c/db_home/dbs/initjhs1.ora

하면 해결 완.

profile
˗ˋˏ O R A C L E ˎˊ˗

0개의 댓글