AnsweredAssumed Answered

Log as sysdba

Question asked by Robert Kowalczyk on Jan 13, 2021
Latest reply on Jan 14, 2021 by Ahmed Nofal

Hello,

 

I have problem with login directly as sysdba using sqlplus.

 

hostname:~ # su - oracle
oracle@hostname:~> sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 13 11:57:27 2021

 

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

 

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

 


Enter user-name: sys as sysdba
Enter password: (avuser password)

 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL> show user
USER is "SYS"
SQL>

 

In another environment I can log directly to the database using sqlplus

 

hostname2:/home/oracle # su - oracle
oracle@hostname2:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 13 12:13:08 2021

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show user
USER is "SYS"

What do I should to fix the error? Can anybody know?

 

Regards

Outcomes