Re: Oracle Administration

From: Novice <zacNOzaSPAM_at_agorics.com.invalid>
Date: Mon, 24 Jan 2000 18:17:38 +1600
Message-ID: <25edd503.f3552749@usw-ex0109-066.remarq.com>

Here is an UDATE:

Orcale server comes up normally when system boots. The instance sar3 comes up without any hiccup. Only problem is I cannot access it thru sqlplus although I am able to access sar3 from Sql Worksheet from a client PC.

When I use svrmgrl and try to shutdown the database manually it gives the error
ORA-01034: ORACLE not available

So I use dbshut. I then try to start the database using svrmgrl and this is what I get

SVRMGR> startup open sar3
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
ORA-01504: database name 'SAR3' does not match parameter db_name 'sar1'
SVRMGR>

• 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 - 20:17:38 CST