Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> listener / tnsname / mystery (NT4 Oracle 7.3.4)
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 bytesDatabase mounted.
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 bytesDatabase 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 bytesDatabase mounted.
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