I have recently had a server crash that is hosting both an 11g and 19c databases. Upon restart by IT staff, I discovered that one of the two 19c instances was idle. The 11g instances are all mounted, open and accepting SQL Developer connections.I was able to mount and open it using the init.ora file as an argument in the startup. I checked and the database is reporting, through SQL Plus, that it is mounted and open. The listener has been restarted successfully. However, trying to connect to it through SQL Developer I get ORA-01034. Any advice on what the problem is would be appreciated.
Error: ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist 01034, 0000 "Oracle not available"
SQL Developer is local and I have not tried remote sql plus as I am remoting into the Win 2012 R2 host server to run the commands. There is one listener for the database. Stopped and restarted listener and reports STATUS UNKNOWN for both instances.
Have not done anything with the environment variables. I do not have admin rights to the server.