Reports

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|

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


Reply | Threaded
Open this post in threaded view
|

Re: Reports

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

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

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

ErmanArslansOracleBlog
Administrator
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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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

By the way it should be "install" , with 2 "l"s
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

latifa
Sorry but I don't know how to attach log files, menu lokks different as before or I forgot :)
Reply | Threaded
Open this post in threaded view
|

Re: Reports

ErmanArslansOracleBlog
Administrator
With your account logged in, click reply. While you are replying you should click on "More>Upload a file" to upload a file.
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

ErmanArslansOracleBlog
Administrator
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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

latifa
I made : command >> make.log
Reply | Threaded
Open this post in threaded view
|

Re: Reports

latifa
make3.log

It's better
Reply | Threaded
Open this post in threaded view
|

Re: Reports

ErmanArslansOracleBlog
Administrator
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
Reply | Threaded
Open this post in threaded view
|

Re: Reports

latifa

Yes you are right, this library is present in $ORACLE_HOME/lib32/librw.so
Reply | Threaded
Open this post in threaded view
|

Re: Reports

ErmanArslansOracleBlog
Administrator
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.
Reply | Threaded
Open this post in threaded view
|

Re: Reports

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

Regards,
Latifa