layer.shiyu 发表于 2023-4-24 16:40:52

跨平台迁移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
;

********************************************************************
已执行过字符检查:

********************************************************************
----------------------------------------------------------------------------------------

路径及文件创建情况:

----------------------------------------------------------------------------------------

数据库环境及连接:

----------------------------------------------------------------------------------------
请老师指导

admin 发表于 2023-4-24 17:03:57

该脚本,需要dos2unix转linux格式。尽量在linux下直接改脚本。这是在win下改的,也可以使用UltaEdit32转unix格式后,再传送进linux。
页: [1]
查看完整版本: 跨平台迁移oracle(windows->Linux)创建控制文件失败