Link to home
Start Free TrialLog in
Avatar of ptreves
ptreves

asked on

FRM-91500 Error: f90gen

Hello,

Ok, I set my ORACLE_HOME as /u01/app01/oracle_iAS_10g.
Now, when launching the compiler, Iget:

FRM91500: Unable to start/complete the build

1) What now ?

PT

PS: Linux Red Hat Enterprise 3 (ES) server.
Heard that I might need to install openmotif2.1.30.....rpm ???

Avatar of ptreves
ptreves

ASKER

Hello,

I checke and the openmotif RPM are all installed.

1) Any ideas ??

PT
Avatar of ptreves

ASKER

Hello,

I set my environment variables NLS_LANG, and so forth.
Now when I invoke f90gen, I get:

ORA-01034:
ORA-27101:
Linux Error 2
====

I tried starting up my database, which was working well yesterday and I get an error message:

ORA-12545:

1) Please advice ?

PT
Avatar of seazodiac
You should NOT use f90gen,

to recompile the form:

use f90genm.sh instead.


Avatar of ptreves

ASKER

Hello,

I have a coexistance issue between my Oracle 9i database any my compiler environment variable settings to invoke and use the f90gen compiler.
If I set my .bash_profile settings for the Oracle 9i Database, I cannot invoke the f90gen compiler. Vice versa, if I set my .bash_profile file for the f90gen compiler, I cannot startup my Orale 9i database.

1) How can I invoke and compile my application and run the Oracle 9i database at the same time ? the compiler and database need each other for the compilation ?

2) How should I use the f90genm.sh file ?
(I tough it was a script file ??)

Your toughts...

PT
Avatar of ptreves

ASKER

Hello,

I tried to invoke the f90genm instead of f90gen and I got a blue GUI interface. I guess I can use that to compile my Forms/Reports/PLL ??

Your toughts ?

1) What about the coexistance issue ?

PT
Avatar of ptreves

ASKER

Hello,

Tried to use the GUI f90genm interface, and I got an error message:

ORA-12154: TNS: could not resolve service name

YOur toughts ??

PT
Avatar of ptreves

ASKER

Hello,

Ok, I tried to compile a library called hint.pll. I got the following error:

FRM-30312: Failed to compile library

1) What does this mean ?

PT
Avatar of ptreves

ASKER

Hello Veena,

I noticed that the compilation errors are related to Program Units inside my forms concerning certain tables.  After verification, I do confirm that the tables have been correctly imported in my Oracle 9i Database and do contain data.

I am at a loss to understand these and correct these compilation errors ?

Please advice ...

PT
what's veena? Indian language?

Avatar of ptreves

ASKER

Hello,

What importance does that have ?
A person helping me out with these issues........

Your toughts about these problems ?

PT
ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ptreves

ASKER

Hello,

I just installed the Forms/Reports Services 10g on Red Hat Linux.
I do not have a Forms developer as far as I know included.

Please advice ?

PT
Oracle Developer Suite 10g can be downloaded from here:
http://www.oracle.com/technology/products/ids/index.html