OraFAQ Forum: Server Utilities » tablespace import hangs

Home » RDBMS Server » Server Utilities » tablespace import hangs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tablespace import hangs [message #265974]

Sat, 08 September 2007 04:57

orcl dba
Messages: 68
Registered: August 2005

Member

Hi all,
I am migrating a 10.2.0.2 database(its an SAP database) from Solaris to Suse Linux SLES10.1. We are migrating the database using brtools as specified by SAP. The following are the steps:
1.Create the the database with the system,sysaux,temp and undo tablespaces.
2.Put the tablespaces in read-only mode on the source system and convert the datafiles using the rman "convert datafile from platform" command.
3.Perform the global import using the following options:
exp system/manager full=y,rows=n,indexes=n,constraints=n,statistics=none,ignore=y,buffer=10485760,file=exp.dmp
4.Once the full import was done on the target, I started the tablespace import using the command
imp \'sys/change_on_install as sysdba\' parfile=imp.par
Follwing are the contents of the parfile
transport_tablespace=y
statistics=none
buffer=10485760
tablespaces=("ts1","ts2","ts3")
datafiles=('/u01/oradata/db1/data1','/u01/oradata/db1/data2',......)
The tablespace import just hangs there forever not doing anything. Any inputs as to what might be wrong?

Report message to a moderator

Re: tablespace import hangs [message #265979 is a reply to message #265974]

Sat, 08 September 2007 07:44

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Activate trace mode for the import and see what he is doing/waiting for.

Regards
Michel

Report message to a moderator

Re: tablespace import hangs [message #265980 is a reply to message #265979]

Sat, 08 September 2007 08:19

orcl dba
Messages: 68
Registered: August 2005

Member

Hi Michel,
Thanks for the reply. How do I activate trace mode for import?

Report message to a moderator

Re: tablespace import hangs [message #265985 is a reply to message #265974]

Sat, 08 September 2007 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How do I activate trace mode for import?
One way would be via a logon trigger.
Search this board for a thread started by me with a Title similar to "logon trigger not firing" for sample code.

Report message to a moderator

Re: tablespace import hangs [message #265988 is a reply to message #265985]

Sat, 08 September 2007 09:11

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Or you can create import.sql script and add below two lines.

SQL> alter session set tracefile_identifier=my_import_trace_file;

alter session set events '10046 trace name context forever, level 4';

Regards
Taj

Report message to a moderator

Re: tablespace import hangs [message #265990 is a reply to message #265988]

Sat, 08 September 2007 09:33

orcl dba
Messages: 68
Registered: August 2005

Member

My alert log file reports the following error: ORA-07445: exception encountered: core dump [__GI_raise()+53] [SIGIOT] [unknown code] [0x3EA00006300] [] []
After going through metalink, I found that its a bug encountered while doing tablespace imp/exp.The doc is 6057615
Can someone throw light on how to go about this issue?

Report message to a moderator

Re: tablespace import hangs [message #265992 is a reply to message #265990]

Sat, 08 September 2007 10:21

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you do what is indicated at the bottom of the Metalink note?
If so, then raise a SR.
Noone can told how to workaround an Oracle bug but Oracle itself.

Regards
Michel

Report message to a moderator

Previous Topic:	Entry/Exit code is optimized. cannot restore context (UNWIND 22)
Next Topic:	How to trim spaces between strings in SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:04:57 CST 2024