Re: Calling in the Cavalry - Hanging 8i database

Johne_uk wrote:
> There are 3 control files all in diff locations

Ok.

> There are 5 logfile groups each with one logfile of 25MB

Why only one? Is archive logging turned on? What is the status of the log files when it hangs?

> The server is a e450 Sun Sparc, with quad processors and 2GB RAM
> I've never attempted to kill a session as user internal.

Try it just for fun.

> regards
> John

A few random comments?

> PARAMETERS
> ----------
> NAME TYPE VALUE
> resource_limit 1 FALSE

Why? Don't you want to use profiles to manage password reuse, timeout, complexity, etc.?

> instance_groups 2

 > active_instance_count 3

Is this OPS? That is critical to what you have been asking and I don't think you've mentioned it. And you might note the following from the Oracle documentation:

"INSTANCE_GROUPS is an Oracle Parallel Server parameter that you can specify only in parallel mode." as you have parallel server set to FALSE.
> optimizer_index_cost_adj 3 100
> optimizer_index_caching 3 0

These default values are likely a bad choice and should be optimized.

> query_rewrite_enabled 1 FALSE

Why?

> utl_file_dir 2 *

This is a security hazard. You have enabled any PL/SQL to write to any directory where the user Oracle has permissions. No doubt I could in a matter of seconds replace your $ORACLE_HOME/rdbms/admin/utlxplan.sql file with one that gave me control of SYS and SYSTEM.

A few things to think about.

It has been a very long time, more than 3 years since I've seen Oracle 8i so I hereby recuse myself from any further suggestions as others here are likely far more qualified to comment on these matters.

HTH Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond) Received on Sun May 15 2005 - 10:49:57 CDT