oracle 12c

How to check oracle database status – Interview question

let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, …

How to check oracle database status – Interview question Read More »

How to change sys & System user password in Oracle 12C database

We cannot change the sys and system password in usual way as like till 11g. we have different method to do same. following blog describe the way to change user password in oracle 12c database. How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== PDB1@ORCL= alter session set container=CDB$ROOT; Session altered. PDB1@ORCL=show con_id CON_ID …

How to change sys & System user password in Oracle 12C database Read More »