Re: ORA-03135 running plsql locally
- From: David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>
- To: mboligan@xxxxxxxxx
- Date: Sun, 7 Oct 2012 12:08:46 +0100
In this scenario It appears that the 'server side process' has failed,
although that isn't always true.
I suggest that you inspect the alert log and the dump directories to see if
there are logs/dumps from the appropriate time that you can pass onto
Oracle support or us for interpretation.
Dave
On Wed, Oct 3, 2012 at 8:18 PM, mike boligan <mboligan@xxxxxxxxx> wrote:
> Hi,
> I am running Oracle 11.2.0.2.0 64 bit on Solaris 10. I have a process
> that runs on the database server and calls a plsql package via a shell
> script like so:
>
> sqlplus user/pass @scriptname parm1 parm2
>
> The package runs for roughly 2600 seconds and sometimes gets a ORA-03135.
> The package does not fail in the same spot every time. It does not seem to
> fail after x minutes either. I do have sqlnet.expire_time in sqlnet.ora
> on the server, not sure that helps any as this should be using IPC. I do
> see alot of log switching while the job runs, but I don't see how the
> increased activity could cause this error.
>
> Maybe I am missing something, but I don't think I should get this error
> when running a script locally on the database server. Has anyone ever seen
> a similar situation or fill me in on anything I am overlooking? I am
> trying avoid a sqlnet trace because of space concerns on where the output
> would go.
>
> TIA,
> Mike
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
