Oracle 8.1.7 on Suse 7.2

Hi People anyone having problems with their installation of Oracle 8i on Suse pay heed and download JRE from www.blackdown.org.

Thanks Jared all my problems have disappeared !

Gavin

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, December 15, 2001 10:25 PM

>
> Don't know about 7.2. but on 7.1 I installed the Java
> from www.blackdown.org and it took care of the problems
> I had with java.
>
> Before doing that though, just try 'unset NLS_LANG' before
> running the java stuff.
>
> See metalink for details.
>
> Jared
>
> On Saturday 15 December 2001 06:25, Gavin D'mello wrote:
> > Hi I am facing a problem on Suse 7.2 and would be grateful if anyone
could
> > help me out ....
> >
> > I am installing Oracle 8.1.7 on Suse Linux 7.2, however the JRE in this
> > bundle does not seem to work. SO before installation I changed the
default
> > JRE_DIR in oraparam.ini to /usr/lib/jdk1.1.8 ( my local jdk
installation).
> > The install ran smooth. However while doing a typical install Dbassist
> > fails to load throwing errors like
> > SIGSEGV received at bfffd530 in
> > /u01/app/prodcut/oracle/jre/1.1.8/lib/linux/native_threads/libjava
Process
> > terminated
> > dbassist line 103 : 10469 Segmentation Fault
> >
> > $JRE_EXEC -Duser.dir=USER_DIR -classpath $CLASSPATH DBCreateWizard
> > $ARGUMENTS .....
> >
> > Thank You,
> >
> > Gavin
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Saturday, December 15, 2001 5:25 PM
> >
> > > This is not outdated -- the Oracle queries against the data dictionary
> > > tables are tuned for RULE and so analyzing the SYS tables wreaks havoc
> > > in the database.
> > >
> > > --- Amar Kumar Padhi <TS2017_at_emirates.com> wrote:
> > > > My information on this may be a bit outdated. I had read it
somewhere
> > > > that
> > > > statistics are not to be generated for SYS tables. Oracle will
handle
> > > > the
> > > > dictionary information access, irrespective of the optimizer mode
> > > > being
> > > > used. The setting of the optimizer_mode should affect the
application
> > > > queries being generated for other schemas. So if you are using CBO,
> > > > setting
> > > > the Optimizer_mode to first_rows looks more applicable than doing an
> > > > alter
> > > > session every time. I am not able to comment on the poor performance
> > > > when
> > > > accessing the dict.
> > > >
> > > > rgds
> > > > amar
> > > >
> > > > -----Original Message-----
> > > > Sent: Friday, December 14, 2001 11:00 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > FYI,
> > > >
> > > > I just logged a call with Oracle re. Designer 6.0 vs.
> > > > all_cons_columns.
> > > >
> > > > A developer noticed that whenever he queries that data dictionary
> > > > table as
> > > > part of generating database from server models, the process slows
> > > > down to a
> > > > crawl.
> > > >
> > > > If the target doesn't have any constraints, no problem.
> > > >
> > > > I am starting to wonder if it isn't because FIRST_ROWS was specified
> > > > on this
> > > > database, most of the developers are developing forms (6i) so I set
> > > > the
> > > > init.ora parameter accordingly.
> > > >
> > > > The Oracle documentation however implies that the CBO only switches
> > > > to rule
> > > > when there are no stats if optimizer_mode had been set to CHOOSE, if
> > > > it's
> > > > either ALL_ROWS or FIRST_ROWS it tries to use the CBO against the
> > > > data
> > > > dictionary anyway. How the CBO can run when there are no stats
> > > > probably
> > > > means it defaults to full table scans (?).
> > > >
> > > > OPTIMIZER_MODE = { all_rows | first_rows | rule | choose }
> > > >
> > > > The OPTIMIZER_MODE parameter specifies the approach and mode of the
> > > > optimizer for your session.
> > > >
> > > >
> > > > See Also: Oracle8i Concepts <../../server.817/a76965/toc.htm> and
> > > > Oracle8i
> > > > Performance Guide and Reference <../../server.817/a76992/toc.htm>
> > > > for
> > > > information on how to choose a goal for the cost-based approach
based
> > > > on the
> > > > characteristics of your application
> > > >
> > > >
> > > >
> > > > * all_rows specifies the cost-based approach and optimizes for best
> > > > throughput.
> > > > * first_rows specifies the cost-based approach and optimizes for
best
> > > > response time.
> > > > * rule specifies the rule-based approach. (The rule-based optimizer
> > > > does not use function-based indexes.)
> > > > * choose causes the optimizer to choose an optimization approach
> > > > based
> > > > on the presence of statistics in the data dictionary.
> > > >
> > > > Is this correct? If so, then I suppose I should set the init.ora
> > > > parameter
> > > > back to optimizer_mode=choose, and tell each developer to put an
> > > > alter
> > > > session statement on their clients to alter their sessions
> > > > automatically to
> > > > first_rows. The developer using designer will then be able to run
it
> > > > in a
> > > > timely manner.
> > > >
> > > > Please tell me if my suspicion is correct.
> > > >
> > > > If correct, it begs the question: why are first_rows and all_rows
> > > > available
> > > > for the init.ora file???
> > > >
> > > > Regards,
> > > > Patrice Boivin
> > > > Systems Analyst (Oracle Certified DBA)
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Boivin, Patrice J
> > > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> > > > Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Check out Yahoo! Shopping and Yahoo! Auctions for all of
> > > your unique holiday gifts! Buy at http://shopping.yahoo.com
> > > or bid at http://auctions.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Rachel Carmichael
> > > INET: wisernet100_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gavin D'mello
  INET: gavin_d_at_tis.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).