Re: Oracle Administration

From: Novice <zacNOzaSPAM_at_agorics.com.invalid>
Date: Mon, 24 Jan 2000 17:56:40 +1600
Message-ID: <004405ec.eddd47ef@usw-ex0109-066.remarq.com>

When I shutdown normal It tries to shutdown an instance called sar1. sar1 is not started. What does it indicate? So I followed the step you sugested and did startup nomount. It then started sar1 and not sar3. Why is it starting sar1 and not sar3. I have specified N in the last field for sar1 in the oratab file. I am sorry if I'm talking like a Novice. I am. The database was administered previously by somebody who left and I am left with figuring out what is wrong.

Here is the transcript.

SVRMGR> startup nomount
ORACLE instance started.

Total System Global Area                          4873744
bytes
Fixed Size                                          48656
bytes
Variable Size                                     4333568
bytes
Database Buffers                                   409600
bytes
Redo Buffers                                        81920

bytes

SVRMGR> show all

Instance                        local
Spool                           OFF
Timing                          OFF
Termout                         ON
Echo                            OFF
Stoponerror                     OFF
Autorecovery                    OFF
Logsource                       <default>
Maxdata                         20480
Numwidth                        10
Charwidth                       80
Longwidth                       80
Datewidth                       9
Labwidth                        32
Compatibility                   NATIVE
Retries                         infinite
Server Output                   OFF
Autoprint                       OFF
Fetchrows                       infinite
Appinfo                         OFF (USERTEXT : Oracle

Server Manager)

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Sun Jan 23 2000 - 19:56:40 CST