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
How to generate TNS_ADMIN files in R12 Read More »
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
How to create spfile from pfile Read More »
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
How to Stop/Start HFM services Read More »
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 »
ORA-29283: invalid file operation is quite a common error. It happens mostly because of the two reasons (1) The directory and file should have appropriate permission at the OS level for the same user which started the Oracle database For example The directory does not exists on OS ls /u555/app/oracle No such file or directory SQL>
How to solve ORA-29283 : invalid file operation Read More »
