[求助] 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
相关问答:
我安装一台redhat linux5+oracle 10g的服务器,笔记本(XP系统)安装了oracle 10g客户端,结果老是出12560的错误,请高手指点一二,
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
LY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
)
......
我的程序需要连接另一台电脑上的oracle服务器,如果服务器开启,连接操作一切正常。
但是如果oracle服务器没有开启,程序要将近20才返回无法连接数据路。
VC程序通过ADO方式访问oracle数据库
m_pConnection ......
一对多关系查询
表:
ea,eb,ga,gb
表关系如下
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33
事例数据及关系如下:
SQL code:
SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......
declare
soap_request varchar2(30000);
soap_respond varchar2(30000);
http_req utl_http.req;
http_resp utl_http.resp;
BEGIN
soap_request:= ' ......