SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem creating connection to ASM instance (or mounted database in general)

mickywJun 14 2024

I try to use VS code extenstion to test monitoring queries against ASM instance, so using asmsnmp user with sysdba role.
“Test connection” succeeds but there is an error when I try to save connection, i.e. “Create connection”:

Error opening connection 'ASMSNMP.ASM'. Details: ORA-06550: line 4, column 75: PL/SQL: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only ORA-06550: line 4, column 30: PL/SQL: SQL Statement ignored

And in my case there is no connection created after this error :(

I use version v21.10.0

Regards,
Michal

This post has been answered by thatJeffSmith-Oracle on Jun 14 2024

Jump to Answer

Added on Jun 14 2024

3 comments

175 views