Introduction Before explaining the details about How to find archive log history, how to find archive log sequence number in oracle, how to check archive log mode in oracle,how to check archive log location in oracle, how to check archive log size in oracle etc, it will be good to understand the archive log and …
How to find archive log history, Size, Sequence, Archive log status, location Read More »
We might have encountered a problem, where the Application TNS_ADMIN files like tnsnames. ora, listener. ora and sqlnet. ora is incomplete or corrupted. The solution for this issue is either we run autoconfig on the application or we can generate the tns_admin file using one command also. Let’s see How to generate TNS_ADMIN files in …
In this post, we would check out various ways to create spfile from pfile in the Oracle database. First of all, let’s check out the description of both spfile and pfile What is pfile Pfile is a Traditional plain-text parameter file and it does not let you make persistent changes to parameter values. So any alter …
We often have a situation where we need to move the schema from Prod to DEV or from test to another. We will discuss how to import schema in the Oracle database using impdp in this situation How to import schema in Oracle 1. First of all we should take the dump of the schema …
HFM services have different stop/start procedures for various EPM services. Let’s see How to Stop/Start HFM services in VArious EPM versions How to Stop/Start HFM services in 11.1.2.1 to 11.1.2.3 The main processes in this HFM version are HSXServer.exe – Primary HFM process. The process runs on the same machine as the IIS components and …
Here are the steps outlined for How to Clone the Application Server Given source machine is SUN1 and the target machine is SUN2. Prepare steps 1) On the source and target ensure that the PERL5LIB variable is set. 2) $ export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$ORACLE_HOME/perl/lib/site_perl/5.6.1 3) cd $ORACLE_HOME/clone/bin 4) ./prepare_clone.pl ORACLE_HOME=$ORACLE_HOME Create a tar file and copy it …
How to Clone Oracle Application Server 10g Read More »
