Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle-tomcat connection problem

642648Jun 2 2008 — edited Feb 13 2012
Dear all,

We got a problem with Oracle Xe 10g Release 2 (10.2.0.1) with French interface. For some unknown reasons, the Oracle service is no more accessible through the web interface and has to be restarted. Once this is done, everything is working fine until Oracle stops responding. We have investigated listener.log of Oracle and we noticed that a service called beremote.exe (Backup Exec Remote Agent service) runs automatically. We are not sure if this service is related to the problem. Here is the error we keep getting on the listener.log :

[ OCRUTL][1092]u_set_gbl_comp_error: Parameter was NULL
[ OCRUTL][1092]u_set_gbl_comp_error: Parameter was NULL
2008-05-20 08:53:52.968: [ OCRRAW][1092]proprinit: Could not open raw device
2008-05-20 08:53:52.968: [ default][1092]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][1092]u_set_ocr_error: Parameter was NULL
2008-05-20 08:53:52.968: [ CSSCLNT][1092]clsssinit: error(33 ) in OCR initialization
[ OCRUTL][1092]u_set_comp_error: Parameter was NULL
[ OCRUTL][1092]u_set_ocr_error: Parameter was NULL
2008-05-20 13:05:46.468: [ OCROSD][1092]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error
Le système n'a pas trouvé l'option d'environnement spécifiée
The system didn't find the option of specific environment (translated from French)

(more similar errors in css.log file that date far back)

The following information was found in the core_xe_pid_976_tid_x420_2008_5_20_8_53_46.log:

An Unhandled Exception Occurred,
Exception Number : 0xc0000005
Exception Address : 0x60aba5ec


The server is running on Windows XP Professional SP2 1.86Ghz. We upgraded the Ram on the server at 4 gig, but the problem still occurs. We have this installed on 10 machines in total and this problem only happens on this particular computer. We don't think this is a state connection issue. Maybe it's related to Oracle's French interface but we are not sure. We really don't know what to do. Any suggestions are welcome.

Regards,

Emixam.

Comments

Rahul Kumar
hi anuradha,
you can use substitution variable in the grid and then display that in text via GetHeading function.

Hope this helps.

Regards,
Rahul
661221
Rahul,

I tried it but itz not displayed...

the sub var is not visible in any dim member selection tabs ..... so i cant getit in data col/row.......if i type & refer with getheading..itz not workin.....


how can we display it????????/


Thanks
Rahul Kumar
hi,

if substitution varible is defined correctly on the cube then it should definately be displayed on the some dimension member selection.

Please check that.
Once it is visible, just use it as a member in any hidden row/column. Then use GetHeading function to display it in a text box.

Regards,
Rahul
661221
Hi,

I have cross checked all dim's in FR...but could not find 'em in any dim's.......other sub variables which r related to dim's r visible under respective dim's(Ex:Year=$curyr)......

i could see it defined in the outline for this cube.

i fell that the data load sub var is not visible under any dim as itz not related to any of them.....

Is there a way to display it in FR.

Thnx
Rahul Kumar
hi,
yes to display a substitution variable, it has to be associated with one of the dimensions.
and then only you will be able to display it.

May be one other option might be to use LINKED OBJECT in FR. so that just updating the information in one text box of one report will do it in all reports.


You can also use substitution variable in that liked object.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 12 2012
Added on Jun 2 2008
3 comments
323 views