[转帖]oracle异构平台数据库迁移 Linux到Windows 10g到11g_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2117 | 回复: 2

主题： [转帖]oracle异构平台数据库迁移 Linux到Windows 10g到11g

zhsgood

注册用户

等级：列兵
经验：102
发帖：70
精华：0
注册：2011-11-28
状态：离线
发送短消息息给zhsgood

加好友发送短消息息给zhsgood

发消息

发表于：

2015-1-20 17:55:07 | [全部帖] [楼主帖]

楼主

楼主发表于： 2015-01-15 15:23:44

SQL> startup nomount pfile="d:\u01\app\oracle\product\10.2.0\db_1\dbs\initmyora.
ora"

LRM-00116: ')'后跟 'TCP' 时出现语法错误
ORA-01078: 处理系统参数失败

贴出参数文件

# Please change the values of the following parameters:
control_files            = "d:\u01\app\oracle\oradata\cf_D-MYORA_id-2779386184_00ps50a3"
db_create_file_dest    = "d:\u01\app\oracle\oradata
db_recovery_file_dest    = "d:\u01\app\oracle\product\10.2.0\db_1\dbs\flash_recovery_area"
db_recovery_file_dest_size= 3221225472
background_dump_dest     = "d:\u01\app\oracle\product\10.2.0\db_1\dbs\bdump"
user_dump_dest           = "d:\u01\app\oracle\product\10.2.0\db_1\dbs\udump"
core_dump_dest           = "d:\u01\app\oracle\product\10.2.0\db_1\dbs\cdump"
audit_file_dest          = "d:\u01\app\oracle\product\10.2.0\db_1\dbs\adump"
db_name                  = "MYORA"
# Please review the values of the following parameters:
__shared_pool_size       = 96468992
__large_pool_size        = 4194304
__java_pool_size         = 4194304
__streams_pool_size      = 4194304
__db_cache_size          = 167772160
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers              = "(PROTOCOL=TCP) (SERVICE=myoraXDB)"
# The values of the following parameters are from source database:
processes                = 150
nls_language             = "SIMPLIFIED CHINESE"
nls_territory            = "CHINA"
sga_target               = 285212672
db_block_size            = 8192
db_16k_cache_size        = 4194304
compatible               = "10.2.0.1.0"
# log_archive_dest_1       = "d:\u01\app\oracle\archive\arc01.log mandatory reopen=400"
# log_archive_dest_2       = "d:\u01\app\oracle\archive\arc02.log"
log_archive_dest_state_2 = "DEFER"
log_archive_dest_state_3 = "DEFER"
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
db_file_multiblock_read_count= 16
db_flashback_retention_target= 7200
undo_management          = "AUTO"
undo_tablespace          = "UNDOTBS2"
undo_retention           = 600
# utl_file_dir             = "d:\u01\app\oracle\logminer"
job_queue_processes      = 10
open_cursors             = 300
pga_aggregate_target     = 94371840

--友情转载