	Classpath                   : /u01/oracle/PREPROD/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/PREPROD/fs2/EBSapps/comn/java/classes

===============================================================================
 NetServiceHandler 120.28.12020000.6 started for ERPPREP at Wed Mar 23 23:12:13 GST 2016
===============================================================================
  
[ Context Information ] 
    Host              : ERPPREP
    Domain            : sunresort.local
    Out Dir           : /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/out/03232312
    Tier Type         : MIDDLE TIER
Getting connection... 

---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL=''
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ERPPREP
    sDbDomain  : sunresort.local
    sDbPort    : 1523
    sDbSid     : PREPROD
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ERPPREP.sunresort.local:1523:PREPROD
    Connection obtained

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

Connection obtained
NODE_ID Column Availability: true
FND_NODES Snap Shot:
 NODE_NAME = AUTHENTICATION, NODE_ID = 11134
 NODE_NAME = ERPPREP, NODE_ID = 11133

Updating null NODE_IDs
No of rows updated: 0
FND_NODES Snap Shot:
 NODE_NAME = AUTHENTICATION, NODE_ID = 11134
 NODE_NAME = ERPPREP, NODE_ID = 11133
  
 Registering Middle Tier Node
[ Input Information ]
    System Name       : PREPROD
    Server Name       : ERPPREP_PREPROD_APPS
    System CSI Number : N/A
    System Owner      : Oracle Apps
    HostName          : ERPPREP
    Domain Name       : sunresort.local
    RPC Port          : 1629
    Inst Tools Two Task: PREPROD
    Inst Web Two Task : PREPROD
    SID Default Alias : PREPROD
    JDBC SID          : PREPROD
    PRI ORACLE HOME   : /u01/oracle/PREPROD/fs2/EBSapps/10.1.2
    PRI ORACLE HOME NAME: APPS-1012
    PRI ORACLE HOME VERSION: 10.1.2
    AUX ORACLE HOME   : /u01/oracle/PREPROD/fs2/FMW_Home/webtier
    AUX ORACLE HOME NAME: APPS-iAS
    AUX ORACLE HOME VERSION: FMW11gR1
    Appltop Path      : /u01/oracle/PREPROD/fs2/EBSapps/appl
    Appltop Name      : ERPPREP
    Shared Appltop    : Y
    IS WEB            : Y
    IS ADMIN          : Y
    IS CONC           : Y
    IS FORMS          : Y
    Plaform           : LINUX_X86-64
    Tools Local       : null
    Web Local         : null

Middle tier node successfully registered
Node registered, commiting the transaction
Transaction commited

Fetching all the aliases
Domain Column Availability: true
VIRTUAL_IP Column Availability in FND_NODES: true
SCAN_NAME Column Availability in FND_DATABASES: true
SCAN_PORT Column Availability in FND_DATABASES: true
Using SERVICE_NAME for FNDFS_ERPPREP
Using SERVICE_NAME for FNDSM_ERPPREP
Using SERVICE_NAME for PREPROD
Using SERVICE_NAME for PREPROD_BALANCE
Using SERVICE_NAME for PREPROD_FO
Using SERVICE_NAME for PREPROD_LOCAL
Using SERVICE_NAME for PREPROD_REMOTE
Total number of aliases fetched:7
Total number of aliases including FNDFS aliases for APPLTOPs:8
Entry Fetched from Database is: 
PREPROD=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))
            (CONNECT_DATA=
                (SERVICE_NAME=PREPROD)
                (INSTANCE_NAME=PREPROD)
            )
        )

Entry Fetched from Database is: 
PREPROD_FO=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))
            (CONNECT_DATA=
                (SERVICE_NAME=PREPROD)
                (INSTANCE_NAME=PREPROD)
            )
        )

Entry Fetched from Database is: 
PREPROD_LOCAL=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))
        )

Entry Fetched from Database is: 
PREPROD_BALANCE=
        (DESCRIPTION= 
            (ADDRESS_LIST=
                (LOAD_BALANCE=YES)
                (FAILOVER=YES)
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))
            )
            (CONNECT_DATA=
                (SERVICE_NAME=PREPROD)
            )
        )

Entry Fetched from Database is: 
PREPROD_REMOTE=
        (DESCRIPTION= 
            (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))
            )
        )

Entry Fetched from Database is: 
FNDFS_ERPPREP=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1629))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

Entry Fetched from Database is: 
FNDSM_ERPPREP=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1629))
            (CONNECT_DATA=
                (SID=FNDSM)
            )
        )

Entry Fetched from Database is: 
FNDFS_APPLTOP_ERPPREP=
        (DESCRIPTION= 
            (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1629))
            )
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )


Checking for any entries that needs to be generated from context file
ERPPREP already registered
 
Starting writing TNSNAMES.ora at location /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin
Backing up exisiting tnsnames.ora to /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/out/03232312
WARNING: Could not create backup at /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/out/03232312 for tnsnames.ora
Finished writing TNSNAMES.ora at location /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin

Updating APPS_JDBC_URL
    APPS_JDBC_URL Alias= PREPROD_BALANCE
    APPS_JDBC_URL= 
    Update APPS_JDBC_URL Flag= true
    Updating APPS_JDBC_URL= 'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=PREPROD)))'
    APPS_JDBC_URL updated


Updating APPS_JDBC_URL for Patch edition
    Updating s_apps_jdbc_patch_connect_descriptor = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPREP.sunresort.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ebs_patch)(INSTANCE_NAME=PREPROD)))

    Updated APPS_JDBC_URL for Patch edition


Processing APPLFSTT
APPLFSTT=PREPROD
    Updating APPLFSTT to PREPROD_BALANCE;PREPROD_FO;PREPROD
    APPLFSTT updated


Processing sqlnet.ora on middle tier
Domain Column Availability: true
VIRTUAL_IP Column Availability in FND_NODES: true
Secure Nodes List=ERPPREP.sunresort.local
 SQLNET.ora contents: 
tcp.validnode_checking = yes
tcp.invited_nodes = (ERPPREP.sunresort.local)


IFILE=/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin/sqlnet_ifile.ora
 
Starting writing sqlnet.ora at location /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin
Creating an empty iFile:/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin/sqlnet_ifile.ora
iFile Created: /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin/sqlnet_ifile.ora
Backing up existing sqlnet.ora /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/out/03232312
sqlnet.ora does not exist /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/out/03232312
Finished writing sqlnet.ora at location /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin


Processing listener.ora on middle tier
s_enable_listener_password = OFF
instantiate file: 
   source : /u01/oracle/PREPROD/fs2/EBSapps/appl/ad/12.0.0/admin/template/iAS_1012_env.tmp
   dest   : /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/PREPROD_ERPPREP.env
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sql permissions changed to 644 (unix only) 
instantiate file: 
   source : /u01/oracle/PREPROD/fs2/EBSapps/appl/ad/12.0.0/admin/template/APPLSYS_ux.env
   dest   : /u01/oracle/PREPROD/fs2/EBSapps/appl/PREPROD_ERPPREP.env
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sql permissions changed to 644 (unix only) 
instantiate file: 
   source : /u01/oracle/PREPROD/fs2/EBSapps/appl/ad/12.0.0/admin/template/adovars_ux.env
   dest   : /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/appl/admin/adovars_PREPROD_ERPPREP.env
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/appl/admin/adovars_PREPROD_ERPPREP.env permissions changed to 644 (unix only) 
Creation of Directory - /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install Succeeded.
instantiate file: 
   source : /u01/oracle/PREPROD/fs2/EBSapps/appl/fnd/12.0.0/admin/template/admk80ln_ux.sql
   dest   : /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sql
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sql permissions changed to 600 (unix only) 
instantiate file: 
   source : /u01/oracle/PREPROD/fs2/EBSapps/appl/fnd/12.0.0/admin/template/admk80ln.sh
   dest   : /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sh
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sh permissions changed to 700 (unix only)
Execution of /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/install/admk80ln.sh is given to TimedProcess

admk80ln.sh started at Wed Mar 23 23:12:17 GST 2016


The environment settings are as follows ...

       ORACLE_HOME : /u01/oracle/PREPROD/fs2/EBSapps/10.1.2
        ORACLE_SID : 
          TWO_TASK : PREPROD
              PATH : /u01/oracle/PREPROD/fs_ne/EBSapps/appl/ad/bin:/u01/oracle/PREPROD/fs2/FMW_Home/modules/org.apache.ant_1.7.1/bin:/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/scripts:/u01/oracle/PREPROD/fs2/FMW_Home/webtier/perl/bin:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/bin:/u01/oracle/PREPROD/fs2/EBSapps/appl/fnd/12.0.0/bin:/u01/oracle/PREPROD/fs2/EBSapps/appl/ad/12.0.0/bin:/u01/oracle/PREPROD/fs2/EBSapps/comn/util/jdk32/jre/bin:/u01/oracle/PREPROD/fs2/EBSapps/comn/util/jdk32/bin::/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/OPatch:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/u01/oracle/PREPROD/fs2/EBSapps/comn/util/jdk32/jre/bin:/u01/oracle/PREPROD/fs2/EBSapps/comn/clone/bin/../jre/bin:/u01/oracle/PREPROD/fs2/EBSapps/comn/clone/bin/../jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/appltest/bin
      Library Path : /u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/PREPROD/fs2/EBSapps/appl/cz/12.0.0/bin:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib32:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/PREPROD/fs2/EBSapps/appl/sht/12.0.0/lib

SQLPLUS Executable : /u01/oracle/PREPROD/fs2/EBSapps/10.1.2/bin/sqlplus


SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 23 23:12:17 2016

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

Enter value for 1: Enter value for 2: Connected.
# $Header: admk80ln_ux.sql 120.9 2007/03/09 04:31:05 sbandla ship $
# LISTENER.ORA For Oracle Applications
# This file is automatically generated
APPS_PREPROD =
  (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= TCP)(Host= ERPPREP)(Port= 1629))
  )
SID_LIST_APPS_PREPROD =
  (SID_LIST =
    ( SID_DESC = ( SID_NAME = FNDSM )
		 ( ORACLE_HOME = /u01/oracle/PREPROD/fs2/EBSapps/10.1.2 )
		 ( PROGRAM = /u01/oracle/PREPROD/fs2/EBSapps/appl/fnd/12.0.0/bin/FNDSM )
		 ( envs='MYAPPSORA=/u01/oracle/PREPROD/fs2/EBSapps/appl/APPSPREPROD_ERPPREP.env,PATH=/usr/bin:/usr/ccs/bin:/bin,FNDSM_SCRIPT=/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/admin/scripts/gsmstart.sh' )
    )
    ( SID_DESC = ( SID_NAME = FNDFS  )
		 ( ORACLE_HOME = /u01/oracle/PREPROD/fs2/EBSapps/10.1.2 )
		 ( PROGRAM = /u01/oracle/PREPROD/fs2/EBSapps/appl/fnd/12.0.0/bin/FNDFS )
		 ( envs='EPC_DISABLED=TRUE,NLS_LANG=American_America.US7ASCII,LD_LIBRARY_PATH=/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib32:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/PREPROD/fs2/EBSapps/appl/sht/12.0.0/lib,SHLIB_PATH=/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib32:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/PREPROD/fs2/EBSapps/appl/sht/12.0.0/lib,LIBPATH=/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib32:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/PREPROD/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/PREPROD/fs2/EBSapps/appl/sht/12.0.0/lib,APPLFSTT=PREPROD,APPLFSWD=/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/appl/admin;/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/appltmp;/u01/oracle/PREPROD/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/html/oam/nonUix/launchMode/restricted' )
    )
  )
STARTUP_WAIT_TIME_APPS_PREPROD = 0
CONNECT_TIMEOUT_APPS_PREPROD = 10
TRACE_LEVEL_APPS_PREPROD = OFF
LOG_DIRECTORY_APPS_PREPROD = /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/logs/ora/10.1.2/network
LOG_FILE_APPS_PREPROD = APPS_PREPROD
TRACE_DIRECTORY_APPS_PREPROD = /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/logs/ora/10.1.2/network
TRACE_FILE_APPS_PREPROD = APPS_PREPROD
ADMIN_RESTRICTIONS_APPS_PREPROD = ON
IFILE = /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_ERPPREP/ora/10.1.2/network/admin/PREPROD_ERPPREP_listener_ifile.ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_APPS_PREPROD = OFF
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
ERRORCODE = 0 ERRORCODE_END
.end std out.

.end err out.

listener.ora successfully created on middle tier.
Closing connection
Connection Closed

adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END
