Re: 7.3.2 installation on Solaris 2.5 problem

Vladimir Stavitsky wrote:
>
> Hi, everybody;
> today i went through my second installation of Oracle 7.3.2
> on Solaris 2.5. My first installation was rather smooth, but
> it was on my own host which i control completely. This second
> installation was pretty rough.
>
> Finally we installed everything, and all stuff appears to be
> working. The only problem is an error message i get when i start
> sqlplus. This error does not prevent sqlplus from doing all the
> regular stuff correctly, but i am still worried if this thing is
> going to backfire later on. Here's this error message:
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-00900: invalid SQL statement
>
>
> Error accessing package DBMS_APPLICATION_INFO
> You may need to install the Oracle Procedural option
> SET APPINFO requires Oracle Server Release 7.2 or later
>
>
> Any advice will be greatly appreciated.
>
> I have couple more questions. I am a newly converted to Oracle
> Sybase DBA, so sorry if these are FAQ or something.
>
> 1. In this Oracle DBA Handbook their very first example of Oracle
> installation requires 12 disks. Later on they go up to 15 or close
> to that. Is this normal for Oracle? I used to run production mid-
> size Sybase on 4 disks and it was pretty happy.
>
> 2. There are 2 steps in Oracle Web Server configuration during Oracle
> installation; the first one creates a user, and the second one
> creates a listener. I do not understand why they need a listener if
> their web server is already running?
>
> Thanks a lot
>
> --
> ---------------------------------------------------------------------
> ... occurrences like this will be few and far between ...
>
> vlads_at_webvalue.com Vlad Stavitsky vlads_at_lvalue.com
> ---------------------------------------------------------------------

Remember to get 7.3.2.2 patch for that Solaris system. Version 7.3.2.1 does not work. As far as your disk questions, the more the better. You can run with less, but have at least enough to mirror critical files and don't complain about performance if you don't have enough disks to spread data and index tablespaces across different platters. Also, don't be like all those jerks out there who try and increase performance by buying faster and faster CPUs while not doing anything about your disk layout. It won't work, period. I can't say I've seen that specific error message you mention. Received on Thu Aug 15 1996 - 00:00:00 CEST