topic Re: Oracle 9.2.0 Error in Operating System - HP-UX

Oracle 9.2.0 Error

S.K. Chan — Thu, 12 Aug 2004 14:28:48 GMT

I got Oracle 9.2.0 running on HPUX 11i. I got this error everytime I run RMAN. Anyone had or seen this problem before ?
.........
RMAN-12001: could not open channel d1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "XXXXXXX"
ORA-27102: out of memory
HP-UX Error: 12: Not enough space
Additional information: 103
Additional information: 33554432
Additional information: -1073744416
.........
Thanks !!

Re: Oracle 9.2.0 Error

Steven E. Protter — Thu, 12 Aug 2004 14:36:42 GMT

All i can find is metalink

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=421212.999

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=114429.1

The second article indicates possible issues with memory. If there are a lot of database instances open and shared memory is short, that is an avenue of investigation.

I've also gotten that on a box that didn't have enough free swap space.

I'd consdier bumping up SHMMAX to a higher figure, not exceeding the 25% of memory figure at which HP-UX ignores the setting.

Since you are a fellow salad head, I'm making some assumptions.

SEP

Re: Oracle 9.2.0 Error

Yogeeraj_1 — Fri, 13 Aug 2004 01:10:08 GMT

hi,

can you please confirm if this used to work before?

if this is something new, can you please post the rman commands you are using....

thanks
Yogeeraj

Re: Oracle 9.2.0 Error

S.K. Chan — Thu, 26 Aug 2004 18:30:34 GMT

Better late than never ..

It turns out there is a memory leak with the intelligent agent (dbsnmp).

Thanks for all your time !