23-Emerald III

Solved

Oracle Backup from cloned VM server

5 replies
2460 views
Translate All

This is a weird one and I do have an open case with PTC but they want to close it.

I had IT clone the virtual servers for Windchill and Oracle and then ran the Rehost utility with the Rename option on the new machines. Everything looks good and runs as expected.

Until....

I went to do an Oracle expdp backup of the new VM Oracle database. I entered the commands in SQLPlus to create the directory and point it to a folder on the machine. However, when I run the expdp command, Oracle is writing the files to the source machine disk and not the target machine.

This is on WIndchill 11.0 M030 CPS16 with Oracle 12cR1.

Anyone seen this or know how to tell Oracle to use the cur rent host machine for the expdp files?

Installation

BenLoosliAnswer

23-Emerald III

Found the problem and fixed it.

The Rehost utility made a backup copy of the tnsnames file but did not update the file to the new server name.

Changed the lines in the file and now the backup is going to the right folder on the right server.

18-Opal

Ben,

I've never seen it but I can imagine what might cause it.

Did you check the value of DATA_PUMP_DIR?

If DATA_PUMP_DIR was created to include the server that would do it.

The solution would be to recreate.

If you need help getting the value of DATA_PUMP_DIR let me know.

David

Translate

Author

23-Emerald III

Can I find Data_Pump_Dir from SQL Developer?

I did a new Create Directory as <location> command on the target machine, but that still wrote the dump and log file to the source machine.

Translate

18-Opal

Using SQL Developer you can make a connection as sysdba and then run the select statement to retrieve the directory name and path.

Translate