online patching - run edition

[Roshan]

Hello,

after an online patch on a test instance, the patch edition(fs1) became run. Requests are completing in error.
As per log, the program is looking for file from /fs1... instead of /fs2...
image_(4).png

Grateful if you can help.

Regards,
Roshan

[ErmanArslansOracleBlog]

Review your environment. (environment variables, the shell environment that you have started the applications)

As well as the last cutover logs.

2016-06-02 10:05 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hello,

after an online patch on a test instance, the patch edition(fs1) became run. Requests are completing in error.
As per log, the program is looking for file from /fs1... instead of /fs2...
image_(4).png

Grateful if you can help.

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/online-patching-run-edition-tp1052.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

There is no errors in the adop logs. All phases completed successfully.

Below is the content of log file

Cash Management: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

CESLRPROBAI2: Run SQL*Loader- BAI2
+---------------------------------------------------------------------------+

Current system time is 02-JUN-2016 11:37:09

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
$CE_TOP/bin//PROD/fs2/EBSapps/appl/ce/12.0.0/bin/HDIAPR.csv
------------
SQL*Loader-500: Unable to open file (/u01/oracle/PROD/fs1/EBSapps/appl/ce/12.0.0/bin//PROD/fs2/EBSapps/appl/ce/12.0.0/bin/HDIAPR.csv)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

SQL*Loader: Release 10.1.0.5.0 - Production on Thu Jun 2 11:37:09 2016

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

Control File:   /u01/oracle/PROD/fs1/EBSapps/appl/ce/12.0.0/bin/BAI2.ctl
Data File:      /u01/oracle/PROD/fs1/EBSapps/appl/ce/12.0.0/bin//PROD/fs2/EBSapps/appl/ce/12.0.0/bin/HDIAPR.csv
  Bad File:     /u01/oracle/PROD/fs_ne/inst/TESTPROD_erpprodlivedb/logs/appl/conc/out/o1936826.out
  Discard File: /u01/oracle/PROD/fs_ne/inst/TESTPROD_erpprodlivedb/logs/appl/conc/out/o1936826.out
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table "CE"."CE_STMT_INT_TMP#", loaded when REC_ID_NO != 0X3033(character '03')
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect

[Roshan]

We moved the file HDIAPR.csv from fs2 to fs1 and the request completed successfully.

[ErmanArslansOracleBlog]

Well, you give the sql loader control files and datafiles as parameters , now I see..

Well, you can put these parameters to a place, which will not change when you do a filesystem switch.

Consider this as an enhancements for the future. 

2016-06-02 11:06 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

We moved the file HDIAPR.csv from fs2 to fs1 and the request completed successfully.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/online-patching-run-edition-tp1052p1055.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[ErmanArslansOracleBlog]

Or put your sqlloader related files to both of the filesystems(fs1 and fs2) and when there is a change required, update both fs1 and fs2.

alternartively, you can make them online patching enabled using the adop_sync.drv

2016-06-02 13:57 GMT+03:00 Erman Arslan <[hidden email]>:

Well, you give the sql loader control files and datafiles as parameters , now I see..

Well, you can put these parameters to a place, which will not change when you do a filesystem switch.

Consider this as an enhancements for the future. 

2016-06-02 11:06 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

We moved the file HDIAPR.csv from fs2 to fs1 and the request completed successfully.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/online-patching-run-edition-tp1052p1055.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

--

[Roshan]

Thanks :)
I edit the adop_sync.drv file. In between '#Begin Customization' and 'Copy Ends' I put:

rsync -zr /u01/oracle/PROD/fs1/EBSapps/appl/ce/12.0.0/bin /u01/oracle/PROD/fs2/EBSapps/appl/ce/12.0.0/bin

My current run edition is fs1

[ErmanArslansOracleBlog]

Read deployment guide.

your approach is wrong.

Read this: Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

You need to get used using Oracle Support.

you should use %s_current_base% and %s_other_base%

rsync -zr %s_current_base%/EBSapps/comn/java/classes/<Company identifier> %s_other_base%/EBSapps/comn/java/classes 


2016-06-02 14:15 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Thanks :)
I edit the adop_sync.drv file. In between '#Begin Customization' and 'Copy Ends' I put:

rsync -zr /u01/oracle/PROD/fs1/EBSapps/appl/ce/12.0.0/bin /u01/oracle/PROD/fs2/EBSapps/appl/ce/12.0.0/bin

My current run edition is fs1

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/online-patching-run-edition-tp1052p1058.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--