Re: listener / tnsname / mystery (NT4 Oracle 7.3.4)

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 - 14:02:15 CDT