OraFAQ Forum: Server Administration » ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist

Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist (windows server 2008 R2 Standard)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596516]

Tue, 24 September 2013 05:29

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

Hello,

I am facing problem with oracle 11g database,

i am continuesly inserting data to oracle database after some time like 2 hours oracle disconnects,it creates erros like

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0

after restarting the database with shutdown immediate ans startup if i start inserting records it will show erros like

ORA-01653: unable to extend table SYSTEM.GLT_PROT_TRAFFIC_SUM_VOIP by 8192 in tablespace GLCOMM

but i have created the Tablespace with BigFile Auto Extend and max size unlimited, i am having 400GB disk space created Redo logs with 15gb,i have tried serveral times reinstalling the oracle but problem is not solved.

same problem is happenging with small datafiles also,

operating system: windows server 2008 R2 standard

oracle server : 11g

oracle client : 64 bit

Can you please any one suggust some solutions to fix this problem.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596518 is a reply to message #596516]

Tue, 24 September 2013 05:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If all what you say is correct then there is a bug in Oracle and you have to file t on MOS.
I advise you to double check all the points and first in the alert.log for any error.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596519 is a reply to message #596516]

Tue, 24 September 2013 05:46

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

If I understand you correctly, this is what you are doing:

1. Install Oracle
2. Create a database
3. Use it for two hours
4. The instance terminates
5. You re-start the instance
6. All subsequent inserts produce a ORA-01653 error
7. Repeat steps 1 through 6, same results.

That is not normal behaviour. Is it really, exactly, what is happening?

(and, just to do the moderator bit:
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read
)

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596520 is a reply to message #596519]

Tue, 24 September 2013 05:59

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

Thanks for reply,

abow steps are correct

I am using some C#.net application to send records to database,

when i first time reinstall oracle it works for 1 day with out any problem, after that oracle terminates automatically.that time on wards is disconnects frequently

if i manually try to extend the Datafile also i am getting error like

ERROR at line 1:
ORA-01237: cannot extend datafile 6
ORA-01110: data file 6: 'D:\GLCOMM_TABLESPACE\GLCOMM01.DBF'
ORA-27059: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 665) The requested operation could not be completed due to a
file system limitation

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596523 is a reply to message #596520]

Tue, 24 September 2013 06:07

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I don't think this is Oracle's problem. What is your file system type? Fat32, by any chance?

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596524 is a reply to message #596520]

Tue, 24 September 2013 06:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

if i manually try to extend the Datafile also i am getting error like

Quote:

ORA-27059: could not reduce file size

Extend or reduce?

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596526 is a reply to message #596524]

Tue, 24 September 2013 06:22

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

its extend upto 21gb, after that unable to extend error i am facing so i have tried command like

ALTER TABLESPACE GLCOMM RESIZE 80G,

but its not working.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596527 is a reply to message #596526]

Tue, 24 September 2013 06:24

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

The type of the file system is NTFS.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596528 is a reply to message #596526]

Tue, 24 September 2013 06:24

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

"it is not working" is rather an unusual error message: I cannot find it in the docs. I suggest you follow Michel's advice, and look at the alert log and any trace files.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596530 is a reply to message #596528]

Tue, 24 September 2013 06:41

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

datafile is extended upto 21gb,so i have tried following command

SQL>
SQL> ALTER TABLESPACE GLCOMM RESIZE 80G;
ALTER TABLESPACE GLCOMM RESIZE 80G
*
ERROR at line 1:
ORA-01237: cannot extend datafile 6
ORA-01110: data file 6: 'D:\GLCOMM_TABLESPACE\GLCOMM01.DBF'
ORA-27059: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 665) The requested operation could not be completed due to a
file system limitation

[Updated on: Tue, 24 September 2013 06:48]

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596531 is a reply to message #596530]

Tue, 24 September 2013 06:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select round(sum(bytes)/1024/1024/1024)
from v$datafile f, v$tablespace ts
where f.ts# = ts.ts#
  and ts.name = 'GLCOMM'
/
select BIGFILE from dba_tablespaces where tablespace_name='GLCOMM';
select * from v$version where rownum=1;

[Updated on: Tue, 24 September 2013 06:47]

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596532 is a reply to message #596523]

Tue, 24 September 2013 06:46

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

Its extended upto 21GB

SQL> ALTER TABLESPACE GLCOMM RESIZE 80G;
ALTER TABLESPACE GLCOMM RESIZE 80G
*
ERROR at line 1:
ORA-01237: cannot extend datafile 6
ORA-01110: data file 6: 'D:\GLCOMM_TABLESPACE\GLCOMM01.DBF'
ORA-27059: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 665) The requested operation could not be completed due to a
file system limitation

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596533 is a reply to message #596530]

Tue, 24 September 2013 06:47

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I just googled "O/S-Error: (OS 665) The requested operation could not be completed due to a file system limitation" I suggest you do the same.

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596534 is a reply to message #596533]

Tue, 24 September 2013 07:00

swethaalampally
Messages: 7
Registered: September 2013
Location: banglore

Junior Member

SQL> select round(sum(bytes)/1024/1024/1024)
2 from v$datafile f, v$tablespace ts
3 where f.ts# = ts.ts#
4 and ts.name = 'GLCOMM'
5 /

ROUND(SUM(BYTES)/1024/1024/1024)
--------------------------------
23

SQL> select BIGFILE from dba_tablespaces where tablespace_name='GLCOMM';

BIG
---
YES

SQL> select * from v$version where rownum=1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596537 is a reply to message #596534]

Tue, 24 September 2013 07:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do what John said, it contains the solution to your problem.

Report message to a moderator

Previous Topic:	Upgrade
Next Topic:	how to know character set as single character or multi character

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:27:18 CST 2024