Re: Networking problem: Can't connect to database?

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

Without any pertinent error message this can only be resolved by using a crystall ball. Please try to be specific is as possible. This group provides support FOC, hence you should at least try do something to your problems yourself, by providing as specific information as possible, not 'it doesn't work'

Regards,

Sybrand Bakker, Oracle DBA Received on Mon Apr 02 2001 - 15:14:28 CDT