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这个错误我在网上也查了
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号