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 |
|
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 #575179 is a reply to message #575041] |
Mon, 21 January 2013 00:27 |
|
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
|
|
|
|