Oracle dba interview questions and answers for experienced.

Best Oracle DBA Interview Questions and Answers:- In this post , discussing about oracle dba Interview Questions and Answers for senior and junior DBA:—- Grid Computing (Architecture):- Grid computing groups of independent, modular hardware and software components, can be connected and rejoined on demand to meet the changing needs of businesses. Grid computing also enables … Read more

How to resolve rapid clone issue ouicli INSTE8_APPLY 255 in R12

Introduction:- In this article, we will resolve Rapid Clone Issue ouicli.pl inste8_apply 255 in R12. After setting the PATH as below, rerun the Perl and issue got resolved. R12: Rapid Clone Issue ouicli.pl  INSTE8_APPLY 255 During EBS rapid clone, I had faced error as below mentioned. (i,e RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack.). … Read more

How to block restrict prevent access to E-Business Suite from end user.

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

Steps to Clean Nonexistent Nodes or IP Addresses from FND_NODES

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

Steps to Recover Apps Password in EBS R12

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

R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874

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-ERROR which every DBA facing

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