Oracle在客户端as system不能登陆数据库

在oracle的SQLplus客户端登录数据库,sqlplus system/oracle@orcl可以登录,但是加上as sysdba就报错:

[oracle@test ~]$ sqlplus system/oracle@orcl

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 27 23:48:41 2019

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Thu Jun 27 2019 07:45:24 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@test ~]$ sqlplus system/oracle@orcl as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 27 23:48:54 2019

Copyright (c) 1982, 2016, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:

请问这是什么原因?谢谢!

2个回答

sqlplus "sys/oracle@orcl as sysdba"你的system用户默认是没有sysdba角色的

as sysdba应该放前面
图片说明

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐