oracle 01304,关于ORA-01034和ORA-27101的解决方法

[oracle@localhost admin]$ oerr ora 01304

01304, 00000, “subordinate process error. Check alert and trace logs”

// *Cause: A process subordinate to this Logminer process has exited with an

// error condition.

// *Action: Look in the alert log and trace files for additional information.

[oracle@localhost admin]$ oerr ora 27101

27101, 00000, “shared memory realm does not exist”

// *Cause: Unable to locate shared memory realm

// *Action: Verify that the realm is accessible

错误解释：不能找到共享区内存

针对Linux环境

原因：

1. 数据库实例没有启动，检查数据库实例运行状态。

2. 数据库实例不匹配

环境变量中的ORACLE_SID和启动后实例是否一致，包括大小写是否一致?

SQL> startup

ORACLE instance started.

Total System Global Area 717225984 bytes

Fixed Size 2928536 bytes

Variable Size 297795688 bytes

Database Buffers 411041792 bytes

Redo Buffers 5459968 bytes

Database mounted.

Database opened.

SQL> select status, instance_name from v$instance;

STATUS INSTANCE_NAME

OPEN orcl

[oracle@localhost dbs] echo $ORACLE_SID

orcl

以上情况是一样的。

本地远程连接配置如下与数据库环境Database Service是否一致？

本地配置：

ORCLDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.230.129)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

数据库环境Database Service :

查看监听状态：

[oracle@localhost bin]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-APR-2016 15:27:30

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.230.129)(PORT=1521)))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 19-APR-2016 15:20:01

Uptime 0 days 0 hr. 7 min. 28 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.230.129)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary…

Service “ORCL” has 1 instance(s).

Instance “ORCL“, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

此处不相符！！！在netmgr中 修改为一致，并重启监听服务即可！！