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'
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.
Hi Tauseef,
ReplyDeletecongrats 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
Hi,
DeleteThe 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
Hi!
ReplyDeleteIf I only need the database as source for Business Intelligence purposes, would it be sufficient to only install the database VM?
Thanks
Hello,
ReplyDeleteYes, you can only live with DB VM for your purpose.
Regards
Tauseef
Hi Tauseef,
ReplyDeleteI 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
Hello,
DeleteThis 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.
Hi Tauseef,
ReplyDeleteAlthough 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