3 Replies Latest reply: Dec 18, 2012 8:59 AM by 795298 RSS

    Application Server (Process Scheduler) Not Booting

    795298
      Hello to all!

      Having a quite difficult time booting the App. Server. Not sure what is going on? Not to my knowledge has anything changed to make the App. Server not boot this time. Probably a clinch, but still want to share my frustration. I presently run an Oracle 10g DB, PeopleSoft 8.50, Windows 7 Ulimate PC and here's what I am experiencing (see below):

      Microsoft Windows [Version 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. All rights reserved.

      C:\Users\afam>cd\

      C:\>cd pt8.50\appserv

      C:\PT8.50\appserv>psadmin

      PSADMIN -- Tools Release: 8.50.14
      Copyright (c) 1988, 2009, Oracle. All rights reserved.

      --------------------------------
      PeopleSoft Server Administration
      --------------------------------


      1) Application Server
      2) Process Scheduler
      3) Search Server
      4) Service Setup
      q) Quit


      Command to execute (1-4, q): 1


      --------------------------------------------
      PeopleSoft Application Server Administration
      --------------------------------------------

      1) Administer a domain
      2) Create a domain
      3) Delete a domain
      4) Import domain configuration
      q) Quit

      Command to execute (1-4, q) : 1


      Tuxedo domain list:

      1) INNOVATI

      Select domain number to administer: 1



      --------------------------------
      PeopleSoft Domain Administration
      --------------------------------
      Domain Name: INNOVATI

      1) Boot this domain
      2) Domain shutdown menu
      3) Domain status menu
      4) Configure this domain
      5) TUXEDO command line (tmadmin)
      6) Edit configuration/log files menu
      7) Messaging Server Administration menu
      8) Purge Cache
      9) Preload File Cache
      10) Clean IPC resources of this domain
      q) Quit

      Command to execute (1-10, q) : 1


      -------------------------------
      PeopleSoft Domain Boot Menu
      -------------------------------
      Domain Name: INNOVATI

      1) Boot (Serial Boot)
      2) Parallel Boot
      q) Quit

      Command to execute (1-2, q) [q]: 1
      Attempting to boot bulletin board...
      tmadmin - Copyright (c) 2007-2008 Oracle.
      Portions * Copyright 1986-1997 RSA Data Security, Inc.
      All Rights Reserved.
      Distributed under license by Oracle.
      Tuxedo is a registered trademark.
      No bulletin board exists. Entering boot mode.
      INFO: Oracle Tuxedo, Version 10.3.0.0 with VS2005, 32-bit, Patch Level (none)
      Booting admin processes ...

      exec BBL -A :
      process id=8068 ... Started.
      1 process started.
      Attaching to active bulletin board.
      Attempting to boot ...
      INFO: Oracle Tuxedo, Version 10.3.0.0 with VS2005, 32-bit, Patch Level (none)

      Booting server processes ...

      exec PSWATCHSRV -o ".\LOGS\stdout" -e ".\LOGS\stderr" -A -- -ID 49520 -D INNOVAT
      I -S PSWATCHSRV :
      process id=6852 ... Started.
      exec PSAPPSRV -o ".\LOGS\stdout" -e ".\LOGS\stderr" -s@psappsrv.lst -- -D INNOVA
      TI -S PSAPPSRV :
      CMDTUX_CAT:1685: ERROR: Application initialization failure

      tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error ha
      ndler

      tmshutdown -qy



      ==============ERROR!================
      Boot attempt encountered errors!. Check the TUXEDO log for details.
      ==============ERROR!================

      Do you wish to see the error messages in the APPSRV.LOG file? (y/n) [n] :y

      PSADMIN.7352 (0) [12/17/12 21:00:02](0) Begin boot attempt on domain INNOVATI
      PSAPPSRV.4832 (0) [12/17/12 21:00:13](0) PeopleTools Release 8.50.14 (WinX86) st
      arting. Tuxedo server is APPSRV(99)/2
      PSAPPSRV.4832 (0) [12/17/12 21:00:14](0) Cache Directory being used: C:\PT8.50\a
      ppserv\appserv\INNOVATI\CACHE\PSAPPSRV_2\
      PSAPPSRV.4832 (0) [12/17/12 21:00:14](3) File: SQL Access ManagerSQL error. Stmt
      #: 2 Error Position: 0 Return: 1033 - ORA-01033: ORACLE initialization or shu
      tdown in progress
      PSAPPSRV.4832 (0) [12/17/12 21:00:14](1) GenMessageBox(200, 0, M): SQL Access Ma
      nager: File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return:
      1033 - ORA-01033: ORACLE initialization or shutdown in progress
      PSAPPSRV.4832 (0) [12/17/12 21:00:14](1) GenMessageBox(0, 0, M): Database Signon
      : Could not sign on to database INNOVATI with user PS.
      PSAPPSRV.4832 (0) [12/17/12 21:00:14](0) Server failed to start
      PSADMIN.7352 (0) [12/17/12 21:00:21](0) End boot attempt on domain INNOVATI


      Do you wish to see the error messages in the TUXLOG.121712 file? (y/n) [n] :y

      210002.KELVIN!PSADMIN.7352: Begin attempt on domain INNOVATI
      210006.KELVIN!tmadmin.7744.5444.-2: TMADMIN_CAT:1330: INFO: Command: boot -A
      210008.KELVIN!tmboot.7652.7332.-2: 12-17-2012: Tuxedo Version 10.3.0.0 with VS20
      05, 32-bit
      210008.KELVIN!tmboot.7652.7332.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set
      to 120 seconds
      210008.KELVIN!tmboot.7652.7332.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL op
      tion is selected
      210010.KELVIN!BBL.8068.7320.0: 12-17-2012: Tuxedo Version 10.3.0.0 with VS2005,
      32-bit, Patch Level (none)
      210010.KELVIN!BBL.8068.7320.0: LIBTUX_CAT:262: INFO: Standard main starting
      210012.KELVIN!tmboot.7248.3440.-2: 12-17-2012: Tuxedo Version 10.3.0.0 with VS20
      05, 32-bit
      210012.KELVIN!tmboot.7248.3440.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set
      to 120 seconds
      210012.KELVIN!tmboot.7248.3440.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL op
      tion is selected
      210012.KELVIN!PSWATCHSRV.6852.4148.-2: 12-17-2012: Tuxedo Version 10.3.0.0 with
      VS2005, 32-bit
      210012.KELVIN!PSWATCHSRV.6852.4148.-2: LIBTUX_CAT:262: INFO: Standard main start
      ing
      210013.KELVIN!PSAPPSRV.4832.4956.0: 12-17-2012: Tuxedo Version 10.3.0.0 with VS2
      005, 32-bit
      210013.KELVIN!PSAPPSRV.4832.4956.0: LIBTUX_CAT:262: INFO: Standard main starting

      210014.KELVIN!PSAPPSRV.4832.4956.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
      210014.KELVIN!tmboot.7248.3440.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error en
      countered; initiating user error handler
      210018.KELVIN!BBL.8068.7320.0: CMDTUX_CAT:26: INFO: The BBL is exiting system
      210021.KELVIN!PSADMIN.7352: End boot attempt on domain INNOVATI

      Press Enter to continue...


      --------------------------------
      PeopleSoft Domain Administration
      --------------------------------
      Domain Name: INNOVATI

      1) Boot this domain
      2) Domain shutdown menu
      3) Domain status menu
      4) Configure this domain
      5) TUXEDO command line (tmadmin)
      6) Edit configuration/log files menu
      7) Messaging Server Administration menu
      8) Purge Cache
      9) Preload File Cache
      10) Clean IPC resources of this domain
      q) Quit

      Command to execute (1-10, q) :

      Any help would be greatly appreciated! Thanks. Be Blessed
        • 1. Re: Application Server (Process Scheduler) Not Booting
          Herald ten Dam
          Hi,

          I think this is more a question for the Peoplesoft (https://forums.oracle.com/forums/category.jspa?categoryID=152). But half way your log the next error is there:
          2 Error Position: 0 Return:
          1033 - ORA-01033: ORACLE initialization or shutdown in progress
          So I think your database is still starting or has not been shut down correctly. Maybe the real error is in the logging of the database. But otherwise try the other forum.

          Herald ten Dam
          http://htendam.wordpress.com
          • 2. Re: Application Server (Process Scheduler) Not Booting
            795298
            Herald:

            Thanks for getting back to me! I think you are right in that this would be a question more geared toward to the Peoplesoft folks. The post is there, so thank you for that. However, you noted a key observation that led me to want to investigate more. If we look at a past post that speaks to your observation (ORACLE Initialization or shutdown in progress I believe it gave me more clues to go by. I do shared the same thought as the poster in that, the DB should have started as the service started for the DB as already. At any rate, I ran the instructed command in SQL, I got this script:

            Microsoft Windows [Version 6.1.7601]
            Copyright (c) 2009 Microsoft Corporation. All rights reserved.

            C:\Users\afam>cd\

            C:\>sqlplus/nolog

            SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 05:36:02 2012

            Copyright (c) 1982, 2005, Oracle. All rights reserved.

            SQL> connect sys/manager as sysdba
            Connected.
            SQL> shutdown immediate
            ORA-01109: database not open


            Database dismounted.
            ORACLE instance shut down.
            SQL> startup
            ORA-32004: obsolete and/or deprecated parameter(s) specified
            ORACLE instance started.

            Total System Global Area 293601280 bytes
            Fixed Size 1248600 bytes
            Variable Size 83886760 bytes
            Database Buffers 201326592 bytes
            Redo Buffers 7139328 bytes
            Database mounted.
            ORA-16038: log 1 sequence# 1337 cannot be archived
            ORA-19809: limit exceeded for recovery files
            ORA-00312: online log 1 thread 1:
            'C:\ORACLE\PRODUCT\10.2.0\ORADATA\INNOVATI\REDO01.LOG'


            SQL>

            What can be made from this observation? Be Blessed
            • 3. Re: Application Server (Process Scheduler) Not Booting
              795298
              Problem resolved! Thank God! Go to this link http://arjudba.blogspot.com/2008/07/database-startup-fails-with-error-ora.html. I just increased the db_recovery_file_dest_size