Re: Installing Oracle 8i on Linux

Bhavin Shah wrote:

> I had a similar problem with the dbstart script w/ 8.1.6.
> I added one line setting the version which seemed to
> do the trick.
>
> When running dbstart, you should see messages like
> database mounted, etc...
>
> <snip from dbstart script>
>
> # Figure out if this is a V5, V6, or V7 database. Do we really need
> V5?
> if [ -f $ORACLE_HOME/bin/sqldba ] ; then
> VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
> /SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
> print V[1]}'`
> else
> if test -f $ORACLE_HOME/bin/svrmgrl; then
> VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
> /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
> print substr($3,1,3)}'`
> else
> VERSION="8.2"
> fi
> fi
> ################################################
> VERSION=8.1
> ################################################
> STATUS=1
> if [ "$VERSION" = "8.1" ]
> then
> pmon=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
> if [ "$pmon" != "" ];
> then
> STATUS="-1"
> echo "Database \"${ORACLE_SID}\" already started."
> fi
>
> On Sat, 2 Sep 2000, Wouter Verhelst wrote:
>
> > In article <6NNr5.37576$DJ4.327710_at_afrodite.telenet-ops.be>,
> > wouter_at_rock.dezevensprong.local (Wouter Verhelst) writes:
> > > Hello
> > >
> > > If this is not the right newsgroup, please point me to the right
> > > direction. thanks.
> > >
> >
> > <installation problems>
> >
> > OK, this seemed to be an RTFM-issue :-)
> >
> > I read the docs and did it again, this time by the book. Now, I can
> > start sqlplus, but when I do so, I get a prompt for username and
> > password. So, I tried to log on as SYSTEM/manager, but I got 'ORACLE
> > not available'.
> > Like the manual told me to do, I edited /etc/oratab, changing the N of
> > my instance to a Y, then ran dbstart, but I still get that message. I
> > ran 'lsnrctl status', which told me everything was A-OK (at least I
> > think it did; look down for the output).
> > The docs also told me to check whether the file tnsnames.ora can be
> > found. It can; it is in $ORACLE_HOME/network/admin/, the default
> > location.
> > still, I get this message, and lose any clue. Can anyone tell me what
> > I forgot?
> > Output of lsnrctl status:
> > -----------cut--------------
> > LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 02-SEP-2000 02:01:51
> >
> > (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
> >
> > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> > STATUS of the LISTENER
> > ------------------------
> > Alias LISTENER
> > Version TNSLSNR for Linux: Version 8.1.6.0.0 - Production
> > Start Date 02-SEP-2000 01:49:59
> > Uptime 0 days 0 hr. 11 min. 52 sec
> > Trace Level off
> > Security OFF
> > SNMP OFF
> > Listener Parameter File /usr/local/OraHome1/network/admin/listener.ora
> > Listener Log File /usr/local/OraHome1/network/log/listener.log
> > Services Summary...
> > PLSExtProc has 1 service handler(s)
> > rock has 1 service handler(s)
> > The command completed successfully
> > -----------cut--------------
> >
> > If anyone could help me out, I'd be really grateful.
> >
> > --
> > 1:54am up 2:49, 3 users, load average: 0.02, 0.14, 0.19
> >
> > Voor een vertaling van Documentation/Configure.help naar het Nederlands:
> > http://users.pandora.be/wouter.verhelst/configure.html
> >
> > One thing about the past.
> > It's likely to last.
> > -- Ogden Nash
> >

It is difficult to understand how Oracle can release a script like this. It is looking for a line containing "PL/SQL" and the version, but 8.1.6 doesn't mention PL/SQL anymore, the script should be looking for a line containing JServer and the version. If 8.1.6 is all you have (not that that is not enough), you could replace the entire script by

svrmgrl << -OEF-
connect internal
shutdown
-OEF- Received on Sat Sep 02 2000 - 08:06:32 CDT