Reports

[latifa]

Hi Erman,

How are you ? I hope you are fine.
Today my issue is about reports in Oracle EBS 12.2.4. After cloning an envvironment from RAC and multinodes to single DB and one AppsTier, I tried to test my components to submit requests:

I have got the following error:

stat_low = 9
stat_high = 0
emsg:was terminated by signal 9
ld.so.1: rwrun: fatal: librw.so: open failed: No such file or directory

Program was terminated by signal 9
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 1434350.

Review your concurrent request log and/or report output file for more detailed information.

I run adadmin to generate reports files but no changes.

Any advise please ?

Thank you in advance for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

Thanks Latifa . I hope you are fine as well :)

what is your platform (Solaris, AIX , Linux) ?

Thanks

[latifa]

Thanks for your reply Erman.

The platform is as following using uname -a:

SunOS testserver 5.11 11.3 sun4v sparc sun4v

Regards,
Latifa

[ErmanArslansOracleBlog]

Is librw.so present?
Check it using: find  / -name librw.so -print

if it is not present, do the following- >

cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist:
cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install

[latifa]

Is librw.so present?   --> Not present

So I have done this :

cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk instal


--> lot of errors : it doesn't work.

Regards

[ErmanArslansOracleBlog]

Send me the output of :  make -f ins_reports.mk install

By the way it should be "install" , with 2 "l"s

[latifa]

I ran it twice:
1. With adding LD_OPTIONS="-L/lib -L/lib/sparcv9"; export LD_OPTIONS in the .profile file --> make.log
2. without -->make2.log

However now I have another error message in the request log:

BINARY

Enter Password:
REP-0004: Warning: Unable to open user preference file.
REP-0091: Invalid value for parameter 'P_Curr_val'.

Regards,
Latifa

[latifa]

Sorry but I don't know how to attach log files, menu lokks different as before or I forgot :)

[ErmanArslansOracleBlog]

With your account logged in, click reply. While you are replying you should click on "More>Upload a file" to upload a file.

[latifa]

Thank You Erman. I used to connect without login that's why I couldn't access to the upload menu.

make2.log
make.log

Regards
Latifa

[ErmanArslansOracleBlog]

I don't see any errors in these logs?

Did you redirected the standart error/stderr  into these log files?
Command syntax: command >outfile 2>&1

[latifa]

I made : command >> make.log

[latifa]

make3.log

It's better

[ErmanArslansOracleBlog]

There are warning for the objects like zrmpu_functypes, but I believe, now you have librw.so

Please search it using:  find  / -name librw.so -print and update me

[latifa]

Yes you are right, this library is present in $ORACLE_HOME/lib32/librw.so

[ErmanArslansOracleBlog]

So your report once again.
This time you should not be getting "ld.so.1: rwrun: fatal: librw.so: open failed: No such file or directory" error.

[latifa]

This error message doesn't appear any more. Thank you very much for your help.

Regards,
Latifa

[khadeer]

Hi,

  I am facing the similar issue on my newly cloned instance.

BINARY

stat_low = 9
stat_high = 0
emsg:was terminated by signal 9
ld.so.1: rwrun: fatal: libjvm.so: open failed: No such file or directory


PLEASE HELP ME.

Regards,
Ahmed.

[ErmanArslansOracleBlog]

Khader;

What is your OS?
What is the filesystem that you use for string EBS apps tier?