oracle数据库备份

WBOY
發布: 2016-06-07 17:45:53
原創
919 人瀏覽過

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这个错误我在网上也查了

相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板
關於我們 免責聲明 Sitemap
PHP中文網:公益線上PHP培訓,幫助PHP學習者快速成長!