Tuesday, January 28, 2014

Startup Shutdown R12.2

=======================



 I have followed the blog http://ltd.kentw.co.uk/technical/managing-oracle-e-business-suite-r12-2/ to setup this on my machine.

In R12.2 there are two filesystems. One is the run (runtime) and the other patch (patching).

I have created a vis.sh file similar to one given in the above site.

#/usr/bin/bash

. $HOME/EBSapps.env run

DBFS=/apps/oracle/VIS/11.2.0

OID=VIS_starworld

DBSCRIPTS=$DBFS/appsutil/scripts/$OID

PATCH_TOP=$APPL_TOP_NE/../patch;export PATCH_TOP

OPATCH_PLATFORM_ID=226; export OPATCH_PLATFORM_ID

alias addbctl=$DBSCRIPTS/addbctl.sh

alias addlnctl=$DBSCRIPTS/addlnctl.sh

alias adstrtal=$ADMIN_SCRIPTS_HOME/adstrtal.sh

alias adstpall=$ADMIN_SCRIPTS_HOME/adstpall.sh

alias adadminsrvctl=$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh

alias adopmnctl=$ADMIN_SCRIPTS_HOME/adopmnctl.sh

alias adcmctl=$ADMIN_SCRIPTS_HOME/adcmctl.sh

alias runenv=". $HOME/EBSapps.env run"

alias patchenv=". $HOME/EBSapps.env patch"

alias dbenv=". $DBFS/$OID.env"

alias vis=". $HOME/vis.sh"

alias ops="ps -fed | grep VIS | wc -l"

alias opsl="ps -fed | grep VIS"


Here I have changed the values of DBFS and OID according to my environment.

I have placed this file in the home directory of the oravis user.

[oravis@starworld ~]$ pwd

/home/oravis

[oravis@starworld ~]$ ls -l vis.sh

-rwxr-xr-x 1 oravis oinstall 754 Jan 11 18:52 vis.sh

[oravis@starworld ~]$


I have then called it from the .bashrc file

[oravis@starworld ~]$ cat .bashrc

# .bashrc



# Source global definitions

if [ -f /etc/bashrc ]; then

. /etc/bashrc

fi

if [ -f /home/oravis/vis.sh ]; then

. $HOME/vis.sh

fi

# User specific aliases and functions

[oravis@starworld ~]$


The EBSapps.env is available from 12.2.2 and is also applicable for R12.2.0. I have placed the same in $HOME directory of oravis and applvis user.

Here too, I have to change the node info file to point according to my environment.

Startup

[oravis@starworld ~]$ . ./vis.sh



E-Business Suite Environment Information

—————————————-

RUN File System : /apps/oracle/VIS/fs1/EBSapps/appl

PATCH File System : /apps/oracle/VIS/fs2/EBSapps/appl

Non-Editioned File System : /apps/oracle/VIS/fs_ne

DB Host: starworld.appstek.ca Service/SID: VIS



Sourcing the RUN File System …



[oravis@starworld ~]$


[oravis@starworld ~]$ addlnctl start VIS

Logfile: /apps/oracle/VIS/11.2.0/appsutil/log/VIS_starworld/addlnctl.txt



You are running addlnctl.sh version 120.4





Starting listener process VIS ...





LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 27-JAN-2014 22:13:49



Copyright (c) 1991, 2011, Oracle. All rights reserved.



Starting /apps/oracle/VIS/11.2.0/bin/tnslsnr: please wait...



TNSLSNR for Linux: Version 11.2.0.3.0 - Production

System parameter file is /apps/oracle/VIS/11.2.0/network/admin/VIS_starworld/listener.ora

Log messages written to /apps/oracle/VIS/11.2.0/admin/VIS_starworld/diag/tnslsnr/starworld/vis/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))

STATUS of the LISTENER

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

Alias VIS

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 27-JAN-2014 22:13:50

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /apps/oracle/VIS/11.2.0/network/admin/VIS_starworld/listener.ora

Listener Log File /apps/oracle/VIS/11.2.0/admin/VIS_starworld/diag/tnslsnr/starworld/vis/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Services Summary...

Service "VIS" has 1 instance(s).

Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully



addlnctl.sh: exiting with status 0



addlnctl.sh: check the logfile /apps/oracle/VIS/11.2.0/appsutil/log/VIS_starworld/addlnctl.txt for more information ...



[oravis@starworld ~]$


[oravis@starworld ~]$ addbctl start VIS



You are running addbctl.sh version 120.1





Starting the database VIS ...





SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 27 22:14:29 2014



Copyright (c) 1982, 2011, Oracle. All rights reserved.



Connected to an idle instance.

ORACLE instance started.



Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 452987080 bytes

Database Buffers 1660944384 bytes

Redo Buffers 21725184 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



addbctl.sh: exiting with status 0



[oravis@starworld ~]$



Starting the apps

[applvis@starworld ~]$ . ./vis.sh



E-Business Suite Environment Information

—————————————-

RUN File System : /apps/oracle/VIS/fs1/EBSapps/appl

PATCH File System : /apps/oracle/VIS/fs2/EBSapps/appl

Non-Editioned File System : /apps/oracle/VIS/fs_ne

DB Host: starworld.appstek.ca Service/SID: VIS



Sourcing the RUN File System …



[applvis@starworld ~]$

[applvis@starworld ~]$ adstrtal apps/apps



You are running adstrtal.sh version 120.24.12020000.6





Enter the WebLogic Server password:



The logfile for this session is located at /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adstrtal.log



Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/jtffmctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running jtffmctl.sh version 120.3.12020000.4



Validating Fulfillment patch level via /apps/oracle/VIS/fs1/EBSapps/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for VIS on port 9300 ...



jtffmctl.sh: exiting with status 0





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adopmnctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adopmnctl.sh version 120.0.12020000.2



Starting Oracle Process Manager (OPMN) ...



adopmnctl.sh: exiting with status 0



adopmnctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adopmnctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adapcctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adapcctl.sh version 120.0.12020000.2



Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl start: opmn is already running.

opmnctl startproc: starting opmn managed processes...



adapcctl.sh: exiting with status 0



adapcctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adapcctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adnodemgrctl.sh start -nopromptmsg

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adnodemgrctl.sh version 120.11.12020000.4





Calling txkChkEBSDependecies.pl to perform dependency checks for oacore

Perl script txkChkEBSDependecies.pl got executed successfully





Starting the Node Manager...

NMProcess:

NMProcess: Jan 27, 2014 10:29:26 PM weblogic.nodemanager.server.NMServerConfig initDomainsMap

NMProcess: INFO: Loading domains file: /apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains

NMProcess:

NMProcess: Jan 27, 2014 10:29:26 PM weblogic.nodemanager.server.NMServer

NMProcess: INFO: Loaded node manager configuration properties from '/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties'

NMProcess: Node manager v10.3

NMProcess:

NMProcess: Configuration settings:

NMProcess:

NMProcess: NodeManagerHome=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

NMProcess: ListenAddress=starworld.appstek.ca

NMProcess: ListenPort=5556

NMProcess: ListenBacklog=50

NMProcess: SecureListener=false

NMProcess: AuthenticationEnabled=true

NMProcess: NativeVersionEnabled=true

NMProcess: CrashRecoveryEnabled=false

NMProcess: JavaHome=/apps/oracle/VIS/fs1/FMW_Home/jrockit64

NMProcess: StartScriptEnabled=false

NMProcess: StopScriptEnabled=false

NMProcess: StartScriptName=startWebLogic.sh

NMProcess: StopScriptName=

NMProcess: LogFile=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log

NMProcess: LogLevel=INFO

NMProcess: LogLimit=0

NMProcess: LogCount=1

NMProcess: LogAppend=true

NMProcess: LogToStderr=true

NMProcess: LogFormatter=weblogic.nodemanager.server.LogFormatter

NMProcess: DomainsFile=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains

NMProcess: DomainsFileEnabled=true

NMProcess: StateCheckInterval=500

NMProcess: QuitEnabled=true

NMProcess: UseMACBroadcast=false

NMProcess: DomainRegistrationEnabled=true

NMProcess: DomainsDirRemoteSharingEnabled=false

NMProcess:

NMProcess: Domain name mappings:

NMProcess:

NMProcess: EBS_domain_VIS -> /apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS

NMProcess:

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms-c4ws_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.Listener run

NMProcess: INFO: Plain socket listener started on port 5556, host starworld.appstek.ca

Refer /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adnodemgrctl.txt for details



adnodemgrctl.sh: exiting with status 0



adnodemgrctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adnodemgrctl.txt for more information ...





.end std out.

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/rgf/TXK/txkChkEBSDependecies_Mon_Jan_27_22_29_13_2014/txkChkEBSDependecies_Mon_Jan_27_22_29_13_2014.log



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adalnctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



adalnctl.sh version 120.3.12020000.2



Checking for FNDFS executable.

Starting listener process APPS_VIS.



adalnctl.sh: exiting with status 0





adalnctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adalnctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adcmctl.sh start

Timeout specified in context file: 1000 second(s)



script returned:

****************************************************



You are running adcmctl.sh version 120.19.12020000.3



Starting concurrent manager for VIS ...

Starting VIS_0127@VIS Internal Concurrent Manager

Default printer is noprint



adcmctl.sh: exiting with status 0





adcmctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adcmctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adadminsrvctl.sh start -nopromptmsg

Timeout specified in context file: 1000 second(s)



script returned:

****************************************************



You are running adadminsrvctl.sh version 120.10.12020000.2



Starting WLS Admin Server...

Refer /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adadminsrvctl.txt for details



adadminsrvctl.sh: exiting with status 0



adadminsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adadminsrvctl.txt for more information ...





.end std out.



.end err out.



****************************************************











Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting forms_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adformsctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start forms-c4ws_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting forms-c4ws_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adforms-c4wsctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting oafm_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adoafmctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting oacore_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adoacorectl.txt for more information ...





.end std out.



.end err out.



****************************************************







All enabled services for this node are started.



adstrtal.sh: Exiting with status 0



adstrtal.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adstrtal.log for more information ...



[applvis@starworld ~]$

[applvis@starworld ~]$

[applvis@starworld ~]$






Friday, January 24, 2014

Installing R12.2 on Linux

Installing R12.2 on Linux.
=========================================================



Building the stage.

The following files were downloaded from Oracle E-delivery website.





Unzip the V35215-01 files to create the startCD directory.

unzip -q '/data/softwaredownloads/r122/V35215-01_*.zip' -d
unzip -q '/data/softwaredownloads/r122/V35215-01_*.zip' -d .
unzip -q '/data/softwaredownloads/r122/V35215-01_*.zip' -d .
unzip -q '/data/softwaredownloads/r122/V35215-01_*.zip' -d .


cd to the bin directory under startCD

eg. /data/softwaredownloads/r122/Stage122/startCD/Disk1/rapidwiz/bin

then run the buildstage.sh file to build the stage directory.




Choose option 1