没有仔细看,但是末尾有提示说要执行root.sh文件,但是没有提醒要执行rootpre.sh文件,
试试这个文件吧,源地址上也没有了,只好去安装软件的压缩包里面重新解压取这个文件,需要ROOT权限才能运行,SA协助,解决了!!
又碰到一个问题,
建控制文件不起来,怪了第一、二个可以建起来,第三个提示路径不对,怪吧,要么一个都建不起来啊,后来发现时initSID.ora这个文件是源库拷贝内容过来的,有换行,晕!
CREATE CONTROLFILE REUSE SET DATABASE "idep2" RESETLOGS FORCE LOGGING NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/DataExchange2/oradata/id
ep2/control03.ctl'
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory
具体语句如下:
create pfile='/app/oracle/product/10.2.0/db_1/dbs/init_idep2.ora' from spfile;
idep2.__db_cache_size=4261412864
idep2.__java_pool_size=16777216
idep2.__large_pool_size=16777216
idep2.__shared_pool_size=1023410176
idep2.__streams_pool_size=33554432
*.audit_file_dest='/app/oracle/admin/idep2/adump'
*.background_dump_dest='/app/oracle/admin/idep2/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/DataExchange2/oradata/idep2/control01.ctl','/DataExchange2/oradata/idep2/control02.ctl','/DataExchange2/oradata/idep2/control03.ctl'
*.core_dump_dest='/app/oracle/admin/idep2/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='idep2'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=1174405120
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1105
*.sga_max_size=5368709120
*.sga_target=5368709120
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/app/oracle/admin/idep2/udump'
orapwd file=/app/oracle/product/10.2.0/db_1/dbs/orapwidep2 password=idep240 entries=10;
alter database backup controlfile to trace;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "idep2" RESETLOGS FORCE LOGGING NOAR