Switchover Activity Issues

While Switch over the Database from Standby to Primary we will get below error

ORA-16139: media recovery required

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

ERROR at line 1:

ORA-16139: media recovery required

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

*ERROR at line 1:

ORA-16139: media recovery required

SQL> recover database until cancel;

ORA-00283: recovery session cancelled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Solution:-

SQL> recover standby database;

Note: Here we need to provide the AUTO Command.

After completion of recovery we need to execute the below command.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Note: here some situations after giving the recover standby database

Command the database will shutdown automatically.

Then we have start database in mount state then we need to execute the below command

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

while doing  switchover activity on primary using get MMON  error


SQL> alter database commit to switchover to physical standby with session shutdown; 
alter database commit to switchover to physical standby with session shutdown 
* 
ERROR at line 1: 
ORA-00450: background process 'MMON' did not start 
ORA-00600: internal error code, arguments: [ksbs1p0], [0x380032B88], [], [], 
[], [], [], [], [], [], [], []. 
* 

Sol:-

SQL> alter database commit to switchover to standby with session shutdown; 

Unable to see the  Functional administrator responsibility for  Oracle EBS

Run the FNDWFDSURV, "Workflow Directory Services User/Role Validation" concurrent program successfully from System Administrator responsibility. Use the parameters 10000, yes, yes, yes.

How to change the password of CTXYS, ODM and MGDSYS users for Oracle EBS 12.1.2

MGDSYS:-

 alter user <SCHEMA> identified by <NEW_PASSWORD>; 

CTXSYS and ODM:-

FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> ORACLE <schema> <new_pwd> 

After use FNDCPASS it's recommended to run autoconfig. 

While extending SGA size get out of memory error in Solaris

Please check the shmmax parameter under /etc/system and

Ensure shmmax kernel setting is equal or larger than the sga_max_size

set shmsys:shminfo_shmmax=<size in bytes>
set semsys:seminfo_semmni=1024 
set semsys:seminfo_semmsl=1024 
set shmsys:shminfo_shmmni=100 

if we want to increase the SGA size from 10 GB to 20 GB we need to maintain the shhmax value at OS level>=20 GB

How to to find the  timestamp for rebuild index and Gather Stats:-

 for rebuild index:-

select TO_CHAR(last_ddl_time,'DD-MON-YYYY HH24:MI:SS') DDL,timestamp from
dba_objects where object_name like '%GL_JE_LINES_U1%';


 for gather stats:-

select last_analyzed from dba_indexes where index_name like '%GL_JE_LINES_U1%';