Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Networking problem: Can't connect to database?
Doesn't sound like a networking problem, you know, like layer 1-2 and your application can't go down the OSI and get to the other side and MACs talking blah blah...
This is an oracle configuration problem....you said you can communicate with the other two...
"Ron" <ronyin_at_tpts5.seed.net.tw> wrote in message
news:9aaaom$v6$1_at_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 Fri Apr 13 2001 - 15:17:56 CDT