Hello all,
I'm kind of stumped by this one, and wondering if there might be a logical reason for not being able to use a password when logging into a 12c database as sys@<SID> as sysdba.
This totally baffles me, and I'm wondering if this isn't a new feature of 12c that does not allow use of password when logging in as sys.
Platform: CentOS (Linux) 5.10 - x86-64
DB: 12.1.0.1
So, I initially set up the database using sys and with a password of sys.
I normally login as / as sysdba, so I did not test logging in as sys using a password.
Today, I tried logging in as "sys@<SID> as sysdba" and it prompts me for password, and after I type sys I get an ORA-01017 invalid user/password.
Okay, so, let's do some basic testing.
$ echo $ORACLE_SID
nmsrepd
$ sqlplus / as sysdba
(connected)
SQL> select password from user$ where name = 'SYS';
PASSWORD
---------------------------------------------------
4DE42795E66117AE
1 row selected.
SQL> alter user sys identified by test;
User altered.
SQL> select password from user$ where name = 'SYS';
PASSWORD
----------------------------------------------------
D3CE9AB10E42F19D
1 row selected.
$ sqlplus sys@nmsrepd as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 9 11:44:17 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Okay, let's go back into the database and change the system password to the same and test the system account.
SQL> alter user system identified by test;
User altered.
Now, let's try connecting as system using password of "test"
$ sqlplus system@nmsrepd
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 9 11:47:21 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Last Successful login time: Wed Jul 09 2014 11:25:07 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
When I try again with the sys@<SID> as sysdba and using password of "test", it fails.
What's going on here?
PS: I did confirm the tnsnames.ora has correct SID/service name and there are no other aliases at the OS level.
One last test to show it using the "test" password.
$ sqlplus sys/test@nmsrepd as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 9 11:54:05 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied