Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist (windows server 2008 R2 Standard)
ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist [message #596516] Tue, 24 September 2013 05:29 Go to next message
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.
icon11.gif  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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.



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 Go to previous messageGo to next message
John Watson
Messages: 8922
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
)
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 Go to previous messageGo to next message
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



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 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
icon5.gif  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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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?

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 Go to previous messageGo to next message
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.

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 Go to previous messageGo to next message
swethaalampally
Messages: 7
Registered: September 2013
Location: banglore
Junior Member
The type of the file system is NTFS.
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
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 Go to previous messageGo to next message
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

icon5.gif  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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
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 Go to previous messageGo to next message
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
icon14.gif  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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Thu Mar 28 10:58:05 CDT 2024