Oracle Not Available

[vetis]

Environment information:
* Oracle version: 9 I
* Operating system: Windows 2000 Server

After running many processes in the bank The system displays the following message Error:

Select all

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

Is there any definitive correction for this?

Att,

[diegoleite]

Friend,

explains better .... you are direct on the server ?? Have you checked your environment variables? Is this in the same session that you performed processes?

[LoadingXp]

Connect to your server and verify the status after this error.

Connect with SYS or through a member of the operating system which is SYSDBA.

Select all

SET ORACLE_SID=<SEU_SID> 
sqlplus /nolog 
conn / as sysdba 
 
select status from v$instance;

Greater details Take the alertlog_<SID>.log file from your database.

Hugs

[ruevers]

Does some mistake in Alert Log?

[vetis]

Personal thanks for the help!
But the problem was resolved after I took the bank of Windows 2003 Server and passed to Red Hat.
was a Windows memory management problem.

Att,

[leandrolco]

Good choice vetis, since now you are using as Linux, you have how you make some settings at the traffic lights. So you can use the maximum server.
follows some tips for tuning.

* Edit the Linux semaphore file: /etc/sysctl.conf
-Adicate the following lines

Select all

kernel.shmmax = 503316480 
kernel.shmall = 503316480 
kernel.sem = 160 320 128 128

These Values ??are based on the server's memoria in the example: This server has 512MB RAM, in bytes is a number of 536870912 bytes
512 x 1024 x 1024 = 536870912 or else use the command $free -b]
knowing that Linux needs 32MB to operate normally. Make the following account.

32 x 1024 x 1024 = 33554432 bytes

Take your mémia 536870912 - 33554432 = 503316480 This result will be used for the parameters kernel.shmmax and kernel.shmall

Now the kernel.sem parameters is reached with the following information.

Checking the init.ora You will find a number referencing:
Standard is 150 Processes
Take this number and add 10, where 160 is 160, the second Number simply multiply by 2 o 160 getting 320. The last two numbers are patterns 128 128.

Then simply restart the server, for the settings to enter action, or then run the command as root:

Select all

#sysctl -p /etc/sysctl.conf

After these settings here, the result was visibly very good!