Help - Search - Members - Calendar
Full Version: Error 0ra-12518
Oracle DBA Forums > Oracle > Oracle Forum
Manny
When performing impdp, I get this error ORA-12518: (TNS:listener could not hand off client connection). I have set auto memory management, why does it not allocate more memory to large_pool. What can I do to address this issue.

Thank you.
HAL9000
Manny,

"I have set auto memory management"

Not a good idea, it's buggy. I would go back to manual:

http://www.dba-oracle.com/t_amm_automatic_memory_resize.htm

"why does it not allocate more memory to large_pool. "

Are you setting the "buffers" import parm?

It could be many things, but I'll bet if you turn-off AMM it will work. Here are other common causes of the ORA-12518 error:

http://www.dba-oracle.com/sf_ora_12518_tns..._connection.htm
Manny
QUOTE (HAL9000 @ Jul 10 2008, 03:45 PM) *
Manny,

"I have set auto memory management"

Not a good idea, it's buggy. I would go back to manual:

http://www.dba-oracle.com/t_amm_automatic_memory_resize.htm

"why does it not allocate more memory to large_pool. "

Are you setting the "buffers" import parm?

It could be many things, but I'll bet if you turn-off AMM it will work. Here are other common causes of the ORA-12518 error:

http://www.dba-oracle.com/sf_ora_12518_tns..._connection.htm


Am using impdp (datapump) is there a buffer parameter for datapump?
HAL9000
"is there a buffer parameter for datapump?"

Sorry, yes.

You can control input buffers with impdp using the "buffer" parm. Also, there are other parms that control allocated memory:

http://www.dba-oracle.com/oracle_tips_load_speed.htm

It makes a big difference in load time:

Import Option
Elapsed Time (Seconds)
Time Reduction

commit=y
120
-

commit=y
buffer=64000
100
17%

commit=n
buffer=30720
72
40%

commit=N
buffer = 64000
67
44%
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.