跨平台迁移oracle(windows->Linux)创建控制文件失败
报错信息----------------------------------------------------------------------------------------
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-07202: sltln: invalid parameter to sltln.
----------------------------------------------------------------------------------------
脚本信息:
----------------------------------------------------------------------------------------
CREATE CONTROLFILE REUSE SET DATABASE orcl19 RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl2/redo01.log' SIZE 500M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl2/redo02.log' SIZE 500M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl2/redo03.log' SIZE 500M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/orcl2/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl2/system01.dbf',
'/u01/app/oracle/oradata/orcl2/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl2/users01.dbf'
CHARACTER SET ZHS16GBK
;
********************************************************************
已执行过字符检查:
********************************************************************
----------------------------------------------------------------------------------------
路径及文件创建情况:
----------------------------------------------------------------------------------------
数据库环境及连接:
----------------------------------------------------------------------------------------
请老师指导
该脚本,需要dos2unix转linux格式。尽量在linux下直接改脚本。这是在win下改的,也可以使用UltaEdit32转unix格式后,再传送进linux。
页:
[1]