无法使用Oracle SQL Developer以SYS身份登录数据库 [英] Unable to log in to database as SYS with Oracle SQL Developer

问题描述

我已经与Oracle合作了一段时间，但在管理方面却是一个菜鸟，而且我正在学习，所以请多多包涵.

I've worked with Oracle for some time but very much a noob with the Admin side of things and am learning, so bear with me.

我无法使用具有SYS用户名的SQL Developer登录到我的数据库(orcl_test).我可以使用SYS作为SYSDBA在带有SQL的SQLPlus中正常登录-当我尝试使用SQL Developer时，出现错误:
ORA-01017:无效的用户名/密码；登录被拒绝.

I cannot log on to my database (orcl_test) with SQL Developer with the SYS username. I can log on just fine in SQLPlus with SYS as SYSDBA - when I try with SQL Developer I get an error:
ORA-01017: invalid username/password; logon denied.

在SQLPlus中以SYSDBA身份作为SYS登录，我在数据库中创建了一个测试表，并为测试用户SCOTT授予了SELECT权限. Scott用户可以通过不带问题的SQL Developer登录并访问允许的表.

Logging on as SYS as SYSDBA in SQLPlus, I created a test table within the database and granted the test user SCOTT with SELECT permissions. The Scott user can log on through SQL Developer w/o problem and access the allowed tables.

我已经检查了Scott用户和SYS是否使用相同的设置登录-
主机名:(IP地址)
端口:1521
SID:orcl_test

I have checked that the Scott user and SYS are logging in using the same settings -
Hostname: (ip address)
Port: 1521
SID: orcl_test

对于SYS，我将角色标记为SYSDBA-否则设置是相同的.

For SYS I flag the role SYSDBA - but otherwise the settings are the same.

关于为什么无法使用SYS登录的任何想法?我只是忽略了某些东西还是配置了不正确的数据库?

Any thoughts on why I can't log on using SYS? Am I just overlooking something or have I configured my db incorrectly?

不确定这是否相关，但是我不能使用"localhost"作为主机名，我必须输入IP地址.在哪里配置Oracle以识别本地主机?

Not sure if this is relevant but I cannot use 'localhost' for the hostname, I have to enter the IP address. Where do I configure Oracle to recognize localhost?

这是在运行Windows XP的独立测试盒上新安装的Oracle 11.2.0.1.0.运行Oracle SQL Developer 1.5.5.

This is a new installation of Oracle 11.2.0.1.0 on a standalone test box running Windows XP. Running Oracle SQL Developer 1.5.5.

推荐答案

来自 SYSDBA系统特权和(以SYSDBA身份登录并连接到数据库:

1-连接AS SYSDBA调用SYSDBA特权.如果省略AS 以SYS用户身份(SQL命令行)登录时的SYSDBA子句 拒绝登录尝试.

1--Connecting AS SYSDBA invokes the SYSDBA privilege. If you omit the AS SYSDBA clause when logging in as user SYS, the SQL Command Line rejects the login attempt.

2-使用SQL Developer，打开与SYS用户 AS SYSDBA 的数据库连接.

2--Using SQL Developer, open a database connection to the SYS user AS SYSDBA.

所以-如果这对您有用:

So - if this works for you:

sqlplus sys/Oracle_1@pdborcl as sysdba;

尝试:" SYS AS SYSDBA "，如下所示:

Try: "SYS AS SYSDBA" as below:

或者:

您可以输入:"SYS"并从下拉菜单中选择ROLE:SYSDBA.

you can type in: "SYS" and select from dropdown-menu ROLE: SYSDBA.

这篇关于无法使用Oracle SQL Developer以SYS身份登录数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！