DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Oracle Report Server

  1. #1
    Join Date
    May 2005
    Posts
    129

    Oracle Report Server

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Quote Originally Posted by roadwarriorDBA
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2005
    Posts
    129

    Thumbs up

    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.


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by roadwarriorDBA
    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.
    Jeff Hunter

  5. #5
    Join Date
    May 2005
    Posts
    129
    Quote Originally Posted by marist89
    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.

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Make sure you are running the sqlplus from the correct home ie the infrastructure home where the database is installed.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    May 2005
    Posts
    129
    Quote Originally Posted by adewri
    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.

  8. #8
    Join Date
    May 2005
    Posts
    129
    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

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    did you install the patches that are requird for redhat 3 before hand? (patch 3006854) as listed in the requirements

  10. #10
    Join Date
    May 2005
    Posts
    129
    Quote Originally Posted by davey23uk
    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.
    Last edited by roadwarriorDBA; 07-28-2005 at 05:33 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width