Tuesday, January 22, 2013

Installing EBS R12.1.3 using Oracle VM Template without VM Server & Manager (Part 4 of 4)

Section 5 – Using Oracle Applications 12.1.3

Now every ting is done and we are ready feel the first glimpse of Oracle EBS 12.1.3 on our own machine.

First update the HOST on system from where we want to access the application. For me, I am using the same laptop where I installed Oracle EBS12.1.3. So I will update the hosts file on HOST system.

You can fine the hosts file under %system32%/drivers/etc/hosts
Your login URL would be http://hostname.domainname.com:80NN (where NN is the port we have given while configuration). For me its 'http://ebsapp.apps.com:8002'

ON the login screen login with generic login details
Operations / welcome
Sysadmin / sysadmin
Maintaining your instance:
-          Every time you need to switch off your system please follow the below steps.
o   Stop the application tier services.
Oracle has provided prebuilt script when ran with ‘oracle’ user starts / stops the application tier service.
Login with oracle user (oracle / oracle) and run the script
 [oracle@ebsapp]# . /u01/stopapps.sh

o   Shut down the application tier server
[root@ebsapp]# shutdown –h now

o   Stop the database tier services
Same as application tier run the start/stop script on database tier server to stop the data base services
Login with oracle user (oracle / oracle) and run the script

[oracle@ebsdb]# . /u01/stopdb.sh

o   Shut down the database tier server
[root@ebsdb]# shutdown –h now

-          The first time we start the database / application tier server, the oracle user account has configured to ask for password change. It’s a good idea to change the default password.
If you don’t want to change the default password then enter ‘NO’ at every prompt and run the below command at both the servers.

[root@ebsdb]# touch /home/oracle/.passchanged
[root@ebsapps]# touch /home/oracle/.passchanged

-          When you try to start the Application service for the first time you will see errors like below
The issue comes because there are two .env files under /u01/E-BIZ/inst/apps/
Either rename the file OR A better way is to add following entry to your .bash_profile

App Server: APPSVIS_ebsapp.env
[oracle@ebsapps]# echo ". /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp.env -s" >> ~/.bash_profile
DB Server: VIS_ebsapp.env
[oracle@ebsdb]# echo ". /u01/E-BIZ/db/tech_st/11.2.0.2/VIS_ebsdb.env -s" >> ~/.bash_profile
Note – Replace ebsdb/ebsapps with your respective hostname.


7 comments :

  1. Hi Tauseef,
    congrats for your article.

    I´m almost done. I followed your instructions and added line to bash_profile:

    [oracle@ebsapp apps]$ cat ~/.bash_profile
    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
    . ~/.bashrc
    fi

    # User specific environment and startup programs

    PATH=$PATH:$HOME/bin

    export PATH
    . /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp -s.env


    -----------------------

    When I logon with oracle user:

    login as: oracle
    oracle@192.168.56.200's password:
    Last login: Fri Apr 12 14:59:13 2013 from 192.168.56.1
    -bash: /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp: No such file or directory
    [oracle@ebsapp ~]$ . /u01/startapps.sh
    -bash: /u01/E-BIZ/inst/apps/mydb_atgtxk02/ora/10.1.2/mydb_atgtxk02.env: No such file or directory
    -bash: /u01/E-BIZ/inst/apps/mydb_atgtxk02/appl/admin/adovars_mydb_atgtxk02.env: No such file or directory
    grep: /u01/E-BIZ/inst/apps/mydb_atgtxk02/appl/admin/mydb_atgtxk02.xml: No such file or directory
    -bash: /u01/E-BIZ/inst/apps/mydb_atgtxk02/admin/scripts/adopmnctl.sh: No such file or directory
    grep: /u01/E-BIZ/inst/apps/mydb_atgtxk02/appl/admin/mydb_atgtxk02.xml: No such file or directory
    -bash: /u01/E-BIZ/inst/apps/mydb_atgtxk02/admin/scripts/adapcctl.sh: No such file or directory
    grep: /u01/E-BIZ/inst/apps/mydb_atgtxk02/appl/admin/mydb_atgtxk02.xml: No such file or directory
    -bash: /u01/E-BIZ/inst/apps/mydb_atgtxk02/admin/scripts/adoacorectl.sh: No such file or directory
    grep: /u01/E-BIZ/inst/apps/mydb_atgtxk02/appl/admin/mydb_atgtxk02.xml: No such f-

    ------------------------------

    I have checked /u01/E-BIZ/inst/apps/

    and I have same files as you.

    Any ideas?

    Thanks

    ReplyDelete
    Replies
    1. Hi,

      The issue happens because of multiple .env files under " /u01/E-BIZ/inst/apps/". You might see 'APPSmydb_atgtxk02.env' and 'mydb_atgtxk02.env'.

      Remove these files and check it will work. Not sure why you .bash_profile not picking up updated details.

      Regards
      Tauseef

      Delete
  2. Hi!

    If I only need the database as source for Business Intelligence purposes, would it be sufficient to only install the database VM?

    Thanks

    ReplyDelete
  3. Hello,

    Yes, you can only live with DB VM for your purpose.

    Regards
    Tauseef

    ReplyDelete
  4. Hi Tauseef,

    I followed the steps mentioned above and installed the db as well the app tier servers. However, I am unable to open the login URL - http://ebsapp.apps.com:8002(i used same port,host,domain values as used by you in the steps). I get a message from the browser : This page cant be displayed. Is there a way I can find more debug information for this issue?

    Thanks

    ReplyDelete
    Replies
    1. Hello,

      This could be because of many issues. Listing down couple of debug options to validate :-
      - Please try to stop and start both DB and APPS tier. Just validate all the service complete with status 0.
      - Please validate if you are able to ping the DB tier from application tier machine.
      - Try rerunning autooconfig on APPS tier instance.

      Delete
  5. Hi Tauseef,

    Although I am not at a working instance yet, I realy like your post.
    All seems to be running fine on the APPS and DB services, but how do I get the instance to use/start the right Java applet when having multiple version on my laptop.

    If you have any idea, please let me know.

    Maurice

    ReplyDelete

SeachBox