ORACLE Set default database, Ora-01034:oracle not available ora-27101:shared memory realm does not exist

Oracle Set Default Database

If we have multiple databases installed on our servers or on our computers, when we use Sqlplus, what database are we logged into when we specify the database? Today we have an old problem:

Ora-01034:oracle Not available

Ora-27101:shared Memory realm does not exist

have also encountered before: according to the blog on the Internet step-by-step operation is OK, but today try not to, after analysis found that it is my login is another database, but if each time the designated login to the database is too troublesome, to query some information, set the default database:

First open the registry, Win+r run Regedit and then Hkey_local_machine\software\oracle\key_oradb12home2>oracle_sid set the SID for the default database

Simply attach the solution:

Ora-01034:oracle Not available

Ora-27101:shared Memory Realm does not exist method, this is found from the Internet a very reliable method, at least every time you encounter can solve my problem!

Workaround One:

ERROR:

Ora-01034:oracle Not available

Ora-27101:shared Memory realm does not exist

Process id:0

Session id:0 Serial Number: 0

Because of this small mistake, toss me for several hours, the special record is as follows.

Search the Internet for the next solution, as follows:

Sqlplus "Sys/password as SYSDBA"

Connection successful, prompting "connected to idle routine"

Sql> Startup

The ORACLE routine has been started.

Total System Global area 535662592 bytes

Fixed Size 1375792 bytes

Variable Size 293601744 bytes

Database buffers 234881024 bytes

Redo buffers 5804032 bytes

The database is loaded.

ORA-03113: End of file for communication channel

Process id:5412

Session Id:5 Serial Number: 5

A new error occurred: ORA-03113: The end of the file for the communication channel; analysis may be due to the database forced shutdown last night, resulting in the file status may not be consistent, because the normal shutdown of the database to verify the files, so that the time when the file is restarted.

Find the solution as follows:

Sql> Conn/as SYSDBA

Connected to the idle routine.

Sql> Startup Mount

The ORACLE routine has been started.

Total System Global area 535662592 bytes

Fixed Size 1375792 bytes

Variable Size 293601744 bytes

Database buffers 234881024 bytes

Redo buffers 5804032 bytes

The database is loaded.

Sql> select * from V$log;

group# thread# sequence# BYTES BLOCKSIZE members ARC

---------- ---------- ---------- ---------- ---------- ---------- ---

STATUS first_change# first_time next_change# next_time

---------------- ------------- -------------- ------------ -------------

1 1 340 52428800 1 NO

INACTIVE 8474486 February-April-11 8522856 February-April-11

3 1 342 52428800 1 NO

INACTIVE 8555222 June-April-11 8565162 November-April-11

2 1 343 52428800 1 NO

Current 8565162 November-April -11 2.8147E+14

sql> ALTER DATABASE open Resetlogs

2;

ALTER DATABASE open Resetlogs

*

An error occurred on line 1th:

The ora-01139:resetlogs option is only valid after incomplete database recovery

sql> recover database until time ' 2011-04-11 12:12:12 '

Complete media recovery.

sql> ALTER DATABASE open resetlogs;

The database has changed.

sql> shutdown

The database is closed.

The database has been uninstalled.

The ORACLE routine has been closed.

Sql> Startup

The ORACLE routine has been started.

Total System Global area 535662592 bytes

Fixed Size 1375792 bytes

Variable Size 293601744 bytes

Database buffers 234881024 bytes

Redo buffers 5804032 bytes

The database is loaded.

The database is already open.

Workaround: Two

My top size: Big Small

When attempting to log on to PL/SQL, the user name (SYSTEM/PWD) is entered, and Oracle reports the following error:

ERROR:

ORA-27101 Shared Memory Realm does not exist

ORA-01034 ORACLE Not available &<60;

consulted the relevant

ORA-27101 Shared Memory Realm does not exist

ORA-01034 ORACLE Not available &<60;

The description is interpreted as Oracle_home or ORACLE_SID is not set correctly.

But no errors were found after checking bash_profile;

Wrong point, did not open Oracle service;

Solution to directly open the Oracle-related repository service;

or follow the steps below:

Lsnrctl start

Sqlplus '/as sysdba '

Sql> Startup

Emctl Start Dbconsole

Isqlplusctl start

ORACLE Set default database, Ora-01034:oracle not available ora-27101:shared memory realm does not exist