Re: 03114 - Unable to connect

"Derek Megyesi" <dmegyesi_at_truecontext.com> wrote in message news:<i2KQ8.8163$YG5.1817946_at_news20.bellglobal.com>...
> Hello,
>
> I am a Verification Engineer at a local startup in Ottawa and we are
> installing Oracle 8i (8.1.7) on our Solaris 8 box. I am using the OUI
> (Oracle Universal Installer) GUI to do the installation and no matter what I
> do, I keep getting this pop-up error window "ORA-03114 - Unable to connect
> to Oracle."
>
> I have looked on the web for help and this problem is very common, yet the
> solutions that people give or very vague and often very techy. Oracle
> installation on unix should be very easy ..trivial.. I have done al the
> steps..set my semaphores, creating oracle and apache accounts, made the
> permissions correct. The problem is that Oracle can't talk to the Database.
>
> 1) What does the above error mean? and how is it generated?
> 2) What is the solution? How do I fix it?? Any help is valued !!
>
> Please help!
>
> Email me at dmegyesi_at_truecontext.com
>
> Derek

This error means "A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may also happen if communication trouble causes a disconnection."

1. Try to ping the server. If you can then go to step 2 else check your network connection etc.
2. Try to tnsping the oracle sid. If you can then go to step 3 else setup your service using net8 configuration assistant. Check middleware (Net8) setup. Also check if correct protocols are specified in listener.ora file on the server.
3. Try connecting using SQL*Plus. If you can then you are all set else go to step 4.
4. Try connecting using server manager. If you can then go to step 2 again. Check your Middleware setup else check your database to see if it is open and properly installed.

HTH Received on Sat Jun 22 2002 - 01:40:04 CDT