Process time out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Process time out

  1. #1
    Join Date
    Apr 2002
    Posts
    50
    I have my SQLPLUS client open and when it is inactive for maybe an hour, then I get 'end-of-file comunication channel' and I have to login again.
    Is it possible in Oracle 8i to have an upper limit for the time period when a process can remain inactive ?

    Shiva.

  2. #2
    Join Date
    Aug 2001
    Posts
    75
    May be your DBA's has set up a profile which timesout session if you are inactive for a certain period of time. The default values are UNLIMITED but It may be that DBA's has created a new profile and assigned that profile to the user.

    You can query dba_users to find out which profile has been assigned to you and also query dba_profiles to find out information about profile.

    Sanjay

    Originally posted by Shiva
    I have my SQLPLUS client open and when it is inactive for maybe an hour, then I get 'end-of-file comunication channel' and I have to login again.
    Is it possible in Oracle 8i to have an upper limit for the time period when a process can remain inactive ?

    Shiva.
    OCP 8i

  3. #3
    Join Date
    Apr 2002
    Posts
    50
    Thanks for your reply Sanjay.
    Well, I have been assigned the defaul user profile, with unlimited IDLE_TIME & CONNECT_TIME.
    Could anything else be the reason ?

    Shiva.

  4. #4
    Join Date
    Aug 2001
    Posts
    75
    Are you sure that your database does not go down. This error usually comes when you are connected and then your database goes down and then you will see this error
    "end-of-file comunication channel"

    Please check your alert.log to find out please database was shutdown. Which Version of Oracle you are using ?

    Sanjay
    OCP 8i

  5. #5
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    No no this is not b'cos the db has gone down, this happens very frequently to me also(with several instances), I once tried to find out the reason for this but got nowhere, yes the profile everything seems to be fine, I would be really thankful if someone solves this mystery.
    KN

  6. #6
    Join Date
    Apr 2002
    Posts
    50
    That is what I too thought at the beginning, but no, the database is not down. The database is up and running but I get an 'end-of-file........' error. I am running Oracle8i and there is only one instance.

    Any thoughts towards this issue is greatly appreciated.

    Shiva.

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    A network connection loss may also cause this problem;

    Sanjay

  8. #8
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Somebody could have killed your process. This also generates the error.

    Vijay.
    Say No To Plastics

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width