时间:2021-07-01 10:21:17 帮助过:18人阅读
oracle备份
我把"d:oracleoradata"里的数据库文件夹和"d:oracleadmin"中的数据库文件夹从机器a复制到机器b中对应的文件夹,然后改了listener.ora、tnsnames.ora文件
listener.ora文件为
# listener.ora network configuration file: d:oracleora92networkadminlistener.ora
# generated by oracle configuration tools.listener =
(description_list =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc0))
)
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
)
)sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = d:oracleora92)
(program = extproc)
)
(sid_desc =
(global_dbname = jiegou)
(oracle_home = d:oracleora92)
(sid_name = jiegou)
)
(sid_desc =
(global_dbname = jiegou2)
(oracle_home = d:oracleora92)
(sid_name = jiegou2)
)
)
tnsnames.ora文件# tnsnames.ora network configuration file: d:oracleora92networkadmintnsnames.ora
# generated by oracle configuration tools.jiegou =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
(connect_data =
(service_name = jiegou)
)
)inst1_http =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(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)
)
)jiegou2 =
(description =
(address_list =
(address = (protocol = tcp)(host = wangpei)(port = 1521))
)
(connect_data =
(service_name = jiegou2)
)
)
其中jiegou2是我这边自己建的一个新数据库,应该不会有影响。
不过用plsql登录时报错ora-12500:tns:监听程序无法启动专用服务器进程
问题有两个:①按理说这种方法应该是没有问题的,估计是我没对应上oracle里的某个映射关系,不知道有没有人遇到我这种类似的问题,讨论讨论这种方法能不能做出来
②ora-12500这个错误我在网上也查了