无法在 SQL Developer 中打开 View->DBA Menu(已安装 Oracle 12C 标准版)

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/24143886/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-10 05:40:11  来源:igfitidea点击:

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

oracleoracle-sqldeveloperoracle12c

提问by RobinHood

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.

我已经安装了 Oracle 12C 标准版。那里一切正常。我还连接了 Oracle SQL Developer Client 4.0。从中我可以访问表、索引等。

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.

我试图通过单击“查看”->“DBA”菜单从 SQL Developer Client 中查看表空间详细信息。通过单击此菜单,不会打开任何内容。

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

通过 EM 我可以看到那些。但是我想看透SQL开发人员。

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

我不确定是否需要进行任何设置,以便可以打开 View -> DBA 菜单。

Attached Screenshot for reference:

附截图供参考:

Here I am selecting the DBA option under View Menu

在这里我选择查看菜单下的 DBA 选项

enter image description here

在此处输入图片说明

But I don't see any DBA related window.

但我没有看到任何与 DBA 相关的窗口。

enter image description here

在此处输入图片说明

采纳答案by Alex Poole

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:

选择 View->DBA 菜单项将显示“DBA”面板,位于 SQL Developer 窗口的左侧和“Connections”面板下方的某处;确切的位置可能会有所不同,具体取决于您显示的其他面板:

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

在此处输入图片说明

回答by ame-h

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

我遇到了同样的问题,通过以下方式解决:Windows->将窗口重置为出厂设置。之后一切正常

回答by Chathura

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

转到 Sql Developer 窗口的菜单-->将 Windows 重置为出厂设置

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

然后转到查看菜单 ----> 单击 DBA

it works.(Version 17.2.0.188)

它有效。(版本 17.2.0.188)

回答by Hrithu

I have got this problem a month ago.

一个月前我遇到了这个问题。

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

1-转到 C:\Documents and Settings\“您的个人资料”\Application Data\SQL Developer

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

2-保存您的连接:o.jdeveloper.db.connection.11.1.1.0.22.49.35

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

3-删除 C:\Documents and Settings\“您的配置文件”\Application Data\SQL Developer

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

4-重新启动SQL developer,会重新创建相同的目录结构。

5-exit SQL developer

5-exit SQL 开发人员

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

6-将备份“o.jdeveloper.db.connection.11.1.1.0.22.49.35”复制到C:\Documents and Settings\“你的配置文件”\Application Data\SQL Developer

7- you should be able to see the connection tab

7- 您应该能够看到连接选项卡

回答by mcs5234

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

1.) 保存位于 Windows 10 中的当前 SQL 连接 xml 文件: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\

2.) 现在删除位于以下位置的 SQL Developer 文件夹和 sqldeveloper 文件夹: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.

3.) 现在删除包含实际 SQL 开发人员应用程序文件的主 sqldeveloper 文件夹。这将位于您最初解压缩 SQLDeveloper 下载的任何位置。

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

4.) 下载最新版本的 SQL Developer 并在任何你喜欢的地方解压。

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

5.) 启动 SQL developer 并指定您的 JDK 位置。

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

6.) 将您的连接 xml 文件复制到您的漫游 SQL Developer 目录: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

7.) 启动 SQL Developer,选择视图 -> DBA 后,您的 DBA 视图现在应该可用