Database Security Products (MOSC)

MOSC Banner

ORA-01017: invalid username/password; logon denied for SYS user

edited May 18, 2018 5:01AM in Database Security Products (MOSC) 2 commentsAnswered

Hi Team,

when am trying to connect to database as SYS its giving ORA-01017.

[oracle@test~]$ . oraenv

ORACLE_SID = [oracle] ? vcrsd01

The Oracle base has been set to /u01/app/oracle

[oracle@test~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 1 23:43:53 2018

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

ERROR:

ORA-01017: invalid username/password; logon denied

But am able to connect when provided the password

[oracle@test~]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 1 23:57:14 2018

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

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center