1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

shifting of oracle 11G datbase from one server to another server

Discussion in 'General' started by alwarmani@gmail.com, Oct 2, 2011.

  1. Dear friends i want shift my oracle 11G database from tower server to HP rack server. i tried to copy all datafiles / redolog files in oralce home directory and started the database with pfile with nomount. the instant started when i created the database by usesing create database with existing logfile and datafile it gives the error of- Error at line 1
    ora-01092. Please help out i am new to oracle. Thanks for help
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Once you copy all database files from one server to another you do NOT try to create the database again; it exists. Use the pfile/spfile and start it, mount it and open it.