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%';