Re: starting oracle in unix

In article <8ioo5s$i57$1_at_plutonium.btinternet.com>,   "Chris.Read" <Chris.Read_at_btinternet.com> wrote:
> Does anyone know of any web pages pr faq's for fundamentals of oracle
 for
> unix system administrators, that covers basics like conecting to the
 db and
> what processes need to be running ?
>

Greetings, Chris,

1. You want to start reading the 'Oracle Concepts' manual - it's part of the basic documentation on the CD set. Other good books are the Oracle Press series - Oracle Beginner's Handbook, etc.
2. To start Oracle (HP-UX/AIX/Solaris), Korn shell assumed:

     export ORACLE_SID=name of database
     export ORACLE_HOME=path to database executables
      eg: /opt/oracle/product/8.1.6
     export PATH=$PATH:$ORACLE_HOME/bin:

     At the command prompt:

     svrmgrl

     You should see:

     Oracle Server Manager Release 3.1.6.0.0 - Production
     Copyright (c) 1997, 1999, Oracle Corporation  All Rights Reserved

     Oracle 8i Enterprise Edition Release 8.1.6.0.0 - Production
     With the Partitioning Option
     JServer Release 8.1.6.0.0. - Production

     SVRMGR>

    At the SVRMGR> prompt type:

    connect internal;
    startup;

    You should then see something like:

    Database mounted.
    Database opened.

    Total System Global Area                 xxxxxxxxxxxxxxxx bytes
    Fixed Size                               xxxxxxxxxxxxxxxx bytes
    Variable Size                            xxxxxxxxxxxxxxxx bytes
    Database Buffers                         xxxxxxxxxxxxxxxxx bytes
    Redo Buffers                             xxxxxxxxxxxxxxxxx bytes

    Where xxxxxxx = the numbers for your system.

   If you do a ps -ef | grep oracle, you should see at least five (5)    processes per instance - the SMON, PMON, LGWR, CKPT, RECO processes.

   If you're using SQL*Net, there will be Listener processes as well.

   This is the minimum and assumes that someone has installed Oracle    and configured the initsid.ora file (this is the parameter file    Oracle uses to determine the size and configuration of its memory    processes, basically)

   I guess you're also expected to function as the DBA? You should    have your manager send you to the Database Administration class -    it's five days, and gives you the foundations. Of course, if you're    in the situation most of us are in this industry, you'll be expected    to install and support Oracle with no training at all (I was an IBM    MVS IMS/DB2 DBA who couldn't spell UNIX when I first started 8 years    ago).

   Best wishes to you in your career.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 23 2000 - 00:00:00 CDT