Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:
sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.
Any ideas? 7 13439
NTidd wrote: Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
Windows 2000 Server? Oracle9i Release 1?
(I'd certainly be looking at upping the memory a bit - I'd expect
512M/CPU, but that's likely off topic!)
In the above you do not need to shutdown. It's already shut down,
recognizable by the 'connected to an idle instance' message and the
reason for the ORA-01034/27101. (Nothing wrong with your procedure
though.)
TSTO - something's terminating the Oracle instance. Any chance you've
got Windows Update running and rebooting the machine automatically? Or
some other utility? Do you have Oracle's services auto-starting after
reboot? What else is running on the machine? Is there a job
consistently running immediately prior to the 'crash'? Can you monitor
for memory leaks?
Hmm, Windows update is set to run and install updates I believe, but
not to reboot. This is release 1 from oracle. We initially thought
that it was the backups but the backups run at midnight, and sometimes
users can connect up to about 9:00 am before it crashes. After reboot
everything starts up and works as it should, the server is running
sp4. About the only other thing running on this machine is iis and an
online app that uses oracle.
Hans Forbrich <fo******@yahoo .net> wrote in message news:<3F******* ********@yahoo. net>... NTidd wrote: Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
Windows 2000 Server? Oracle9i Release 1?
(I'd certainly be looking at upping the memory a bit - I'd expect 512M/CPU, but that's likely off topic!)
In the above you do not need to shutdown. It's already shut down, recognizable by the 'connected to an idle instance' message and the reason for the ORA-01034/27101. (Nothing wrong with your procedure though.)
TSTO - something's terminating the Oracle instance. Any chance you've got Windows Update running and rebooting the machine automatically? Or some other utility? Do you have Oracle's services auto-starting after reboot? What else is running on the machine? Is there a job consistently running immediately prior to the 'crash'? Can you monitor for memory leaks? NT***@douglas-associates.com (NTidd) wrote in
news:db******** *************** ***@posting.goo gle.com: Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
What are the last 20-30 lines of the alrtSID.log file? This will
give you a clue if the DB is falling over because of itself or
because of an outside influence. If the log file just stops,
that is to say that everything's normal until it breaks, then
there in an outside process killing the DB. If the log file
reports errors, like ORA-00600 or ORA-07745, then you need to
research those errors and see why Oracle is falling over.
Good Luck,
Mike
> news:db******** *************** ***@posting.goo gle.com: Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
HELLO,
I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS
SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE
INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR
LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS
NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.
REGARDS,
CHERRISH VAIDIYAN
Cherrish Vaidiyan wrote: HELLO, I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.
REGARDS, CHERRISH VAIDIYAN
Would you mind:
- not shouting?
- learn to spell?
--
Regards, Frank van Bortel un************* **@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0******* *************** ***@posting.goo gle.com>... news:db******** *************** ***@posting.goo gle.com:
Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
HELLO, I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.
REGARDS, CHERRISH VAIDIYAN
Yep, that is amazing, simply amazing. Anyways found out that there
was a miscommunicatio n with one of my fellow coworkers, and it appears
to be a backup exec problem. Thanks for the help. un************* **@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0******* *************** ***@posting.goo gle.com>... news:db******** *************** ***@posting.goo gle.com:
Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do:
sqlplus /nolog connect sys as sysdba password: connected to an idle instance shutdown ORA-01034 Oracle not available ORA-27101 Shared memory realm does not exist startup
Then it starts up and works fine for another day or so.
This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz processors.
Any ideas?
HELLO, I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.
REGARDS, CHERRISH VAIDIYAN
Yep, that is amazing, simply amazing. Anyways found out that there
was a miscommunicatio n with one of my fellow coworkers, and it appears
to be a backup exec problem. Thanks for the help. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: simianphile |
last post by:
OK, I had a problem that I've now fixed but I can't really understand
what was causing it in the first place. I have an intranet site that
uses basic authentication to allow users to view and update information
from an Oracle DB (ver 8.1.6 -- ancient, I know). Anyway, the site
worked fine as long as the machine accessing the ASP page was running
Win 2k but when an XP machine tried to view the page, the client got an
error:
Microsoft...
|
by: Harry |
last post by:
Using Oracle 8i enterprise on win 2000 (sp3)
Installed the standard configuration & whenever I make a connection it
takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason
there for slowness.
Once I'm connected the queries work pretty much instantanously but to
connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10 secs. I
connect using OLEDB from Visual Basic development environment & after
the 1st connection...
|
by: Phil Hindmoor |
last post by:
Hi,
I am sure if anyone can help me, you guys can!
I am an Informix Developer, moving to Oracle 8i and later databases.
I am struggling to find the Oracle equivelant to many of the useful
Informix features that I have come to rely upon.
I have looked through the Oracle/Infomix groups and some helpful
users have posted some solutions, but many of them seem to be very
complex work-arounds for features that were readily available in
|
by: SerGioGio |
last post by:
Hello,
I am going nuts. I am trying to connect to my local ORACLE instance using
ODBC.
It used to work few weeks ago, but it fails now.
Connection with:
- SQL*plus: connection works!
- DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
works when I hit the driver's "test connection"
|
by: Ellen K. |
last post by:
Hi all,
Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.
While at my current job I've been working with mostly SQL Server, now
I need to connect to our Oracle Financials running on HP-UX. The
Oracle DBA set me up as a user and installed the Oracle client on my
box and I have the tnsnames file, but I still can't establish a
connection to the database from my...
| |
by: Ellen K |
last post by:
Hi all,
I set up our Oracle Financials as a linked server to one of my SQL
Server boxes. On running a test query, I got the following error
message:
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
OLE DB error trace .
The Oracle datatype of the column with the supposedly inconsistent
|
by: Nick Palmer |
last post by:
Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two
DB2 databases and I need to get access to the tables in one from the other.
In Oracle I would just create a DB Link between the two instances. Is such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
by: Steve Foo |
last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.
I have contacted Singapore Microsoft support regarding the problem .Unfortunately they are not able to help me and eventually direct me here
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting
Hopefully Microsoft Experts here can help me up. Thx
Introduction...
|
by: Chris Botha |
last post by:
The machine is running XP Pro with all the latest service packs, etc. I must
access an Oracle database so I installed the Oracle client stuff. I can
query Oracle from a Windows app, no problem. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
|
by: Ruslan A Dautkhanov |
last post by:
Hello !
I'm about to install O9i on FreeBSD box.
uname -a:
FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2:
Fri Apr 23 19:19:43 KRAST 2004
rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386
uname -a under oracle user :
Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23
19:19:43 KRAST 2004 i686 unknown
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |