oracle异构平台数据库迁移 Linux到Windows 10g到11g

[w612994378]

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

[美到心痛]

把dispatchers = "(PROTOCOL=TCP) (SERVICE=myoraXDB)" 这一行先删了试试