易截截图软件、单文件、免安装、纯绿色、仅160KB

[求助] oracle无法启动

服务器下电几天后今天上电,数据库却怎么也起不了了,具体情况如下:

SQL> startup
ORACLE instance started.

Total System Global Area 5010685952 bytes
Fixed Size                  2159272 bytes
Variable Size            3758099800 bytes
Database Buffers        1207959552 bytes
Redo Buffers              42467328 bytes
ORA-03113: end-of-file on communication channel
Process ID: 5465
Session ID: 665 Serial number: 3


alert.log文件片段:
Mon Jul 30 07:40:40 2007
MMNL started with pid=15, OS id=5872
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Mon Jul 30 07:40:40 2007
ALTER DATABASE  MOUNT
Errors in file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 5858): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 5858


amw_mman_5858文件内容:
Trace file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Ora


相关问答:

linux + oracle用XP访问不了

我安装一台redhat linux5+oracle 10g的服务器,笔记本(XP系统)安装了oracle 10g客户端,结果老是出12560的错误,请高手指点一二,

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

连接其他机器的oracle.

    LY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
    )
    ......

关于Oracle数据库连接超时问题

我的程序需要连接另一台电脑上的oracle服务器,如果服务器开启,连接操作一切正常。
但是如果oracle服务器没有开启,程序要将近20才返回无法连接数据路。
VC程序通过ADO方式访问oracle数据库
m_pConnection ......

Oracle 9i 一对多的关系查询

一对多关系查询

表:
ea,eb,ga,gb
表关系如下
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33


事例数据及关系如下:
SQL code:

SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......

oracle使用utl_http的问题

declare
  soap_request varchar2(30000);
  soap_respond varchar2(30000);
  http_req utl_http.req;
  http_resp utl_http.resp;

BEGIN
  soap_request:= ' ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号