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

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

1 个解决方案

#1

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