Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Apps Administration categories is related to EBS issues and solutions.
Introducton:- In this post we will discuss ‘How to clone EBS and Database clone using rman backup’. Here we will perform rapid clone for ebs and restore database using rman How to clone EBS and Database? Follow the below steps carefully to complete ‘rapid clone using rman’ backup for the EBS & Database … Read more
how to block restrict prevent access E-Business Suite from users access And Allow Specific Users in 11i/R12:- In this post we will know how to prevent EBS user access(restrict ebs login from user in oracle) and allow specific user in 11i/R12. During critical activity going from the business side and willing to restrict/prevent Business users accessing Oracle Applications, … Read more
Introduction: – Here we will discuss how to steps to clean nonexistent nodes and cleanup fnd_node in R12. To clear fnd_node in ebs, we need to execute FND_CONC_CLONE.SETUP. Steps to clean nonexistent nodes. We are going to execute FND_CONC_CLONE.SETUP to clear fnd_node table. Step 1:- Execute EXEC FND_CONC_CLONE.SETUP_CLEAN; SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; SQL> COMMIT; Note: … Read more
Here we will discuss about useful Steps to recover APPS password in EBS R12. Suppose someone forgot to remember the APPS and SYSADMIN password, just follow the below steps to recover the same password. To recover APPS password:- create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionMa nagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;/ … Read more
Her we will see Steps to bounce apache in r12 using automate Apache server restart (bounce) script. In this post we will know how to automate Apache server restart through shell script. If you are thinking to automating Apache server restart which can be done through a crontab entry. Pls check … Read more
Introduction: – In this post we will know how to resolve R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874: warning in the execution of ODCIINDEXALTER routine. How to R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1? During EBS clone I faced the following error while try to run adcfgclone.pl on appsTier then autoconfig failed … Read more
ORA- 12514,ORA-12537,ORA-00600/ORA-07445, ORA-12154 ORA- 12514: TNS:listener does not currently know of service requested in connect descriptor. Cause: – The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) … Read more
In this post we will fix ORA Error in oracle database. Oracle database symptoms ORA Error :- 1. Symptoms Memory heap error ORA-7445[kssrem] and ORA-7445[kggchk] is reported in the alert.log and PMON terminates. ORA-07445: exception encountered: core dump [kssrem()+176] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] ORA-07445: … Read more
Recently I have faced and resolved the ora 1691 unable to extend lobsegment APPLSYS.SYS_LOB in tablespace APPLSYSD in our production environment. How to fix ora 1691 unable to extend lobsegment. Error: ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000255030C00040$$ by 1574805 in tablespace APPLSYSD Analysis and Solution: Step1: Verify Free space in tablespace & Check data file … Read more
Introduction: – In this post we will discussed How to restore RMAN backup from PROD to TEST database 10g,11gR2,12c,19c:- The situation here is we have taken an RMAN backup on PROD (Source) and we need to restore those backup pieces on different server as TEST (target) database. It’s actually cloning the database from … Read more