Re: Client/Server troubles.

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Mon, 04 May 1998 20:38:15 GMT
Message-ID: <354e2735.9391794@www.sigov.si>

On Sun, 03 May 1998 19:53:22 -0500, Ryan <rich7_at_flash.net> wrote:

> We have just installed Oracle8 server on a Solaris 2.6 platform. I am
>trying to connect my
>95/NT PC (running Oracle8 Client). I started up (with mount) the
>database (called TEST) made sure the listener is up and active. No
>problems there. But when I try to connect via Net8, The Net8 easy config
>
>says - "Cannot connect, Database is either initializing or shutting
>down". It says this after 20 minutes have passed after launching the DB.
>
>After shutting down the listener the client says "No listener found" so
>I know it is detecting the listener when it is up.
>
>Any clues would be helpful.

Your database is not available yet if you start it up with the MOUNT option. You must OPEN it to make it available to the client aplication. The process of starting up the database consists of three phases:

Starting the instance (i.e. starting the oracle server processes and forming a SGA) in NOMOUNT mode. In this phase, only the initialisation file is read (init<SID>.ora),while the control, the redo and the database files are not touched by this phase.

You can reach this phase by isuing: "STARTUP NOMOUNT".

2. Mounting the database. In this phase, control file is read, while redo files and database files are not touched, and hance the actual data from the database is not accessible yet.

You can reach this phase by isuing: "STARTUP MOUNT". If database has allready been started in nomount mode, you can mount it by isuing "ALTER DATABASE MOUNT". 3. Opening the database. In this phase, all the redo files and database files (listed in the control file) are associated with this instance and their contents is now available to the users.

You can reach this phase by isuing "STARTUP", which is the same as "STARTUP OPEN". If the database is allready started in MOUNT mode, you can open it with "ALTER DATABASE OPEN".

>Thanks
>Ryan

Regards,

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon May 04 1998 - 15:38:15 CDT