RE: Oracle DB Connection Problem

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Thu, 06 Dec 2001 13:50:54 -0800
Message-ID: <F001.003D682C.20011206102854@fatcity.com>

Ken

The database is not up. The NT services are not running.

To start them, from GUI go to Start|Control Panel|Administrative Tools|Services, find the Oracle service and start it. Check the service to be sure it is "Auto Start" enabled.

If you cannot get to the machine, telnet to the box and, at the DOS prompt, type : net start oracleservice{sid}

The above will start the Oracle service and the database both.

hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, December 05, 2001 8:30 PM To: Multiple recipients of list ORACLE-L

 8.1.7 on Dell W2000 server.

When I try to login via sqlplus I get this:

ORA-01034 Oracle not available
ORA-27101 shared memory realm doesn't exist

Then I get:

Login:
Password:

And this error:
ORA-12560 TNS: protocol adapter error.

Any ideas as to what the problem is?

Thanks,
Ken Janusz
Sufficient Systems, Inc.   

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 06 2001 - 15:50:54 CST