Oracle ADDM shows Virtual Memory Paging on 10gR2 11gR2

March 9, 2012 by 9 Comments 

Problem description

I’ve recently notices a common issue on Oracle Enterprise Linux 5.x with Oracle database 10gR2 and 11gR2. The Oracle ADDM Performance Analysis showed the following alert as a top event  in both OEM console – Virtual Memory Paging and in the ADDM report – Significant virtual memory paging was detected on the host operating system.

Problem Analysis

From the first look I thought this was a virtual memory issue on the boxes but on the other hand I could not find any evidence at OS level of any problem with virtual memory paging. Additionally I was surprised that the issue occurred at the same time on different servers and Oracle versions. So, below I did some checks to prove there was no memory issue on these Linux boxes. Read more »

Oracle Data Pump (expdp) schema export fails with ORA-01801

November 29, 2011 by 3 Comments 

Platform

Oracle Database Server 10gR2 (10.2.0.5)

Problem

Data Pump (expdp) schema export fails on Oracle 10gR2 with following Oracle error:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
ORA-01801: date format is too long for internal buffer
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
Read more »

Oracle Listener refused connection ORA-12519 troubleshooting

November 11, 2011 by 13 Comments 

Platform

Oracle database 11gR2 (11.2.0.2.2)

Problem

New database connection attempts to Oracle database 11gR2 fail with following Oracle error:

Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found   [SQLCode: 12519], [SQLState: 66000] None None

Read more »

Oracle 11gR2 client installation on Windows 7 troubleshooting

October 14, 2011 by 16 Comments 

Problem

Installation of Oracle 11gR2 client on Windows 7 32-bit using Oracle Universal Installer (OUI) failing on prerequisite with below mentioned error. Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email