data guard配置过程中,我将主数据库的datafile,archive log以及control file拷到备用站点上,并对备用数据库的初始化文件修改,在用startup nomount pfile=d:\oracle\admin\stbytest0\pfile\stbytest0init.ora命令启动备用库时ORACLE报错:ORA-01041: 内部错误,hostdef 扩展名不存在的问题。 stbytest0init.ora文件如下:
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
############################################################################## ###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=test0XDB)" ###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE ###########################################
# Job Queues
###########################################
job_queue_processes=10 ###########################################
# Instance Identification
###########################################
instance_name=stbytest0 ###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.0.0 ###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE ###########################################
# Archive
###########################################
standby_archive_dest='d:\oracle\oradata\stbytest0\stbyarchive'
log_archive_dest_1='LOCATION=D:\oracle\oradata\stbytest0\archive'
log_archive_format=%t_%s.dbf
log_archive_start=true ###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=10485760 ###########################################
# Database Identification
###########################################
db_domain=""
db_name=test0 ###########################################
# File Configuration
###########################################
control_files=("D:\oracle\ora92\stbytest0\stbytest0-1.ctl", "D:\oracle\ora92\stbytest0\stbytest0-2.ctl", "D:\oracle\ora92\stbytest0\stbytest0-3.ctl") ###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648 ###########################################
# Cursors and Library Cache
###########################################
open_cursors=300 ###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1 ###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\stbytest0\bdump
core_dump_dest=D:\oracle\admin\stbytest0\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\stbytest0\udump ###########################################
# Processes and Sessions
###########################################
processes=150 ###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300 ###########################################
# Cache and I/O
###########################################
db_block_size=16384
db_cache_size=25165824
db_file_multiblock_read_count=16
fal_server=stbytest0
fal_client=test0 spfile=d:\oracle\ora92\database\spfilestbytest0.ora
主数据库名为test0,备用数据库名为stbytest0 备用数据库的tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools. OEMREP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP2)
(INSTANCE_NAME = oemrep2)
)
) STBYTEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stbytest0)
)
) TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
(INSTANCE_NAME = test2)
)
) TEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test0)
)
) ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) 其中STBYTEST0为备用数据库的服务名,主数据库站点名为yk,备用数据库站点名为yk2,
各位帮忙看一下,先谢了!!!备用数据库的tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools. OEMREP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP2)
(INSTANCE_NAME = oemrep2)
)
) STBYTEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = STBYTEST0)
)
) TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
(INSTANCE_NAME = test2)
)
) TEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test0)
)
) ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora文件如下: # LISTENER.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools. LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
) SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oemrep2)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = oemrep2)
)
(SID_DESC =
(GLOBAL_DBNAME = test2)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = test2)
)
(SID_DESC =
(GLOBAL_DBNAME = STBYTEST0)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = STBYTEST0)
)
)哪位知到的话帮忙指点一下,分数不够可以再加,先谢了!!!
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
############################################################################## ###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=test0XDB)" ###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE ###########################################
# Job Queues
###########################################
job_queue_processes=10 ###########################################
# Instance Identification
###########################################
instance_name=stbytest0 ###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.0.0 ###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE ###########################################
# Archive
###########################################
standby_archive_dest='d:\oracle\oradata\stbytest0\stbyarchive'
log_archive_dest_1='LOCATION=D:\oracle\oradata\stbytest0\archive'
log_archive_format=%t_%s.dbf
log_archive_start=true ###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=10485760 ###########################################
# Database Identification
###########################################
db_domain=""
db_name=test0 ###########################################
# File Configuration
###########################################
control_files=("D:\oracle\ora92\stbytest0\stbytest0-1.ctl", "D:\oracle\ora92\stbytest0\stbytest0-2.ctl", "D:\oracle\ora92\stbytest0\stbytest0-3.ctl") ###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648 ###########################################
# Cursors and Library Cache
###########################################
open_cursors=300 ###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1 ###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\stbytest0\bdump
core_dump_dest=D:\oracle\admin\stbytest0\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\stbytest0\udump ###########################################
# Processes and Sessions
###########################################
processes=150 ###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300 ###########################################
# Cache and I/O
###########################################
db_block_size=16384
db_cache_size=25165824
db_file_multiblock_read_count=16
fal_server=stbytest0
fal_client=test0 spfile=d:\oracle\ora92\database\spfilestbytest0.ora
主数据库名为test0,备用数据库名为stbytest0 备用数据库的tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools. OEMREP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP2)
(INSTANCE_NAME = oemrep2)
)
) STBYTEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stbytest0)
)
) TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
(INSTANCE_NAME = test2)
)
) TEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test0)
)
) ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) 其中STBYTEST0为备用数据库的服务名,主数据库站点名为yk,备用数据库站点名为yk2,
各位帮忙看一下,先谢了!!!备用数据库的tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools. OEMREP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP2)
(INSTANCE_NAME = oemrep2)
)
) STBYTEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = STBYTEST0)
)
) TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
(INSTANCE_NAME = test2)
)
) TEST0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test0)
)
) ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora文件如下: # LISTENER.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools. LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yk2)(PORT = 1521))
) SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oemrep2)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = oemrep2)
)
(SID_DESC =
(GLOBAL_DBNAME = test2)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = test2)
)
(SID_DESC =
(GLOBAL_DBNAME = STBYTEST0)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = STBYTEST0)
)
)哪位知到的话帮忙指点一下,分数不够可以再加,先谢了!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货