Error When Connecting To Database Instance Using SQL Developer
(Doc ID 1992276.1)
Last updated on NOVEMBER 13, 2019
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle SQL Developer - Version 4.0 and later
Information in this document applies to any platform.
Symptoms
On SQL Developer 4.0 version, Making and Saving Connections
ACTUAL BEHAVIOR
---------------
When connecting to a database connection using SQL Developer, The Query Result portion of the screen displays:
/ by zero
Connection using SQL*Plus, works.
STEPS
-----------------------
SQL Developer 4.0.3
Database 11.2.0.4
DB Client 12.1.0.1
The issue can be reproduced with the following steps:
1. Have the connection come up with the warning: your password will expire in x days.
2. Try to run a query
3. Receive the "/ by zero" for the query result.
Changes
Password Warning that the password needs reset in x days
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |