Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3568574Oct 14 2017 — edited Dec 26 2017

I recently installed oracle 11g on windows bootcamp on my mac. After running sqlplus and putting the system user and password I get:

C:\Users\yzhan161>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Sat Oct 14 13:55:25 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter user-name: system

Enter password:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Process ID: 0

Session ID: 0 Serial number: 0

I also ran an sql instance using sys as sysdba which loaded an idle instance. After running startup I get:

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-00600: internal error code, arguments: [kspifisp:ksfdread_resilver], [0x00097C870], [0x00097C600], [512], [], [], [], [], [], [], [], []

SQL>

There may be a problem with my sid and oracle_home variables as well. However, I do not know how to check them and what they should be. Any solutions? Im using windows 10 pro on bootcamp.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 23 2018
Added on Oct 14 2017
8 comments
13,833 views