Re: Problem with two databases on the same system

Well, to start with, I wouldn't check what I was connected to by selecting global_name. That can pretty much be set to anything you like, and dynamically too. Select * from v$instance or v$database is more reliable.

Otherwise, I'm afraid it's just a question of what's in your listener.ora and your tnsnames.ora, and since we don't have sight of those just yet, it's impossible to give any real advice. Post back with the details, and we can take it from there. (sqlnet.ora, too).

Regards
HJR

--
-----------------------------------------------
Resources for Oracle : http://www.hjrdba.com
===============================

"Berry" <berry_at_traserv.com> wrote in message
news:a8jlei$bto$1_at_news.btcnet.nl...


> My english is not very good, so I hope you can read this :)

> --------------------------------------------------------------

>

> Hello,

>

> I've installed two Oracle 8i databases on my Linux RH7.2 system.

> When I want to connect, from a remote system, to one of these databases

I'd


> got a problem.

>

> The SID-names from both databases are tpp and tpb.

>

> So, when I log in with system/manager_at_tpp and I enter the following code:

>

> select * from global_name;

>

> I get the message tpp. So, that's ok.

>

> But when I log in as system/manager_at_tpb, I get the same tpp as global

name.


>

> --

>

> It loooks like that the listener listens to the database who is selected

in


> the .bash_profile.

>

> When I change de ORACLE_SID in my .profile in tpb, the global_name is tpb

> for both code_rules.

>

> --

>

> What is the problem. I want to use two differant databases.

>

>