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
相关问答:
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
在执行包的时候引用oracle spatial空间函数出错,出错情况如下
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
我在开发的这个应用并发性比较高,oracle更新数据时候如何处理并发处理呢?各位大侠发表好的观点啊,在线等待!
oracle数据更新时,会自动默认行锁定,楼主不要操心,Oracle对并行处理已经很成熟了
引用
oracle ......
我是在toad中输入下段sql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
SQL code:
declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('请输入部门号和部门名:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......