Start/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!!

Start/Stop Oracle Apps Instance.
This looks very simple, hah I know this is just run adstrtal.sh/adstpall.sh, addbctl.sh and addlnctl.sh. I used to think like this, then after gaining experience I came with my own steps.

In previous approach, Did I took adequate step for checking any running concurrent requests .. did I took enough precaution to check what critical happenings going on in database like hot backup.. Now we shall take care :-)

I assume you know the script location, I shall cover, if you still suggest me to include.

Starting is Simple.

  1. addbctl.sh start
  2. addlnctl.sh start SID
  3. adstrtal.sh apps/password

Stoping is also fairly simple but “small care” needs to be taken to avoid critical issues.

I start my preparation sometime before the downtime scheduled, to let the concurrent request finish. Following are the steps to bring down middle-tier services

  1. Bring down the concurrent manager before maintenance say 20 mins before.
    adcmctl.sh stop apps/Password
  2. Check if any concurrent reqeust is running. if running, check what it is doing, like sql, session is active.
  3. Check previous execution of similar program took how much time.Is it worth to wait or cancel the request
  4. If it is affecting downtime then login from front-end and terminate the concurrent program, and make a note of request id(communicate to user who submitted this request so they can submit again)
  5. Check the OS process id, whether it got terminated or not. If running then its a runaway process kill it. I dont like killings but…
    SQL> select oracle_process_id from fnd_concurrent_requests where request_id=&Request_id;

For bringing down database tier.

  1. Check if hot backup is going on or not..
    To check, go to alert log file $ORACLE_HOME/admin/CONTEXT_NAME/bdump/alert_sid.log
    and also from sqlplus
    SQL> select distinct status from v$backup;
    If it returns row containing “ACTIVE” then hot back is in progress.
    Wait till it gets over.
    Otherwise next startup shall create problem. Though we have ways and means to overcome but why do that.
  2. Conditional – If you are using DR, pls take care of following steps
    1. Check which archive dest state refer for DR, enable it .
      From show parameter log_archive_dest.. you may come to know..
      say if you are using 3rd then run the sql
      SQL>alter system set log_archive_dest_state_3=enable;
    2. Check if standby is performing managed recovery.
      SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;PROCESS STATUS
      ——- ————
      ARCH CLOSING
      ARCH CONNECTED
      MRP0 WAIT_FOR_LOG
      RFS WRITING
      RFS RECEIVING
      RFS RECEIVING
    3. Cancel managed recovery operations.
      SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
    4. Shut down the standby database.
      SQL> SHUTDOWN IMMEDIATE;
  3. Stop database
  4. Now stop the listener
  5. If still database is not going down, check in alert log , what exactly is going on.
  6. Check if any processes are running having local=NO is running. If yes, kill..

About the Author AppsDBA

Leave a Comment:

30 comments
SubbaRao says April 16, 2008

Good one, keep it up my friend,

Regards,
SubbaRao

Reply
Neha Mittal says April 17, 2008

Hi Naresh

Good piece of info,thanks for sharing this.

Regards
Neha Mittal

Reply
hyder says April 17, 2008

It’s realy nice.Thanks for sharing ……..

Hyder

Reply
Vanitha Sivakumar says April 28, 2008

Naresh,

What is differnce when we shut CCM using
adcmctl.sh stop apps/{password}

adcmct.sh abort apps/{password}

Shouldn’t ‘stop’ handle any request that may be running on CCM?

Please clarify.

Thanks,
Vanitha Sivakumar.

Reply
Atul says April 28, 2008

option “stop” will wait for running request to finish where as “abort” will terminate any running request.

Reply
Vanitha Sivakumar says April 28, 2008

Atul,

If ‘Stop’ can handle any running concurrent requests, do we need to perform manual steps { 2 to 5} mentioned in the notes {under section : steps to bring down middle-tier services) ?

Thanks,
Vanitha Sivakumar.

Reply
Naresh says April 29, 2008

Stop doesn’t handle the running concurrent request. We have only two option either to terminate or wait till the CR completes.

Reply
muhammedazher says May 12, 2008

Hi,

Can ne body help me….i have a problem with CCM, yesterday after bouncing TEST instance, the CCM is showing inactive….

Regards
Azher

Reply
SubbaRao says May 12, 2008

Azher,

Please check whether Concurrent Manager up or not. If it is not up, start the Concurrent Manager

adcmctl.sh start apps/

Regards,
SubbaRao

Reply
Atul says May 12, 2008

Azher,
As suggested by Subba Rao, if you still can’t see CM up after starting service using adcmctl.sh then check log file at $APPLCSF/log/$CONTEXT_NAME/_.mgr

where MM is month on which you started CM & DD is Date

Reply
lakshmikanthan says May 14, 2008

AutoConfig is configuring the Database environment…

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /ften/r02/oracle/ftendb/9.2.0
ERROR: OA_JRE_TOP isn’t available at either of the following locations
JDK – /ften/r02/oracle/ftendb/9.2.0/jdk
JRE – /ften/r02/oracle/ftendb/9.2.0/jdk
Pass option ‘java’ on command line
ERROR: OA_JRE_TOP isn’t available at either of the following locations
JDK – /ften/r02/oracle/ftendb/9.2.0/jdk
JRE – /ften/r02/oracle/ftendb/9.2.0/jdk
Pass option ‘java’ on command line
ERROR in setting Environment variable ADJREOPTS

HOW TO CHANGE THE LINK FILE USER AND GROUP OF OWNERSHIP

lrwxrwxrwx 1 venkatesan applften 17 Dec 29 12:38 jdk -> /usr/opt/jdk1.3.1

lrwxrwxrwx 1 venkatesan applften 10 Dec 29 12:30 JRE -> appsjre118

lrwxrwxrwx 1 venkatesan applften 5 Dec 29 12:35 oui21 -> oui22

Reply
Naresh says May 14, 2008

The soft link can be dropped using ‘rm’ command and recreate after loging as applmgr user using the following cmd

ln -s source_file myfile

Replace source_file with the name of the existing file for which you want to create the symbolic link (this file can be any existing file or directory across the file systems). Replace myfile with the name of the symbolic link

or

you may use chown command to change ownership.

Regards
Naresh

Reply
lakshmikanthan says May 21, 2008

hi Naresh
thanks for your kind information

But tried to change ownership via root and oracle user. i checked env file also.also jdk1.3.1 was already installed.
i cant able to modify that one
please tell me another way to change that link file ownership,i am critical situation.

Reply
lakshmikanthan says May 21, 2008

thanks Naresh

now i retrieved my problem

Reply
swathi says May 27, 2008

hello atul,

really wonderful work ur doing…

i just joined in small company oracle apps trainee, i did mtech(pg) in IT stream and 9i ocp also.

please i need to know list of things to learn in oracle apps dba.

is there any hand on book to study pls gv the author name

hope u replay atul

Reply
SubbaRao says May 28, 2008

Swathi,

Its just my opinion,

Good, You can find all the topics in this site. Follow this site carefully and go through the all documents related to Oracle Apps DBA in Oracle Documents.

Here is the link for Oracle Documentation for Release 12 and 11i.

http://download-uk.oracle.com/docs/cd/B34956_01/current/html/doctop.html

http://download-west.oracle.com/docs/cd/B25516_06/current/html/docset.html

Good Luck,

Regards,
SubbaRao

Reply
dangana says June 23, 2008

Hi Atul,
Thank you for immense contribution, i really appreciate your effort infact i follow your post this gives me the courage to even start installing 11i, but unfurtnately for me while running my installation on linux 4 i recieved an error, the detail in the log is below:

Oracle Applications Rapid Install Wizard Install log
>> Using Rapid Wizard Version : 11.5.10.35
>> Install session started : Mon Jun 23 03:20:22 EDT 2008
>> Rapid Wizard source location : /home/stage11i/startCD/Disk1/rapidwiz
>> Command Line arguments for this execution :
================================================================
=
Install Session Information
Host Name : localhost.localdomain
Host Operating System : Linux
User running Install : applmgr
================================================================
=
InstUpgPanel
User
action : Install Oracle Applications
Install type : Standard Install
InstallPanel
User
action : Create configuration file
Description : To create a new intance cofiguration.
NumNodesPanel
Install
type : Single node Install
Description : Installs all the services on a single node.
InstallSidPanel
Database
type : Vision Demo Database
Database name : VIS
RdbmsPanel
Derived
Mount Points :
Oracle OS User : applmgr
Oracle OS Group : dba
Base Install directory : /d01/oracle
Oracle Home : /d01/oracle/visdb/9.2.0
Data Top (SYS) : /d01/oracle/visdata
Data Top (LOG) : /d01/oracle/visdata
Data Top (TXN) : /d01/oracle/visdata
Data Top (ARCHIVE) : /d01/oracle/visdata
MtierInfoPanel
Configuration
Information for Node localhost
Admin
Server / Concurrent
Mgr / Forms Server / Web Server
Derived Mount Points :
Apps OS User : applmgr
Apps OS Group : dba
Base Install directory : /d01/oracle
APPL_TOP Mount point : /d01/oracle/visappl
APPL_TOP aux. 1 : /d01/oracle/visappl
APPL_TOP aux. 2 : /d01/oracle/visappl
APPL_TOP aux. 3 : /d01/oracle/visappl
COMMON_TOP : /d01/oracle/viscomn
8.0.6 ORACLE_HOME : /d01/oracle/visora/8.0.6
iAS ORACLE_HOME : /d01/oracle/visora/iAS
Temp Directory : /d01/oracle/viscomn/temp
PortPanel
Selected
port pool :
Domain Name : localdomain
Database Port : 1521
RPC Port : 1626
Reports Port : 7000
Web Listener Port : 8000
OProcMgr Port : 8100
Web PLSQL Port : 8200
Servlet Port : 8800
Forms Listener Port : 9000
Metrics Server Data Port : 9100
Metrics Server Req. Port : 9200
JTF Fulfillment Server Port : 9300
Map Viewer Servlet Port : 9800
OEM Web Utility Port : 10000
VisiBroker OrbServer Agent Port : 10100
MSCA Server Port : 10200
MSCA Dispatcher Port : 10300
Java Object Cache Port : 12345
OACORE Servlet Port Range : 1600016009
Discoverer Servlet Port Range : 1700017009
Forms Servlet Port Range : 1800018009
XMLSVCS Servlet Port Range : 1900019009
AppsConfig temp dir set to: /tmp
ConfigFilePanel
Setting
temp directory to : /tmp
/tmp/
Writing configuration file to : /tmp/config.txt
Port Availability Check :
Database
Port Value = 1521…… Available
RPC Port Value = 1626…… Available
Forms Listener Port Value = 9000…… Available
Metrics Server Port Value = 9100…… Available
Metrics Client Port Value = 9200…… Available
Forms Servlet Port Range Value = 18000…… Available
Forms Servlet Port Range Value = 18001…… Available
Forms Servlet Port Range Value = 18002…… Available
Forms Servlet Port Range Value = 18003…… Available
Forms Servlet Port Range Value = 18004…… Available
Forms Servlet Port Range Value = 18005…… Available
Forms Servlet Port Range Value = 18006…… Available
Forms Servlet Port Range Value = 18007…… Available
Forms Servlet Port Range Value = 18008…… Available
Forms Servlet Port Range Value = 18009…… Available
Report Listener Port Value = 7000…… Available
Web Listener Port Value = 8000…… Available
Web Listener PLSQL Port Value = 8200…… Available
Servlet Port Value = 8800…… Available
JTF Fulfillment Server Port Value = 9300…… Available
Map Viewer Servlet Port Value = 9800…… Available
OEM Web Utility Port Value = 10000…… Available
VisiBroker OrbServer Agent Port Value = 10100…… Available
MSCA Server Port Value = 10200…… Available
MSCA Dispatcher Port Value = 10300…… Available
OACORE Servlet Port Range Value = 16000…… Available
OACORE Servlet Port Range Value = 16001…… Available
OACORE Servlet Port Range Value = 16002…… Available
OACORE Servlet Port Range Value = 16003…… Available
OACORE Servlet Port Range Value = 16004…… Available
OACORE Servlet Port Range Value = 16005…… Available
OACORE Servlet Port Range Value = 16006…… Available
OACORE Servlet Port Range Value = 16007…… Available
OACORE Servlet Port Range Value = 16008…… Available
OACORE Servlet Port Range Value = 16009…… Available
Discoverer Servlet Port Range Value = 17000…… Available
Discoverer Servlet Port Range Value = 17001…… Available
Discoverer Servlet Port Range Value = 17002…… Available
Discoverer Servlet Port Range Value = 17003…… Available
Discoverer Servlet Port Range Value = 17004…… Available
Discoverer Servlet Port Range Value = 17005…… Available
Discoverer Servlet Port Range Value = 17006…… Available
Discoverer Servlet Port Range Value = 17007…… Available
Discoverer Servlet Port Range Value = 17008…… Available
Discoverer Servlet Port Range Value = 17009…… Available
XMLSVCS Servlet Port Range Value = 19000…… Available
XMLSVCS Servlet Port Range Value = 19001…… Available
XMLSVCS Servlet Port Range Value = 19002…… Available
XMLSVCS Servlet Port Range Value = 19003…… Available
XMLSVCS Servlet Port Range Value = 19004…… Available
XMLSVCS Servlet Port Range Value = 19005…… Available
XMLSVCS Servlet Port Range Value = 19006…… Available
XMLSVCS Servlet Port Range Value = 19007…… Available
XMLSVCS Servlet Port Range Value = 19008…… Available
XMLSVCS Servlet Port Range Value = 19009…… Available
Operating System Check
command
: /home/stage11i/startCD/Disk1/rapidwiz/bin/checkOS.sh
Operating System patch/version test has succeeded
O/S User and Group Check
ORACLE
HOME OWNER applmgr
ORACLE HOME GROUP ACCOUNT dba
APPLICATION TIER USER ACCOUNT applmgr
APPLICATION TIER GROUP ACCOUNT dba
Port Uniqueness Check :
All
ports are unique.
File System Check :
Database
ORACLE_HOME has write privileges:
Mount Point = /d01/oracle/visdb/9.2.0
Database ORACLE_HOME admin folder has write privileges:
Mount Point = /d01/oracle/visdb/9.2.0/appsutil
Database ORACLE_HOME temp folder has write privileges:
Mount Point = /d01/oracle/visdb/9.2.0/appsutil/temp
Database Install Log Directory has write privileges:
Mount Point = /d01/oracle/visdb/9.2.0/appsutil/log/VIS_localhost
Database Install Out Directory has write privileges:
Mount Point = /d01/oracle/visdb/9.2.0/appsutil/out/VIS_localhost/templbac
Database System File Directory has write privileges:
Mount Point = /d01/oracle/visdata
Database Log File Directory has write privileges:
Mount Point = /d01/oracle/visdata
Database Transaction File Directory has write privileges:
Mount Point = /d01/oracle/visdata
Database Archive File Directory has write privileges:
Mount Point = /d01/oracle/visdata
APPL_TOP has write privileges:
Mount Point = /d01/oracle/visappl
APPL_TOP admin has write privileges:
Mount Point = /d01/oracle/visappl/admin
APPL_TOP mount 2 has write privileges:
Mount Point = /d01/oracle/visappl
APPL_TOP mount 3 has write privileges:
Mount Point = /d01/oracle/visappl
APPL_TOP mount 4 has write privileges:
Mount Point = /d01/oracle/visappl
COMMON_TOP has write privileges:
Mount Point = /d01/oracle/viscomn
JAVA_TOP has write privileges:
Mount Point = /d01/oracle/viscomn/java
JDK_TOP has write privileges:
Mount Point = /d01/oracle/viscomn/util/java/1.4/j2sdk1.4.2_04
PORTAL_TOP has write privileges:
Mount Point = /d01/oracle/viscomn/portal
Temp Directory has write privileges:
Mount Point = /d01/oracle/viscomn/temp
APPL_TOP admin Install Log Directory has write privileges:
Mount Point = /d01/oracle/visappl/admin/VIS_localhost/log
APPL_TOP admin Install Out Directory has write privileges:
Mount Point = /d01/oracle/visappl/admin/VIS_localhost/out/templbac
Apps ORACLE_HOME has write privileges:
Mount Point = /d01/oracle/visora/iAS
Tools ORACLE_HOME has write privileges:
Mount Point = /d01/oracle/visora/8.0.6
File Space Check :
Mount
Point for /d01/oracle/visdb/9.2.0 = /
Disk space on system acceptable :
Database ORACLE_HOME = /d01/oracle/visdb/9.2.0
required = 3091.0
actual = 97266.25
Mount Point for /d01/oracle/visdata = /
Disk space on system acceptable :
Database System File Directory = /d01/oracle/visdata
required = 12023.0
actual = 94175.25
Mount Point for /d01/oracle/visdata = /
Disk space on system acceptable :
Database Log File Directory = /d01/oracle/visdata
required = 160.0
actual = 82152.25
Mount Point for /d01/oracle/visdata = /
Disk space on system acceptable :
Database Transaction File Directory = /d01/oracle/visdata
required = 28870.0
actual = 81992.25
Mount Point for /d01/oracle/visdata = /
Disk space on system acceptable :
Database Archive File Directory = /d01/oracle/visdata
required = 21206.0
actual = 53122.25
Mount Point for /d01/oracle/visappl = /
Disk space on system acceptable :
APPL_TOP = /d01/oracle/visappl
required = 5705.0
actual = 31916.25
Mount Point for /d01/oracle/visappl = /
Disk space on system acceptable :
APPL_TOP mount 2 = /d01/oracle/visappl
required = 3212.0
actual = 26211.25
Mount Point for /d01/oracle/visappl = /
Disk space on system acceptable :
APPL_TOP mount 3 = /d01/oracle/visappl
required = 5852.0
actual = 22999.25
Mount Point for /d01/oracle/visappl = /
Disk space on system acceptable :
APPL_TOP mount 4 = /d01/oracle/visappl
required = 2524.0
actual = 17147.25
Mount Point for /d01/oracle/viscomn = /
Disk space on system acceptable :
COMMON_TOP = /d01/oracle/viscomn
required = 2963.0
actual = 14623.25
Mount Point for /d01/oracle/visora/iAS = /
Disk space on system acceptable :
Apps ORACLE_HOME = /d01/oracle/visora/iAS
required = 2600.0
actual = 11660.25
Mount Point for /d01/oracle/visora/8.0.6 = /
Disk space on system acceptable :
Tools ORACLE_HOME = /d01/oracle/visora/8.0.6
required = 3027.0
actual = 9060.25
Host/Domain Check
command
: /bin/ping c
1 localhost
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=0 ttl=64 time=0.036 ms
localhost.
localdomain ping statistics 1
packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.036/0.036/0.036/0.000 ms, pipe 2
host ping has succeeded
command : /bin/ping c
1 localhost.localdomain
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=0 ttl=64 time=0.031 ms
localhost.
localdomain ping statistics 1
packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.031/0.031/0.031/0.000 ms, pipe 2
host.domain ping has succeeded
OS Patch Checks
running
command : OSPatchCheck.checkPatch()
OS = Linux OSVersion = 2.6.911.
ELsmp
No Patch Information available for this Platform
System Utilities Check
These
utilities need to be accessible on your system in order to do administrative tasks.
command : /home/stage11i/startCD/Disk1/rapidwiz/bin/adchkutl.sh
Checking for make… found /
usr/bin/make
Checking for ld… found /
usr/bin/ld
Checking for cc… found /
usr/bin/cc
Checking for ar… found /
usr/bin/ar
Checking for ksh… found @(#)
PD KSH v5.2.14 99/07/13.2
Utility check completed successfully
System Utilities Availability test has succeeded
DoInstallPanel Summary
Text
The Rapid Install Wizard will now install the following:
DoInstallPanel User
continued install at warning dialog.
Starting
from Rapid Install Full Stage area /home/stage11i/oraDB/Disk1
RapidWiz location: /home/stage11i/startCD/Disk1/rapidwiz
Install Media location: /home/stage11i/startCD/Disk1
APPL_TOP location: /d01/oracle/visappl
Database ORACLE_HOME: /d01/oracle/visdb/9.2.0
Database SID: VIS
Database Context Name : VIS_localhost
Creating 9.2.0 DB Context from /
home/stage11i/startCD/Disk1/rapidwiz/etc/adxdbctx.tmp to /
d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/etc/adxdbctx.tmp
dest : /d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
dest : /d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
dest : /d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visdb/9.2.0/temp/restart.xml
dest : /d01/oracle/visdb/9.2.0/temp/restart.xml
instantiate file:
source : /d01/oracle/visdb/9.2.0/temp/restart.xml
dest : /d01/oracle/visdb/9.2.0/temp/restart.xml
Creating APPL_TOP Context from /
home/stage11i/startCD/Disk1/rapidwiz/etc/adxmlctx.tmp to /
d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/etc/adxmlctx.tmp
dest : /d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visappl/admin/VIS_localhost.xml
dest : /d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visappl/admin/VIS_localhost.xml
dest : /d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visappl/admin/VIS_localhost.xml
dest : /d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /d01/oracle/visappl/admin/VIS_localhost.xml
dest : /d01/oracle/visappl/admin/VIS_localhost.xml
instantiate file:
source : /d01/oracle/viscomn/temp/restart.xml
dest : /d01/oracle/viscomn/temp/restart.xml
instantiate file:
source : /d01/oracle/viscomn/temp/restart.xml
dest : /d01/oracle/viscomn/temp/restart.xml
Processing DriverFile = /home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
Running Instantiation Drivers for /
home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
Processing DriverFile = /home/stage11i/startCD/Disk1/rapidwiz/template/adriapps.drv
Running Instantiation Drivers for /
home/stage11i/startCD/Disk1/rapidwiz/template/adriapps.drv
Total number of processes in Current Install 5
Processing DriverFile = /home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
Running Instantiation Drivers for /
home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/template/adrun9i.sh
dest : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh
backup : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh to /
d01/oracle/visdb/9.2.0/appsutil/out/VIS_localhost/templbac/adrun9i3.sh
setting permissions: 755
setting ownership: applmgr:dba
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/template/adrundb.sh
dest : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrundb.sh
backup : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrundb.sh to /
d01/oracle/visdb/9.2.0/appsutil/out/VIS_localhost/templbac/adrundb3.sh
setting permissions: 755
setting ownership: applmgr:dba
Step 0 of 5
Command: /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh
Step 1 of 5: Doing UNIX preprocessing
Processing Step 1 of 5
Executing: /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh APPS APPS
STARTED INSTALL PHASE : 9i RDBMS : Mon Jun 23 03:22:46 EDT 2008
runProcess_1
Executing command:
/home/stage11i/startCD/Disk1/rapidwiz/jre/Linux/1.4.2//bin/jre mx512M
classpath
\n /
home/stage11i/startCD/Disk1/
rapidwiz/jre/Linux/1.4.2//lib/rt.jar:/home/stage11i/startCD/
Disk1/rapidwiz/jre/Linux/1.4.2//lib/i18n.jar:
/home/stage11i/startCD/Disk1/rapidwiz/jlib/j
ava:/home/stage11i/startCD/Disk1/rapidwiz/jlib/
xmlparserv2.zip
oracle.apps.ad.autoconfig.InstantiateFile e
/
d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml d
/home/stage11i/startCD/Disk1/rapidwiz/driver/db/driver/gdb920.drv pwd
no_password_here log
/d01/oracle/visdb/9.2.0/appsutil/log/VIS_localhost/dbInstall.log
verbose
Enter the location of the CD labeled Oracle Applications Rapid Install RDBMS
Disk
1 :
Checking Disk contents in /
home/stage11i/startCD/Disk1/rapidwiz
Checking Disk contents in /
home/stage11i/oraDB/Disk1
Checking Disk contents in /
home/stage11i/oraDB/Disk1
UnzipCount:108
Processing Disk1….
Processing Disk2….
Processing Disk3….
runProcess_2
Statusstring Copying the Database Context template file.
runProcess_3
Statusstring Executing Command: InstantiateFile d
instconf.drv
Executing command: /home/stage11i/startCD/Disk1/rapidwiz/jre/Linux/1.4.2//bin/jre
mx512M
classpath
/
home/stage11i/startCD/Disk1/rapidwiz/jre/Linux/1.4.2//lib/rt.jar
:/home/stage11i/startCD/
Disk1/rapidwiz/jre/Linux/1.4.2//lib/i18n.jar:
/home/stage11i/startCD/Disk1/rapidwiz/jlib/j
ava:/home/stage11i/startCD/Disk1/rapidwiz/jlib/xmlparserv2.zip
oracle.apps.ad.autoconfig.InstantiateFile e
/
d01/oracle/visdb/9.2.0/appsutil/VIS_localhost.xml d
/
d01/oracle/visdb/9.2.0/appsutil/driver/instconf.drv pwd
no_password_here log
/
d01/oracle/visdb/9.2.0/appsutil/log/VIS_localhost/dbInstallcfg.log
runProcess_4
Statusstring Executing Command: recreating context file
runProcess_5
Statusstring Executing Command: InstantiateFile d
addbtmpl.drv
runProcess_6
Statusstring Executing Command: adlnkoh.sh
adlnkoh.sh started at Mon Jun 23 03:44:29 EDT 2008
logfile located in /d01/oracle/visdb/9.2.0/install/make.log
Error while running adlnkoh.sh. Please check logfile
Errors while running adlnkoh.sh
There was an error while running the command /
d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh APPS APPS
/d01/oracle/visdb/9.2.0/appsutil/install/adlnkoh.sh: line 198: /
d01/oracle/visdb/9.2.0/bin/sqlplus: No such file or directory
RW50010:
Error: script
has returned an error: 1
RW50004:
Error code received when running external process. Check log file for
details.
Running Database Install Driver for VIS instance
Processing DriverFile = /home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
Running Instantiation Drivers for /
home/stage11i/startCD/Disk1/rapidwiz/template/adridb.drv
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/template/adrun9i.sh
dest : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh
backup : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh to /
d01/oracle/visdb/9.2.0/appsutil/out/VIS_localhost/templbac/adrun9i4.sh
setting permissions: 755
setting ownership: applmgr:dba
instantiate file:
source : /home/stage11i/startCD/Disk1/rapidwiz/template/adrundb.sh
dest : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrundb.sh
backup : /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrundb.sh to /
d01/oracle/visdb/9.2.0/appsutil/out/VIS_localhost/templbac/adrundb4.sh
setting permissions: 755
setting ownership: applmgr:dba
Step 0 of 5
Command: /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh
Step 1 of 5: Doing UNIX preprocessing
Processing Step 1 of 5
Executing: /d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh APPS APPS
STARTED INSTALL PHASE : 9i RDBMS : Mon Jun 23 03:47:02 EDT 2008
runProcess_6
Statusstring Executing Command: adlnkoh.sh
adlnkoh.sh started at Mon Jun 23 03:47:02 EDT 2008
logfile located in /d01/oracle/visdb/9.2.0/install/make.log
Error while running adlnkoh.sh. Please check logfile
Errors while running adlnkoh.sh
There was an error while running the command /
d01/oracle/visdb/9.2.0/temp/VIS_localhost/adrun9i.sh APPS APPS
/d01/oracle/visdb/9.2.0/appsutil/install/adlnkoh.sh: line 198: /
d01/oracle/visdb/9.2.0/bin/sqlplus: No such file or directory
RW50010:
Error: script
has returned an error: 1
RW50004:
Error code received when running external process. Check log file for
details.
Running Database Install Driver for VIS instance.

waiting for your anticipated solution
thank

Reply
Atul says June 23, 2008

Issue happened while relinking database binaries.

Check gcc version mentioned at http://onlineappsdba.com/index.php/2007/10/31/install-oracle-11i-115102-on-linux/

A) set environment variable LD_ASSUME_KERNEL=2.4.19 for root user
B) gcc -v (Should be of version 3.2.x) For any other version

install gcc version 3.2.X and create softlink as mentioned in above

Reply
Rahul says July 23, 2008

Hi,
You are doing a great job man. Hats off to you as i have learned so many things from your website.

Regards,
Rahul

Reply
Ahmed says July 27, 2008

Hi
I am getting the error when login to the Applications 11i we are having 2 nodes 1 is for Apps and other is for Database the error is

“[Load Applet at (null)]: ORA-20000: Invalid License Key [192.168.20.48]ORA-20002: Key expired at 25-JUL-2008 ORA-06512: at “APPS.XXLPR_WEB_UTIL”, line 149 ORA-06512: at “APPS.XXLPR_WEB_UTIL”, line 204 ORA-06512: at line 1″
The IP mentioned in the error is Database node IP
need you support to solve this issue

Reply
jee says October 7, 2008

hi
any one can help me
i installed Oracle apps in my laptop,it starts working fine ,suddenly EBS not working . DEV working fine

Please help me out

thanks
jee

Reply
Kiran says March 5, 2009

Atul
Can you pls help me out with below error

[Load Applet at (null)]: ORA-20000: Invalid License Key [172.31.208.46]ORA-01403: no data found ORA-06512: at “APPS.XXLPR_WEB_UTIL”, line 149 ORA-06512: at “APPS.XXLPR_WEB_UTIL”, line 204 ORA-06512: at line 1

Reply
Naresh says March 5, 2009

This seems to be issue with license key. When the above error is thrown

Reply
Sanjeev Nanda says August 28, 2009

Hi Atul,

You are doing a great job man,please help me

what adclonectx.pl does ,what instconf.drv does when it run on db tier and what it does when it run application tier,

what sequence these script run

adchkutl.sh,dclonectx.pl , instconf.drv when you run adcfgclone.sh

waiting for your anticipated answar.

Reply
Sanjeev Nanda says August 28, 2009

Hi
what Techstack driver files instconf.drv and template files (forOracle_iAS_Home/appsutil/templateOracle_806_Home/appsutil/template) it contains what information.

regards
sanjeev

Reply
Atul Kumar says September 2, 2009

@ Sanjeev

instconf.drv is Template file driver file for applying a clone using AutoClone for IAS_ORACLE_HOME or ORACLE_HOME (forms/report) on Middle Tier

$IAS_ORACLE_HOME/appsutil/driver/instconf.drv (on Middle Tier) – Template file driver file for applying a clone using AutoClone in Web Server Oracle Home

$ORACLE_HOME/appsutil/driver/instconf.drv (on Middle Tier) – Template file driver file for applying a clone using AutoClone in Forms & Reports ORACLE_HOME

$ORACLE_HOME/appsutil/driver/instconf.drv (on Database Tier) – Template file driver file for applying a clone using AutoClone in Database ORACLE_HOME

Template file

Any files under the $ORACLE_HOME that contain system specific information, will be replicated and converted into a template. These templates are placed into the $ORACLE_HOME/appsutil/template directory

Reply
Sanjeev Nanda says September 2, 2009

hi Atul,
thanks for your kind information.
please let me know /admin/template
FND_TOP/admin/template, and AD_TOP/Admin/template, contains.

regards
sanjeev

Reply
Sanjeev Nanda says September 2, 2009

please let me know /admin/template
FND_TOP/admin/template, and AD_TOP/Admin/template, contains.

Regards
sanjeev

Reply
Sanjeev Nanda says September 2, 2009

please let me know PROD_TOP/admin/template
FND_TOP/admin/template, and AD_TOP/Admin/template, contains.

Regards
sanjeev

Reply
neenagoel says January 21, 2010

Please help. Database conection failed. Failed to open service , error 1060.

I am installing r12.1.1 on windows server 2003. It fails on step 1.

It is very urgent

Reply
Add Your Reply