Sanae BEKKAR – My Blog –

We have been authenticated, so we are in.

We can now successfully start up, shut down, and remotely administer this database using the SYSDBA account.

Now, we have another user, OPS$TKYTE, who has been granted SYSDBA, but will not be able to connect remotely yet:
[tkyte@dellpe ~]$ sqlplus ‘ops$tkyte/foobar’@ora12cr1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:22:21 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR: ORA-01017: invalid username/password; logon denied
The reason for this is that OPS$TKYTE is not yet in the password file.

In order to get OPS$TKYTE into the password file, we need to “regrant” that account the SYSDBA privilege:
[tkyte@dellpe ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:23:11 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

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
SYS@ORA12CR1> grant sysdba to ops$tkyte;
Grant succeeded.
SYS@ORA12CR1> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[tkyte@dellpe ~]$ sqlplus ‘ops$tkyte/foobar’@ora12cr1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:23:25 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
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.