Re: HELP!!! Can't run SQLFORMS (runform45m)......

From: oracle <oracle_at_nightmare.com>
Date: 1997/03/01
Message-ID: <3317D726.248F_at_nightmare.com>


------------6AE423147EFC8
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii

Joe wrote:
>
> Hi,
> Two days ago, our system (AIX 4.1) was shut down and can't come
 back.
> My System Administor re-installed AIX operating system and brought
> the system backup.
> After system was brought back, I did some works to bring the
 database up
> and all databases are there. Now, my question is that I can't bring
 up any
> thing relates to X Motif stuffs, such as Forms.
>
> The following is the message I got when I try to run FROMS
> exec() : 0509-036 Cannot load program runform45m because of the
 following
> errors:
>
> 0509-023 Symbol _XmSetFocusFlag in ksh is not defined
> 0509-023 Symbol _XmpopupSpringLoad in ksh is not defined
> 0509-023 Symbol _XmPopdown in ksh is not defined
> 0509-026 System error: cannot run a file that does not
 have a
> valid format
>
> I tried " make -f oracle.mk install", which was suggested by Oracle
 tech
> support and no luck.
> We are completely dead.
> Any help will be appreciated........
>
> E-mail to joe.kau_at_lmco.com

Sounds like you are missing libXm.so.

When I do an nm on libXm.a I get:

libXm.a

._XmSetFocusFlag    |       824|extern|                  |      |
|.text _XmSetFocusFlag     |    167424|extern|                  |
|     |.data libXmu.a

It is defined in libXm.a. My guess is that you are linking with the shared version of this and it does not exist anymore. Or you need to set your LD_LIBRARY_PATH to the directory where this file is.

Also making oracle is not going to help you. You need to relink the forms products. You did explain which version of forms so I am going to assume it is from the dev/2000 family and it is 1.0.

To relink do the following:

% cd $ORACLE_HOME/forms45/lib
% make -f sqlforms45.mk install

This will relink both the motif and character products. If you get undefined symbols here it may be because the administrator did not install all the packages for Motif or the Motif and X11 libraries are not in /usr/lib. On my system all these libraries are linked to /usr/lpp/X11/lib/R5 and /usr/lpp/X11/lib/R5/Motif1.2

If you do have shared versions of the Motif and X11 libraries make sure LD_LIBRARY_PATH points to them.

Not sure why support had you relink oracle. These calls are all Motif calls which has nothing to do with "oracle".

------------6AE423147EFC8
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset=us-ascii

<HTML><BODY>

<DT>Joe wrote:<BR>

&gt;&nbsp;<BR>
&gt; Hi,<BR>
&gt;&nbsp;&nbsp; Two days ago, our system (AIX 4.1) was shut down and can't
come back.<BR>
&gt;&nbsp;&nbsp; My System Administor re-installed AIX operating system and brought<BR>
&gt;&nbsp;&nbsp; the system backup.<BR>
&gt;&nbsp;&nbsp; After system was brought back, I did some works to bring the database up<BR>
&gt;&nbsp;&nbsp; and all databases are there.&nbsp; Now, my question is that I can't bring up any<BR>
&gt;&nbsp;&nbsp; thing relates to X Motif stuffs, such as Forms.<BR>
&gt;&nbsp;<BR>
&gt;&nbsp;&nbsp; The following is the message I got when I try to run FROMS<BR>
&gt;&nbsp;&nbsp;&nbsp;&nbsp; exec() : 0509-036 Cannot load program runform45m
because of the following<BR>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; errors:<BR>
&gt;&nbsp;<BR>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0509-023 Symbol _XmSetFocusFlag in ksh is not defined<BR> &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0509-023 Symbol _XmpopupSpringLoad in ksh is not defined<BR> &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0509-023 Symbol _XmPopdown in ksh is not defined<BR> &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0509-026 System error: cannot run a file that does not have a<BR> &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; valid format<BR>
&gt;&nbsp;<BR>
&gt;&nbsp;&nbsp; I tried &quot; make -f oracle.mk install&quot;, which was suggested by Oracle tech<BR>
&gt;&nbsp;&nbsp; support and no luck.<BR>
&gt;&nbsp;&nbsp; We are completely dead.<BR>
&gt;&nbsp;&nbsp; Any help will be appreciated........<BR>
&gt;&nbsp;<BR>
&gt;&nbsp;&nbsp; E-mail to joe.kau_at_lmco.com<BR>
<BR></DT>

<DT>Sounds like you are missing libXm.so.</DT>

<DT>&nbsp;</DT>

<DT>When I do an nm on libXm.a I get:</DT>

<DT>&nbsp;</DT>

<DT>libXm.a&nbsp;</DT>

<DT>._XmSetFocusFlag&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 824|extern|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; |.text _XmSetFocusFlag&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp; 167424|extern|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; |.data libXmu.a
&nbsp;</DT>

<DT>&nbsp;</DT>

<DT>It is defined in libXm.a.&nbsp; My guess is that you are linking with the shared version of this and it does not exist anymore.&nbsp; Or you need to set your LD_LIBRARY_PATH to the directory where this file is.</DT>

<DT>&nbsp;</DT>

<DT>Also making oracle is not going to help you.&nbsp; You need to relink the forms products.&nbsp; You did explain which version of forms so I am going to assume it is from the dev/2000 family and it is 1.0.</DT>

<DT>&nbsp;</DT>

<DT>To relink do the following:</DT>

<DT>&nbsp;</DT>

<DT>% cd $ORACLE_HOME/forms45/lib</DT>

<DT>% make -f sqlforms45.mk install</DT>

<DT>&nbsp;</DT>

<DT>This will relink both the motif and character products.&nbsp; If you get undefined symbols here it may be because the administrator did not install all the packages for Motif or the Motif and X11 libraries are not in /usr/lib.&nbsp; On my system all these libraries are linked to /usr/lpp/X11/lib/R5 and /usr/lpp/X11/lib/R5/Motif1.2</DT>

<DT>&nbsp;</DT>

<DT>If you do have shared versions of the Motif and X11 libraries make sure LD_LIBRARY_PATH points to them.</DT>

<DT>&nbsp;</DT>

<DT>Not sure why support had you relink oracle.&nbsp; These calls are all Motif calls which has nothing to do with &quot;oracle&quot;.</DT>

<DT>&nbsp;</DT>

<DT>&nbsp;</DT>

</BODY>
</HTML>
------------6AE423147EFC8-- Received on Sat Mar 01 1997 - 00:00:00 CET

Original text of this message