Start-up Shutdown Scripts in Oracle Apps R12

Nice basic info Atul.

However,
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

should read

$INST_TOP/logs/appl/admin/log

as INST_TOP is

“Install_base/inst/apps/$CONTEXT_NAME

Hi

There is going to be a Blogcamp in India on 16th of June. Around 250 bloggers will be taking part in the event.

This is what they say on their blog: “The way unconferences work is that, you don’t have an agenda, rather we will put up a white board, where participants will themselves add the topics they are interested to speak upon. Depending upon the number of speakers we will go for multiple threads. There will be some intense discussions, we will have a lot of fun and yes there will be blogging, video blogging, photo blogging, podcasting … everything under the blogger sun.”

The registrations have started. We are planning to have 250 participants from all over the country. There are some people taking part virtually, using youtube, slideshare, skype etc. if you are interested please add your name to the wiki.

Check the:
wiki: http://barcamp.org/BlogCampPune
official blog: http://www.blogcamppune.blogspot.com

rashmi

Thanks Arun for correcting it and apologies to my readers.

Thanks once again, I’ll change them soon

How to bounce concurrent manager in R12

thanks
Abhi

For bounce concurrent manager we have to run this script only.
adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh.
Nothing more requires ?

Hi Atul,

For bounceing the concurrent manager in R12 we need only to run this script.
v) adcmctl.sh
Script to start / stop concurrent manager,

Nothing more requires ?

with Thanks
Abhishek

Yes adcmctl.sh is enough to bounce CM

Hi Atul,
Have you still faced any bug with adstpall.sh or adstrtal.sh scripts in R12i where script doesn;t validate the apps password passed with the scripts, if yes, is there any work around known without changing the scripts.

thnks.

Hi Atul/all,

When i am starting Apps by using ./adstrtal most of the application are showing that status 2. when i saw in log files it showing that opmn is not started.I started all the listener and sqlplus all the thing.

Can any help regarding this one.

Vasavi

Vasavi,
You have to check opmn log file to find that why opmn is not starting ..

Update output from opmn.log under 10.1.3 in INST_TOP

Hi Atul,

i checked in the opmn.log resides under 10.1.3 in INST_TOP but i didn’t find any thing related to this.last log changed on long back.

Can u help me any other way?

thanks & regards
Vasavi

Hi Atul/All,

I found that running the autoconfig script is the problem for this one.I tried to run but it is giving that sutoconfig is compelted with error.in the log file it is showing that spl is failed to start at this time timed out it is showing.

really i need it.can any one help me regarding this one.

thanks & regards

Vasavi

Is database and database listener up ?

Can you do sqlplus apps/apps@[SID] from middle tier ?

Post log file output for autoconfig

Hi Atul,

I statred the listener and databae in the oracle user and both are started adn up.And i then come to applmgr user and i am trying to start the adstrtal.sh it is giving the status 2.Then start the adautoconf.sh file in the log file

when i started the sqlplus apps/apps@SID it is showing that timed out

getConnectionUsingAppsJDBCConnector() –>
APPS_JDBC_URL=”
Trying to get connection using SID based connect descriptor
getConnection() –>
sDbHost : apps12
sDbDomain : us.oracle.com
sDbPort : 1521
sDbSid : VIS
sDbUser : APPS
Trying to connect using SID…
getConnectionUsingSID() –>
JDBC URL: jdbc:oracle:thin:@apps12.us.oracle.com:1521:VIS
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() –>
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=
(PROTOCOL=tcp)(HOST=apps12.us.oracle.com)(PORT=1521))(
CONNECT_DATA=(SERVICE_NAME=VIS)))
Exception occurred: java.sql.SQLException: Io exception:
The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() –>
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PRO
TOCOL=tcp)(HOST=apps12.us.oracle.com)(PORT=1521)
)(CONNECT_DATA=(SERVICE_NAME=VIS.us.oracle.com)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Connection could not be obtained; returning null

——————-ADX Database Utility Finished—————

Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database

StackTrace:
java.sql.SQLException: Could not get connection to the database
at oracle.apps.ad.tools.configuration.CVMHelper.
processNewContextFile(CVMHelper.java:787)
at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1718)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1520)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:684)

can you help me regarding this one

thanks & regards
Vasavi

Problem is that you can’t do
sqlplus apps/apps@SID

Is DB & middle tier on same machine ?
If they are on different node, is there any firewall between middle tier and db tier ?

On DB Node
lsnrctl status
netstat -an | grep

On Application Node
telnet

Hi Atul,

both the DB and Middle tier in the same machine.But both are in different user.

I tried to find the status of the lsnrctl it showing connection timed out.

Thanks & regards

Vasavi

Hi Atul,

Sorry for the above post.I found that my lsnrctl is up. and dba also i am able to run in oracle user in the same computer. and i am not able to connect to the dba from the another user (applmgr) in the same machine.
i think no firewall b/n two users in the same machine

thanks & regards

Vasavi

Hello Vasavi,
Please paste the content of sqlnet.ora file.

Warm Regards,
CrazyDBA

Hi CrazyDBA,

this is the content of sqlnet.ora

# $Header: sqlnet.ora 120.0 2005/06/20 15:31:53 appldev noship $
# $AutoConfig$
#
# stored in %s_tools_oh%/net80/admin/%s_contextname%

#NAMES.DEFAULT_DOMAIN = default.com

SQLNET.AUTHENTICATION_SERVICES= NONE
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME=%s_sqlnet_expire_time%

—
Can u help me regarding this one

thanks & regards
Vasavi

Vasavi,
Check listener log to find why listener is not starting

check $TNS_ADMIN/../$SID.log

Hi Atul,

I’m running R12 under VMWare using OEL 5.2.

Starting the database using addbctl.sh takes about 15 minutes. The same goes for stopping the database.

Is this normal? The virtual machine has been assigned 3GB RAM and one core of my 2.5GHz core 2 duo processor.

If not, do you have an idea how to speed things up?

Regards,
Brian

Hi Athul I recently installed R12 Business suite with VISION data base on Suse11.1.
When I try to open System profiles ,I get this error:

Unknow plugin(applicaiton/x-java-applet;jpi-version=1.5.0_13)

I try installing 1.5.0_13 ,I could not get this version
Can you le

Hi Athul I recently installed R12 Business suite with VISION data base on Suse11.1.
When I try to open System profiles ,I get this error:

Unknow plugin(applicaiton/x-java-applet;jpi-version=1.5.0_13)

I try installing 1.5.0_13 ,I could not get this version
Can you let me know how can get out of this proble

Thanks

You need JRE 1.5.13 on client machine for browser. Download and install from

http://java.sun.com/javase/downloads/index_jdk5.jsp

I could get it running now with little struggle with libXm.so.2.
I used jdk1.6.0_12 , and changed all the references

Thanks

[…] 1. Apply Oracle E-Business Suite Patches (at-least 12.0.3, autoconfig template patch to support latest OAS i.e. 10.1.3.4) 2. Apply 10.1.3.4 patchset to 10.1.3 Oracle Home using runInstaller (10.1.3.4 is latest certified patchset as of 12 Mar 09). Ensure Oarcle Home is set to 10.1.3 (Not 10.1.2) 3. Run Autoconfig 4. Apply additional patches to 10.1.3 oracle home (using opatch and not adpatch) 5. Regenerate appsborg.zip and appsborg2.zip files using adadmin 6. Restart application tier services for r12 , click here for how to start/stop services on R12 […]

Hi Atul,

Do i need to set any env parameter before starting database listerner.

the above said procedure is not working….

some services failed to start… following is the small subset of log

Web Entry Point Services Oracle HTTP Server APP_apps17 adapcctl.sh Started
Web Application Services OACORE OC4J Instance APP_apps17 adoacorectl.sh Failed
Web Application Services FORMS OC4J Instance APP_apps17 adformsctl.sh Failed
Web Application Services OAFM OC4J Instance APP_apps17 adoafmctl.sh Failed

Thanks

Ash

Atul,

when i am starting listener its giving me mesage:

Logfile: /erpdb/db/tech_st/10.2.0/appsutil/log/APP_apps17/addlnctl.txt
Starting listener process APP …
addlnctl.sh: exiting with status 1

i checked logfile: the error message line is

/erpdb/db/tech_st/10.2.0/bin/tnslsnr: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
the tnslsnr file exists.

Thanks

Amit

@ ASH,
Yes you need to set environment variable before starting/stopping services.

@ Amit ,
Relink library

Check this post
http://onlineappsdba.com/index.php/2009/01/02/oem-dbconsole-startup-issues-on-10g-r2-database-for-11ir12/

Thanks Atul, for the reply,

Just check the step i am following for starting R12,

1. Login as oracle user
2. set env variables (ORACLE_HOME, LD_LIBRARY_PATH)
3. start db listener (./addlnctl.sh start APP)
– lsnr started with status 0
4. start database (./addbctl.sh start normal)
– database started with status 0
5. login as applmgr
6. start apps (./adstrtall.sh)
– status is 4
– checked logfile: HTTP Server, OCJ4, ICSM services failed to start.

Am i wrong somewhere.

Thank You
Ash

Demo system fell over, 6am – no apps dba on hand and no sysadmin manuals with me, followed your guide to the scripts, bounced the mid-tier – nothing, bounced the database – still nothing, rebounced the mid-tier started, no concurrent managers, activeated them – nothing, bounced the concurrent managers – GREAT STUFF I’m back and running, Thanks

[…] know more about startup services in R12 check here  or Metalink Note […]

Please,Atul, I would like to know for browsers’s requirements: I noticed that systems of less than 1GB of memory were unable to access the EBS link. I did all the tricks to get it to connect. At contrary, systems of 1GB and above of memory are able to access the link. What could one do? Is there any way to amend this?Thanks

@ Nadiarabiu,
There is no such memory requirement (1GB) for cleints . I can access R12 from laptop with 256 MB RAM without issues

hai atul,

when Concurrent Manager is down,what are precautions have to take.

@ambatisk,
I am not clear about your question – what are precautions have to take.

Did you mean how to monitor CM or what what to do once you notice CM is down ?

How to monitor CM – either use custome shell scripts and check for count of FNDLIBR process or monitor CM log file for internal manager.

– use OEM grid control with plugin for oracle apps

What to do if CM is down ? – Check error message in log , fix issue and start CM

Dear Atul,

Hi,

IE8 is compatible with Oracle 12. since i have windows 7 installed on my pc. I need to access oracle ebs but In order to access this application, you must install the J2SE Plugin version 1.5.0_13. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

Copyright ©1998, 1999, 2000, 2001, 2002 Oracle Corporation

I did the above installation but still i am not able to work on forms and functions and menus were not able opened.

kindly help me.
thanks
Azam

@ Azam, Check if there is any popup blocker or any IE plugin which is blocking forms .

What error or message you get when you click on forms ?

Hi Atul,

I lost the power and needed to restart my r12 database and application tier.

When I ran the “./adstrtal.sh apps/apps” command I get

adstrtal.sh: Exiting with status 4

I am new to these things.

Thanks in advance for any help.
Padmaja

@ padmajabodla,
One of our support staff will take control of your machine remotely and fix this for you.

Atul

Thanks Atul,

I do not know what happened but after couple of times shutting down the DB and restarting it worked fine.

Thanks,
Padmaja

Hi Atul,

If adstpall.sh or adstrtal.sh got removed accidentally for a particular environment ,then is there any way to recover that?

Thanks
Saptarshi

Hi,

I have query to start WF mailer internal components like “Workflow Agent Listener Service”, “Workflow Document Web Services Service” and “Workflow Mailer Service” to start from API. normail API used to start mailer service itself is calling following package but it is not handling internal components. We want to explicitly restrat component services.

fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);

is for mailer itself, but found no way to start above from this package.

Anybody can revert on this?

Hi Atul
I can see that the query dated back to April 2014th by Abu is not answered. Are you still following this thread?
Well, I am observing a very interesting behavior with one of our cloned instances. I set it up couple of days back and for few reasons I was forced to shutdown the application instance immediately after starting, which starts without throwing any errors. However, while stopping the services I was getting
ERROR : Timed out( 100000 ): Interrupted Exception for oacore, forms and oafm scripts

I attempted almost every possible workaround solutions provided by various bloggers and oracle community seniors, yet not resolving the timed out errors.

Interestingly, I left the instance running over night and the next day tried to stop the instance using the adstpall.sh and within few seconds all the scripts were closed with status 0!

Can you please shed some light in to this particular situation? Does it emphasis towards the resources being too busy to answer the oacore, forms, oafm scripts in a timely manner as the concurrent jobs are triggered and the system is busy?

My current enviornment

IBM 3600 Server with 2xXeon processor
20GB memory, Oracle Linux 7 64bit
EBS R12, 12.0.6 64Bit
Database 10.2.0.3
Single node, using local disks

regards,

Rajesh

@Atul

I checked almost all possible log files for oacore, forms & oafm and couldn’t find anything relevant that could help me to resolve the timed out error. Do you have any suggestions?

regards,

Rajesh

Hello Atul
I rectified the issues as following:
OEL/RHEL 7 hosts file entries are formatted in a different way for the localhost, which was the true reason for timeouts while shutting down the services. Once formatted as recommended by Oracle, all the services were shutting down normally.
Hope it helps few others out there.

regards,
Rajesh

Hi Rajesh,

I am also faced “timeout” issue in a Different application installation process (SAS VA).

You are correct, the SAS support asked me to change the host name format to pass the issue.,..

Thanks for your findings..

Hi Abdul

Just realized that there is a new comment! Anyway, I had kept on reading hundreds of articles about the timed out errors, usually happening due to the lock files. However, as my issues were while shutting down the services, raising Error: Missing Ormi[S]://:

I came across a BI related thread, even though it was not at all related to the topic I was searching for, I noticed that the OP mentioned something like “localhost” and a port number.

It was just pure logic, forced me to check out the hosts file formatting and to my utter surprise, realized for the first time that both EL 6 & EL 7 have a different pattern for the localhost entries.

I knew that I solved the issue, prior restating the server to confirm it!

We had the original deployment of R12 almost 6 years back over RHEL 5 & trust me mate, the same instance provides much better performance over OEL 7, sad that Oracle will NOT support such deployments though.

regards,

Rajesh

When I working on the PC..suddenly laptop got shutdown.so when I connect to the login r12 apps login page,page can’t be displayed error is thrown..If itry to connect apps/apps@vis ,it is showing that oracle intialuzation or shutdown in progress..kindly help me what are all the steps do I need to do..

Even I restarted the services related to vis from services window…and then tried to ligin the r12 login page..page can’t be displayed error..pls guide

Page cant be displayed when i tired to logi n into the R12 page….So when i tried to start the ofcleConcMgrVIS_apps service.Could nt start the oracleConcMgrVIS_apps service on local computer error..R12 is installed in Windows 2003 server….Please guide..

Is startup and shutdown scripts are refer to CONTEXT_FILE in execution time ?

Thanks,
Vipul Megharaj

Oracle apps dba classes enquiry