Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Networking problem: Can't connect to database?
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