How to Upgrade Oracle Application Server 10g R2 (10.1.2) forms/reports in R12/12i – 5983622

Hi All,
Oracle Application Server and Developer Suite 10g Rel 2 Software, can we get this stuff from Oracle edelivery site.
Kindly reply with the URL.

Thanks,
Pinaki

Hi All,
I also have a different query.
While Running the below command in the Application Tier
“$ORACLE_HOME/bin/frmcmp help=y”
It gave a unfamiliar error i.e
“FRM-91500: Unable to start/complete the build.”
Kindly help me??

Regards,
Pinaki.

@ Pinaki,

Oracle Application Server and Developer Suite 10g Rel 2 Software is available via patch 5983622 from metalink

You need X Server running on your machine and Display set properly in order to execute this command via ssh or putty

For ” FRM-91500: Unable to start/complete the build ”
or run this command directly on server with X server or console

Check Metalink Note
753135.1 FRM-91500: UNABLE TO START/COMPLETE THE BUILD Encountered When Compiling Form…

@ Atul,

Thanks for a quick reply, can you tell me from where can I get X server and moreover do I need it if I am working in the Server directly and not using from any remote computer via putty or ssh?

Regards,
Pinaki

Do I need it if I am working in the Server directly ?

No you don’t need it if you are working on server directly with screen connected for display.

Ensure you can run xclock or any GUI like runInstaller .

try X tools like hummingbird, KEA! X, Xvc, Xvfb ..

use frmcmp_batch in form 10g instead of using frmcmp which throws an error “FRM-91500: Unable to start/complete the build.”

Hi,
oracle.security.jazn.JAZNInitException: /d2/
R12/ ab/ apps/ RUP4XB6/ apps/ tech_st/ 10.1.2/ sysman/ j2ee/ config/ jazn-data.xml (No such file or directory)

does that mean it is pointing to source instance, I am having the same issue and i tried regenrating jar files also but still the smae issue, would appreciate if you can shed some kmore light on this
thanks
Pravin

okay i found the issue if you open jazn.xml it’s referencing source instance changiung that to target instance will fix the issue and no need to create file in another location.
thanks

Pravin

Hi Atul,

We are upgrading Discoverer from 10.1.2.2 to 10.1.2.3.

While applying patch 5983622 we are facing issue on credentials of orcladmin

========================
Error retrieving the OID Administrator DN. Please ensure you OID connect information is correct
========================

Please help..

Thanks !!

Avadhut

Avadhut,
Is this standalone discoverer (NO OID) or with OID ?

Do you know orcladmin password for OID ?

Hi Atul,

We are using discoverer with OID.

and I know the password of orcladmin for OID.

Thanks !!

— Avadhut

Hi Atul,

Thanks !!

Issue :The orcladmin account was locked.

We unlocked the account and have started with the upgrade process.

— Avadhut

Hi Atul.

i upgraded our disocverer to 10.1.2.3, but my infradb registry still points to 10.1.2.0.2.

also, do we need to do metadata repository update also after software update ?

Oralce says Bug 6631051 10.1.2.3 DISCOVERER VERSION IS NOT UPGRADED AFTER PATCHSET

Regards
Narayana

@ Narayana,
Which discoverer you are using (standalone or integrated with SSO/OID) – Looking at infradb registry it seems you are using later please confirm ?

Which table your are referring to view version ?

thanks Atul for quick response

apps is integrated with sso+oid and similary disocver also.

APP_REGISTRY in infra database.

also, i observed if we install 10.1.4.0 metadata repository it will install 10.2.0.2 components .

is it correct ? correct if iam wrong

I’ve installed 10gr2 app server and BI froms and reports as well as BI discoverer. when i use the url

http://ictdb04ias:7778/discoverer/plus

I get the internal error :
The server encountered an internal error or misconfiguration and was unable to complete your request.

please suggest how do I run discoverer using the url above. I can’t seem to find anything on otn or google that will help.

@ MA

1. Check if OC4J for discoverer is running

opmnctl staus

Discoverer | ServicesStatus | XXXXX | Alive
Discoverer | PreferenceServer | XXXXX | Alive

2. Check logs at
a) $ORACLE_HOME/opmn/logs/opmn.log
b) $ORACLE_HOME/opmn/ logs/OC4J~OC4J_BI_Forms~default_island~1
c) $ORACLE_HOME/j2ee/ OC4J_BI_Forms/ application-deployments/ discoverer/ OC4J_BI_Forms_default_island_1/ application.log

Hi All,
I’m trying to upgrade to 10.1.2.3 but while i’m in step no.:3.8: Redeploy the new Forms EAR file i got the next error:

=======================
Program : /u03/oracle/BKPD/apps/ap
ps_st/appl/fnd/12.0.0/patch/115/b
in/txkCfgOC4JApp.pl started @ Mon Oct 19 15:18:16 2009

*** Log File = /u03/oracle/BKPD/inst/apps/BKPD_apps
prod1/logs/appl/rgf/TXK/txkCfgOC4JApp_
Mon_Oct_19_15_18_16_2009.log

Argument key : formsinstancepass
Argument value : ******
Argument key : oacorewebmodulename
Argument value : html
Argument key : oacoreappname
Argument value : oacore
Argument key : formsinstancename
Argument value : forms
Argument key : oc4jpass
Argument value : ******
Argument key : oafminstancepass
Argument value : ******
Argument key : formswebmodulename
Argument value : formsweb
Argument key : oafminstancename
Argument value : oafm
Argument key : applicationname
Argument value : forms
Argument key : runautoconfig
Argument value : No
Argument key : oafmwebmodulename
Argument value : webservices
Argument key : ascontrolwebmodulename
Argument value : ascontrol
Argument key : appsuser
Argument value : APPS
Argument key : oacoreinstancename
Argument value : oacore
Argument key : formsappname
Argument value : forms
Argument key : contextfile
Argument value : /u03/oracle/BKPD/inst/ap
ps/BKPD_appsprod1/appl/admin/BKPD_appsprod1.xml
Argument key : ascontrolappname
Argument value : ascontrol
Argument key : removeoc4jinstance
Argument value : Yes
Argument key : weboh1013
Argument value : /u03/oracle/BKPD/apps/tech_st/10.1.3
Argument key : mapviewerwebmodulename
Argument value : web
Argument key : oafmappname
Argument value : oafm
Argument key : mapviewerappname
Argument value : mapviewer
Argument key : oacoreinstancepass
Argument value : ******
Argument key : toolsoh1012
Argument value : /u03/oracle/BKPD/apps/tech_st/10.1.2
Execute SYSTEM command : /u03/oracle/BKPD/apps/tech_st/10.1.3/jdk/bin/java -Djava.security.auth.policy=/u03/oracle/BKPD/inst/
apps/BKPD_appsprod1/ora/10.1.3/j2ee/forms/config/j
azn.xml -jar /u03/oracle/BKPD/apps/tech_st/10.1.3
/j2ee/home/jazn.jar -user oc4jadmin -password ******* -listrealms
jazn.com

Execute SYSTEM command : /u03/oracle/BKPD/ins
t/apps/BKPD_appsprod1/admin/scripts/adopmnctl.sh stop

You are running adopmnctl.sh version 120.4.12000000.3

Stopping Oracle Process Manager (OPMN) and the managed processes …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u03/oracle/BKPD/inst/app
s/BKPD_appsprod1/logs/appl/admin/log/adopmnctl.txt for more information …

*****************************************************
Required values for starting OC4J instance “forms”:
====================================================
s_formsstatus = enabled
s_forms_nprocs = 1 (value should be greater than 0)

Existing values from the context file:
======================================
s_formsstatus = enabled
s_forms_nprocs = 1
———————————————-

*** Values for context variables are VALID ***

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

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

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

Stopping all OPMN processes.
Execute SYSTEM command : /u03/oracl
e/BKPD/inst/apps/BKPD_appsprod1/admin/scripts/adopmnctl.sh stop

You are running adopmnctl.sh version 120.4.12000000.3

Stopping Oracle Process Manager (OPMN) and the managed processes …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u03/ora
cle/BKPD/inst/apps/BKPD_appsprod1/logs/
appl/admin/log/adopmnctl.txt for more information …

OPMN stopped.
Execute SYSTEM command : /u03/oracle/BKPD

/apps/tech_st/10.1.3/opmn/bin/opmnctl start
opmnctl: opmn started.
Execute SYSTEM command : /u03/oracle/BKPD/ap
ps/tech_st/10.1.3/opmn/bin/opmnctl startproc instancename=forms

Errors encountered running /u03/oracle/BKPD/apps/ap
ps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl

*******FATAL ERROR*******
PROGRAM : /u03/oracle/BKPD/apps/apps_st/appl
/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl(/u03/ora
cle/BKPD/apps/apps_st/appl/fnd/12.0.0/bin/txkrun.pl)
TIME : Mon Oct 19 15:19:14 2009
FUNCTION: TXK::Process::run [ Level 3 ]
MESSAGES:
Command error: = 52224, = /u03/oracle/BKPD/apps/tech_st/10.1.3/opmn/bin/s
startproc instancename=forms

STACK TRACE
TXK::Error::abort(‘TXK::Error’,’HASH(0x20110b54)’) called at /u03/oracle/BKPD/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError(‘TXK::Proces
s=HASH(0x20b8271c)’,’Command error: = 52224, = /u03/oracle/BKPD/app…’,’undef’) called a
t /u03/oracle/BKPD/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError(‘TXK::Process=HA
SH(0x20b8271c)’,’Command error: = 52224, = /u03/oracle/
BKPD/app…’) called at /u03/oracle/BKPD/apps/apps_st/appl/au/12

.0.0/perl/TXK/Process.pm line 449
TXK::Process::run(‘TXK::Process=HASH(0x20b8271c)’,’HASH(0x210914e0)’) called at /u03/oracle/BKPD/apps/apps_st/appl/fnd/12.0.0
/patch/115/bin/txkCfgOC4JApp.pl line 1471
TXK::RunScript::execOPMNControl(‘HA
SH(0x20f00938)’) called at /u03/oracle/BKPD/apps/

apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 541
require /u03/oracle/BKPD/apps/apps_st/ap
pl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl called at /u03/oracle/BKPD/apps/apps_st/appl/au/12.0.0/perl/TXK/RunScript.pm line 105
TXK::RunScript::require(‘TXK::RunScript’,’/
u03/oracle/BKPD/apps/apps_st/appl/f
nd/12.0.0/patch/115/bin/t…’) called at /u03/oracle/
BKPD/apps/apps_st/appl/au/12.0.0/perl/TXK/Script.pm line 177
eval {…} called at /u03/oracle/BKPD/app
s/apps_st/appl/au/12.0.0/perl/TXK/Script.pm line 177
TXK::Script::run(‘TXK::Script=HASH(0x20

532860)’,’/u03/oracle/BKPD/inst/apps/BKPD_app
sprod1/logs/appl/rgf/TXK’,’/u03/oracle/BKPD/app
s/apps_st/appl/fnd/12.0.0/patch/115/bin/t…’)
called at /u03/oracle/BKPD/apps/ap
ps_st/appl/fnd/12.0.0/bin/txkrun.pl line 150
===========================
============================

Note that following :
– I followed note no.: 397174.1
– also checked the password for oc4jadmin and it is correct.

Any body knows how to solve this problem ?
Thanks for any reply.

hi.

I’m upgrading from 12.0.6 to 12.1.1 on Itanium Server.

I finished to upgrade OracleAS 10g Release 3 Patch Set 5 (10.1.3.5.0).

Now… in the upgrade of OracleAS 10g Forms and Reports I get an error in the section Configuration Assistants (OUI) step OC4J Instance Configuration Assistant – Failed.

OUI output:

#####################
========================================
Output generated from configuration assistant “Application Server website Configuration Assistant”:

Configuration assistant “Application Server website Configuration Assistant” succeeded
=======================================
Output generated from configuration assistant “OC4J Instance Configuration Assistant”:

Reading ini file – ‘/u01/oracle/MABETST1/apps/tech_
st/10.1.2/j2ee/deploy.ini’Adding web-app ‘webapp.war’ for app ‘BC4J’.
OC4J instance ‘home’: Adding property ‘jbo.server.in_oc4j=true’
Adding web-app ‘IsWebCacheWorkingWeb.war’ for app ‘IsWebCacheWorking’.
Initializing DCM..oracle.ons.SubscriptionExcep
tion: Subscription request timed out after 1200
00 millseconds. Possible causes: OPMN may no
t be running, you may have an OPMN running in an alternate ORACLE_HOME using duplicate port values, or OPMN may be misconfigured.
at oracle.ons.SubscriptionNotification.waitForReply(SubscriptionNotification.java:82)
at oracle.ons.ONS.addSubscriber(ONS.java:336)
at oracle.ons.Subscriber.realStartup(Subscriber.java:92)
at oracle.ons.Subscriber.(Subscriber.java:80)
at oracle.ons.ONS.createNewSubscriber(ONS.java:690)
at oracle.ias.sysmgmt.task.TaskMaster.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.TaskMaster.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.InstanceManager.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.InstanceManager.init(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.doDeploy(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.execute(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.deploy(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.main(Unknown Source)
ERROR: Caught exception while initializing DCM.

Oc4jDeploy tool completed, but with errors.

Configuration assistant “OC4J Instance Configuration Assistant” failed
###########################################

On the shell where i ejecute runInstaller:

###########################################
failed to get the ias-instance
Error: No ias instance to append to
###########################################

can you help me please? I did not found anything in metalink, thanks a lot.

And… what means

3. Ensure that Inventory is pointing to right location

¿?

Sorry, i’m newer on this.

Thanks.

I have installed Oracle Discoverer from the link http://www.oracle.com/technology/software/products/ias/htdocs/101202.html from the section “Business Inteligence” by downloading CD1 and CD2 for Windows.it has installed discoverer version 10.1.2.0.Want to upgrade to 10.1.2.3 using Patchset3 5983622.
I have installed 10.1.2.0 with the name BIHome_1 in E Drive.The path of installation is E:\Oracle\BIHome_1.Now when i am trying to install patchset3 “5983622” ,it is asking me for the name and path and by defult it is taking name as oracleas1 and path as E:\OraHome_1.When i try to install giving option as “s/w upgrade” it is giving me error as “there is no patch that needs to be applied”
What shuld be the actual path of this patch?should i point the path to E:\Oracle\BIHome_1?

can you tell me correct path for this patch to be installed?

@ Madhuri,
You need to install patch under E:\Oracle\BIHome_1 . When you apply patch and screen on which it gives E:\OraHome_1 from dropdown select E:\Oracle|BI_Home1

Thank you Atul.I had other Queries.Can you please help me out since i am new to this tool.
1)When i create a new report in Discoverer Desktop,it is by default saved as a .DIS file right?or is there any other format in which it can be saved?
2)When i open the Discoverer Desktop,i am asked for the User name and Password.How is the authentication done for this user name and password?What is the flow that is followed?
3)When i open the Discoverer Deskop with a particular user and password,how can we be sure that we are accessing a particular EUL that we want to access and we are fetching data from that particular EUL to generate reports?If the same user has access to two EUL’s how can we know which EUL are we accessing when we open desktop?
Or is it that one user can hve access to only one EUL?
4)Can you please let me know how can i find that metadata of the report that i generate that is in .DIS format?

Thanks

For OBIEE the user credentials are authenticated using .rpd.So how is the User credential done in Discoverer 10g Desktop?

How can the EUL be made online?

any API or webservice available in Discoverer 10g to fetch metadata of the Discoverer reports

I am trying to find if i can do a direct jump from oracle app server 10.1.2.0.2 to 10.1.3.5, or need to do any intermediate installs.
Please suggest.

Hii…

How can i shutdown my OPMN from 10.1.2 Home.

when i issued the following command,

$ORACLE_HOME/opmn/bin/opmnctl stopall

it returns the following error.

Unable to connect to opmn.
Opmn may not be up.

Can anyone help me in solving this issue….waiting 4 ur replies..

Thanks nd Regards..

Hi Atul,

In one of my client location we have a Oracle 11g R2 database on Oracle Solaris10.

as per requirement i wanna install application server i downloaded Oracle SOA Suite 10g (10.1.3.1) i have followed your post Install Oracle SOA Suite : 10.1.3.1.0 for installing. as i followed the step –Select First option “J2EE , Web Server and SOA Suite”. i got an error saying “Database version should be 9.2.0.7 or higher in the 10.1.0.5 or higher in Oracle Database 10g Release 1 series, Oracle Database XE (10.2.0.1), 10.2.0.2 or higher in the Oracle Database 10g Release 2 series.”

As my database is 11g i meet all requirements…. but my installation can not continue after this.

Kindly advise..

Hi Atul

My EBS version is 12.0.4, I am trying to apply 12.1.1 on it, I have successfully upgraded my database from 10.2.0.3 to 10.2.0.4

now trying to apply 5983622

but when I select Oracle Application Server and Developer Suite 10g Rel 2 Software update 10.1.2.3.0
and press enter it gave error

“There are no patches that need to be applied from the patchset Oracle Applicaiton Server and Developer Suite 10g Rel 2 Software Update 10.1.2.3.0”

please guide me how to solve this problem

thanks and regards

sani

Hi,
Is it possible to upgrade/migrate Oracle AS 10g to Weblogic/Fusion if running 12.1.3? And if so can you point me to some documentation? Thanks!

Hello Sani,

I am also experiencing the same error ‘There are..’ when applying patch 5983622.

Can you kindly tell me how you resolved this problem at your end?

If anybody else knows kindly post the resolution.

Many thanks in advance

Hi Atul,

I have Oracle Forms and Reports Services & J2EE Services both as Standalone Services.
I am on version 10.1.2.3.0 and I want to upgrade the complete infra to 10.1.3.4

Please tell me which patch set number is right for the upgrade for both the standalone services from 10.1.2.3.0 to 10.1.3.4

Awaiting for your Reply.

—
Lammeki Diengdoh
+91-993-021-5637
Mumbai

Hi,

We have upgrade IAS_oracle_home 10.1.2 to 10.1.2.3.As per the doc. After the applying the 5983622.can we need to apply 14825718 Forms – Bundle Patch.In our env. we need to follow doc. 397174.1.
My application Version:12.0.6
database:10.2.0.4

Thanks
Piyush