Oracle 8 on Solaris question

From: kenneth long <klong66_at_yahoo.com>
Date: Mon, 06 Sep 1999 19:43:53 -0800
Message-ID: <4RdB3.1803$Zd.993651@WReNphoon3>

Here goes,
UTL_FILE_DIR=
is what is required for using the Oracle "utl_file" package. This is where the Oracle will be reading and writing from using the functions/procedures in utl_file package ( like a C open call ). Take a look at the documentation in the Oracle reference for more details.

The location of the PFILE is usually in a director similar to: /u00/oracle/admin/<SID>/pfile/
or check in $ORACLE_HOME/dbs for a softlinked pfile...

To stop oracle ( assuming multiple instances running and

                 Not an OPS system i.e. clustered)

logon as oracle.

export ORACLE_SID=<SID>
svrmgrl

> connect internal
> shutdown immediate ( stops the instance, but waits for

                           users to finish transactions )

> startup (if a pfile existed in $ORACLE_HOME/dbs )
> startup PFILE=<PATH to YOUR PFILE>
> exit

   -**** Posted from RemarQ, http://www.remarq.com/?a ****-  Search and Read Usenet Discussions in your Browser - FREE - Received on Mon Sep 06 1999 - 22:43:53 CDT