Home » RDBMS Server » Server Administration » Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist (split from hijacked thread)
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist (split from hijacked thread) [message #574982] Thu, 17 January 2013 05:57 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hello i also got this same error michel but i did this steps and my database open successfully in archive mode but

i did this step

C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 15:59:33 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL> Shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL> shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL>
SQL> exit
Disconnected


C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 16:12:44 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.

SQL> startup pfile="F:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.112420121
3196";
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2066080 bytes
Variable Size             385878368 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14708736 bytes
Database mounted.
Database opened.
SQL>
SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
SQL> SELECT log_mode
  2  FROM v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>

here its my init.ora file

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=""
db_name=orcl
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=f:\oracle\product\10.2.0\admin\orcl\bdump
core_dump_dest=f:\oracle\product\10.2.0\admin\orcl\cdump
user_dump_dest=f:\oracle\product\10.2.0\admin\orcl\udump
 
###########################################
# File Configuration
###########################################
control_files=("f:\oracle\product\10.2.0\oradata\orcl\control01.ctl", "f:\oracle\product\10.2.0\oradata\orcl\control02.ctl", "f:\oracle\product\10.2.0\oradata\orcl\control03.ctl")
db_recovery_file_dest=f:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size=2147483648
 
###########################################
# Job Queues
###########################################
job_queue_processes=10
 
###########################################
# Miscellaneous
###########################################
compatible=10.2.0.3.0
 
###########################################
# Processes and Sessions
###########################################
processes=150
 
###########################################
# SGA Memory
###########################################
sga_target=1610612736
 
###########################################
# Security and Auditing
###########################################
audit_file_dest=f:\oracle\product\10.2.0\admin\orcl\adump
remote_login_passwordfile=EXCLUSIVE
 
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)"
 
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=836763648
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
log_archive_format = 'arch_%r_%t_%s.arc'



[mod-edit: This post was split from the following hijacked thread from years earlier by bb:
http://www.orafaq.com/forum/t/100332/0/unread/43710/#msg_574982 ]

[Updated on: Thu, 17 January 2013 15:23] by Moderator

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #574983 is a reply to message #574982] Thu, 17 January 2013 06:05 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
and my here is my this SPFILEORCL.ORA file

                                   orcl
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__shared_pool_size=352321536
orcl.__streams_pool_size=0
*.audit_file_dest='f:\oracle\product\10.2.0\admin\orcl\adump'
*.background_dump_dest='f:\oracle\product\10.2.0\admin\orcl\bdump'
*.compatible='10.2.0.3.0'
*.control_files='f:\oracle\product\10.2.0\oradata\orcl\control01.ctl','f:\oracle\product\10.2.0\oradata\orcl\control02.ctl','f:\oracle\product\10.2.0\oradata\orcl\control03.ctl'
*.core_dump_dest='f:\oracle\product\10.2.0\admin\orcl\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='f:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest='location=F:\sharc'
*.open_cursors=300
*.pga_aggregate_target=836763648
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1610612736
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='f:\oracle\product\10.2.0\admin\orcl\udump'
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #574988 is a reply to message #574983] Thu, 17 January 2013 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry your problem is?

Regards
Michel
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #575038 is a reply to message #574988] Fri, 18 January 2013 04:36 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
michel today when i shutdown my database and again i startup this i got this error msg again

i go this error

F:\oracle\product\10.2.0\db_1\BIN>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 18 16:00:02 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.
SQL> startup pfile = "F:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.1124201
213196";
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #575039 is a reply to message #575038] Fri, 18 January 2013 04:59 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
C:\Users\Administrator>set oracle_sid=orcl

C:\Users\Administrator>set db_name =orcl

C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 18 16:24:28 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is inco
rrect.
SQL>
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #575041 is a reply to message #575039] Fri, 18 January 2013 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the error in your parameter.

Regards
Michel
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #575179 is a reply to message #575041] Mon, 21 January 2013 00:27 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
look this michel

C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 21 11:41:46 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.

SQL> startup pfile ="F:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.11242012
13196";
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2066080 bytes
Variable Size             385878368 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14708736 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is inco
rrect.
SQL>


F:\oracle\product\10.2.0\db_1\BIN>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 21 11:57:47 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.

SQL> startup pfile ="F:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.11242012
13196";
ORA-03113: end-of-file on communication channel
SQL>

[Updated on: Mon, 21 January 2013 00:30]

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #575181 is a reply to message #575179] Mon, 21 January 2013 01:28 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
 create spfile from pfile;


Which pfile?

Quote:
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated


Fix your parameter.

Regards
Michel
Previous Topic: ASMlib devices
Next Topic: error message in TOAD
Goto Forum:
  


Current Time: Thu Mar 28 06:51:56 CDT 2024