(server = dedicated)
(service_name = orcl)
)
)
extproc_connection_data =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc0))
)
(connect_data =
(sid = plsextproc)
(presentation = ro)
)
)
sqlnet.ora文件为:
sqlnet.authentication_services= (nts)
names.directory_path= (hostname,tnsnames, onames)
sqlnet.expire_time=2
在主数据库和备用数据库用lsnrctl start和lsnrctl stop启动和关闭监听器.然后在主数据库用tnsping standby和在备用数据库用tnsping orcl试看两个库是否是通的.
用初始化参数文件启动数据库到mount状态下.
sql> startup mount pfile= f:\oracle\admin\standby\pfile\initstdby.ora;