Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Networking problem: Can't connect to database?

Networking problem: Can't connect to database?

From: Ron <ronyin_at_tpts5.seed.net.tw>
Date: Tue, 3 Apr 2001 00:54:19 +0800
Message-ID: <9aaaom$v6$1@news.seed.net.tw>

i'm running oracle8.0.5 on Aix4.3.
I have 3 databases(db1,db2,db3) with same sid(db1,db2,db3). i use win2000 as client to connect those databases by Net8 assitant. but it's odd i can only connect to db1 & db2.

i'm using same port 1521 for all 3 databases. should i use different port no. for 3 databases? if yes, how should i configure different port No.?

the listener file as:
LISTENER =
  (ADDRESS_LIST =
 (ADDRESS= (PROTOCOL= TCP)(Host= 10.80.0.2)(Port= 1521))   )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME= db1)
(ORACLE_HOME= /oracle/product/8.0.5)
(SID_NAME = db1)

    )
    (SID_DESC =
(GLOBAL_DBNAME= db2)
(ORACLE_HOME= /oracle/product/8.0.5)
(SID_NAME =db2)

    )
    (SID_DESC =
(GLOBAL_DBNAME= db3)
(ORACLE_HOME= /oracle/product/8.0.5)
(SID_NAME =db3)

    )
    (SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /oracle/product/8.0.5)
(PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF Ron Received on Mon Apr 02 2001 - 11:54:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US