Oracle won't start??

[kook04]

Hello all,

I hope that someone can help me with this. For some reason, Oracle will not allow me to use its associated applications. If I try to start SQL*Plus, here are the errors I get:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Also, programs like DBA Studio won't even start up. It just hangs at the intro splash screen.

I would appreciate if anyone could help, and if more info is needed, let me know.

Thank you... Kennedy ------
KJR

 

[Thiko]

Hi, i got this off metalink for you:

Problem Description
-------------------

You are attempting a client connection to an 8i database via
sqlplus and receive the following errors:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

You have installed 8.1.7 on the same server in a seperate
ORACLE_HOME.

Solution Description
--------------------

1) For local (BEQ) connections:

Verify that ORACLE_SID is set and points to a valid 8.1.7
database which is up and running.

% echo $ORACLE_SID
junk

% ps -ef |grep smon
oracle 24603 1 0 15:22:51 ? 0:02 ora_smon_JUNK

In this scenario, as ORACLE_SID is case-sensitive on the Unix
platform, a database called 'junk' isn't running. The fix would
be to set ORACLE_SID correctly or to the valid instance.

% setenv ORACLE_SID JUNK

2) For remote (TCP/listener) connections:

Review the listener.ora currently used to startup the listener
and verify the ORACLE_HOME is correct for all listed 8i
databases.

If the ORACLE_HOME points to the 8.1.7 software yet the database
was created with 8.1.6 or 8.1.5, then this error can occur.


Explanation
-----------

Previously when the ORACLE_HOME or ORACLE_SID was set incorrectly,
in the 'oracle' or client user's environment, only ora-1034 was reported.

ORA-01034 "ORACLE not available"

With 8.1.7, the ora-27101 is reporting that the shared memory
key generated by the client doesn't match any currently
existing keys. This is to be expected if the ORACLE_HOME used by
the client isn't the same as the one used to startup the database
with or the ORACLE_SID is not correctly referencing the right
instance.

Many Thanks.

Thiko!

 

[kook04]

Thanks for your response Thiko, but I am not using Unix. I should have specified that I am running 8.1.7 on Windows 2000 Pro. From what I have gathered, it may have something to do with my ORACLE_SID, but I am not sure, and don't know how to set this variable anyhow. Still looking for help.

Thanks eveyone...Kennedy ------
KJR

 

[wushutwist]

On NT use:

SET ORACLE_SID = YOUR_SID

Wushutwist

 

[kook04]

Ok guys, I am getting closer. I think that I am going to need someones help to get over the last hump.

I have found that if I use svrmgrl.exe I can start the database up manually. I type 'startup' at the prompt, and then SWL*Plus works. How can I get the DBase to start automatically at boot?

Thanks...Kennedy ------
KJR

 

[wushutwist]

You need to start Oracle as an NT Service. Try:

ORADIM -startup -sid ORCL -usrpwd ORACLE
-pfile c:\oracle\database\initORCL.ora
-starttype SRVC, INST

Where ORCL is your Oracle SID name and ORACLE is your password for internal. Wushutwist

 

[kook04]

Does it matter that I am running Win2000 and not NT? I ask because I have come across some things in Oracles documentation concerning NT that does not pertain to 2000. For instance, there is no ControlPanel>Services icon in 2000.

Kennedy ------
KJR

 

[raygg]

Try this: start>settings>control panel>administrative tasks>component services - and there you will find the oracle services just like in NT.

I had a similar problem a couple of times in NT 817 on my desktop and bounced the database to eliminate it each time.

 

[kook04]

raygg, I found what you were pointing me to, but sure enought, it has my DB as starting up "Automatic". Of course, this is not working. I can't figure out why.

Kennedy ------
KJR

 

[raygg]

I named my database XFILE on my w2k workstation desktop. I find my service in that panel labeled as OracleServiceXFILE. I double click on that service name to get a modal window labelled 'OracleServiceXFILE Properties (Local Computer)'. In this window you can click on the Automatic tab to change it to Manual or Disabled. Read the oracle manuals about this stuff to learn more. Either STOP or START will be grayed out - indicating the db status is the opposite. To bounce the db when START is grayed out - click on STOP and another modal window with a progress bar will appear while the db is shutting down. The reverse process is used to startup the db. All this does is shut down - bounce - the db by shutting down the w2k process (formerly the NT process).

You can also avoid this whole process by rebooting - it will automatically restart your database.

You can reboot also the command line by going to start>programs>accessories>command prompt which opens what in NT was called the MSDOS window. I suggest you put this command prompt on your desktop as a shortcut. In command line you enter
SVRMGRL
CONNECT INTERNAL/PASSWORD - DEFAULT IS ORACLE
SHUTDOWN IMMEDIATE (TO SHUT DOWN DB)
STARTUP (TO STARTUP DB)

Another way to do this is to logon to sqlplus using internal/oracle. I suggest also that you put a shortcut to sqlplus on your desktop.
Then enter startup and shutdown there.
If you do not logon thru sqlplus as internal/oracle you have to logon as 'username/password as sysdba'. You set up your own username as a sysdba by logging on as either system or internal - I forget which - and grant the sysdba role to yourself, which you should also grant dba. After this you cannot startup/shutdown the db using sqlplus unless you logon with the 'as sysdba' designation, altho you still have dba rights.

 

[raygg]

FYI - 'Automatic' means that the db restarts when you reboot. If it crashes or freezes with no reboot - occasionally it will reboot itslef but I do not think that is because of the 'Automatic' status of the NT/w2k process.

 

[kook04]

Raygg,

That's the problem. The db does not restart when I reboot. If it is running, and I do a reboot, I have to manually restart it my self.

Kennedy ------
KJR

 

[raygg]

Have you changed or added any init.ora parameters?

 

[kook04]

Only:

utl_dir_file = *

Kennedy

(Thanks for all your help) ------
KJR

 

[raygg]

I have not had that problem - I scanned metalink for 'automatic restart windows 2000' - check out these docs:
162993.99, 148894.1, 70988.996

Hope this helps

Ray