Perhaps you should connect to one database, make the changes, disconnect.
Then do it again for the second database.
<mpir_at_compuserve.com> wrote in message news:7n2h3e$54p$1_at_nnrp1.deja.com...
> I do not know what your 600 errors are, but you also have to do an
> 'alter system archivelog mode enable' (or similar) command to actually
> start the archiving, in addition to modifying the init file.
>
> In article <7n21is$tie$1_at_nnrp1.deja.com>,
> Tony Adolph <tony.adolph_at_viaginterkom.de> wrote:
> > Hello All,
> >
> > The followning extract has been cut and pasted from a svrmgr session.
> > The reason the databases are going up and down is to edit the pfiles
> to
> > start archiving. At no times during these changes is either the
> > listener stopped/started or the listener.ora or tnsnames.ora changed.
> > The ORACLE_SID in the registry is set to PINS (which is the same as
> the
> > alias in tnsnames.ora)
> >
> > Can anyone please eplain to me how on earth the listener (or some
> other
> > process "changes its mind")
> >
> > Oh yes there's an internal error which does seem to be start of the
> > "strangeness". This problem is not just a one off, I cannot
> > consistantly connect to database I expect to.
> >
> > Here's the extract....
> >
> > SVRMGR> connect internal_at_PINS
> > Password:
> > Connected to an idle instance.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 7505780 bytes
> > Fixed Size 35760 bytes
> > Variable Size 7052228 bytes
> > Database Buffers 409600 bytes
> > Redo Buffers 8192 bytes
> > Database mounted.
> > Database opened.
> > SVRMGR> select name, value from v$parameter where name ='db_name';
> > NAME VALUE
> >
> > ----------------------------------------------------------------
> > --------------
> > -----------------------------------------------------------------
> > db_name PINS
> >
> > 1 row selected.
> >
> > SVRMGR> select * from v$database;
> > NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
> > --------- -------------------- ------------ ---------- ----------
> > PINS 07/13/99 09:13:04 NOARCHIVELOG 7075 7008
> > 1 row selected.
> >
> > SVRMGR> connect internal_at_ORCL
> > Password:
> > Connected.
> > SVRMGR> select * from v$database;
> > NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
> > --------- -------------------- ------------ ---------- ----------
> > ORCL 07/08/99 15:17:08 NOARCHIVELOG 35928 35839
> > 1 row selected.
> >
> > SVRMGR> shutdown
> > ORA-00600: internal error code, arguments: [2141], [411833809],
> > [411840697], [],
> > [], [], [], []
> > SVRMGR> shutdown immediate
> > ORA-00600: internal error code, arguments: [2141], [411833809],
> > [411840697], [],
> > [], [], [], []
> > SVRMGR> shutdown abort
> > ORACLE instance shut down.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 7505780 bytes
> > Fixed Size 35760 bytes
> > Variable Size 7052228 bytes
> > Database Buffers 409600 bytes
> > Redo Buffers 8192 bytes
> > Database mounted.
> >
> > SVRMGR> connect internal_at_ORCL
> > Password:
> > Connected to an idle instance.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 7505780 bytes
> > Fixed Size 35760 bytes
> > Variable Size 7052228 bytes
> > Database Buffers 409600 bytes
> > Redo Buffers 8192 bytes
> > Database mounted.
> > Database opened.
> >
> > SVRMGR> select * from v$database;
> > NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
> > --------- -------------------- ------------ ---------- ----------
> > PINS 07/13/99 09:13:04 NOARCHIVELOG 7090 7074
> > 1 row selected.
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
> --
> Joseph R.P. Maloney, CCP,CSP,CDP
> MPiR, Inc.
> 502-451-7404
> some witty phrase goes here, I think.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Tue Jul 20 1999 - 18:03:34 CDT
