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

is ORCL a defined alias in the tnsnames.ora file?

I am primarily an AIX Oracle user, but I have had problems with connecting the way you are trying to. I have 2 instances, on 2 different servers, TEST and PROD. If I log on to PROD as system/manager, and issue connect system_at_TEST, it prompts me for a password. I enter the password, it says connected, but I stay connected to the PROD instance. If I enter connect system/manager_at_TEST, it connects fine to TEST.

Try issuing the connect user/pass_at_PINS or user/pass_at_ORCL and see if that helps.

HTH,
Roy

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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 10:57:53 CDT