HP-Unix安装oracle 10g错误
各位大侠:
小弟是oracle初学者，在hp-unix上安装oracle时出现一个错误，请各位大侠帮忙。
hp-unix B.11.23 U 64位 16C 48G内存 安装oracle 10.2.0.1.0版本数据库。
在安装到configuragion assistant页面时，第二项出现（应该是在dbca创建数据库时）一个错误：
ORA-3113 "end of file on communication channel"
查看安装日志中提示：
System parameters with non-default values:
processes = 150
sga_target = 15418261504
control_files = /oracle/app/oracle/oradata/dm/control01.ctl, /oracle/app/oracle/oradata/dm/control02.ctl, /oracle/app/oracle/oradata/dm/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=dmXDB)
job_queue_processes = 10
background_dump_dest = /oracle/app/oracle/admin/dm/bdump
user_dump_dest = /oracle/app/oracle/admin/dm/udump
core_dump_dest = /oracle/app/oracle/admin/dm/cdump
audit_file_dest = /oracle/app/oracle/admin/dm/adump
db_name = dm
open_cursors
相关问答：
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
然後按回車鍵 說明: user/password@dbname 分別表示用戶名，密碼和服務名 f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
select sum（a.t)from ta a group by ta.a,这条语句将表ta中的数据按照a字段分组汇总t字段。
结果比如：
3 30
4 50
我想得到这个结果：
1 0
2 0
3 30
4 50
5 0
这个结果，请问sql语句怎么写？多谢
nobody ......
我是在toad中输入下段sql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
