oracle 无法使用 PL/SQL Developer 登录
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13879527/
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
Unable to log-in using PL/SQL Developer
提问by
I have problem with logging into my database using Pl/SQL Developer. All connection parameters are defined in TNSNAMES.ORA and work perfectly with SQL Developer.
我在使用 Pl/SQL Developer 登录我的数据库时遇到问题。所有连接参数都在 TNSNAMES.ORA 中定义并且与 SQL Developer 完美配合。
Unfortunately, when I try to connect using PL/SQL Developer, I am receiving a message with no content. I am using version 9.0.6.1665.
不幸的是，当我尝试使用 PL/SQL Developer 进行连接时，我收到一条没有内容的消息。我使用的是 9.0.6.1665 版本。
Is this a known issue and what might I be doing wrong?
这是一个已知问题吗？我可能做错了什么？
Here is image of this strange error:
这是这个奇怪错误的图像：
回答by Ujjwal
Probably you might have already resolved your issue, but I would like to add my solution here.
可能您已经解决了您的问题，但我想在这里添加我的解决方案。
I faced the same issue of blank error screen on trying to logon to PL/SQL Developer. OS Win 7 Pl/SQL Dev 7.1.3 Oracle client 10g
我在尝试登录 PL/SQL Developer 时遇到了同样的空白错误屏幕问题。操作系统 Win 7 Pl/SQL Dev 7.1.3 Oracle 客户端 10g
Step 1: I checked the output of "tnsping". It resulted in error - Message 3511 not found The cause was incorrect setting of ORACLE_HOME value in my environment. After correcting ORACLE_HOME, tnsping started to work but I still got the same blank error screen in PL/SQL Developer. Edit:Refer the linkfor more info on setting ORACLE_HOME correctly.
第 1 步：我检查了“tnsping”的输出。它导致错误 - 未找到消息 3511 原因是我的环境中 ORACLE_HOME 值设置不正确。更正 ORACLE_HOME 后，tnsping 开始工作，但我仍然在 PL/SQL Developer 中看到相同的空白错误屏幕。 编辑：有关正确设置 ORACLE_HOME 的更多信息，请参阅链接。
Step 2: I started PL/SQL Developer with option "Run as Administrator". After providing the administrator password, I was able to logon successfully through PL/SQL Developer
第 2 步：我使用“以管理员身份运行”选项启动了 PL/SQL Developer。提供管理员密码后，我可以通过PL/SQL Developer成功登录
Step 3: Later I changed the User Account Control settings (Win 7 Control Panel > User Accounts > Change User Account Control settings). I set it to "Never notify" and restarted my PC. Thereafter, I ran PL/SQL Developer as normal user and did not face the issue.
第 3 步：后来我更改了用户帐户控制设置（Win 7 控制面板 > 用户帐户 > 更改用户帐户控制设置）。我将其设置为“从不通知”并重新启动了我的电脑。此后，我以普通用户身份运行 PL/SQL Developer 并没有遇到此问题。
I hope this helps someone.
我希望这可以帮助别人。
回答by Abul Mohsin
- Make sure you are connected to Network/VPN.
- Open PL/SQL Developer.
- Click on Tools -> Preferences. Select the very first option: Connection.
- From Oracle Home drop down list, select the correct option. If you are not sure which is correct, try choosing one after another until the one that works for you.
- Restart PL/SQL Developer.
- Cross your fingers and retry to connect to your databases. If it works, say "Buiya". If it doesn't, scream "F***", and Google search.
- 确保您已连接到网络/VPN。
- 打开 PL/SQL 开发人员。
- 单击工具 -> 首选项。选择第一个选项：连接。
- 从 Oracle Home 下拉列表中，选择正确的选项。如果您不确定哪个是正确的，请尝试一个接一个地选择，直到最适合您的那个。
- 重新启动 PL/SQL Developer。
- 交叉手指并重试连接到您的数据库。如果有效，请说“Buiya”。如果没有，请尖叫“F ***”，然后谷歌搜索。
回答by Jenna Leaf
5 Things to get PLSQL Developer to work after its installation.
安装 PLSQL Developer 后让其工作的 5 件事。
- You need an Oracle Client. Google "Oracle Tech Support Download"and download a suitable Oracle Client for your environment(w32/64 or linux). When you install, make sure your picks includes "runtime" option. Get the newest appropriate version even if your PL/SQL Developer is old. Mine is
- "win32_11gR2_client".
- Use your Control Panel's System Settings, edit your environmental vars - make sure Oracle's bin pathis in both System Path and User Path or at least User Path. Mine is
- C:\Oracle\product\11.2.0\client_1\bin
- Re-install your PL/SQL Developer if you still have login issue. The developer will open up a blank doc in which you can use HELP's "Register" item to register your Product-Key and your (given serial No. and password).
- Check "Support Info" under HELP. Go thru their info. Edit your environmental var to make sure the info gets all the correct search paths. Use the Tools/Preferences/Connection/(Oracle Home and OCI library) Dropdownto select the desired version
Go to Oracle Top Directory. Use search function to search all the subdirectories for a file called tnsnames.ora.
a. Enter that path to System setting's Environment.
b. Follow the expected format, provide the names for TNS resolution. Edit the file to include an addr list
var1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = _____)(PORT = ____)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = _____)))
var2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ______)(PORT = ____)) (CONNECT_DATA = (SERVER = DEDICATED)(SID = _____)))
- 您需要一个 Oracle 客户端。谷歌“Oracle 技术支持下载”并为您的环境（w32/64 或 linux）下载合适的 Oracle 客户端。安装时，请确保您的选择包括“运行时”选项。即使您的 PL/SQL Developer 是旧的，也要获得最新的合适版本。我的是
- “win32_11gR2_client”。
- 使用您的控制面板的系统设置，编辑您的环境变量 - 确保 Oracle 的 bin路径在系统路径和用户路径中，或者至少在用户路径中。我的是
- C:\Oracle\product\11.2.0\client_1\bin
- 如果您仍然有登录问题，请重新安装您的 PL/SQL Developer。开发人员将打开一个空白文档，您可以在其中使用 HELP 的“注册”项来注册您的产品密钥和您的（给定序列号和密码）。
- 检查帮助下的“支持信息”。浏览他们的信息。编辑您的环境变量以确保信息获得所有正确的搜索路径。使用Tools/Preferences/Connection/(Oracle Home and OCI library) 下拉菜单选择所需的版本
转到 Oracle 顶级目录。使用搜索功能在所有子目录中搜索名为tnsnames.ora的文件。
一种。输入系统设置环境的路径。
湾 按照预期的格式，提供 TNS 解析的名称。编辑文件以包含地址列表
var1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = _____)(PORT = ____)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = _____)))
var2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ______)(PORT = ____)) (CONNECT_DATA = (SERVER = DEDICATED)(SID = _____)))
SERVICE_NAME and SID are interchangeable!
SERVICE_NAME 和 SID 可以互换！
