Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> listener / tnsname / mystery (NT4 Oracle 7.3.4)

listener / tnsname / mystery (NT4 Oracle 7.3.4)

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Tue, 20 Jul 1999 14:37:18 GMT
Message-ID: <7n21is$tie$1@nnrp1.deja.com>


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. Received on Tue Jul 20 1999 - 09:37:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US