Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

issue connecting to database 19c

hi am not able to connect to datbase in sql developer but datbase is up and running and open
 select status from v$instance;

STATUS
------------
OPEN

SQL> !

  2  ;

D
-
X

SQL> select status from v$instance;

STATUS
------------
OPEN

error




ASKER CERTIFIED SOLUTION
Avatar of Binh Win
Binh Win
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chalie001
chalie001

ASKER

i got solution i have to put corrent sid in server tnsname
Yep, Oracle DB connection issues are mostly related to the TNSnames.ora file.