OS환경 : Oracle Cloud Linux (64bit)
DB 환경 : Oracle Cloud ATP Database 18.4.0.0
에러 : ORA-28759: failure to open file
sqlplus 로 원격지인 atpdb에 접속시도 후 에러발생
1 2 3 4 5 6 7 8 9 | $ sqlplus admin/패스워드@atpdb_high SQL*Plus: Release 18.0.0.0.0 - Production on Wed Jan 16 15:03:21 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. ERROR: ORA-28759: failure to open file |
해결 방법 : sqlnet.ora 파일의 경로 확인
sqlnet.ora 파일 안 DIRECTORY경로가 wallet가 있는 경로가 맞는지 확인한다.
1 2 3 4 | $ vi sqlnet.ora WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/oracle"))) SSL_SERVER_DN_MATCH=yes |
정상적인 경로로 수정
1 2 3 4 | $ vi sqlnet.ora WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/oracle/jsh/instantclient_18_3"))) SSL_SERVER_DN_MATCH=yes |
재접속
잘 들어가지는것을 확인할 수 있다.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | $ sqlplus admin/패스워드@atpdb_high SQL*Plus: Release 18.0.0.0.0 - Production on Wed Jan 16 14:16:19 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Last Successful login time: Mon Jan 14 2019 15:24:49 +09:00 Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 SQL> select instance_name, version, status from v$instance; INSTANCE_NAME VERSION STATUS ---------------- ----------------- ------------ e7e1pod1 18.0.0.0.0 OPEN |
원인 : sqlnet.ora 파일 안 DIRECTORY경로가 맞지 않아 발생한 오류
참조 : Connecting To ADW/ATP Using Sqlplus Is Failing With "ORA-28759: failure to open file" (문서 ID 2498200.1)