adop issues and solutions
1> http://apdba.blogspot.com/2015/12/fs-clone-cannot-be-called-while.html FS clone cannot be called while a patching cycle is active $ adop…
Increase connection pool – SSO
Please increase the connection pool and restart the services and monitor the system. Set the initial…
RAC – Invalid userid/password
After upgrade to 12c, check if sqlnet.ora has below information SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11 SQLNET.ALLOWED_LOGON_VERSION_CLIENT =…
SCA Utility. REP-0104: Unable to Delete File ‘APXIAWRE.rdf’
Solution – Reports.log located under $APPLCSF/$APPLLOG has reached the maximum file size limit of 2GB.…
ISM can not be locked oradism creation failed
Set the correct group and permission for oradism. For example, set the permissions for ORADISM…
Register 11.2 DB with 12.1 Clusterware fails with CRS-0245
https://petesdbablog.wordpress.com/2013/07/20/register-11-2-db-with-12-1-clusterware-fails-with-crs-0245/ The final solution was to apply the Path 16742216 (GI PSU) in my Database…
ins_emagent.mk error while installation of Oracle RAC
During the link phase you will encounter an error invoking the “ins_emagent.mk” Solution: During the…
How to fix expired RCU Database password for OAC
How to fix expired RCU Database password for OAC (Doc ID 2352213.1) select username,ACCOUNT_STATUS,EXPIRY_DATE, profile…
how to find scn number
select min(maxnc), null from (select max(next_change#) maxnc from v$backup_redolog group by thread#) col min(maxnc) format…
Validate Backups
Validate backup – http://www.oracle-scn.com/rman-restore-validate-a-proactive-health-check/