473,322 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Oracle Not Available

:confused: We have Oracle 9i installed on Windows 2000 Server , It was working fine , suddenly when we log it is giving Oracle Not Available Shared Memory Realrm dose not exists.

When we try to log with sqlplus nolog
we get the SQL Prompt but when we connect to dba as
connect sys as sysdba

we get an error Message :- TNS: Unable to Connect to destination


If any one can help please

Thanks in Advance
Aug 29 '06 #1
1 3632
vssp
268 100+
Hai try this
Check the event for viewer to cross-check whether all the Oracle background (like PMON) have started successfully.. If so, then ur instance startup mode could be manual. For this you have 2 options :

1) drop and re-create service for the database in automatic mode => using Oradim
2)write a command line scipt to start the database from the SQL+ when running it


Try issuing the following commands..

sqlplus /nolog

connect / as sysdba

(just check whether it says "Connected to an idle instance")

shutdown immediate

startup

This will start the database..
Aug 29 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Ton | last post by:
I have a question about connectivity between different databases. Oracle, DB2400 and SQL_server. It is easy to integrate application products that are running on different DB platforms? What...
1
by: Crowe | last post by:
Greetings Everyone: Oracle 9i installed on a sun solaris box. No protocol adapters available. I would greatly appreciate any help from the db gurus on this forum. after bringing up the...
5
by: michael newport | last post by:
Oracle opens arms to Mozilla By Stephen Shankland and Alorie Gilbert, CNET News.com Oracle wants its applications to integrate better with Mozilla's open-source desktop software Oracle is...
11
by: Charlie Martin Beta program | last post by:
Well, it turns out that Google automagically mangled email addresses in the last try, so here goes again. Confio Software, a Boulder-based system performance tools developer, is preparing to...
28
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which SQL server version should I choose, to have a...
5
by: NormaJean Sebastian via DBMonster.com | last post by:
Hi, I almost read all of the "DB2 vs Oracle" thread... The summary I got from that was all databases essentially do the same things, the decision of which one you use primarily depends on...
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
4
by: Francis Awofeso | last post by:
I am new to .NET and I am trying to connect to Oracle database. Can someone with this experience please describe the steps or process to connect to Oracle from .Net. I will appreciate it if anyone...
8
by: =?Utf-8?B?RGF2aWQrKw==?= | last post by:
Hi, I have been developing Web Services in VS2005. Usually I use the built in server in VS2005 to test and develop the Web Service. However I now want to make this Web Service available to...
19
by: Gregor =?UTF-8?B?S292YcSN?= | last post by:
Hi! I'm using DB2 database on one server and ORACLE database on the second one. I want to move some data from ORACLE database to DB2 database and update some columns on ORACLE database so I know...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.