ora-01034 ora-27101

cyanolive

Appears when connecting to oracle database under windows
ora-01034: ORACLE not available
ora-27101: shared memory readm does not exit

error.

Check the windows service list. Both oracleSERVER and oracleSERVER1 are running.

Start-run-cmd
c:\> sqlplus / nolog
sql> conn sys / abcdefg @ server as sysdba
sql> startup

After that, the application can connect to oracle for normal use.
However, after the computer restarts, the same problem occurs, and the instance server must be started manually.

I don't know where the problem is.

cyanolive

For the time being, I can only write a batch file to open the database instance after the system logs in. The method is as follows, please teach

Write oraStartup.bat
@echo off
cd\
sqlplus /nolog @oraStartup.sql>>oraStartup.log

Write oraStartup.sql
conn sys/abcdefg@server as sysdba
startup

Put the oraStartup.bat batch file to the start-Program-Startup. Let the system run oraStartup.bat after login to open the database instance

claude741

I have encountered this problem, but I don't have to deal with it like that.
You can do this
c:\>sqlplus /nolog
sql>startup pfile='D:\oracle\admin\oradb01\pfile\init<sid>.ora';
(I installed ORACLE under the D drive)
sql>create spfile from pfile;
According to the above method, there is no need to manually start the instance every time.

yanyanming

There is a problem with the memory, or there is a problem with the memory setting in the pfile

windowflow

Check what is the default ORACLE_SID in some registry?

woaitang

Oracle_sid in the registry to see if there is a difference

sd1672554

Mostly the oracle-sid in your registry has a problem. Also check whether there is a problem with the parameters in the spfile or pfile that your oracle starts, and excessive memory resources are set.