Home/Questions/Q 5603
In Process
Sanjay
Sanjay

Sanjay

View Profile
  • 0
Contributor
Asked: 2021-02-25T07:47:05+05:30

ORA-01034 ORACLE not available

  • 0

I have oracle 18 and SQL was working fine on command prompt. I had created few tables as well. I wanted to run it on localhost using APEX for pluggable database, so installed Apex 19.1 but it did not work on localhost despite many tries and suggestions from many vdos. Finally, I removed it (@apxremov.sql), deleted all folders. Then I unzipped Apex 5 and wanted to install Apex 5 as per your vdo but now I neither run SQL on command prompt nor initiates installation. Hence, I can not change database to pluggable database. It gives following error....

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0

 

How to fix this ? At least I should run SQL on command prompt as it was before.

Thanks

ora-01034

    2 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      It seems your Oracle database instance is not running. You need to shut down Oracle database and then restart it. The following are the steps:

      Run SQLPLUS:

      sqlplus / as sysdba

      Then execute the below command:

      shutdown immediate

      Then exit:

      exit

      Again open SQLPLUS:

      sqlplus / as sysdba

      Execute the following command:

      startup
      • 0

    You must login to add an answer.