Re: Connecting to Oracle database

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 15 Apr 1998 11:39:02 -0700
Message-ID: <6h2us6$v1m$1@pebble.ml.org>

In article <B491AFEA3214D1119E0300A0C943315C09095B_at_CAESAR1>, Rietveld, Timo <T.Rietveld_at_oreade.nl> wrote:
>Problem solved! Database was down...how could I know???

If your db is on unix, you could log onto the unix and do a ps -ef|grep ora_ This will show all the background processes running, with the SID appended. For example, if your SID is TIMO, you might see a process ora_dbwr_TIMO.

It is possible for the DBA to restrict access to the db with it running, though.

>
>> -----Original Message-----
>> From: Rietveld, Timo
>> Posted At: Wednesday, April 15, 1998 10:03 AM
>> Posted To: server
>> Conversation: Connecting to Oracle database
>> Subject: Connecting to Oracle database
>> Importance: High
>>
>> Hi,
>>
>> I can't connect to the Oracle database suddenly. It always worked
>> fine!
>> I'm a newbie in Oracle, so I don't know many details. I work on a
>> network and when trying to connect I get te following messages:
>>
>> When entering the right username, password, but no host string:
>> ERROR: ORA-03121: no interface driver connected - function not
>> performed
>>
>> When entering the right username, password and host string:
>> ERROR: ORA-12203: TNS:unable to connect to destination
>>
>> The error occurs with all Oracle applications.
>> I hope you have a solution, since I can't do anything without
>> connecting to the db. Our dba seems to be on holiday...
>>
>> Regards,
>>
>> Timo
>

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Wed Apr 15 1998 - 13:39:02 CDT