Re: Problem with two databases on the same system

From: Berry <berry_at_traserv.com>
Date: Fri, 5 Apr 2002 10:39:54 +0200
Message-ID: <a8jnq0$ds0$1@news.btcnet.nl>

When I change the password for my system user in tpb. The password automatically changed by tpp (the same). So, it looks like I have one database.

# LISTENER.ORA Configuration File:/ora81/app/oracle/product/8.1.6/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = Bangkok)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ora81/app/oracle/product/8.1.6)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = tpp)
(ORACLE_HOME = /ora81/app/oracle/product/8.1.6)
(SID_NAME = tpp)

    )
    (SID_DESC =
(GLOBAL_DBNAME = tpb)
(ORACLE_HOME = /ora81/app/oracle/product/8.1.6)
(SID_NAME = tpb)

    )
  )

# TNSNAMES.ORA Configuration File:/ora81/app/oracle/product/8.1.6/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

TPP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Bangkok)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = tpp)

    )
  )

TPB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Bangkok)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = tpb)

    )
  )

# SQLNET.ORA Configuration File:/ora81/app/oracle/product/8.1.6/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a8jmn7$6cn$1_at_lust.ihug.co.nz...

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

Received on Fri Apr 05 2002 - 02:39:54 CST