Home » RDBMS Server » Server Administration » transportable tablespace RHEL to Solaris (Oracle 10g R2/ Linux 6.2, Solaris 10)
transportable tablespace RHEL to Solaris [message #663725] Thu, 15 June 2017 05:08 Go to next message
reym21
Messages: 201
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day!

Can you please advise me on what to do next.

I'm transporting a non-critical production database from Linux to Solaris.
I completed the prerequisites prior to importing the export dump file
from source server (Linux) to the destination server (Solaris).

My import datapump failed many times due to this 2 recurring errors:
1) ORA-29349- 'tablespace already exist' (data/index tablespaces recreated to the destination server); &
2) ORA-27037- 'unable to obtain file status' (whenever I dropped the affected tablespace).

Please refer to the attached logs.

Thank you & best regards,

[Updated on: Thu, 15 June 2017 05:11]

Report message to a moderator

Re: transportable tablespace RHEL to Solaris [message #663727 is a reply to message #663725] Thu, 15 June 2017 05:24 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
In your attachment you say
** AFFECTED DATAFILE RECREATED BEFORE DATA PUMP EXECUTION **
and
** AFFECTED INDEX DATAFILE DROPPED PRIOR TO DATA PUMP EXECUTION **
What are you actually doing? How do you recreate or drop this datafile? Why have you not simply dropped the tablespaces before attempting the transport?
Re: transportable tablespace RHEL to Solaris [message #663767 is a reply to message #663727] Fri, 16 June 2017 21:15 Go to previous messageGo to next message
reym21
Messages: 201
Registered: February 2010
Location: Philippines
Senior Member

@John Watson

Sir,
I'm still encountering this same error, re: ORA-27037- unable to obtain file status, '/dtaarea2/oracle/datafiles/site/site_data_01.dbf'.

The only tablespaces existing are SYSTEM, SYSAUX, USERS, UNDO & TEMP.

Thank you for your prompt advise.

Re: transportable tablespace RHEL to Solaris [message #663769 is a reply to message #663767] Sat, 17 June 2017 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-27037: unable to obtain file status
 *Cause:  stat system call returned an error, additional information
          indicates which function encountered the error
 *Action: check errno
Re: transportable tablespace RHEL to Solaris [message #663772 is a reply to message #663767] Sat, 17 June 2017 03:26 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
reym21 wrote on Sat, 17 June 2017 03:15
@John Watson

Sir,
I'm still encountering this same error, re: ORA-27037- unable to obtain file status, '/dtaarea2/oracle/datafiles/site/site_data_01.dbf'.

The only tablespaces existing are SYSTEM, SYSAUX, USERS, UNDO & TEMP.

Thank you for your prompt advise.

You want "prompt advice"? In that case, pay a consultant.
Re: transportable tablespace RHEL to Solaris [message #664788 is a reply to message #663772] Thu, 03 August 2017 10:46 Go to previous message
Bill B
Messages: 1695
Registered: December 2004
Senior Member
you have corrupted your database by dropping the Datafile. Either recover the datafile by going through recovery using your backup. If you don't have backup then drop and recreate the database. create the tablespaces where you want them on the new server. You can now run IMPDP. Ignore the errors about the tablespace already existing, it doesn't hurt anything. As long as the tablespace name is the same as what it is in the export file it will happily make the objects and import the data. most IMPDP runs have some errors showing. Not a big deal.

[Updated on: Thu, 03 August 2017 10:46]

Report message to a moderator

Previous Topic: creating a database link between 12c and 8i
Next Topic: Cleaning Database after development and tests
Goto Forum:
  


Current Time: Wed Nov 22 21:53:35 CST 2017

Total time taken to generate the page: 0.06472 seconds