Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9iAS forms and reports using VFB

Simon_139
Occasional Advisor

Oracle 9iAS forms and reports using VFB

Hi,

I am trying to get Oracle reports to run usning the VFB on hpux 11.11

I have installed the patch PHSS_30871

I have got VFB to start , please see my /etc/rc.config.d/xvfb

START_XVFB=1
USE_XHP=1

XINIT=/usr/contrib/bin/X11/xinit
XVFB_XINITRC=/etc/X11/xvfb.xinitrc

PERL=/usr/contrib/bin/perl
XVFB_DAEMON=/etc/X11/xvfb_daemon.pl

XHP=/usr/bin/X11/Xhp
XVFB=/usr/bin/X11/Xvfb

XVFB_USER="root"
XVFB_GROUP="root"
XVFB_DISPLAY=10
XVFB_MMAP="/var/X11/Xserver"
XVFB_ARGS="-screen 0 1024x768x8 -pn -fp /usr/lib/X11/fonts/misc -sp /etc/X11/SecurityPolicy "
XVFB_PIDFILE=/var/run/Xvfb_${XVFB_DISPLAY}.pid
XVFB_LOG=/var/X11/Xserver/logs/Xvfb_${XVFB_DISPLAY}.log

I took the atributes from Oracle Metalink.

VFB starts up ok , and the /var/X11/Xserver/log/xvfb10.log reports

access control disabled, clients can connect from any host


I have altered the oracle file $ORACLE_HOME/6iserver/server_reports to use DISPLAY:10.0

Oracle 9iAS is running the Forms and reports Server and the Apache over no SSL.

Any help greatly appreciated

Thanks


4 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle 9iAS forms and reports using VFB

You need to get a /etc/rc.config.d/xvfb from a working system, not one that metalink has that might not be with hpu-ux.

Please state your exact version numbers if 9ias etc and I'll try and find you one from a matching system.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Simon_139
Occasional Advisor

Re: Oracle 9iAS forms and reports using VFB

Hi,

The oracle versions are

Oracle Server Manager Release 3.0.6.0.0 - Production
Oracle9i Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production

Thanks
Steven E. Protter
Exalted Contributor

Re: Oracle 9iAS forms and reports using VFB

Attached is an xfvb file that worked with 9i 1.0.2.2 pl 12 and 9i rel 2 and briefly with 10G.

It may work, it may not. There are other examples that may work for you searchiing itrc.

back up your original.
/sbin/init.d/xvfb stop
# deploy the copy
/sbin/init.d/xvfb start

This may require tweaking with Oracle support.

Check the log files for the httpd server but I think you are probably getting REP-3000 errors when you run reports.

See attachment

SEP

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Simon_139
Occasional Advisor

Re: Oracle 9iAS forms and reports using VFB

Hi,

I did some investigation, and with my Friend Andy Hancock , we discovered that to make this work you need the MWM running.

the attached TAR contains everything to make this work for me.

Hope it helps someone else

Thanks