Re: Effect of listener on existing connections?


<groups.broberg@xxxxxxxxx> wrote in message
news:a8f8b4b1-adbb-4916-9b23-8d72f6d221ba@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Writes:

Oracle support is not giving us satisfactory results. Perhaps you can
give some answers?

We've recently upgraded our system to Oracle 10.2.0.3.0, running on
Solaris (sparc) 10 inside a ZFS zone (our previous system was Oracle
9.2.0.4.0 running on sparc Solaris 8, and was running on that for the
last 5 years). Since the upgrade 6 weeks ago, we've had two instances
where our applications (running in the same O/S environment on a
different node on the cluster) have locked up - existing connections
to Oracle become unresponsive when executing SQL (with no error
message - they just block), and attempts to create new connections are
met with the error:
"ORA-03135: connection lost contact".

How hard would it be to eliminate the zoning..?
I dont think this is related nor ZFS but if you could test w/o
these changes then youd know for sure.

I dont know why you would do this in the first place. Zones are
appropriate for some things and you generally get better
throughput from ZFS over UFS but zones just stir up the pot for me.

Dedicate the box(es) to Oracle only - dont even make a special
project for it - just use default. Keep things simple as possible.

Maybe you have reasons for all this fancy overhead but so far I see none : >

.

Relevant Pages

  • Re: Effect of listener on existing connections?
    ... Solaris 10 inside a ZFS zone (our previous system was Oracle ... throughput from ZFS over UFS but zones just stir up the pot for me. ... as different clients have different backup strategies. ...
    (comp.databases.oracle.server)
  • Oracle DB on ZFS Version 2
    ... That is not enough to convince my boss to go with ZFS for Oracle ... on the nature of your database, you may find a number of the tuneables ... We had one issue with ZFS and one with contiguous blocks of memory on ...
    (SunManagers)
  • Re: (mirroring &) ZFS: 9=no-ZFS; 10=yes?; 11=open=ZFS (improved)?
    ... Oracle dba wants a single 10MB file from a 1.5TB filesystem, ... Or a read-only mode during backup or something - kinda like Oracles ... I had the tape tech do a backup off ZFS direct to tape and then a ... Well you kinda brought up that ZFS likes things small and countered ...
    (comp.unix.solaris)
  • Re: Should Oracle buy OpenVMS?
    ... boost to bring it into the 21st century, port it to a modern platform ... If Oracle bought OpenVMS ... it gives them the option to continue Sparc or end Sparc ... could be used to build/rebuild an OpenVMS support group. ...
    (comp.os.vms)
  • Re: (mirroring &) ZFS: 9=no-ZFS; 10=yes?; 11=open=ZFS (improved)?
    ... Oracle dba wants a single 10MB file from a 1.5TB filesystem, ... Or a read-only mode during backup or something - kinda like Oracles ... to do "zfs receive" on a snapshot with a huge file in it. ... and need separate slices for each mount point. ...
    (comp.unix.solaris)