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这个错误我在网上也查了
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/511486.html
微信扫一扫 
支付宝扫一扫 
