Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
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
Resolving Shutdown Immediate Hang Situations | Sometimes we are facing the situation were shutting down the instance with shutdown immediate seems to take infinite time and database look like that the session is hung. In most of the cases this is not a hang. Hang can be defined as a scenario when few sessions/processes are … 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
Here is ‘steps to recover Applications context file if it is corrupted or deleted’. If the Oracle Applications Context file is corrupted or deleted, then we need to follow the below steps to recover the Context file as well. To retrieve/recover Applications context file. Run the adclonectx.pl as shown below. perl /clone/bin/adclonectx.pl retrieve On being prompted … Read more
In this post we will discuss how to configure DMZ (Isupplier on external node) on shared file system. To add external node, we must follow the below steps. Steps to Add Node to a Shared Application Tier File System for Oracle E-Business Suite R12 Configuring DMZ in R12. Here we will know ‘how to configure isupplier (dmz) in … Read more
In this post we will learn how to check ora error on oracle database using shell scripts. We can prepare scripts and schedule to monitor error in alert log., due to this error our database not functioning as expected. To overcome this issue well prepare proactive alert to check the ora error if any. How … Read more