[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

錯誤解釋：不能找到共享區(qū)內(nèi)存

針對Linux環(huán)境

原因：

1. 數(shù)據(jù)庫實(shí)例沒有啟動，檢查數(shù)據(jù)庫實(shí)例運(yùn)行狀態(tài)。

2. 數(shù)據(jù)庫實(shí)例不匹配

環(huán)境變量中的ORACLE_SID和啟動后實(shí)例是否一致，包括大小寫是否一致?

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

以上情況是一樣的。

本地遠(yuǎn)程連接配置如下與數(shù)據(jù)庫環(huán)境Database Service是否一致？

本地配置：

ORCLDB =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

數(shù)據(jù)庫環(huán)境Database Service :

查看監(jiān)聽狀態(tài)：

[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中 修改為一致，并重啟監(jiān)聽服務(wù)即可！！

總結(jié)

以上是生活随笔為你收集整理的oracle 01304,关于ORA-01034和ORA-27101的解决方法的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。