Oracle Backup from cloned VM server

[BenLoosli]

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?

[d_graham]

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

[BenLoosli]

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.

[d_graham]

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

[BenLoosli]

When I open SQL Developer, I then scroll down to the Directories folder and select the DB_DUMP (my name for the dump directory) and it displays the Owner, Direectory_name, Directory Path and Origin_Con_ID. The path has no machine associated with it. It is pointing to a valid folder on this machine: e:\util\backup. I have created a new Mydir directory that points to the e:\ root folder and this also wrote the files back across the network to the source machine.

One thing I have not tried yet is to create a new disk folder that does not exist on the source machine and then create a new Oracle dump directory that points to it and see what happens. 

[BenLoosli · Accepted solution]

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.