adrelink ar25runb
Date: Sat, 3 Jul 1999 00:25:37 -0700 (PDT)
From: abdulfattah abdulkarim abdulfattah_a@yahoo.com
Subject: adrelink ar25runb
HI,
We are running 10.7 SC16.1 on HP UNIX 10.20.
I was trying to relink ar25runb, adrelink ended with following error :
"/usr/ccs/bin/ld: Can't find library for -lXm"
Appreciate all your feedback.
Abdul
Date: Mon, 5 Jul 1999 22:08:23 +0530
From: "Mehra, Varun (CAP, GECSI)" Varun.Mehra@geind.GE.com
Subject: RE: adrelink ar25runb
Abdul
We are on the same configuration as yours and had encountered this problem
in the not so distant past. I requested our DBA to cull out his 2 pennys for
you and here its is:
The problem "/usr/ccs/ld -lXm not found" when running adrelink on Oracle
Apps Ver 10.7 Sc, HP-UX 10.20 comes due to lack of motif mode patches on the
system or due to lack of proper configuration of the motif mode library
(SRW2C_LIBS). Please follow the steps mentioned to overcome this :
1) Apply the motif mode patch on the unixserver.These can be got from your
HP Vendor.
2) After the motif mode patches have been appplied, login into appl_top and
obtain the file fnd_link.mk file which is ususally under the
$APPL_TOP/install/out directory. Edit fnd_link.mk and replace the -lXm,
-lXt,-lX11 paramters in the SRW2C_LIBS with -l:libXm.l,-l:libXm.t and
-l:libX11.l respectively.
3) After making the above changes run the adrelink again and you can create
ar25runb executable successfully.
My 2 pence from experience: Prior to applying these steps, please take a
complete backup of your APPL_TOP.
Regards and all the luck
Varun Mehra
Consultant-Oracle Applications
GE Capital - India
Abnormal disconnect - F45
Date: Wed, 07 Jul 1999 10:51:45 -0600
From: "Randy Lee" randy_lee@mk.com
Subject: f45srvm,f45ctl ERROR messages
Hello everybody:
We have been in production on 10.7NCA, Applications since abour Dec
1,1998. We are running the web server and form servers on Solaris. Most
of the end abusers are using the appletviewer, with a few jinitiators.
About 1 out of every 3 connected forms clients are getting Abnormally
disconnected. the majority of those disconnects are
with a status: ERROR: Read failed, error #131, Connection terminated
Has anybody else experienced simular statistics?
Has anybody been given a valid/concrete reason for this message from
ORACLE Support?
Looking for answers, Thanks for your continued support,
Randy lee
Date: Wed, 7 Jul 1999 13:33:51 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: re: f45srvm,f45ctl ERROR messages
We are experiencing similar problems. We are running 10.7NCA on 7.3.3.6
RDBMS on Solaris (DB and apps tiers). Our users are almost exclusively
running applet viewer (v.1.1.15, 1.1.18 and 1.1.21). Our experieinces have
been two-fold. One is like yours in that the user gets an error:
"FRM-99999 a Network error occurred, teh client will not be able to
continue." This only affects the Oracle connection, Other network
connections remain intact. (Interesting note: this primarily happens with
OE and Service.) This happens to some of my users several times each day --
especially if they are VERY BUSY!
A second anomally is the user will have a screen which appears normal, and
they can move the mouse to the various fields, and they can select the
pull-down menus -- but nothing works! They cannot enter data intot he
fields, the menu selections do not work. This is frustrating my users
endlessly! I have searched metalink for guidance. The little I found
(increase the virtual memory on the PC) did not work for us . Prior calls
to Oracle support have been an exercise in futility.
This is truly our biggest problem at this stage of the game. We have been
live since January 4 this year and my users are very disgruntled.
Any guidance you gurus out there can offer would be GREAT!
TIA:
Karen Blackwell
DBA/SA
RockShox, Inc.
Date: Wed, 7 Jul 1999 15:52:48 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: f45srvm,f45ctl ERROR messages
The FRM-99999 errors are generally related to an extreme sensitivity to
LAN/WAN latency. Later versions of D2K address this somewhat. patchset 4 of
D2K 1.6.1 (Forms 4.5.10.10) was recommended to us by OWWS to address those
problems. It got better, but it did not go away.
I've never heard of your second problem. Our other problem manifests as the
so-called "white screen of death" where the application window will freeze
completely, and if momentarily covered, will not repaint after it is
uncovered. This is caused by a complete crash of the server f45runw process.
We do not use AppletViewer. We found it to be unreliable and unstable. We
moved 100% to JInitiator. However, the client seems to be unrelated to
FRM-99999 errors.
Date: Wed, 7 Jul 1999 20:21:35 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: f45srvm,f45ctl ERROR messages
We had similar errors until applying patchset 3 and later, patchset 4, of
Developer/2000 1.6.1 on our middle tier (AIX). Also, we use JInitiator
exclusively due to complexity of distributing the AppletViewer worldwide to
our users. Some users still seem to get the keyboard lock-up problem you
describe, but I believe it's pretty rare.
I suggest applying the latest supported Dev/2k patchset (patchset 5, the
last time I checked) and seeing if that makes a difference. I would guess
that the later versions of the AppletViewer would behave better in general,
but that probably won't make a big difference for FRM-9999 errors. The only
supported JInitiator is equivalent to the 1.1.21.1 AppletViewer, and so
that's probably worth experimenting with, also.
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
Date: Thu, 8 Jul 1999 10:46:28 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: f45srvm,f45ctl ERROR messages
I suppose this is one of those quirks that we are compelled to live with
whether we like it or not! However, I have been educated by this list
(courtesy Derek Vaith) on how to effectively reduce F45 errors. This piece
of essential advice goes as follows:
quote
I don't think you will ever completely eliminate F45 errors, at least
not as long as we use a Windows platform, but I have some suggestions
which have helped me in the past. Try this on a couple of client
machines and see if it helps.
First, and this is key. There MUST be a minimum of 100 Mb of free
disk space on the hard drive for swapping.
Second, right click on the My Computer Icon, then choose properties.
Choose the performance tab. Click the File System button. Set the
typical role of this machine to be 'Network Server', and set the read
ahead optimization to none. Click the OK button, the choose the Virtual
Memory button. Make sure that it is set to allow Windows to manage.
end quote
Regards
Date: Thu, 8 Jul 1999 09:21:48 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: f45srvm,f45ctl ERROR messages
I am 10.7 NCA on Sun SPARC Solaris. We used to get a lot of these errors
in the past but these are now quite rare.
* There is a problem with networking in Solaris 2.6. We had no issues
with 2.5 but as soon as we went 2.6 it was rubbish. A lot of this has
been addressed in later O.S. patches. Make sure you have the latest tcp
patches applied. Sun deny any knowledge of issues.
* We only use appletviewer as we find this infinitely more stable,
reliable and performs significantly better that the initiator. The
performance is related to the control of cache or local jar file for
startup over the cross you fingers approach of using a browser.
* We prefer to use NT as the network software seems much more stable.
* Set the virtual memory setting quite high. We set our to both a
minimum and maximum of about 250MB. Setting both the same I understand
improves the performance and reliability of NT. The default of 72MB did
cause stability problems when systems were also intensive word, excel
users.
* Later patch sets and associated applications patches included
additional JAVA classes in the appscore file reducing the dependency on
the forms server during application startup and stability of the
applications.
* Monitor your network. There is a permanent connection maintained
between the application server and the appletviewer. If this connection
is lost even briefly it can cause the FRM-99999 errors. A congested WAN
link can also cause this. Talk to tour WAN provider about more detailed
or install a tool yourself such as MRTG (free!, web based)
* On the keyboard lock up. Are you using Dells. We get exactly the same
thing and to solve it we unplug the keyboard and plug it back in again.
Clears the problem in 90% of the cases.
Hope some of this helps
Graham.
Date: Thu, 8 Jul 1999 20:11:04 EDT
From: Nikora@aol.com
Subject: Re: f45srvm,f45ctl ERROR messages
We installed AP, PO on 107NCA. The version of the appletviewer is 1.1...16o
2nd and 3rd tiers are HP 10.20 . We made sure all PCs using appletvierwer
had 128MB RAM . Upgraded D2k to patch set 4 . Also made sure nothing else
ran on the Forms server - HP-10.20 with dedicated 700MB RAM .No problems with
appletviewer absolutely since going live in March '99.
George
Maintenance Pack
Date: Thu, 17 Jun 1999 16:38:47 -0800
From: janet_schieber@power-one.com
Subject: 11.0.3 Maintenance Pack
I'm getting ready to install the 11.0.3 Maintenance Pack on a test
applications server. Right now we're on 11.0.2 running on Solaris 2.6.
Has anyone done this install before? Were there any problems with the
install? Have there been any serious problems since?
Our database is running on a separate server on Solaris 2.6. The
database version is 8.0.4.3.0.
Thanks in advance.
Janet Schieber
Power-One, Inc.
Date: Fri, 18 Jun 1999 12:26:42 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: 11.0.3 Maintenance Pack
We just installed 11.0.3 in Production this week (we also were on 11.0.2)
after experimenting with it in other environments such as Test. It fixed
several problems in the modules we use (GL, AR, AP, PA) and doesn't seem to
have caused any significant problems. The patching process was smooth
except for an error with the akload.class step that happens near the end of
the database driver; if it fails with a '178 SHIP DATE' error, you can call
support and they have a fix.
Also, 11.0.3 took about 6 hours to apply on a 4-way IBM SP2 node running AIX
4.2.1. It was a typical 80/20 sort of thing where 80% of the steps took 20%
of the time, and the other 20% of the steps took 80% of the time; the worst
offender was a SQL script that had to update the
PA_COST_DISTRIBUTION_LINES_ALL table, which is easily the biggest table in
our database (~1,000,000 rows and growing quickly). This script did not
appear to use adpatch's batch size parameter and insisted on committing
every 500 rows, meaning that it took about an hour to run.
Anyway, other than that everything seemed pretty normal.
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
Toolbar Shortcut keys in V11.2?
Date: Fri, 18 Jun 1999 10:12:32 -0400
From: "Thornton, Mark" Mark.Thornton@ccai.net
Subject: Toolbar Shortcut keys in V11.2?
Does anyone know to get the text (when you sit on it with the mouse) for the
Toolbar shortcut keys in V11.2?
We have it in 10.7, is this an install issue in V11?
Date: Fri, 18 Jun 1999 12:28:05 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: Toolbar Shortcut keys in V11.2?
This feature is not available in 11.0.x, although I believe it's supposed to
be in 11i (aka 11.5).
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
Execute Shell script after OraApp request
Date: Tue, 22 Jun 1999 12:01:03 -0500
From: Kurt Greener kgreener@styline.com
To: "Oracle DBA list (E-mail)" OraApps-DBA@cpa.qc.ca
Subject: Adding a shell script.
Can anyone help me adding a UNIX shell script to execute after
and Oracle application request. We are running 10.7NCA (on NT) as app
server and HP-UX as dB server.
Specifically I am trying to get the UNIX shell script to be
executed after the NACHA payroll process runs. I have to manually run
it for each payroll process now.
Date: Tue, 22 Jun 1999 13:24:00 -0400
From: "Jacques, Pascale (SSC)" pjacques@ssc.knightridder.com
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: RE: Adding a shell script.
If the request is requested via a report submission you can create a report
set which include job1 followed by UNIX shell script job2. You will have to
register the UNIX shell script in APPS via concurrent/program/define.
Copy Apps layer
Date: Wed, 23 Jun 1999 12:52:20 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
To: "Apps DBA list" oraapps-dba@cpa.qc.ca
Subject: Apps Copy
Hi
I want to copy the Application layer of
My oracle apps software.
I want to copy only apps server components.
can any one ( who has done successfully) point
the steps involved in this
My oracle Apps is 11.0.2 NCA on
SunOS.
I have two separate machines for
database+conc.progs and
Forms server+webaserver
HTH
Regards,
K Gopalakrishnan
Database Administrator
Wipro GE Medical Systems
Bangalore - 560017, INDIA
Date: Wed, 23 Jun 1999 08:30:39 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
To: oraapps-dba@cpa.qc.ca
Subject: RE: Apps Copy
Gopalakrishnan
Where do want to copy your application layer and from where?
We have done this from one test to another test on the same box.
You have to relink all the application layer executables though.
In our case we upgraded one of our test bases from 10.7 char to 10.7 NCA and
copied the application layer
to another test database that was refreshed from prod.
Please let us know what is that you want to do exactly.
Thanks
Swamy Venkatayogi
Oracle Apps DBA
Commercial Intertech Corp
Date: Thu, 24 Jun 1999 20:55:13 +0530
From: Gopalakrishnan K gopalak@wiproge.med.ge.com
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: RE: Apps Copy
Hi
I am using Oracle Apps 11.0.2 NCA on SunOs.
I want to copy my existing forms/web server to
the same machine.I have another server for databse
Hope you got my problem
Regards !
Gopalakrishnan K
Database Administrator
GE Medical Systems Limited.
Pune 411014, INDIA
Date: Thu, 24 Jun 1999 12:36:07 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
To: oraapps-dba@cpa.qc.ca
Subject: RE: Apps Copy
You can do it .See for any executables that need relinking.
Adding new Legal entity - Oraapps 10.7
Date: Sun, 27 Jun 1999 03:29:28 -0700 (PDT)
From: S F sf3010@yahoo.com
To: oraapps-dba@cpa.qc.ca
Subject: OraApps 10.7 - Adding new Legal Entities
Hi,
There is a need arising in our company to add new legal entities.
Currently we have only one. Would anyone be kind enough to share
his/her experience related to adding new Legal Entities in a
pre-existing Oracle Apps. Database? Any clues/ideas/documents would be
most welcome.
Thanks in advance,
Best regards,
SF
sf3010@yahoo.com
Install of Forms 4/5 on Oracle 8
From: david solomon david_solomon_uk@yahoo.com
Reply-To: oraapps-dba@cpa.qc.ca
Subject: Forms 4/5 and Oracle 8
Date: Thu, 1 Jul 1999 03:19:52 -0400 (EDT)
Hi,
Some time ago we installed Forms 4/5 and Oracle 8 on standalone PCs
running either NT, Windows 95 and Workgroup. As far as I could tell,
the database name was "oracle" as a local database.
The problem was when trying to connect from form designer to the local
database it hanged and we had to terminate the process by
altctrldel. We tried not to include the name of the database on
the sign on menu; but this did not help.
Any suggestions to allow Forms 4/Forms 5 to connect to Oracle 8 local
database?.
Regards
David
Date: Thu, 01 Jul 1999 04:45:07 PDT
From: Pete Beer pbeer@hotmail.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Forms 4/5 and Oracle 8
Go ahead and use a service name (you mentioned "oracle"). What you need to
do is set up an entry in the tnsnames.ora file (%ORACLE_HOME%\net8\admin)
for the "oracle" servicename using the BEQUETH option. This works great.
If you don't want to use a servicename, set the LOCAL environment variable
to the local database SID (LOCAL=ORCL). You will alos want to set
ORACLE_SID.
Regards;
Pete Beer
Conley - Canitano
pbeer@hotmail.com
Move Oracle Applications from Dec Unix to NT
Date: Thu, 1 Jul 1999 16:26:09 -0600
From: GCS joewang@gcs-usa.com
To: oraapps-dba@cpa.qc.ca
Subject: Move Oracle Applications from Dec Unix to NT
Hi,
We are currently running Oracle Financials 10.7 16.1SC on Dec Unix boxes.
We
need to move our Oracle Application to NT Servers.
Any one had experience doing this. What are the things we need to watch for
and how would you do it?
TIA
Autopatch error on applying server update patch
Date: Thu, 22 Jul 1999 00:46:11 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
hi , i was wondering if anyone has had some experience in installing
oracle aplications rel10.7, i ve done it a few tiems, but ive come
acrros this error the otehr day which was along the lines of:
unable to rename file f:\applr107\fnd\6.1\mesg\mesg.tmp
to f:\applr107\fnd\6.1\mesg\mesg.msg
this occurs when using using autopatch to aply the server update
patches, does anyone have a clue as to what this error is on about? why
do i get this renaming rerror, thanks alot
Naqi Mirza
Date: Wed, 21 Jul 1999 15:01:41 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
check the permissions on the file???
Hope this helps!!!
-Harish
Date: Thu, 22 Jul 1999 01:02:19 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
hi harish,
no ive checked for file permissions but thats not the problem, what ive
even done is tried to rename the file myself , and got a sharing
violation error (oh i forgot to mention i was installing on windows NT)
or hat the file is currently being used by another appliation, now on
several reboots ive rerun the patch session and got the same error (the
reanming one), but on a fresh reboot i can then rename the file myself
and then recieve no sharing violation error. and when i start the patch
session again it continues sucessfully, i was just wondering if anyone
knew what the casue of the error was.
thanks though..............
Naqi Mirza
Date: Wed, 21 Jul 1999 18:12:06 -0500
From: "Shockey, David" DShockey@jwrinc.com
I've had odd errors like this that were fixed by reinstalling the NT
Service Pack that was already applied to the machine.
Date: Sat, 24 Jul 1999 18:58:25 -0700
From: "ALLBEE, Roger" rallbee@shl.com
Hey Naqi,
Try renaming f:\applr107\fnd\6.1\mesg\mesg.msg and then reapply patch. This
is a bit of a kludge, but then again so is NT. Please no additional
responses required for that last statement.
Good luck.
Regards,
Roger Allbee
Date: Sun, 25 Jul 1999 21:00:43 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
hi roger,
Yeah thanks for that , that what i eventually had to do, i
was just wondering what casued it though, but since u say NT thats even
reason for me, thanks again
regasrds
Naqi
How to track real owner of a session in 11.0 NCA
Date: Mon, 26 Jul 1999 07:14:14 -0700
From: jhendrickson@princesscruises.com (John Hendrickson)
Subject: Techie question for DBA's out there.
Now that we are implementing 11.0 with NCA, I no longer have a direct
method of determining who is the "true" owner of a session in v$sessions.
I used to be able to rely on osuser, but now that returns the user that
started up the web form server. Does Oracle Application keep a reference
that would tie a specific session to a specific applications signon? It is
going to be hard to track down those people that reserve records and then
go to lunch.
-John Hendrickson
Date: Mon, 26 Jul 1999 11:18:55 -0300
From: Melanie Perry Melanie.Perry@moncton.org
Subject: RE: Techie question for DBA's out there.
Hi John
Here is a really good script to get that sort of info....hope it helps a
bit.
fndusrmap.sql
Melanie Perry
SSA \ DBA
The City of Moncton
Moncton, NB
Canada
filename="fndusrmap.sql"
-- This script will map Oracle Application users currently logged on
-- to the system.
--
-- AUTHOR: Andy Rivenes, arivenes@appsdba.com
--
-- DATE: 11/06/98
--
-- REQUIREMENTS:
--
-- MODIFICATIONS:
--
--
SET PAGESIZE 9999;
SET VERIFY off;
SET FEEDBACK off;
SET LINESIZE 132;
--
-- ACCEPT reqid CHAR PROMPT 'Enter Request ID -- ';
--
COLUMN uname HEADING 'User Name' FORMAT A12;
COLUMN shrtnam HEADING 'Application' FORMAT A11;
COLUMN respnam HEADING 'Responsibility' FORMAT A14;
COLUMN frmnam HEADING 'Form' FORMAT A10;
COLUMN sid HEADING 'Oracle|Process' FORMAT 999999;
COLUMN spid HEADING 'Server|Process' FORMAT 9999999;
COLUMN suser HEADING 'Client|OS User' FORMAT A8;
COLUMN process HEADING 'Client|Process' FORMAT A8;
COLUMN smach HEADING 'Client|Machine' FORMAT A8;
COLUMN sprog HEADING 'Program' FORMAT A15 WORD_WRAPPED;
COLUMN cli HEADING 'Client|Info' FORMAT A15 WORD_WRAPPED;
--osuser, process, machine, program, client_info - v$session
SELECT usr.user_name uname,
app.application_short_name shrtnam,
resp.responsibility_name respnam,
form_name frmnam,
vsess.sid sid,
vproc.spid spid,
vsess.osuser suser,
vsess.process process,
vsess.machine smach,
vsess.program sprog,
vsess.client_info cli
FROM applsys.fnd_logins l,
applsys.fnd_application app,
applsys.fnd_login_responsibilities lresp,
applsys.fnd_login_resp_forms lform,
applsys.fnd_responsibility resp,
applsys.fnd_form frm,
applsys.fnd_user usr,
v$process vproc,
v$session vsess
WHERE l.login_id = lresp.login_id (+)
AND l.login_id = lform.login_id (+)
AND app.application_id (+) = resp.application_id
AND l.user_id = usr.user_id
AND lresp.responsibility_id = resp.responsibility_id (+)
AND lresp.resp_appl_id = resp.application_id (+)
AND lform.form_id = frm.form_id (+)
AND lform.form_appl_id = frm.application_id (+)
AND l.end_time IS NULL
AND lresp.end_time IS NULL
AND lform.end_time IS NULL
AND l.spid = vsess.process
AND l.login_name = vsess.osuser
AND vproc.addr = vsess.paddr (+)
/
Date: Mon, 26 Jul 1999 10:28:51 -0400
From: "Yadav, Surendra" YadavS@usa.redcross.org
To: "'John Hendrickson'" oraapps-l@cpa.qc.ca,
Subject: RE: Techie question for DBA's out there.
You might have to play around with this script, but this might answer some
of your concerns :
select distinct
fu.user_name user_name,
fl.start_time,
fl.end_time,
fl.terminal_id nca_server,
fl.submitted_login_id conc_req_id,
vs.sid ,
vs.serial# ,
vp.spid unix_pid,
vs.lockwait,
vl.type,
vs.status,
substr(vl.lmode,1,1) lock_mode,
vs.program user_program,
vs.command comm
from
fnd_user fu,
fnd_logins fl,
v$lock vl,
v$process vp,
v$session vs
where
fu.user_id = fl.user_id
and fl.pid = vp.pid
and vp.addr = vs.paddr
and vs.sid = vl.sid
and trunc(fl.start_time) = trunc(sysdate) ;