I am trying to run utlrp.sql on an oracle database version 9.2.0.6
running on IBM AIX 5.2 .
I receive Ora-3113 disconnection messages during execution of the
script.
Am receiving Ora-7445 [][][][][] during execution of catproc which also
terminates the connection as an end result.
I have executed the slibclean command on the O.S after shutdown all the
instances as per one of the solutions but to no avail.
Any help guys

Regards

Without looking at parameter settings, and hardware specs, the only
guess anyone can make is your database is seriously whacked, and you
have severe virtual memory problems

--
Sybrand Bakker
Senior Oracle DBA

> Am receiving Ora-7445 [][][][][] during execution of catproc which also
> terminates the connection as an end result.

Is there a parameter in the first set of brackets? Or are all of the
brackets empty? If there is a parameter in the first set of brackets,
then do a search for "ORA 7445 parameter_value" in Metalink. If you do
not have access to Metalink, then you might want to do a Google search.

When you run catproc, make sure you are running this as SYS, not SYSTEM.
You may already know this.


HTH,
Brian



--
================================================== =================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Hi ,
I have run the commands as SYS .....
Is there any way i could make the Db work ...
There are a couple of other Db's on the same box ,which do not cry
foul...
I even shutdown all the instances and restarted the server(for any leak
in memory issues) and the db's but the problem still persists.

Regards

> I have run the commands as SYS .....

Then that isn't the problem.

> Is there any way i could make the Db work ...

Did you read what I posted before?

>> Am receiving Ora-7445 [][][][][] during execution of catproc which also
>> terminates the connection as an end result.
>
> Is there a parameter in the first set of brackets? Or are all of the
> brackets empty? If there is a parameter in the first set of brackets,
> then do a search for "ORA 7445 parameter_value" in Metalink. If you do
> not have access to Metalink, then you might want to do a Google search.

Do you have any followup with respect to the above?

Thanks,
Brian

--
================================================== =================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Hi Brian,

Like said , the Ora-7445 has no values in the brackets .
I even tried the slibclean (clean of kernel memory )
option as per one of the metalink notes for IBM .
But the error still exists ....


Regards
Keith

Lord'N'Master wrote:
> Hi Brian,
>
> Like said , the Ora-7445 has no values in the brackets .
> I even tried the slibclean (clean of kernel memory )
> option as per one of the metalink notes for IBM .
> But the error still exists ....

Well, as long as we're playing 20 questions...

Did you try it after rebooting the server and before bringing up the
other databases?
Before bringing up any databases, does ipcs show anything owned by
oracle?
Are there any trace files?
Do the trace files show any lines that say things like Exception
Signal?
Is there anything in the alert log?
What is your large pool set to?
How much swap do you have defined?
How big are all your SGA's?
Is your ulimit different for that database environment?
What does vmstat say?
Are all databases running under a single set of executables?
What does ldd say about the oracle executable?
lsattr -E -l sys0
Have you checked metalink Note:282036.1 lately?
Have you checked metalink Note:69642.1 lately?

jg
--
@home.com is bogus.
http://news.bbc.co.uk/1/hi/entertainment/4774429.stm