Re: OAS408x installation

From: Verna Legaspi <vlegaspi_at_uswest.net>
Date: Mon, 21 Aug 2000 16:55:46 -0700
Message-ID: <Ukjo5.966$Ls3.257451_at_news.uswest.net>


> > I've got 4081 installed on both Solaris 2.6, 2.51 and Linux RedHat 6.2.
> > There's some things I'd like to note:
> > * The Solaris 2.6 install works - for the most part. We have some
 issues
> > with applications using both LiveHTML & PL/SQL cartridges.
>
> I tried to install the PL/SQL toolkit application. The OAS manager
> said it has such thing, but the applications said that it cannot
> be started up. Is it normal?
How does the OAS manager tell you that the PL/SQL Toolkit is already [Quoted] installed? I don't think there's a way to tell via the OAS Manager if the toolkit has been installed. I believe you have to look into the database for the presence of oas_public and websys users to make sure the toolkit has been installed.

> > * I haven't installed any of the "extras" such as the toolkit, logger
> > tables, etc on Solaris 2.6
>
> If there's no "extras" application/cartridge, how OAS be used? [Quoted]
Our implementation of OAS on Solaris 2.6 was an "upgrade" from OAS 3.x. We already have a database schema that holds all the PL/SQL Toolkit packages. This is why we did not need to install the PL/SQL Toolkit separately.

As far as I know, the logger tables, log analyzer, database browser, etc. are not needed for OAS to operate.

> > * I installed the toolkit on Solaris 2.51 - seems to work fine
>
> Same as the above, the red flag is normal? How to start it up?
> I tried to use 4082, the installation part for those toolkit/logger
> has few error, is it a cause to make it not work?
 The applications having a red flag (down) for status may be normal. If no [Quoted] [Quoted] one has used the application in a while, it will be taken down. It will [Quoted] become a green flag (up) when it's needed/called.

> The situation is that when I click the database browser:
> 1. It searches the xxx.mydomain.com (I supposed to have
 *.comp.hkbu.edu.hk)
> and when I mannally changed the domain in the URL, the OAS drags
> it down and logs wrb.log that the node's virtual memory is 0.
I don't know anything about the database browser.

> 2. It does on Redhat 6.2 and Solaris 7. Both OS have the (1) problem.
> Are there any missing, install PL/SQL toolkit, change PL/SQL parameter,
> install DAD, grant DBA privilege, install the rest of
 application/database
> browser.

[Quoted] I'm not quite sure what you're asking, here... but basically, the steps to getting OAS working using a PL/SQL cartridge is:

1.  Install Oracle DB
2.  Install OAS
3.  Install PL/SQL Toolkit - verify in DB that oas_public & websys users
have been created
4.  Create OAS application
5.  Create & configure PL/SQL cartridge within the application
6.  Create DAD for PL/SQL cartridge

Access stored procedures via:
http://hostname:port/plsqlcart_virtual_path/package.procedure

You shouldn't need to grant DBA privileges unless your application needs it.

HTH,
Verna Received on Tue Aug 22 2000 - 01:55:46 CEST

Original text of this message