Muhammad Asif

Monday, August 14, 2017

Rapid Clone Failed While Running "Adcfgclone.pl dbTier": ORA-01194 and RC-00118

Refer: 375389.1

While cloning Oracle EBS 12.1.1...I retry below command after getting this error.

$ perl adcfgclone.pl dbTier

...

...
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 581506616 bytes
Fixed Size 452152 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes

Control file created.

alter database open resetlogs

Solution:

Please follow one of the following solutions (In a crash and burn or non business critical instance):

Solution 1

Startup mount;
SQL> recover database using backup controlfile until cancel;
-- type CANCEL

SQL> alter database open resetlogs;

Retry the clone. If the SQL commands or the reattempt of the clone fails to recover the database, then you must follow solution 2. There are no other solutions for this issue.

Solution 2
1. Shutdown the source database normally.
2. Re-copy the database files from the source to target and retry the clone process.

Wednesday, August 9, 2017

Installing Oracle EBS 12.1.1 on Oracle Linux 6 (64-bit)

Env:

EBS: 12.1.1
O/S: Oracle Linux 6 (64-bit)
-------------------------------------------

Prerequisites:

Edit ‘/etc/hosts’ file and add the hostname in the below shown format

[root@apps12 rapidwiz]# cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.0.0.28 apps12.ora.com apps12

[root@apps12 rapidwiz]#

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

Edit the /etc/sysctl.conf file and configure the kernel settings as shown below. After editing the file, use the
“sysctl -p” command or restart the system to invoke the new settings.

[root@apps12 rapidwiz]# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Oracle Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Disable netfilter on bridges.
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0

kernel.shmall = 2097152
kernel.shmmax = 5203054592
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 9815744
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
fs.aio-max-nr = 1048576
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 10485762
net.core.wmem_default = 10485762
net.core.rmem_max = 4194304
net.core.wmem_max = 10485762

[root@apps12 rapidwiz]# /etc/sysctl.conf/sysctl -p

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

Edit the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as below.

hard nofile 65536
soft nofile 4096
hard nproc 16384
soft nproc 2047
hard stack 16384
soft stack 10240

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

Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. Add or update the following entries to these minimum settings in the /etc/resolv.conf file.

options attempts:5

options timeout:15

-------------------------------------------------------------------------------------------------
Create oraInst.loc if not exists and add below entry.

[root@apps12 etc]# ls -l oraInst.loc
-rwxrwxrwx. 1 oracle dba 59 Jul 18 14:02 oraInst.loc

[root@apps12 etc]# cat oraInst.loc

inventory_loc=/ora/oracle/CRP/oraInventory
inst_group=dba

[root@apps12 etc]#

--------------------------------------------------------------------------------------------------
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/

openmotif21-2.1.30-11.EL6.i686 (32-bit)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

libXrender-0.9.5-1.el6.i686

binutils-2.20.51.0.2-5.20.el6.x86_64

compat-libstdc++-296-2.96-144.el6.i686

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.5-6.el6.x86_64

gcc-c++-4.4.5-6.el6.x86_64

glibc-2.12-1.7.el6.i686 (32-bit)

glibc-2.12-1.7.el6.x86_64

glibc-common-2.12-1.7.el6.x86_64

glibc-devel-2.12-1.7.el6.i686 (32-bit)

glibc-devel-2.12-1.7.el6.x86_64

libgcc-4.4.4-13.el6.i686

libgcc-4.4.4-13.el6.x86_64

libstdc++-devel-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6.x86_64

libstdc++-4.4.4-13.el6.i686

libstdc++-4.4.4-13.el6.x86_64

libXi-1.3-3.el6.i686

libXp-1.0.0-15.1.el6.i686

libXp-1.0.0-15.1.el6.x86_64

libXtst-1.0.99.2-3.el6.i686

libaio-0.3.107-10.el6.i686

libaio-0.3.107-10.el6.x86_64

libgomp-4.4.4-13.el6.x86_64

make-3.81-19.el6.x86_64

gdbm-1.8.0-36.el6.i686

gdbm-1.8.0-36.el6.x86_64

redhat-lsb-4.0-3.0.1.el6.x86_64

sysstat-9.0.4-11.el6.x86_64

util-linux-ng-2.17.2-6.el6.x86_64

compat-libcap1-1.10-1.x86_64

compat-libstdc++-33-3.2.3-69.el6.x86_64

elfutils-libelf-devel-0.148.1-el6.x86_64

libaio-devel-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6.x86_64

unixODBC-2.2.14-11.el6.i686

unixODBC-devel-2.2.14-11.el6.i686

xorg-x11-utils-7.4-8.el6.x86_64

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

Create users and assign default groups as shown below. ‘oracle‘ user is the owner of database tier and ‘applmgr‘ is the owner of application tier and these users belong to ‘dba’ group. We follow these notations through out the installation process. Also create required directories and change permissions as shown below.

# groupadd dba
useradd -g dba oracle
useradd -g dba applmgr
mkdir /ora/apps121stage
chmod -R 777 oracle:dba /ora/apps121stage
chown -R oracle:dba /ora/apps121stage
chgrp -R dba /ora/apps121stage

Error:

AC-00402: Unable to read driver file: /opt/oracrp/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv

Solution:

First of all rename the unzip version 6 because unzip ver 6 does not support staging of EBS 12.1.1 so we need download and install ver 5 for staging EBS 12.1.1

Rename the unzip version 6

# mv /usr/bin/unzip /usr/bin/unzip6

Download unzip version 5 for staging below the steps

https://oss.oracle.com/el4/unzip/unzip.html

unzip utility
unzip-5.51-10.el5.src.rpm

Installation

Download tar archive containing unzip utility

Extract the unzip utility from the tar file

Copy this utility to /usr/local/bin

Provide execute permission to downloaded file using command :

Make sure you run unzip as /usr/local/bin/unzip

Creating Staging Area (All Zip files in apps121stage folder)

# cd /ora/apps121stage

# unzip \*.zip

[root@apps12 apps121stage]# pwd
/ora/apps121stage

[root@apps12 apps121stage]# ls

oraAppDB oraApps oraAS oraDB startCD

B53824-01_1of4.zip V15680-01_1of3.zip V15684-01_1of3.zip V15688-01_1of2.zip
B53824-01_2of4.zip V15680-01_2of3.zip V15684-01_2of3.zip V15688-01_2of2.zip
B53824-01_3of4.zip V15680-01_3of3.zip V15684-01_3of3.zip V15689-01.zip
B53824-01_4of4.zip V15681-01_1of3.zip V15685-01_1of3.zip V15690-01_1of3.zip
V15681-01_2of3.zip V15685-01_2of3.zip V15690-01_2of3.zip
V15681-01_3of3.zip V15685-01_3of3.zip V15690-01_3of3.zip
V15682-01_1of3.zip V15686-01_1of3.zip V15691-01_1of3.zip
V15682-01_2of3.zip V15686-01_2of3.zip V15691-01_2of3.zip
V15682-01_3of3.zip V15686-01_3of3.zip V15691-01_3of3.zip
V15679-01_1of3.zip V15683-01_1of3.zip V15687-01_1of3.zip
V15679-01_2of3.zip V15683-01_2of3.zip V15687-01_2of3.zip
V15679-01_3of3.zip V15683-01_3of3.zip V15687-01_3of3.zip

[root@apps12 apps121stage]#

[root@apps12 rapidwiz]# pwd

/ora/apps121stage/startCD/Disk1/rapidwiz

[root@apps12 rapidwiz]# ls

adautostg.pl driver images oui RapidWiz.ini template
bin etc jlib rapidwiz RapidWizVersion unzip
ClientWiz.cmd File jre RapidWiz.cmd RapidWizVersion.cmd

[root@apps12 rapidwiz]# ./rapidwiz

http://apps.ora.com:8000

RW-50015: Error: – HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button

RW-50015: Error: – HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button

/ora/apps121/PROD/inst/apps/PROD_apps12/logs

HTTP

-----
checking URL = http://apps12.ora.com:8000

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page

----------
checking URL = http://apps12.ora.com:8000/OA_HTML/help

RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory

------------------
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP

----
checking URL = http://apps12.ora.com:8000/OA_HTML/jtfTestCookie.jsp

RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page

-----------
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
[root@apps12 logs]#

Checking Application status :-

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

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

Due to missing library. /usr/lib/libdb.so.2

if you got this type of error then you can take a new terminal and Down the all application services and follow below steps.

Solution:=

================================================================
* Shut DB services. (Database User oracle)

$ cd /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12

$./addlnctl.sh

$./addbctl.sh stop

Shut Application Services (Application user appsmgr)

/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts

$ ./adstpall.sh apps/apps

* create the below link for library file

root ]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

# vi /etc/selinux/config

change the SELINUX=enforcing

* Startup all application services. And press the Retry button

after check the oacore status

./addlnctl.sh start PROD

./addbctl.sh start

./adstrtal.sh start

[root@apps12 scripts]# ./adoacorectl.sh status

You are running adoacorectl.sh version 120.13

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: PROD_apps12.apps12.ora.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 715 | Alive
OC4JGroup:default_group | OC4J:forms | 644 | Alive
OC4JGroup:default_group | OC4J:oacore | 559 | Alive
HTTP_Server | HTTP_Server | 502 | Alive

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /ora/apps121/PROD/inst/apps/PROD_apps12/logs/appl/admin/log/adoacorectl.txt for more information ...

[root@apps12 scripts]#

Monday, August 7, 2017

RW-50016: RW-00023: RW-50015 Installing Oracle EBS 12.1 Error

While installing Oracle EBS 12.1 on Oracle linux 6 getting below error.

Log file path
---------------

/ora/apps121/VIS/db/tech_st/11.1.0/appsutil/log/VIS_apps12

Environment File

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

RW-50016: Error: - Database ORACLE_HOME environment file was not created:
File = /ora/apps121/PROD/db/tech_st/11.1.0/PROD_apps12.env
RW-50016: Error: - Apps ORACLE_HOME environment file was not created:
File = /ora/apps121/PROD/inst/apps/PROD_apps12/ora/10.1.3/PROD_apps12.env
RW-50016: Error: - iAS ORACLE_HOME environment file was not created:
File = /ora/apps121/PROD/inst/apps/PROD_apps12/ora/10.1.2/PROD_apps12.env
RW-50016: Error: - APPL_TOP environment file was not created:
File = /ora/apps121/PROD/apps/apps_st/appl/PROD_apps12.env
RW-50016: Error: - ADOVARS environment file was not created:
File = /ora/apps121/PROD/apps/apps_st/appl/admin/adovars.env
RW-50016: Error: - APPSCONFIG was not created:
File = /ora/apps121/PROD/apps/apps_st/appl/admin/adconfig.txt
DBC File

---------

RW-00023: Error: - DBC file was not created:
File = /ora/apps121/PROD/inst/apps/PROD_apps12/appl/fnd/12.0.0/secure/PROD.dbc
HTTP

-----

checking URL = http://apps12.ora.com:8000

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page

----------

checking URL = http://apps12.ora.com:8000/OA_HTML/help

RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory

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

RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP

----

checking URL = http://apps12.ora.com:8000/OA_HTML/jtfTestCookie.jsp

RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page

-----------

RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.

Solution:
----------

# vi /etv/selinux/config

[root@apps12 VIS_apps12]# cat /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

While installing Oracle EBS 12.1 getting error.

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

/ora/apps121/VIS/db/tech_st/11.1.0/appsutil/log/VIS_apps12

Unzip Count:153

Processing Disk1....

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

RW-50010: Error: - script has returned an error: 1
RW-50004: Error code received when running external process. Check log file for details.
Running Database Install Driver for VIS instance

[root@apps12 VIS_apps12]#

Solution:

-----------

[root@apps12 VIS_apps12]# mv /usr/bin/unzip /usr/bin/unzip-ver6

Refer: 1455077.1

Saturday, August 5, 2017

Oracle E-Business Suite Upgrade 12.1 to 12.1.3

Env:

Oracle Linux 6, EBS 12.1, DB
----------------------------------------

1080973.1

Thursday, August 3, 2017

How to start or stop Database / Application Tier in Oracle EBS 12.x

Environment: Oracle Linux 6, DB 11.2, EBS 12.x

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

<<Stop Server Command Order>>

1.Apps Management User,cd $ADMIN_SCRIPTS_HOME

stop apps server

$ /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts ./adstpall.sh apps/apps

/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12

2.DB Admin User,

cd $RDBMS_ORACLE_HOME/appsutil/scripts/<SID_hostname>

/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12 Stop DB Listener
./addlnctl.sh stop VIS
Stop DB Server
./addbctl.sh stop abort/normal/immediate

<<Start Server Command Order>>

1.DB Admin User,
/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12

cd $RDBMS_ORACLE_HOME/appsutil/scripts/<SID_hostname>

Start Database
./addbctl.sh start VIS

Start Database Listener
./addlnctl.sh start VIS

$ /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts

2.Apps Management User,cd $ADMIN_SCRIPTS_HOME

start Apps Server

./adstrtal.sh apps/apps

------------------------------------------------------------------------------------------------
STOP APPLICATION:

$ /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts

bash-4.1$ ./adstpall.sh apps/apps (Default UserName / Password)

You are running adstpall.sh version 120.22.12020000.5

Enter the WebLogic Server password:
The logfile for this session is located at /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adstpall.log
Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/jtffmctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running jtffmctl.sh version 120.3.12020000.4

Shutting down Fulfillment Server for VIS on port 9300 ...

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adcmctl.sh stop
Timeout specified in context file: 1000 second(s)

script returned:
****************************************************

You are running adcmctl.sh version 120.19.12020000.3

Shutting down concurrent managers for VIS ...
ORACLE Password:
Submitted request 7437985 for CONCURRENT FND SHUTDOWN

adcmctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adapcctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adapcctl.sh version 120.0.12020000.2

Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl stopproc: stopping opmn managed processes...

adapcctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adopmnctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adopmnctl.sh version 120.0.12020000.2

Stopping Oracle Process Manager (OPMN) and the managed processes ...
opmnctl stopall: stopping opmn and all managed processes...

adopmnctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/admanagedsrvctl.sh abort oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.4

Stopping oafm_server1...
......Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adoafmctl.txt for details

admanagedsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/admanagedsrvctl.sh abort forms-c4ws_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.4

Stopping forms-c4ws_server1...
......Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adforms-c4wsctl.txt for details

admanagedsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/admanagedsrvctl.sh abort forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.4

Stopping forms_server1...
.......Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adformsctl.txt for details

admanagedsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/admanagedsrvctl.sh abort oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.4

Stopping oacore_server1...
........Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adoacorectl.txt for details

admanagedsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adalnctl.sh stop
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

adalnctl.sh version 120.3.12020000.2

Shutting down listener process APPS_VIS.

adalnctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adadminsrvctl.sh stop -nopromptmsg
Timeout specified in context file: 1000 second(s)

script returned:
****************************************************

You are running adadminsrvctl.sh version 120.10.12020000.2

Stopping WLS Admin Server...
Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adadminsrvctl.txt for details

adadminsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts/adnodemgrctl.sh stop -nopromptmsg
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adnodemgrctl.sh version 120.11.12020000.4

adnodemgrctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0

adstpall.sh: check the logfile /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adstpall.log for more information ...

bash-4.1$

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

LISTENER STOP

-bash-4.1# su - oracle

-bash-4.1$ pwd

/ora/appsoft/VIS/11.2.0

SET THE PARAMETER

-bash-4.1$ . VIS_apps12.env

-bash-4.1$ echo $ORACLE_HOME

/ora/appsoft/VIS/11.2.0

-bash-4.1$ echo $ORACLE_SID

VIS

/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12

-bash-4.1$ ./addlnctl.sh stop VIS (Stop Listener)

Logfile: /ora/appsoft/VIS/11.2.0/appsutil/log/VIS_apps12/addlnctl.txt

You are running addlnctl.sh version 120.4

Shutting down listener process VIS ...

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-AUG-2017 16:12:55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps12.ora.com)(PORT=1521)))
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /ora/appsoft/VIS/11.2.0/appsutil/log/VIS_apps12/addlnctl.txt for more information ...

-bash-4.1$

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

DATABASE STOP

/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12

-bash-4.1$ ./addbctl.sh stop immediate; (Shutdown Database Immediate/Normal/Abort)

You are running addbctl.sh version 120.1

Shutting down database VIS ...

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 3 16:18:12 2017

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

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
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

-bash-4.1$

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

Startup Database
----------------------

/ora/appsoft/VIS/11.2.0/appsutil/scripts/VIS_apps12

-bash-4.1$ ./addbctl.sh start

You are running addbctl.sh version 120.1

Starting the database VIS ...

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 3 16:22:07 2017

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

-bash-4.1$

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

Startup Listener:

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

-bash-4.1$ ./addlnctl.sh start VIS
Logfile: /ora/appsoft/VIS/11.2.0/appsutil/log/VIS_apps12/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 03-AUG-2017 16:24:05

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

Starting /ora/appsoft/VIS/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /ora/appsoft/VIS/11.2.0/network/admin/VIS_apps12/listener.ora
Log messages written to /ora/appsoft/VIS/11.2.0/admin/VIS_apps12/diag/tnslsnr/apps12/vis/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps12.ora.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps12.ora.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias VIS
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 03-AUG-2017 16:24:05
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora/appsoft/VIS/11.2.0/network/admin/VIS_apps12/listener.ora
Listener Log File /ora/appsoft/VIS/11.2.0/admin/VIS_apps12/diag/tnslsnr/apps12/vis/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps12.ora.com)(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 /ora/appsoft/VIS/11.2.0/appsutil/log/VIS_apps12/addlnctl.txt for more information ...

-bash-4.1$

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

APPLICATION STARTUP

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

$ /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts

-bash-4.1$ . APPSVIS_apps12.env

-bash-4.1$

-bash-4.1$ cd $ADMIN_SCRIPTS_HOME

-bash-4.1$ pwd

/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/admin/scripts

-bash-4.1$ ls

adadminsrvctl.sh adformsrvctl.sh adstrtal.sh msc

adalnctl.sh admanagedsrvctl.sh cz64bitengine.pl mwactl.sh

adapcctl.sh adnodemgrctl.sh gsmstart.sh mwactlwrpr.sh

adautocfg.sh adopmnctl.sh ieo

adcmctl.sh adpreclone.pl java.sh

adexecsql.pl adstpall.sh jtffmctl.sh

-bash-4.1$

bash-4.1$ ./adstrtal.sh 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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adstrtal.log

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/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:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adopmnctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adapcctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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: <Aug 3, 2017 4:25:39 PM> <INFO> <Loading domains file: /ora/appsoft/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains>
NMProcess: Aug 3, 2017 4:25:39 PM weblogic.nodemanager.server.NMServerConfig initDomainsMap
NMProcess: INFO: Loading domains file: /ora/appsoft/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains
NMProcess: <Aug 3, 2017 4:25:39 PM> <INFO> <Loaded node manager configuration properties from '/ora/appsoft/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties'>
NMProcess: Aug 3, 2017 4:25:39 PM weblogic.nodemanager.server.NMServer <init>
NMProcess: INFO: Loaded node manager configuration properties from '/ora/appsoft/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties'
NMProcess: Node manager v10.3
NMProcess:
NMProcess: Configuration settings:
NMProcess:
NMProcess: NodeManagerHome=/ora/appsoft/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
NMProcess: ListenAddress=apps12.ora.com
NMProcess: ListenPort=5556
NMProcess: ListenBacklog=50
NMProcess: SecureListener=false
NMProcess: AuthenticationEnabled=true
NMProcess: NativeVersionEnabled=true
NMProcess: CrashRecoveryEnabled=false
NMProcess: JavaHome=/ora/appsoft/VIS/fs1/FMW_Home/jrockit64
NMProcess: StartScriptEnabled=false
NMProcess: StopScriptEnabled=false
NMProcess: StartScriptName=startWebLogic.sh
NMProcess: StopScriptName=
NMProcess: LogFile=/ora/appsoft/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=/ora/appsoft/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 -> /ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS
NMProcess:
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <EBS_domain_VIS> <AdminServer> <Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/data/nodemanager/startup.properties">
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/data/nodemanager/startup.properties"
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <EBS_domain_VIS> <forms_server1> <Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/data/nodemanager/startup.properties">
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/data/nodemanager/startup.properties"
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <EBS_domain_VIS> <oafm_server1> <Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/data/nodemanager/startup.properties">
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/data/nodemanager/startup.properties"
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <EBS_domain_VIS> <oacore_server1> <Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/data/nodemanager/startup.properties">
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/data/nodemanager/startup.properties"
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <EBS_domain_VIS> <forms-c4ws_server1> <Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms-c4ws_server1/data/nodemanager/startup.properties">
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.AbstractServerManager log
NMProcess: INFO: Startup configuration properties loaded from "/ora/appsoft/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms-c4ws_server1/data/nodemanager/startup.properties"
NMProcess: <Aug 3, 2017 4:25:40 PM> <INFO> <Plain socket listener started on port 5556, host apps12.ora.com>
NMProcess: Aug 3, 2017 4:25:40 PM weblogic.nodemanager.server.Listener run
NMProcess: INFO: Plain socket listener started on port 5556, host apps12.ora.com
Refer /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adnodemgrctl.txt for details

adnodemgrctl.sh: exiting with status 0

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

.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/rgf/TXK/txkChkEBSDependecies_Thu_Aug_3_16_25_31_2017/txkChkEBSDependecies_Thu_Aug_3_16_25_31_2017.log

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adalnctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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_0803@VIS Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adadminsrvctl.txt for details

adadminsrvctl.sh: exiting with status 0

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

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adformsctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adforms-c4wsctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adoafmctl.txt for more information ...

.end std out.

.end err out.

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

Executing service control script:
/ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/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 /ora/appsoft/VIS/fs1/inst/apps/VIS_apps12/logs/appl/admin/log/adstrtal.log for more information ...

bash-4.1$