ORA-01034: ORACLE不可用ORA-27101:共享内存域不存在

Question

当我试图使用服务名orcl从客户端连接到服务器数据库时，我得到了上面的错误。当我使用另一个服务名称时，它正在连接，即dms

下面是我的listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = dms)
      (SERVICE_NAME = dms)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
#      (PROGRAM = extproc)
    )
  (SID_DESC =
     (SID_NAME = orcl)
     (SERVICE_NAME = dms)
    # (GLOBAL_DBANME = orcl)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
   #  (PROGRAM = extproc)
  )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))

    )
  )

ADR_BASE_LISTENER = /home/oracle/app/oracle
and tnsnames.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
     #(SERVICE_NAME = orcl.localdomain)
      (ORACLE_SID = dms)
      (SERVICE_NAME = orcl)
    )
  )

DMS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dms)
      (ORACLE_SID = dms)
    )
  )

请告诉我该怎么做？

Answer 1

打开命令提示符，执行以下命令：

set oracle_sid=DATABASE NAME
sqlplus /nolog
conn sys/sys as sysdba
shutdown abort
startup

Answer 2

有时，数据库无法正确挂载，因此需要手动挂载。为此，请关闭它，然后启动它，然后挂载。以oracle用户身份登录，然后运行以下命令：

sqlplus / as sysdba;
shutdown immediate;
startup nomount;
alter database mount;
alter database open;

Answer 3

确保您的ORACLE_HOME和ORACLE_SID正确，以便在windows中查看当前值，然后在命令提示符下键入

echo %ORACLE_HOME%

然后

echo %ORACLE_SID%

如果这些值不是您当前的oracle home和SID，则需要更正它们。这可以在Windows环境变量中完成。

查看 this page for more info