Hi All:

I need Help ASAP. This is major problem for me.
I have Oracle 8.1.7.3 installed on Sun Solaris 2.7.

When I start the listener. Then check the status it show the following:
connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orion)(PORT=1521)))
status of the LISTENER
----------------------
Alias listener817
version TNSLSNR for Solaris: Version 8.1.7.3 - Production
Uptime 0 day 0 hr 0 min 51 sec
Trace Level off
Security off
SNMP off
Listenr Parmeter file /app/ora817/server/8.1.7/network/listener.ora
Listener Log File /app/ora817server/8.1.7/network/log/listener817.log
Services Summary...
PROD has 1 service handler(s)
SUNY has 1 sercie handler(s)
The command completed successfully.

At this time I am able to go to my client and connect to the database.

But after a short while, if I try to connect to the database again from the
client
I cannot. I get the following error:

ORA - 12545: Connect failed because target host or object does not exist.

I then looked at the status of my listener and there where more services
handlers.

Alias listener817
version TNSLSNR for Solaris: Version 8.1.7.3 - Production
Uptime 0 day 0 hr 2 min 05 sec
Trace Level off
Security off
SNMP off
Listenr Parmeter file /app/ora817/server/8.1.7/network/listener.ora
Listener Log File /app/ora817server/8.1.6/network/log/listener817.log
Services Summary...
PROD has 3 service handler(s)
SUNY has 5 sercie handler(s)
The command completed successfully.

The listener.ora file is as follow:
#Generated by Oracle configu4ration tools
SID_LIST_LISTENER817 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SUNY)
(ORACLE_HOME = /app/ora817/server/8.1.7
(SID_NAME = SUNY)
)
(SID_DESC =
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = /app/ora817/server/8.1.7
(SID_NAME = PROD)
)
)
LISTENER817 =
(DESCRIPTION_LIST =
(ADDRESS = (PROTOCOL = IPC ) (HOST = orion) (Port = 1521))
)

Could you please explain to me what is going on and how to fix this problem
thanks
dlj
Oracle LazyDBA home page