ORA-00445: background process "PMON" did not start after 120 seconds
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: ORA-00445: background process "PMON" did not start after 120 seconds

  1. #1
    Join Date
    Nov 2002
    Posts
    9

    ORA-00445: background process "PMON" did not start after 120 seconds

    I have a wierd situation on my hands. We originally had relinked
    oracle (8.1.7) under the root user in linux by accident and when the
    database was started up, some of the processes were running as root.
    A problem for obvious reasons. So we shutdown did some relinking with
    the oracle user, changed some ownerships. Now when we try to start
    the database, it times out and we get
    ORA-00445: background process "PMON" did not start after 120 seconds
    in one of the alert logs. Looking at a log I see that the startup
    does read the init.ora file but we get no further output after
    the bdump, udump and cdump locations get set.

    We also get the ORA-03113: end-of-file on communication channel error
    but that is easily solved.

    I've all over for answers but have come up with nothing. I don't
    believe that it is an issue with the SHMMAX values or anything like
    that because the database instance was previously running ok and
    nothing has changed.

    Any ideas or suggestions on the above problem would be greatly
    appreciated. Has anyone else mistakenly linked and ran the db under
    root? Solutions?

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Did you check the permissions for the Oracle account?

    I don't have any significant experience with Linux, but I seem to remember similar issues when the Oracle account had permissions issues with the spawned processes.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Nov 2002
    Posts
    9
    Originally posted by jrpm
    Did you check the permissions for the Oracle account?

    I don't have any significant experience with Linux, but I seem to remember similar issues when the Oracle account had permissions issues with the spawned processes.


    The permissions seem to be fine. The oracle user is the owner of everything in $ORACLE_HOME/bin.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    does the oracle executable in $ORACLE_HOME/bin have the setuid permission on it?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Seems like the simplest solution would be to re-install in a different ORACLE_HOME under the "oracle" user.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Nov 2002
    Posts
    9
    Originally posted by davey23uk
    does the oracle executable in $ORACLE_HOME/bin have the setuid permission on it?
    The oracle executable does have the setuid permission.

    As far as re-installing, I'm really trying to avoid that solution. I'd rather understand the problem and solution.

  7. #7
    Join Date
    Nov 2002
    Posts
    9
    Any ideas?

  8. #8
    Join Date
    Nov 2002
    Posts
    9
    Any ideas?

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    paste trace file

  10. #10
    Join Date
    Nov 2002
    Posts
    9
    Anyone have any ideas? I'm still having the same problem.

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