CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperoracle12c
RobinHood
RobinHood

Reputation: 2397

Can't open View->DBA Menu in SQL Developer (Oracle 12C Standard Edition Installed)

I have installed Oracle 12C Standard Edition. Everything works fine there. I have also connected the Oracle SQL Developer Client 4.0. From that I can access the tables, indexes etc.

I am trying to see the tablespace details from SQL Developer Client by clicking the View -> DBA menu. By clicking this menu, nothing is getting opened.

Through EM I can able to see those. But I want to see through SQL developer.

I am not sure, whether I need to do any settings, so that the View -> DBA menu can be opened.

Attached Screenshot for reference:

Here I am selecting the DBA option under View Menu

enter image description here

But I don't see any DBA related window.

enter image description here

Upvotes: 25

Views: 48399

Answers (5)

Chathura
Chathura

Reputation: 61

goto Menu of the Sql Developer windows-->Reset the Windows to Factory Settings

and then goto view menu ----> click DBA

it works.(Version 17.2.0.188)

Upvotes: 4

mcs5234
mcs5234

Reputation: 1

1.) Save your current SQL connection xml file located in windows 10: C:\Users\"youruseraccount"\AppData\Roaming\SQL Developer\systemXXXXX\o.jdeveloper.db.connection.xxxxxx

2.)Now delete your SQL Developer Folder and sqldeveloper folder located in: C:\Users\"youruseraccount"\AppData\Roaming\

3.)Now delete the main sqldeveloper folder containing the actual SQL developer application files.This would be located wherever you initially unzipped the SQLDeveloper download.

4.)Download the latest version of SQL Developer and unzip wherever you like.

5.)Launch SQL developer and specify your JDK location.

6.)Copy your connections xml file to your roaming SQL Developer directory here: C:\Users\"youruseraccount"\AppData\Roaming\SQL Developer\systemXXXXXX)\o.jdeveloper.db.connection.xxxxxx

7.)Launch SQL Developer and your DBA view should now be available after selecting view -> DBA

Upvotes: 0

Hrithu
Hrithu

Reputation: 281

I have got this problem a month ago.

1-Go to C:\Documents and Settings\"your profile"\Application Data\SQL Developer

2-Save your connection : o.jdeveloper.db.connection.11.1.1.0.22.49.35

3-delete the C:\Documents and Settings\"your profile"\Application Data\SQL Developer

4-restart SQL developer, will recreate the same directory structure.

5-exit SQL developer

6-copy the backup "o.jdeveloper.db.connection.11.1.1.0.22.49.35" to C:\Documents and Settings\"your profile"\Application Data\SQL Developer

7- you should be able to see the connection tab

Upvotes: 0

ame-h
ame-h

Reputation: 1627

I faced same problem, solved by: Windows->reset windows to factory settings. After that everything worked fine

Upvotes: 135

Alex Poole
Alex Poole

Reputation: 191275

Selecting the View->DBA menu item displays the "DBA" panel, on the left side of the SQL Developer window and somewhere below the "Connections" panel; the exact placement may vary a bit depending on which other panels you have displayed:

enter image description here

You then need to add a connection in that window' if you click the green plus sign you can choose an existing connection to add to this panel. Once you've done that you can expand the sections to see the tablespaces:

enter image description here

Upvotes: 4

Related Questions