Post RAC Operations

[latifa]

Hi Erman,

We migrated to RAC configuration for EBS 12.2.4.
While executing cpadmin.sh, this script requested me the new  $FND_SECURE/DB1.dbc instead of the one generated $FND_SECURE/DB.dbc (this one corresponds to the previous configuration without RAC).

How can I correct this ? even processes, domain, context_name are all with DB naming.

Please let me know if you need more explainations :)
Regards,
Latifa

[ErmanArslansOracleBlog]

Please send me the output of cpadmin.sh (I want to see the exact prompts...)

[ErmanArslansOracleBlog]

Okay...
I see the script, it builds the dbc file path as follows;

# Check for dbc file
if [ "$DBCFILE" = "" ]; then
  DBCFILE=$FND_SECURE/$TWO_TASK.dbc
fi

if [ ! -f "$DBCFILE" ]; then
    bail "Unable to find .dbc file: $DBCFILE"
fi

So, you have 2 choices.

1)you can set TWO_TASK env variable to "DB" and then execute the cpadmin.sh afterwards.. (i.e export TWO_TASK=DB)
2)or you can set DBCFILE env variable to "$FND_SECURE/DB.dbc" and then execute the cpadmin.sh afterwards.. (i.e export DBCFILE=blablabla)

[latifa]

Hi Erman,

Here is the results:

cpadmin.sh

** ERROR:
** Unable to find .dbc file: /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/appl/fnd/12.0.0/secure/DBOFINP1.dbc

I run Adautocfg.sh before that and it leads to generate cpadmin.sh

/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/appl/fnd/12.0.0/secure/DBOFINP.dbc
instead of
/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/appl/fnd/12.0.0/secure/DBOFINP1.dbc

Before running adautocfg.sh, which varaibles in the context_file should update with DBOFINP1 to get automatically this dbc file ?

Or should I do cloning from the begining ... So I should clone even the master server ...

Thanks in advance Erman.

Latifa

[latifa]

I think I should change Weblogic Domain from _DB to _DB1 ...

What do you think ?

Is there a procedure to do that ?

[ErmanArslansOracleBlog]

It is all related with the TWO_TASK environment variable, as I mentioned earlier.

That environment variable is set from the environment file located in 10.1.2 ORACLE HOME (apps tier)
This home is also known as tools home..

Example path:

 /u01/install/APPS/fs2/inst/apps/ORAPROD_ermansrv1/ora/10.1.2/ORAPROD_ermansrv1.env

So you can just modify that file , especially the line that is setting the TWO_TASK;

example line:

TWO_TASK="ORAPROD"
export TWO_TASK


However, you shouldn't modify those files manually, because autoconfig will overwrite it anyways.

So, the answer of your question is " I believe you should  update the s_tools_twotask and run autoconfig.."

-->>

<TWO_TASK oa_var="s_tools_twotask" osd="unix">ORAPROD</TWO_TASK>

[ErmanArslansOracleBlog]

What do you mean by "weblogic domain from DB to DB1" ?

I don't know which document you are following, as well as the thing that make you believe that there is a relation between the weblogic domain & cpadmin.sh..

Send me detailed info, document name, things that you did, and the question (in details), if you want further support on this.

thanks.

[latifa]

Hi Erman,

I already updated this parameter but it's not enough:

<TWO_TASK oa_var="s_tools_twotask" osd="unix">DBOFINP1</TWO_TASK>
         <CP_TWOTASK oa_var="s_cp_twotask">DBOFINP1</CP_TWOTASK>
..
<TWO_TASK oa_var="s_weboh_twotask" osd="unix">DBOFINP1</TWO_TASK>

However, I can see in the context_file this parameter:

<start_cmd oa_var="s_jtffstart">/opt/application/V12/fs2/EBSapps/comn/util/jdk/jre/bin/java -ms128m -mx256m -classpath .:/opt/application/V12/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/opt/application/V12/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/opt/application/V12/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/opt/application/V12/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/opt/application/V12/fs2/EBSapps/comn/java/classes:/opt/application/V12/fs2/EBSapps/comn/java/classes/3rdparty/RFJavaInt.zip -Dengine.LogPath=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dengine.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/temp -Dengine.CommandPromptEnabled=false -Dengine.CommandPort=9302 -Dengine.AOLJ.config=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/appl/fnd/12.0.0/secure/DBOFINP.dbc -Dengine.ServerID=5000 -Ddebug=off -Dengine.LogLevel=1 -Dlog.ShowWarnings=false -Dengine.FaxEnabler=oracle.apps.jtf.fm.engine.rightfax.RfFaxEnablerImpl -Dengine.PrintEnabler=oracle.apps.jtf.fm.engine.rightfax.RfPrintEnablerImpl -Dfax.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dprint.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dengine.ServerInstanceID=5000 -DTurnOffLowPriorityMonitor=no -Dengine.MaxBatchThreads=12 oracle.apps.jtf.fm.FulfillmentServer >> /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log/jtffmctl.txt</start_cmd>

[ErmanArslansOracleBlog]

Did you run autoconfig after updating it?

2 Mar 2017 16:46 tarihinde "latifa [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi Erman,

I already updated this parameter but it's not enough:

<TWO_TASK oa_var="s_tools_twotask" osd="unix">DBOFINP1</TWO_TASK>
         <CP_TWOTASK oa_var="s_cp_twotask">DBOFINP1</CP_TWOTASK>
..
<TWO_TASK oa_var="s_weboh_twotask" osd="unix">DBOFINP1</TWO_TASK>

However, I can see in the context_file this parameter:

<start_cmd oa_var="s_jtffstart">/opt/application/V12/fs2/EBSapps/comn/util/jdk/jre/bin/java -ms128m -mx256m -classpath .:/opt/application/V12/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/opt/application/V12/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/opt/application/V12/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/opt/application/V12/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/opt/application/V12/fs2/EBSapps/comn/java/classes:/opt/application/V12/fs2/EBSapps/comn/java/classes/3rdparty/RFJavaInt.zip -Dengine.LogPath=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dengine.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/temp -Dengine.CommandPromptEnabled=false -Dengine.CommandPort=9302 -Dengine.AOLJ.config=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/appl/fnd/12.0.0/secure/DBOFINP.dbc -Dengine.ServerID=5000 -Ddebug=off -Dengine.LogLevel=1 -Dlog.ShowWarnings=false -Dengine.FaxEnabler=oracle.apps.jtf.fm.engine.rightfax.RfFaxEnablerImpl -Dengine.PrintEnabler=oracle.apps.jtf.fm.engine.rightfax.RfPrintEnablerImpl -Dfax.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dprint.TempDir=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log -Dengine.ServerInstanceID=5000 -DTurnOffLowPriorityMonitor=no -Dengine.MaxBatchThreads=12 oracle.apps.jtf.fm.FulfillmentServer >> /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/logs/appl/admin/log/jtffmctl.txt</start_cmd>

---

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/Post-RAC-Operations-tp2235p2245.html

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

[latifa]

Yes Erman

[ErmanArslansOracleBlog]

I just tried Latifa.
I updated the context file as follows;

<TWO_TASK oa_var="s_tools_twotask" osd="unix">ORATEST_BALANCE</TWO_TASK>

Then run autoconfig (apps tier)

Checked the env file which is in /u01/install/APPS/fs2/inst/apps/ORATEST_daroratestappsrv1/ora/10.1.2 ->

[applmgr@daroratestappsrv1 10.1.2]$ ls -lrt
total 20
drwxr-xr-x 3 applmgr oinstall 4096 Jan 26 15:11 network
drwxr-xr-x 3 applmgr oinstall 4096 Jan 26 15:13 forms
drwxr-xr-x 2 applmgr oinstall 4096 Jan 26 15:13 bin
drwxr-xr-x 3 applmgr oinstall 4096 Jan 26 15:13 reports
-rw-r--r-- 1 applmgr oinstall 3196 Mar  3 14:27 ORATEST_ermansrv1.env

It updated!

TWO_TASK="ORATEST_BALANCE"
export TWO_TASK
 
(it was only "ORATEST" earlier")

my environment was set accordingly as well.

[applmgr@ermansrv1 scripts]$ echo $TWO_TASK
ORATEST_BALANCE


My environment is 12.2 (12.2.4), what is yours?
Are you doing the same things or not?


Send me all your actions with screenshots and logs if your issue persists..
Read this if you want to load balance EBS connections.. It will give you the idea
http://ermanarslan.blogspot.com.tr/2014/01/ebs-on-oracle-rac-exadata-load-balance.html

[latifa]

Hi Erman,

Thank you very much Erman for your feedback, and I am sorry for the delay to reply (lot of work :)).

So, I have the same as you Erman. My system is also 12.2.4 and I have also updated the variables in the context file and the result is OK like following (like you).

echo $TWO_TASK

Result: DBFINP1

/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp03/ora/10.1.2$ ls -l
total 20
drwxr-xr-x   2 opfinbac gpfinbac       3 Dec  6 16:21 bin
-rw-r--r--   1 opfinbac gpfinbac    3245 Feb 27 17:54 DBOFINP_udkfinp03.env
drwxr-xr-x   3 opfinbac gpfinbac       3 Dec  6 16:21 forms
drwxr-xr-x   3 opfinbac gpfinbac       3 Dec  6 16:21 network
drwxr-xr-x   3 opfinbac gpfinbac       4 Dec  6 16:21 reports

TWO_TASK="DBOFINP1"
export TWO_TASK

However, As I run cpadmin.sh and it was looking for the $FND_SECURE/DBFINP1.dbc (which is not generated automatically while running autoconfig (I have instead DBOFINP.dbc which is generated). I said to my self may be I will have other casis where I will need to do that manually and it's not convenient or it will make problems later.

Do you think we should leave CONTEXT_NAME and other variables with DBOFINP and we will not have problems ? Even, the env file is also called DBFINP_udkfinp03.env and not DBOFINP1_udkfinp03.env ? Is it correct ?

If we want to exchange DBOFINP with DBOFINP1, we must do Cloning all servers ? Or is there any other solution ?

I want to be iso with another environemnt where this is done with cloning. That's what I don't want to do if the environment is ok.

Regards,
latifa

[ErmanArslansOracleBlog]

Hi Latifa,

First of all cpadmin.sh is not an important thing. I mean the connection that it establishes is not important. It can reach the instance directly or it can reach the instance using the SERVICE_NAME.  That script is for controlling the concurrent managers and as long as it is able to connect to the correcct database, you don't need to care which TNS entry it uses.
 
However, i see DBOFINP.. the letter "O" is interesting, because I see your TWO_TASK is set to DBFINP1.(so your db name should be DBFINP) ** What is DBOFINP?

send me the following outputs->

From the db node ->

1)ps -ef |grep pmon

2)sqlplus "/as sysdba"
SQL>show parameter name

[ErmanArslansOracleBlog]

3)Send me the values of the following as well..
Following from the apps tier context_file ->

s_contextname
s_systemname
s_dbSid
s_dbGlnam
s_dbSidLower
s_sitename

[latifa]

Hi erman,

It was a missing, sorry :) : it's DBOFINP,DBOFINP1,DBOFINP11 and DBOFINP12.

Here what you asked for:

DBTier
--------
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      DBOFINP1
db_unique_name                       string      DBOFINP1
global_names                         boolean     FALSE
instance_name                        string      DBOFINP11
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string
service_names                        string      DBOFINP1, ebs_patch


AppsTier
----------
<oa_context_name oa_var="s_contextname">DBOFINP_udkfinp03</oa_context_name>

<oa_system_name oa_var="s_systemname">DBOFINP</oa_system_name>
<global_db_name oa_var="s_dbSid">DBOFINP1</global_db_name>
<global_db_name oa_var="s_dbGlnam">DBOFINP1</global_db_name>
<db_name_lower oa_var="s_dbSidLower">dbofinp1</db_name_lower>
<oa_site_name oa_var="s_sitename">DBOFINP</oa_site_name>

[ErmanArslansOracleBlog]

your s_systemname should be DBOFINP1.
How did you end up with DBOFINP?

Check the db tier context file as well. Check s_systemname in db context file.
It should be DBOFINP1. If not ->

Ensure that you have taken a backup of your environment.
Clean the topology information:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
From OAM, change the s_systemname from the application tier context files from FINPRD1 to FINPRD, so they can match the values as in the DB context files.
Run autoconfig in all DB nodes;
Run autoconfig in all Apps nodes.

In short, the s_systemname in db and apps context file should be equal and in your case it should be set to DBOFINP1

[latifa]

Yes it is unpdated like that in DBTier:

<oa_system_name oa_var="s_systemname">DBOFINP1</oa_system_name>

NB: DBOFINP is the DB name before migrating to RAC and in the fresh install of EBS witout RAC.

with RAC, we built the context_file and run adconfig on DBTier nodes.

We run autoconfig on AppsTiers also after updating somme variables but not this one and "s_sitename".


Regards

[ErmanArslansOracleBlog]

Run autoconfig on appstier after changing s_systemname in apps tier context file.

[latifa]

Hi Erman,

I run autoconfig on all AppsTier servers.

However, we don't change lot of values:

context_name is with DBOFINP and not DBOFINP1
context_file also
and many others.

Is it Ok to keep this like that ?

Can we build xml file and recreate context_name manually ?

Or shull we run adcfgclone to have such configuration ? Which option with adcfgclone ?

Thank you in advance for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

I guess it is also there in db tier context file.

I suggest you to clean the fnd_nodes( just in case, to have a clean env, using fnd_conc_clone.setup_clean), rebuild the context file using adbldxml.pl and run autoconfig on db tier, and then I suggest you to run adcfgclone.pl on apps tier like you are recloning this EBS instance. (dont copy anything, leave the fs as is, run preclone first and then run adcfgclone.pl -- like you ar e taking a clone and answer the questions that adcfgclone.pl will ask you correctly)

2017-03-10 23:06 GMT+03:00 latifa [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Erman,

I run autoconfig on all AppsTier servers.

However, we don't change lot of values:

context_name is with DBOFINP and not DBOFINP1
context_file also
and many others.

Is it Ok to keep this like that ?

Can we build xml file and recreate context_name manually ?

Or shull we run adcfgclone to have such configuration ? Which option with adcfgclone ?

Thank you in advance for your help.

Regards,
Latifa

---

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/Post-RAC-Operations-tp2235p2338.html

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

--