[root@avs00155d0b2304 ~]# su - dvaccountmgr
Last login: Tue May 21 12:52:37 IST 2019
-bash-4.1$ sqlplus /
SQL*Plus: Release 12.1.0.2.0 Production on Tue May 21 15:14:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue May 21 2019 12:52:37 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> alter user avsys account unlock;
User altered.
SQL> alter user avsys identified by <password>;
User altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
-bash-4.1$ logout
Login with avsys user.
[root@avs00155d0b2304 ~]# su - oracle
Last login: Tue May 21 15:10:02 IST 2019 on pts/0
The Oracle base has been set to /var/lib/oracle
[oracle@avs00155d0b2304 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.2.0 Production on Tue May 21 15:15:23 2019
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, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> conn avsys/<password>
Connected.
Last login: Tue May 21 12:52:37 IST 2019
-bash-4.1$ sqlplus /
SQL*Plus: Release 12.1.0.2.0 Production on Tue May 21 15:14:15 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue May 21 2019 12:52:37 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> alter user avsys account unlock;
User altered.
SQL> alter user avsys identified by <password>;
User altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
-bash-4.1$ logout
Login with avsys user.
[root@avs00155d0b2304 ~]# su - oracle
Last login: Tue May 21 15:10:02 IST 2019 on pts/0
The Oracle base has been set to /var/lib/oracle
[oracle@avs00155d0b2304 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.2.0 Production on Tue May 21 15:15:23 2019
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, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> conn avsys/<password>
Connected.