Can you answer the following:

1. Are you trying to connect to a remote server or is
the db on the same server?

2. IF the db on the same server, did you try increasing the
semaphore limits, reboot the server and then restart the
db and then try?

3. What was the result of PANDO's suggestion?

4. Can you tnsping servicename?

5*. Last call the oraenv and set the environment variable
and try again? In my opinion, its the environment
variable that causeing all the pains. Recheck with
the same server and set. Don't compare with the other
servers as the path might be different from this
installation.


-Sam

[Edited by sambavan on 10-10-2002 at 03:44 PM]