Oracle Report Server

[roadwarriorDBA]

I have not used Oracle Forms/Reports in at least 5 years. It seems they have done away with this and you need the Oracle Reports Server.

So its all web based now eh?

Also can Reports do a simple dump to a comma delimited text file?

Thanks in advance.

[adewri]

So its all web based now eh?

Also can Reports do a simple dump to a comma delimited text file?

Thanks in advance.

Yes its browser based report now and you need a reports server.

The different formats available are RTF, PDF, XML, CSV, HTML, HTML CSS.

HTH

[roadwarriorDBA]

Thank you!

I love this site. Give me a couple months to come up to speed, get more experience and I will contribute instead of just reaping the benefits.

[marist89]

I love this site. Give me a couple months to come up to speed, get more experience and I will contribute instead of just reaping the benefits.

That's what they all say.

[roadwarriorDBA]

That's what they all say.

LOOOL! Its bad karma not to reciprocate. This is the job I wanted for the last 3 years, get back to all oracle all the time.

But there is rust so I wont be advising anyone until I get up to speed.

Installing Oracle Report server to and Oracle app server right now. Need to find the ias_admin Password and Confirm Password.

Going to have to ask the people who have been here longer than 3 days about that one.

I cannot sqlplus "/ as sysdba" to the apps server - Is this normal.

[adewri]

Make sure you are running the sqlplus from the correct home ie the infrastructure home where the database is installed.

[roadwarriorDBA]

Make sure you are running the sqlplus from the correct home ie the infrastructure home where the database is installed.

Your absolutely correct. The enviro vars were set to portal and when switched it worked as expected, I just got a nice 30 minute overview of the apps server / portal of which I have no experience.

So I am just about done copying reports over and will install to /portal and not /infra - I think I will first check and see if its already there, who knows.

[roadwarriorDBA]

Bummer..

[oracle@codc192 Disk1]$ ./runInstaller
***************************************************************
Please Refer to Quick Installation Guide and/or Metalink Notes
for Redhat 3.0 system setup.
Install and Configuration issues are expected if system is not
setup as per the guidelines before
Oracle Application Server 10g (9.0.4) installs.
Specifically, please ensure the following:
* Availability of gcc-3.2.3, setarch-1.3, pdksh-5.2,
openmotif21-2.1.30, sysstat-4.0.7, gnome-libs-1.4.1.2.90-34.1,
libstdc++-3.2.3, etc.
* Availability of Compat libraries:
compat-libstdc++-devel-7.3-2.96.122,
compat-glibc-7.x-2.2.4.32.5, etc.
* Patch for libcwait.so (Patch no. 3006854)
* Symbolic links for gcc/g++

Enter 'y' if the target system is configured as per the
guidelines specified in the Quick Installation Guide
Answer 'n' to exit runInstaller
Please retry after completing system setup.
***************************************************************
Is system configured correctly ? [y/n] (n)
y


cat: /etc/ld.so.preload: Permission denied
The file /etc/ld.so.preload does not contain /etc/libcwait.so. Please resolve
this problem by referring to the chapter Software Requirements for Red Hat 3.0
in the Quick Install Guide and restart the installer.
[oracle@codc192 Disk1]$ sudo su -
[root@codc192 root]# update
[root@codc192 root]# up2date -u


https://xmlrpc.rhn.redhat.com/XMLRPC

[root@codc192 root]#
[root@codc192 root]#
[root@codc192 root]# up2date -u
https://xmlrpc.rhn.redhat.com/XMLRPC

[root@codc192 root]# up2date
https://xmlrpc.rhn.redhat.com/XMLRPC

[davey23uk]

did you install the patches that are requird for redhat 3 before hand? (patch 3006854) as listed in the requirements

[roadwarriorDBA]

did you install the patches that are requird for redhat 3 before hand? (patch 3006854) as listed in the requirements

No I was sitting next to the unix admin, actually we are in the same cube for now and he was quite helpful, said it was all up to snuff and there is already Oracle portal on the box. Then I got the error and he tried that update process but it did not work. He bailed to the colocation facility and is now fighting other fires.

Wondering if I can get that patch and install it myself. I suppose it wont break whats already there, we have a room full of testers hammering this box.

I will go looking for the patch, weird thing is I cannot find forms/reports install guide for linux, just the one for Solaris. I assumed they put out the Solaris flavor and left the rest to us.