I have an Oracle XE database on computer1.
When I try to connect to it via sqlplus from computer2, it works fine, for both cdb and pdb connections; e.g.:
rlwrap sqlplus timon@//192.168.0.115:9121/xepdb1 SQL*Plus: Release 18.104.22.168.0 - Production on Tue Jun 21 09:40:00 2022 Version 22.214.171.124.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Enter password: Last Successful login time: Tue Jun 21 2022 09:39:11 +03:00 Connected to: Oracle Database 18c Express Edition Release 126.96.36.199.0 - Production Version 188.8.131.52.0 SQL>
When I try to connect to it via DataGrip IDE:
- I can connect to container database with username "sys as sysdba"
- I cannot connect to pluggable database xepdb1. Settings are following:
Error is following:
How can I fix it?