Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Database mismatch

1 view
Skip to first unread message

Basil Jackson

unread,
Aug 29, 2001, 12:21:56 PM8/29/01
to
I have a problem. I have a computer (NT4) with 4 databases and one
instance each. Two databases are only for test purposes (let's say
database A and B). These two test databases are deactivated (Service
set to Manual).

Two of the databases are for production purposes (let's say database C
and D).

The problem is that when I try to access database D, I'm actually
seeing B which isn't even supposed to be running.

Does anyone have a clue as to how the databases may have gotten
crossed and what I might do to get them straight again? I'd really
appreciate it.

Randy

unread,
Aug 29, 2001, 8:53:34 PM8/29/01
to
I don't think it is possible for you to be accessing an instance that is
shut down. Either the B instance is not really stopped or it is not really
the B instance. You didn't say how your are trying to access the D
database, most applications use a file called tnsnames.ora. If that file is
misconfigured, you might well access an incorrect instance.
HTH


"Basil Jackson" <BJac...@BOSGmbH.Com> wrote in message
news:adec38b6.01082...@posting.google.com...

Tho Nguyen

unread,
Aug 29, 2001, 10:30:18 PM8/29/01
to
Hi,
set Oracle_sid=D
HTH,
Tho Nguyen


--
Posted via CNET Help.com
http://www.help.com/

Basil Jackson

unread,
Aug 31, 2001, 5:51:11 AM8/31/01
to
Randy, the NT service for the shutdown databases is set to Manual and
they are not started. Theoretically, they are down.

If I look at InitB.Ora, I see that the database name is "B" and I see
the path for the control files, etc. It's the database B.

If I look at InitD.Ora, I see that the database name is "D" and I see
the path for the control files, etc. It's the database D.

Using SvrMgrL I logon using: CONNECT internal/password@D
If I then look at v$parameter the database name is "B".
Looking at the control files, etc. I see the settings for database
"B".

And then I scream.

I suspect that one of the configurations is out of whack though I have
no idea how it could have happened. You may be right and it could be
TNSNAMES.ORA.

Is there a particular sequence that has to be maintained between two
configuration files?

What is it that actually ties the components like Instance, Listener,
Database together?

Thanks.


BJac...@BOSGmbH.Com (Basil Jackson) wrote in message news:<adec38b6.01082...@posting.google.com>...

Randy

unread,
Aug 31, 2001, 1:53:22 PM8/31/01
to
The linkage is like this. The Listener is independent, has its own
configuration files and can service multiple instances. The database itself
is comprised of the datafiles, they are identified for the instance in the
control files (hopefully you have at least one mirror). The control files
are identified in the Init file which is read when the instance in
initialized.

I can only guess, but it sounds as though your control files might be messed
up, though I would have thought that the instance would never have started
if the control files were wrong. If this should turn out to be the case, I
believe there is a method to manually rebuild a control file.

Are you certain that the OracleServiceB is stopped? It is possible for the
instance to be up with OracleStartB stopped and OracleServiceB running.

Recommend you logon and type:

set ora

to see what Oracle variables might be in your environment. Then:

set ORACLE_SID=B

Do this before starting svrmgr.... Wait a minute!

You are using svrmgrl? I thought that was a Unix utility. What kind of NT
system is this? What version of Oracle are you using?

Puzzled


"Basil Jackson" <BJac...@BOSGmbH.Com> wrote in message

news:adec38b6.01083...@posting.google.com...

Galen Boyer

unread,
Aug 31, 2001, 5:20:10 PM8/31/01
to
On Fri, 31 Aug 2001, har...@bignet.net wrote:

> You are using svrmgrl? I thought that was a Unix utility.
> What kind of NT system is this?

svrmgrl is exactly that on win2K and I think it was the same name
on NT. It is a command line interface just like the UNIX
utility. sqlplus runs in a shell window just like UNIX as
well. (On NT it was plus80).

With the cygwin on NT or 2K, you can run

#!/bin/sh

sqlplus login/password@instance << EOT
select blah ...
;
EOT

Just like on UNIX.

The only issue is that the Oracle machine is not writing and
reading from a UNIX OS :-)

--
Galen Boyer
It seems to me, I remember every single thing I know.

Randy

unread,
Aug 31, 2001, 8:07:12 PM8/31/01
to
"Galen Boyer" <galen...@hotpop.com> wrote in message
news:uofovh...@verizon.net...

> On Fri, 31 Aug 2001, har...@bignet.net wrote:
>
> > You are using svrmgrl? I thought that was a Unix utility.
> > What kind of NT system is this?
>
> svrmgrl is exactly that on win2K and I think it was the same name
> on NT. It is a command line interface just like the UNIX
> utility. sqlplus runs in a shell window just like UNIX as
> well. (On NT it was plus80).
>

I guess my memory is misbehaving (hardly an uncommon occurrence, I fear). I
could have sworn the utility was called SVRMGR23.EXE with Oracle 7 and
SVRMGR30.EXE with Oracle 8, for both NT and Win2K.

Sorry for the error, everyone.

Randy Harris

Galen Boyer

unread,
Sep 1, 2001, 12:56:03 AM9/1/01
to
On Fri, 31 Aug 2001, har...@bignet.net wrote:

>> svrmgrl is exactly that on win2K and I think it was the same
>> name on NT. It is a command line interface just like the UNIX
>> utility. sqlplus runs in a shell window just like UNIX as
>> well. (On NT it was plus80).
>>
>
> I guess my memory is misbehaving (hardly an uncommon
> occurrence, I fear). I could have sworn the utility was called
> SVRMGR23.EXE with Oracle 7 and SVRMGR30.EXE with Oracle 8, for
> both NT and Win2K.
>
> Sorry for the error, everyone.

No need to be sorry because I was talking from an 8i perspective.
I do believe you are correct and also that I mistated my
perspective. Let me try again with your correction about srvmrgl
on 8i as well as 8.0 and a question.

I will submit this to the CoopFAQ on behalf of the group when we
get the list correct. I will also come back later and add
executables.


FOR BOTH NT AND 2000
Version DBA SQL
-------- -------------- ---------
8i svrmgrl sqlplus
8.x svrmgr30.exe plus80
7.x svrmgr23.exe ???

I checked google on behalf of Randy, and his memory looks quite
good. :-)

Sybrand Bakker

unread,
Sep 3, 2001, 6:25:20 AM9/3/01
to
Galen Boyer <galen...@hotpop.com> wrote in message news:<uu1yns...@verizon.net>...

7.x svrmgr23.exe plus33 (DOS) and plus33w (GUI) (this also
applies to 8.0 and 8i: plus80w and sqlplusw for GUI access and plus80
and sqlplus for DOS
only

we probably also should add
exp, imp and sqlldr

8i exp imp sqlldr
80 exp80 imp80 sqlldr80
73 exp73 imp73 sqlldr73

Regards,

Sybrand Bakker, Senior Oracle DBA

Galen Boyer

unread,
Sep 3, 2001, 8:47:07 PM9/3/01
to
On 3 Sep 2001, pos...@sybrandb.demon.nl wrote:

> 7.x svrmgr23.exe plus33 (DOS) and plus33w (GUI) (this also
> applies to 8.0 and 8i:

It doesn't apply to 8.1.7. I have sqlplus and svrmgrl for
command line tools and sqlplusw for the gui.

> plus80w and sqlplusw for GUI access and plus80 and sqlplus for
> DOS only
>
> we probably also should add
> exp, imp and sqlldr
>
> 8i exp imp sqlldr
> 80 exp80 imp80 sqlldr80
> 73 exp73 imp73 sqlldr73

Okay,

So it looks like: (Is it coming out in tabular format for
everybody's newsreaders? It will soon be in html, but want to
make tables are readable by other newsreaders.)

ORACLE SUPPLIED UTILITIES FOR BOTH NT AND 2000:
SQL SQL
Version DBA (Command Line) (GUI) Export Import sqlldr
-------- -------------- -------------- -------- ------ ------ ------
8i svrmgrl sqlplus sqlplusw exp imp sqlldr
8.x svrmgr30.exe plus80 plus80w exp80 imp80 sqlldr80
7.x svrmgr23.exe plus33 plus33w exp73 imp73 sqlldr73

I guess we could just explain the pattern, but then someone would be bound to
ask how to read the pattern.

Have we got it correct?

Basil Jackson

unread,
Sep 8, 2001, 9:59:10 AM9/8/01
to
Wow, I didn't know I'd stir up that kind of debate on what the .exe is
called.
I assure you that on NT4, 8.1.6 uses SvrMgrL.

We seem to be sidetracked from my original problem but I'm grateful
for Randys suggestions (before the debate started). Hopefully, I'll be
able to figure it out and get it back straight. Thanks.

0 new messages