1 Reply Latest reply: Oct 25, 2008 4:45 PM by 466751 RSS

    ORA-01034: ORACLE not available

    557090
      Hi
      My db was upgrades from 9.2.0.7 to 9.2.0.8 som days back. Yesterday we rollback it from 9.2.0.8 to 9.2.0.7.
      When i started the applications 11.5.9 and they were up. I tried to login to db usings apps/apps it showing the below error.

      ERROR:
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      HP-UX Error: 2: No such file or directory

      Any trace
      Thanks in advance.
      Tokala
        • 1. Re: ORA-01034: ORACLE not available
          466751
          That means one of two things. (1) The database hadn't started yet, but will start. Simply retry in a couple minutes. (2) More commonly something caused the memory segment to fail, which didn't get reported by your start up scripts, or your database is offline for maintenance. Sign on as the SYSDBA, issue the manual command to startup. If it still doesn't start, check your database log files for an error.