[SOLVED] Problems performing backup operation using RMAN and Oracle 11g XE

Problems performing backup operation using RMAN and Oracle 11g XE

I need to transfer my oracle 11g databases to a new machine. Both machines are using windows 7.

Already found a lot of descriptions how to do that but its really hard if you are not an oracle expert because there is always information missing.

What I tried is this:

http://www.orafaq.com/forum/t/82720/

But I get stuck at the point where to start the database again in "mounted" mode. After trying "startup mount" I always get "ORA-12514".

So, it is not possible for me, to get the database in a state where I can run the backup operation in RMAN.

Also searched for that problem an found answers what to do but not how do do that.

Thank you very much in advance for any help.

Solution

You will probably have to add your database to the listener.ora in ORACLE_HOME\network\admin

SID_LIST_LISTENER =
  (SID_LIST =
    ....
    (SID_DESC =
      (SID_NAME = YOURDATABASE)
      (ORACLE_HOME = ORACLE_HOME)
      (GLOBAL_DBNAME = YOURDATABASE)
    )
  )

After you have done that restart the listener.