0

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 21.0.0.0.0 - Production on Tue Jun 21 09:40:00 2022
Version 21.6.0.0.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 18.0.0.0.0 - Production
Version 18.4.0.0.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: datagrip settings

Error is following:

enter image description here

How can I fix it?

New contributor
Timofey Pasichnik is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

1 Answer 1

0

In order to connect to a pluggable database, you need to specify the SERVICE_NAME for it (forslash notation '/XEPDB1'), so you will have to specify database type "Oracle Database" and not "Oracle SID" (colon notation ':XEPDB1') in the DataGrip IDE.

Best of luck!

1
  • service name works fine. Thank you for help. Jun 22 at 10:18

Your Answer

Timofey Pasichnik is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.