Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
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