Linux-Misc Digest #772, Volume #20 Thu, 24 Jun 99 15:13:18 EDT
Contents:
Re: Help installing Oracle 8.0.5 on Linux RedHat 6.0 (Raymonds Doetjes)
Re: cron output to screen?? (John McKown)
Re: Cobol compiler sources ("Russell Styles")
Re: Software for making pie and bar charts wanted (Raymonds Doetjes)
----------------------------------------------------------------------------
From: Raymonds Doetjes <[EMAIL PROTECTED]>
Subject: Re: Help installing Oracle 8.0.5 on Linux RedHat 6.0
Date: Sat, 19 Jun 1999 09:53:19 +0200
This is a multi-part message in MIME format.
==============D079271ADB1BA0E2D6EB4393
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Well I got sofar that Oracle runs on RH 6.0. I only don;'t know the
default dba password so prehaps we can trade info ;-)
I have a website attached on this email with the details.
Be sure to download de glibcpatch.tgz from the http://technet.oracle.com
And install all the RedHat/RPMS/compat-*
Then it wil work
Raymond
DIederik de Roos wrote:
> Hi,
>
> How do I instal Oracle 8.0.5 on Linux RedHat 6.0?
>
> I understand that the problem is with glibc-2.1.1-6...? How can get
> Oracle to Compile/link with glibc-2.0.6? I do not want to install
> RedHat 5.2 to get Oracle running.
>
> help would be appreciated.
>
> |)iederiok
==============D079271ADB1BA0E2D6EB4393
Content-Type: text/html; charset=us-ascii;
name="rh6x.html"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="rh6x.html"
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Tom Bissett">
<meta name="GENERATOR" content="Mozilla/4.51C-Caldera [en] (X11; I; Linux 2.2.9
i686) [Netscape]">
<meta name="Description" content="Step-by-step process for installing Oracle on
RedHat Linux">
<title>RedHat 6.0/Oracle install process</title>
</head>
<body text="#000000" bgcolor="#FFFFFF" link="#0000EE" vlink="#551A8B" alink="#FF0000">
<table COLS=1 WIDTH="600" >
<tr>
<td><b><font face="Arial,Helvetica"><font color="#990000"><font size=+4>RedHat
6.0</font></font></font></b>
<br><b><font face="Arial,Helvetica"><font color="#990000"><font size=+3>Step-by-step
Install notes for Oracle 8.0.5</font></font></font></b>
<p><b><font face="Arial,Helvetica"><font color="#000000"><font size=+2>IMPORTANT!
NOTES ABOUT REDHAT 6.0</font></font></font></b>
<br><font color="#000000">RedHat 6.0 is using a new version glibc, <b>and
this new version doesn't agree with Oracle too well.</b> Some of the symptoms
of installing on RedHat 6.0 are:</font>
<ul>
<li>
<font color="#000000">Installation fails if you try to create database
objects during install.</font></li>
<li>
<font color="#000000">Oracle binaries, such as SVRMGRL and SQLPLUS, core
dump when you run them.</font></li>
</ul>
<b><font color="#000000">Oracle recently posted the glibcpatch.tgz file,
which will patch and relink your binaries so that they work on RedHat 6.0.
This "fix" also involves using four compatibility RPMs from RedHat (they
are provided on the RH 6.0 CD), so it's not necessarily the best solution
since it doesn't use the new glibc. Unfortunately, it's the only solution
right now.</font></b><b><font color="#000000"></font></b>
<p><b><font color="#000000">This document explains how to install Oracle
in the RedHat 6.0 environment.</font></b>
<p><b><font face="Arial,Helvetica"><font color="#000000"><font size=+2>The
machine I used to install Oracle</font></font></font></b>
<br> I installed it on a more powerful system for our business, but
the lowest machine I installed was a Pentium 166, 32 megs RAM, 1.6 gig
HD. The install on the 166 takes a while, more than three hours using this
method.
<p><b><font face="Arial,Helvetica"><font size=+2>Sections in this doc</font></font></b>
<br><b>There are four:</b>
<br><b><a href="#rhinstall">RedHat initial install -</a> </b>Covers what
is needed at minimum to install with RedHat 5.2, plus memory parameters
recommended by Oracle and why you shouldn't use them.
<br><b><a href="#preinstall">Oracle pre-install -</a></b> Setting up your
users, groups, mount points and environment variables.
<br><b><a href="#orainstall">Oracle install -</a> </b>Where you actually
install the software.
<br><b><a href="#oracledocs">Oracle Documentation install -</a></b> Needs
to be a separate process due to a bug.
<br><b><a href="#binpatch">Patching the binaries -</a></b> Needed to keep
them from core-dumping.
<br><b><a href="#postinstall">Oracle post-install -</a></b> Clean-up tasks
and testing.
<br><b>I make no guarantees that the installation will work if you decide
to just use part of these instructions vs. the whole thing.</b>
<p><b><font face="Arial,Helvetica"><font size=+2>Editorial comment about
this document</font></font></b>
<br>There's always more than one way to do this sort of thing. This is
what worked for me. I'm not necessarily a Linux guru, so some of you may
see something and question what I was thinking. But hey, it works, so grab
what you can from this document, and have a good laugh when you think I'm
nuts. When you're done laughing, drop a note to me, <a
href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>,
and (kindly) let me know where I'm nuts.
<p><b><font face="Arial,Helvetica"><font size=+2>Why use Redhat?</font></font></b>
<br>Oracle used RedHat when they ported the server to Linux and from all
I have heard, will continue to use RedHat when developing. It will be the
least hassle to install.
<p>
<hr NOSHADE WIDTH="100%">
<p><a NAME="rhinstall"></a><b><font face="Arial,Helvetica"><font color="#CC0000"><font
size=+2>Redhat
Initial Install</font></font></font></b>
<br>1) Select <b>Custom Install</b>
<p>2) Make swap partitions (max. 128 mb ea.) equivalent to <b>three times
RAM installed.</b>
<p>3) <b>Partition the drive</b> to your preferences. I ignored the OFA-compliance
and just made one mount point (/u01). You can also fake OFA by making four
directories, but you won't gain any performance from this. You'll gain
some performance by creating four distinct partitions (/u01, /u02, /u03,
/u04) and you'll gain the most performance by having each of these mount
points on four distinct drives, as Oracle recommends.
<p>4) <b>AT MINIMUM,</b> the <b>C Development</b> package must be installed.
You can add others to suit your needs.
<p>5) After the install is completed, make a /cdrom directory (or can use
the one defined in etc/fstab, which is /mnt/cdrom). This is where we'll
mount the CD.
<ul>
<li>
<b>mkdir /cdrom</b></li>
<li>
<b>chmod 777 /cdrom</b></li>
</ul>
6) If you have the RedHat 6.0 CD, Mount it and change to the /RedHat/RPMS
directory. Then, go to step 8. If you downloaded the RPMs go to step 7:
<ul>
<li>
<b>mount -t iso9660 /dev/cdrom /cdrom</b></li>
<li>
<b>cd /cdrom/RedHat/RPMS</b></li>
</ul>
7) Change into the directory where you placed your compatibility RPMs:
<p>8) The first thing is to install a couple of RPMs:
<ul>
<li>
<b>rpm -ivh kernel-source-2.0.36-0.7.i386.rpm. </b>This is the kernel source,
so that we can recompile the kernel for new memory parameters. More on
that later.</li>
<li>
<b>rpm -ivh tcl-8.0.3-20.i386.rpm </b>This is <b>ONLY</b> if you want to
install the Intelligent Agent, which offers minimal extra capabilities.
The agent itself is very buggy right now, and really doesn't add a lot
to Oracle, so installing it may be more trouble than it's worth.</li>
</ul>
9) Change out of the cdrom directory and unmount the RedHat CD:
<ul>
<li>
<b>cd /</b></li>
<li>
<b>umount /cdrom</b></li>
</ul>
<b><font face="Arial,Helvetica"><font size=+2>Kernel memory params</font></font></b>
<br>The front of the Oracle installation manual lists some memory parameters
which, according to the Oracle install manual, need to be changed before
installing the software. <b>On RedHat 6.0, Oracle will install and run
without reconfiguring the kernel.</b> These new values are just recommendations.
<b>Should you decided to change these parameters, the only parameter you
really need to worry about in RH 6.0 is the SHMMAX.</b> However, if you
set the SHMMAX to what Oracle says, you are telling the system to allow
a shared memory segment to grow as large as 4 Gigs. <b>Many users have
reported problems setting the value this high.</b> Furthermore, if you
only have 32 megs RAM, what's the point? The Redhat 6.0 default setting
for SHMMAX is 32 megs, by the way, so if you have more RAM, you may want
to change these settings. Here's how I did it:
<p><b><font face="Arial,Helvetica">WARNING!</font></b>
<br>Changing the kernel parameters requires recompiling the Linux kernel.
If you have never done this, I highly recommend you get a good book that
walks you through the process and all the 100+ different options when you
run the configure script. If you aren't sure of some of them, choosing
the wrong one may prevent you from booting your system!
<p><b><font face="Arial,Helvetica">Changing memory params</font></b>
<br>1) Change to the directory listed below and edit the shmparam.h file.
<ul>
<li>
<b>cd /usr/src/linux/include/asm</b></li>
<li>
<b>vi shmparam.h</b></li>
</ul>
2) A little further down is a line that says "#define SHMMAX 0x2000000."
The 0x2000000 is hex for 32 megs. Change it to a value that suits you.
I've bumped it up to 0x8000000, which is 134217728, or slightly above the
128 megs RAM I have installed.
<br>Other values:
<br>0x4000000 = 67108854
<br>0x6000000 = 100663296
<p>3) Save the file.
<p>4) You're now ready to proceed with the process of recompiling the kernel.
Recompile it, then continue below.
<p>
<hr NOSHADE WIDTH="100%">
<p><a NAME="preinstall"></a><b><font face="Arial,Helvetica"><font
color="#990000"><font size=+2>Oracle
Pre-Install</font></font></font></b>
<br><b>Before you can install Oracle on a RedHat 6.0 system, you must add
five compatibility packages to make Oracle work. You will also need to
download a patch.</b>
<p>1) If you have the Redhat 6.0 CD the packages listed below are in your
RedHat/RPMS directory. If you do not have the RPMs on your installation,
you'll need to download them from ftp.redhat.com, or one of it's mirrors.
<p><b>Mount your CD as root or download the appropriate packages. Install
them by using the following commands in the order listed below:</b>
<li>
<b>mount -t iso9660/dev/cdrom /cdrom </b>(ignore this if you downloaded
them)</li>
<li>
<b>cd /cdrom/RedHat/RPMS </b>(substitute with your directory if not RH6.0)</li>
<li>
<b>rpm -ivh compat-binutils-5.2-2.9.1.0.23.1.i386.rpm</b></li>
<li>
<b>rpm -ivh compat-glibc-5.2-2.0.7.1.i386.rpm</b></li>
<li>
<b>rpm -ivh compat-egcs-5.2-1.0.3a.1.i386.rpm</b></li>
<li>
<b>rpm -ivh compat-egcs-c++-5.2-1.0.3a.1.i386.rpm</b></li>
<li>
<b>rpm -ivh compat-libs-5.2-1.i386.rpm</b></li>
<li>
<b>cd /</b></li>
<li>
<b>umount /cdrom</b></li>
<p><br>2) Edit /etc/passwd. Change Root's shell from /bin/bash to /bin/sh
(you can change it back after the install is complete. Changing this to
/bin/sh just seems to make the various Oracle shell scripts work better).
<p>3) Log out, then back in as root.
<p>4) Create your groups
<ul>
<li>
<b>groupadd -g 101(or whatever ID you choose) dba</b></li>
<li>
<b>groupadd -g 102 (or whatever ID you choose) oper (this is an optional
group).</b></li>
</ul>
5) Create the oracle user
<ul>
<li>
<b>useradd oracle -g 101 (sub number with dba group number from above)</b></li>
<li>
<b>passwd oracle (to change password)</b></li>
</ul>
6) Edit /etc/passwd. Change Oracle's shell from /bin/bash to /bin/sh.
<p>7) If you didn't make mount points with disk partitioning, make a directory
for oracle, such as /u01.
<ul>
<li>
<b>mkdir /u01. </b>(You can also fake the OFA-compliancy by mkdir /u01,
/u02, /u03 and /u04.</li>
</ul>
8) Change owner and group permissions on these mount points.
<ul>
<li>
<b>chown -R oracle.dba /u01 </b>(run same command for /u02, /u03 and /u04
if you have them)</li>
</ul>
9) Mount the Oracle Server CD:
<ul>
<li>
<b>mount -t iso9660 /dev/cdrom /cdrom </b>(sub w/ your CD device locator).</li>
</ul>
10) Change to oracle CD and orainst directory, define a quick variable
for ORACLE_OWNER, which should be oracle, then run the oratab script.
<ul>
<li>
<b>cd /cdrom/orainst</b></li>
<li>
<b>ORACLE_OWNER=oracle; export ORACLE_OWNER</b></li>
<li>
<b>sh oratab.sh (accept defaults for prompts).</b></li>
</ul>
11) Log out.
<p>12) Log in as oracle.
<p>13)<b> At this point, you will need to download glibcpatch.tgz, </b>which
is available from <a
href="http://technet.oracle.com">technet.oracle.com.</a><b>Registration
is free for technet.</b> This is a patch that will relink the binaries
so that they work.<b> If you are already a member of technet.oracle.com,
</b><a href="http://technet.oracle.com/tech/linux/info/devlic.htm">you
can go straight to the download pages by clicking on this link.</a> Download
the patch into an<b> orapatch </b>subdirectory in oracle's home directory.
<p>14) Verify umask is 022 by typing umask [enter]. If it is, great. If
not, you'll need to put it in .profile, which we create in the next step.
<p>15) Use you favorite editor to create a .profile in your oracle account
home directory. Put the following in the file (sub your value for oracle
base directory):
<ul>
<li>
<b>ORACLE_HOME=/u01/app/oracle/product/8.0.5; export ORACLE_HOME</b></li>
<li>
<b>LD_LIBRARY_PATH=/u01/app/oracle/product/8.0.5/lib; export LD_LIBRARY_PATH</b></li>
<li>
<b>ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE</b></li>
<li>
<b>ORACLE_SID=ORCL; export ORACLE_SID</b></li>
<li>
<b>ORACLE_TERM=386; export ORACLE_TERM (this is for Intel PCs, use appropriate
value if on different platform)</b></li>
<li>
<b>PATH=$PATH:/u01/app/oracle/product/8.0.5/bin; export PATH</b></li>
<li>
<b>TMPDIR=/var/tmp; export TMPDIR</b></li>
<li>
<b>(optional) umask 022 (only if umask does not default to 022)</b></li>
</ul>
16) Log out, then back in as oracle. Type env to see if all the above variables
now appear in your environment.
<p>17) Also make sure all the following paths are in your path statement,
in addition to the Oracle path you specified above: /bin, /usr/bin,
/usr/local/bin.
<p>
<hr NOSHADE WIDTH="100%">
<p><a NAME="orainstall"></a><b><font face="Arial,Helvetica"><font
color="#990000"><font size=+2>Oracle
Install</font></font></font></b>
<br>1) Change to the Oracle install directory
<ul>
<li>
<b>cd /cdrom/orainst</b></li>
</ul>
2) Start the installer
<ul>
<li>
<b>./orainst /c</b></li>
</ul>
3) Choose Custom Install (this let's you create all your passwords ahead
of time, which is convenient).
<p>4) Choose OK to get through the README's.
<p>5) Choose <b>Install, Upgrade or De-install software.</b>
<p>6) Choose <b>Install new product- DO NOT Create DB objects. It
is important that you don't create the database now!</b>
<p>7) Verify your <b>ORACLE_HOME</b> and <b>ORACLE_BASE</b> are correct.
<p>8) Accept the defaults for log files.
<p>9) Choose Install from CD-ROM.
<p>10) Select your appropriate language.
<p>11) The Installer then tells you where the root.sh script will end up.
Hit OK.
<p>12) When you get to the Install options menu, select what you want EXCEPT:
<ul>
<li>
<b>Do not pick Oracle 8.0.5 documentation here. There is a bug in it which
will crash your install process. </b>Luckily, there is a fix, which we
will be apply after the initial install. Just trust me on this one.</li>
<li>
<b>Do not pick JDBC drivers </b>unless you defined a path to your classesxxx.zip
file.</li>
<li>
<b>Do not pick Intelligent agent </b>unless you installed the TCL rpm package
above.</li>
</ul>
13) Hit the install button.
<p>14) Hit Ok at the <b>ULIMIT</b> message. You don't need to worry about
this.
<p>15) Select <b>dba</b> as your dba group.
<p>16) If you specified a different group for operators (oper), enter it
at the OSOPER prompt. Otherwise, accept the default.
<p>17) If you did enter a different group, the installer will tell you
programs will need to be relinked. Just hit OK.
<p>18) <b>At this point, the installer actually begins copying software!</b>
<br>The install process will take a long time on slower machines. Taking
multiple hours is not out of the question. Just be patient.
<p>19) If you get a message that says, "<b>The requested action has been
performed for selected products,"</b> You're in luck. Hit OK. You should
return to the main install screen.
<p>20) Select <b>Exit</b> and then yes at the confirmation.
<p>21) <b>If you do not get the above message, even though the installer
acts like everything was installed correctly, I'll bet it wasn't. Just
a note from experience.</b>
<p>22) You should see a line after exiting that says <b>Result: Success.</b>
Congratulations. This means your software installed successfully. Before
you can use it, though, you might want to do the Oracle Docs below, and
<b>you
must do a few more steps.</b>
<p>
<hr NOSHADE WIDTH="100%">
<p><a NAME="oracledocs"></a><b><font face="Arial,Helvetica"><font
color="#990000"><font size=+2>Oracle
Documentation install</font></font></font></b>
<br><b>Why we have to do this separately:</b> The Oracle install process
tries to install one of the doc files in a <b>non-existent directory</b>
(must be a typo in the install script). This error hangs the above install
process if you try to install the docs along with everything else. Thanks
to the kind help of <a href="mailto:[EMAIL PROTECTED]">Ben Drasin,</a>
here is a way to get the docs installed in their proper place:
<p>1) First we make the Oracle doc directory ahead of time.
<ul>
<li>
<b>mkdir /u01/app/oracle/doc</b></li>
</ul>
2) Then we make a link between two directories. This link will help to
correct the pathname for that one bad file.
<ul>
<li>
<b>ln -s /u01/app/oracle/doc /u01/app/oracle/product/8.0.5</b></li>
</ul>
3) Now, we're going to run the installer from the CD again.
<ul>
<li>
<b>./orainst /c</b></li>
</ul>
4) Select <b>Custom Install.</b>
<p>5) Hit <b>OK</b> at the next <b>two</b> prompts.
<p>6) Select <b>Install, Upgrade, or De-Install software.</b>
<p>7) Select <b>Add/Upgrade software.</b>
<p>8) Accept the default for <b>ORACLE_HOME.</b>
<p>9) Accept the log defaults.
<p>10) Select <b>Install from CD-ROM.</b>
<p>11) Select your language.
<p>12) The installer will now tell you that root.sh already exists. Since
we have not run it yet, we want to <b>append to our existing root.sh,</b>
so select <b>Append.</b>
<p>13) Hit <b>Ok</b> at the "Post-Installation..." message.
<p>14) You are now at the familiar Install screen. Select <b>Oracle Server
Release 8.0.5 Documentation.</b>
<p>15) Hit <b>Install.</b>
<p>16) Accept the pathname for <b>ORACLE_DOC.</b>
<p>17) Select which format you want for the documentation.
<p>18) You should then get a window saying the selected action has been
performed. Hit <b>OK.</b>
<p>19) Hit <b>OK</b> and you'll (hopefully) get the Result: success line.
<p>Now we can proceed with all the Post-install stuff.
<p>
<hr NOSHADE WIDTH="100%"><b><font face="Arial,Helvetica"><font
color="#990000"></font></font></b>
<p><a NAME="binpatch"></a><b><font face="Arial,Helvetica"><font color="#990000"><font
size=+2>Patching
your binaries</font></font></font></b>
<br><b>Unless you apply this patch, your binaries will core-dump when you
run them. Do NOT apply this patch until you have installed the software
above.</b>
<p>1) Change to the directory where you downloaded your patch.
<ul>
<li>
<b>cd ~/orapatch</b></li>
</ul>
2) Extract the patch.
<ul>
<li>
<b>tar -xvzf glibcpatch.tgz</b></li>
</ul>
3) Run the script.
<ul>
<li>
<b>sh glibcpatch.sh</b></li>
</ul>
<p><br>4) As with everything else, the wait could be an hour or more on
slower machines. When the script finishes, you will get a message saying
"Applied glibc patch for Oracle 8.0.5.x successfully."
<p>
<hr NOSHADE WIDTH="100%">
<p><b><font face="Arial,Helvetica"><font color="#990000"><font size=+2>Create
the DB objects</font></font></font></b>
<br><b>This is where we create the original database.</b>
<p>1) Change to the orainst directory on the CD-ROM.
<ul>
<li>
<b>cd /cdrom/orainst</b></li>
</ul>
2) Run the installer again.
<ul>
<li>
<b>./orainst /c</b></li>
</ul>
3) Select <b>Custom Install.</b>
<p>4) Hit <b>OK</b> to get through the two read me's.
<p>5) Select <b>Create/Upgrade Database objects.</b>
<p>6) At the next menu, select <b>Create Database Objects.</b>
<p>7) Verify <b>ORACLE_HOME</b> and <b>ORACLE_BASE</b> are correct, then
hit OK.
<p>8) Accept the defaults for the logfiles by hitting OK.
<p>9) Verify your <b>ORACLE_SID</b> is correct.
<p>10) You are now at the familiar Oracle install screen. <b>You must select
"Oracle 8 Standard RDBMS 8.0.5.0.0" for the database objects to be created.</b>
<p>11) Hit the <b>Install </b>button.
<p>12) Choose <b>Filesystem-based Database</b> regardless of whether you're
installing in a single mount point or multiple mount points.
<p>13) If you have a single mount point, when the installer asks you to
distribute control files over multiple mount points, hit no, and specify
your only mount point in the next window (exam: /u01). If you have multiple
mount points, hit yes and specify them in the next window.
<p>14) Select the appropriate <b>character set.</b>
<p>15) Select the appropriate <b>national character set.</b>
<p>16) Enter in you password for the <b>SYSTEM</b> account. Confirm it.
<p>17) Enter in your password for the <b>SYS</b> account. Confirm it.
<p>18) If you want an internal password for <b>dba</b> and <b>operator,</b>
you can choose yes at this prompt. Otherwise, hit no.
<p>19) Enter in a password for the <b>TNS listener.</b>
<p>20) Hit <b>No</b> if it asks to configure the MTS Listener.
<p>21) Accept the defaults for control files.
<p>22) Hit OK through the next two defaults screens.
<p>23) Finally, select Yes to accept those defaults.
<p>24) At this point the database creation process begins. On slower machines,
this process can also take more than an hour.
<p>25) If you get a message that says, "<b>The requested action has been
performed for selected products,"</b> You're in luck. Hit OK. You should
return to the main install screen.
<p>26) Select <b>Exit</b> and then yes at the confirmation.
<p>27) Proceed to the Post-Install tasks.
<p>
<hr NOSHADE WIDTH="100%">
<br><a NAME="postinstall"></a><b><font face="Arial,Helvetica"><font
color="#990000"><font size=+2>Oracle
post-install</font></font></font></b>
<br>1) Log out, then back in as root.
<p>2) Copy the oracle user's .profile to root's home directory.
<ul>
<li>
<b>cp /home/oracle/.profile /root/.profile</b></li>
</ul>
3) Log out, then back in as root.
<p>4) Run the root.sh script
<ul>
<li>
<b>cd $ORACLE_HOME/orainst</b></li>
<li>
<b>sh root.sh</b></li>
</ul>
5) Verify <b>ORACLE_OWNER, ORACLE_HOME, and ORACLE_SID</b> are correct,
then <b>hit Y.</b>
<p>6) When it asks for the full path name to your local bin directory,
enter /usr/local/bin.
<p>7) The script then tells you that ORACLE_HOME does not match the home
directory for oracle. You need not worry about this. Type a Y and continue.
The script will complete.
<p>8) Now, change to the admin directory, start SQLPLUS, and run the catrep.sql
script
<ul>
<li>
<b>cd $ORACLE_HOME/rdbms/admin</b></li>
<li>
<b>sqlplus</b></li>
<li>
<b>connect as sys (important that you connect as sys and NOT be logged
in as oracle). I have noticed a bug with the export edition: Sometimes,
it does not remember the password you typed in earlier in the install.
If it doesn't, the default password is change_on_install.</b></li>
<li>
<b>@catrep.sql (you will get a few minor errors, which are fine.</b></li>
<li>
<b>The end should say "Commit complete."</b></li>
<li>
<b>Quit.</b></li>
</ul>
9) Log out, then back in as oracle
<p>10) Stop the server:
<ul>
<li>
<b>svrmgrl</b></li>
<li>
<b>connect internal</b></li>
<li>
<b>shutdown</b></li>
<li>
<b>quit</b></li>
</ul>
<b><font face="Arial,Helvetica"><font size=+2>Modifying the
init(ORACLE_SID)file</font></font></b>
<br>After you shut down the Oracle server, it copies a file called
init(ORACLE_SID)_0.ora
to init(ORACLE_SID).ora. Example: If you set ORACLE_SID to ORCL, the file
names would be initORCL_0.ora and initORCL.ora.
<p>The file that has the "<b>_0.ora"</b> was a temporary file created by
oracle for the installation. The other file is the one you want to look
at. It is what Oracle uses to define its System Global Area. The file itself
is pretty self-explanatory. If you have a lot of RAM, consider commenting
out the entries marked "small" and uncommenting the lines marked "medium"
or "large." The default is "small."
<p><b><font face="Arial,Helvetica"><font size=+2>Changing the TNS Listener
permissions</font></font></b>
<br>The TNS listener is installed with improper permissions. Run the following
commands to become root and corect the permissions:
<ul>
<li>
<b>su root</b></li>
<li>
<b>[enter password]</b></li>
<li>
<b>chown oracle.dba $ORACLE_HOME/bin/tnslsnr</b></li>
<li>
<b>chmod 750 $ORACLE_HOME/bin/tnslsnr</b></li>
<li>
<b>chown oracle.dba $ORACLE_HOME/network/log</b></li>
<li>
<b>chmod 775 $ORACLE_HOME/network/log</b></li>
<li>
<b>chown root.dba $ORACLE_HOME/network/log/listener.log</b></li>
<li>
<b>chmod 664 $ORACLE_HOME/network/log/listener.log</b></li>
<li>
<b>exit (to leave root)</b></li>
</ul>
<p><br><b><font face="Arial,Helvetica"><font size=+2>Starting the Oracle
server and testing</font></font></b>
<br><b>Now comes the fun part.</b>
<br>1) If you aren't logged in as oracle, go ahead and log in.
<p>2) If you want to access the Oracle server with the GUI management tools
from another PC, you will need to start the TNS listener. The default config
works for most TCP/IP installations, but you may need to change it. It
worked for us.
<ul>
<li>
<b>lsnrctl start</b></li>
</ul>
3) Start Oracle server back up by connecting as internal.
<ul>
<li>
<b>svrmgrl</b></li>
<li>
<b>connect internal</b></li>
<li>
<b>startup</b></li>
<li>
<b>quit</b></li>
</ul>
4) <b>At this point, you should be able to create users, tablespaces, tables,
etc. Your Oracle database should be up and running.</b></td>
</tr>
<tr>
<td></td>
</tr>
</table>
</body>
</html>
==============D079271ADB1BA0E2D6EB4393==
------------------------------
From: [EMAIL PROTECTED] (John McKown)
Subject: Re: cron output to screen??
Date: 19 Jun 1999 07:39:43 GMT
On 18 Jun 1999 01:58:48 GMT, Sparkzz <[EMAIL PROTECTED]> wrote:
>Hello,
>
>How can I get a cron job to output to the screen, instead of either
>mail or a log??
>
>thanks,
>....Ken
Which screen? If the cron job is running as root, then you can reroute
the output to any tty by setting the cron entry similiar to
00 04 * * * /usr/local/bin/myprogram >/dev/tty1 2>&1
This will run /usr/local/bin/myprogram at 4am every day. It redirects
the output to /dev/tty1. On my system, this is the first virtual
terminal. This always works for root. The output will be displayed
on /dev/tty1 (virtual terminal 1) regardless of who is currently
logged onto the terminal. It will even work if no-one is logged on.
It will work for non-root if the uid which set up the crontab is logged
onto the virtual terminal at the time the command runs. Otherwise, it gets
a "permission denied" message.
------------------------------
From: "Russell Styles" <[EMAIL PROTECTED]>
Subject: Re: Cobol compiler sources
Date: Thu, 24 Jun 1999 12:36:06 -0400
In case anyone else is as dense as I was --
DOS/Win98 does not allow 2 periods in a file name.
rename *.tar to *.gz. and winzip will know how to handle these 2 files (If
you
go directly to the web site, he has a small update as well as the main
source code.
Now as to makeing it work ...
Rildo Pragana wrote in message ...
>-----BEGIN PGP SIGNED MESSAGE-----
>
>
>I have released a (historic) Cobol compiler that may be useful for someone
>trying to implement such language to another OS (Linux?!). It's written
mostly
>in C, with a few x86 assembler routines. Included there is a debugger in
prolog
>(Boralnd's Turbo Prolog(TM)).
>This compiler generates a code that does a simple non-preemptive
multitasking
>for MsDos(Microsoft, TM) and was designed for tying several microterminals
to a
>single PC, each one sharing the same code, but with separate data and stack
>segments.
>Grab the source at http://members.xoom.com/rpragana/rpcobol.tar.gz.
>Everything from now on is release under GPL. Enjoy!
>
>best regards,
>Rildo
> _____ _ __ __ __ __ ___ __ Rildo Pragana
>/\ '__`\/\`'__\/'__`\ /'_ `\ /'__`\ /' _ `\ /'__`\ P.O. Box 721
>\ \ \L\ \ \ \//\ \L\.\_/\ \L\ \/\ \L\.\_/\ \/\ \/\ \L\.\_ Camaragibe
> \ \ ,__/\ \_\\ \__/.\_\ \____ \ \__/.\_\ \_\ \_\ \__/.\_\ PE Brazil
> \ \ \/ \/_/ \/__/\/_/\/___L\ \/__/\/_/\/_/\/_/\/__/\/_/ 54792-990
> \ \_\ [EMAIL PROTECTED] /\____/ FPGA/uControllers * Linux * tcl/tk
> \/_/ +55-81-459-1776 \_/__/ http://members.xoom.com/rpragana/
>
>
>
------------------------------
From: Raymonds Doetjes <[EMAIL PROTECTED]>
Subject: Re: Software for making pie and bar charts wanted
Date: Thu, 24 Jun 1999 19:36:49 +0200
Perhaps GNU plot is of assistance for you guys. (I don't know about pie
chart but bar and lines deffinetly)!!!
Use the gplot2gif or something like that to make gifs out of gnuplots.
Raymond
Dirk Melcher wrote:
> Hi everybody,
>
> does anybody know of a package which can produce pie and bar charts? A
> special requirement is that these charts have to be produced
> non-interactively which means that they should be controled by
> something like a script or command paramters. Preferbly the output
> should be postscript and/or gif. Any hints would be greatly
> appreciated!
>
> Thanks,
>
> Dirk
>
> --
> ******************************************************************
> * Dr. Dirk Melcher email: [EMAIL PROTECTED] *
> * Lenschower Weg 2c Fax : 0451-4801-100 *
> * 23564 Luebeck Tel. : 0451-7073357 *
> ******************************************************************
------------------------------
** FOR YOUR REFERENCE **
The service address, to which questions about the list itself and requests
to be added to or deleted from it should be directed, is:
Internet: [EMAIL PROTECTED]
You can send mail to the entire list (and comp.os.linux.misc) via:
Internet: [EMAIL PROTECTED]
Linux may be obtained via one of these FTP sites:
ftp.funet.fi pub/Linux
tsx-11.mit.edu pub/linux
sunsite.unc.edu pub/Linux
End of Linux-Misc Digest
******************************
