Wednesday, January 26, 2011

.bashrc vs .bash_profile vs .profile

So, I thought I’d finally document the outcome of my experiment here for posterity:
bash_profile: interactive login shells
bashrc: non-interactive login shells
profile: I’m guessing this is used when you do not have a bash_profile file. I found it hard to find a definitive answer, though.
$ cat .bashrc
export BASHRC=’loaded’
$ cat .bash_profile
export BASH_PROFILE=’loaded’
$ cat .profile
export PROFILE=’loaded’
$ echo $BASHRC
$ echo $BASH_PROFILE
loaded
$ echo $PROFILE
Removing my .bash_profile file gives the following results:
$ echo $BASHRC

$ echo $BASH_PROFILE

$ echo $PROFILE
loaded
So, it looks like the .profile is loaded when no .bash_profile exists, but that the .bash_profile supercedes .profile when it is found, preventing it from being loaded.

Tuesday, January 25, 2011

oracle R12 cloning steps

apps cloning
----------------

1) verify source & target nodes softwares versions

    perl,jre,jdk,zip

2) apply latest rapid clone patch for all application nodes

3) Run Autoconfig on application Tier
   
      $COMMON_TOP/admin/scripts/<context_name>/adautocfg.sh

4) Copy Autoconfig file to the RDBMS_ORACLE_HOME

      Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps
             
          i)Login to the applications and set environment file and Create appsutil.zip file
                         perl $AD_TOP/bin/admkappsutil.pl

          ii)Copy this appsutil.zip file to the RDBMS ORACLE_HOME
                         cd $RDBMS_ORACLE_HOME
                          unzip -o appsutil.zip

5) Prepare the Source System Database Tier for Cloning

          cd $RDBMS_ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>
                        perl adpreclone.pl dbTier

Note:It will create template file for cloning on the source system,After the source system is copied to the target system,Rapid Clone updates these templetes to contain the new target system configuration settings.Rapid clone will not change the source system configuraion. And same in apps side

6) Prepare the Source System Application Tier for cloning

          cd $COMMON_TOP/admin/scripts/<CONTEXT_NAME>
                        perl adpreclone.pl appsTier

7) Copy the Application Tier File system(after Shutdown the applications)

8) Copy the Database Tier File System(after shutdown the Database)

9) Configure the Target System Database Server
          
         cd $RDBMS_ORACLE_HOME/appsutil/clone/bin
                       perl adcfgclone.pl dbTier

10) configure the Target System Application Server Nodes

         cd $COMMON_TOP/clone/bin
                       perl adcfgclone.pl appsTier

11) Do the Finishig Tasks like..

   i)Update profile options
   ii)Upadate printer settings
   iii)Update Workflow and other configuration settings

Monday, January 24, 2011

Unabled to call fnd_ldap_wrapper.create_user due to the following reason ora-06508 :PL/SQLcould not find program unit being called

Hi Friends,

I am working on R12.1.3 instance.Got a request to create a user.

security-->user-->define

When i try to create a user it throws me an error saying

Unabled to call fnd_ldap_wrapper.create_user due to the following reason

ora-06508 :PL/SQLcould not find program unit being called.

Tried a lot.This issue can be resolved by running,

alter package APPS.fnd_user_pkg compile;
alter package APPS.fnd_user_pkg compile body;

logout from the login page and relogin.issue will be solved.

Regards,
Naveen