1 2 Previous Next 25 Replies Latest reply: Mar 6, 2011 11:22 AM by Nicolas.Gasparotto RSS

    PeopleSoft HCM 9.1 Installation (OVM Templates)

    586608
      Hi there,


      I've been struggling with the second part of the PeopleSoft HCM 9.1 OVM Templates installation - App-Batch.

      Could Not sign on to database PSHCM91 with user PS
      I've tried all I could see below:
      SELECT roleuser, rolename
      FROM psroleuser
      WHERE rolename in ('PeopleSoft Administrator', 'Portal Administrator');
      
      ROLEUSER   ROLENAME
      --------------    ----------------------------------
      PS              PeopleSoft Administrator
      PSEM          PeopleSoft Administrator
      PSHC          PeopleSoft Administrator
      LSNRCTL status
      brings PSHCM91.corp.peoplesoft.com, I configured the tnsnames on both sides to SERVICE_NAME=PSHCM91.corp.peoplesoft.com
      Checked the tnsnames, everything's ok.

      Can anyone please share more knowledge on this for me.


      Thanks.


      Creems
        • 1. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
          Nicolas.Gasparotto
          Thread moved to dedicated PSOVM forum : <a href=http://forums.oracle.com/forums/forum.jspa?forumID=830&start=0>Forum Home » PeopleSoft Enterprise » PeopleSoft OVM Templates</a>
          Please, follow up there, this is tracked by Oracle people.

          Nicolas.
          • 2. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
            Nicolas.Gasparotto
            Are the images downloaded recently (after Jan-2011) ? By the past there was an issue on password lifetime of PEOPLE and SYSADM, please read that article below and let me know if that applies to you :
            http://gasparotto.blogspot.com/2010/03/psovm-sysadms-password-policy.html
            Or that thread as well might help you (similar case) :
            Suddenly not able to start up the appserver? SQL library error

            Nicolas.
            • 4. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
              Nicolas.Gasparotto
              Please, confirm you're able to connect onto the database from the Apps server.

              Nicolas.
              • 5. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                586608
                Hi Nicholas,

                select username,account_status,expiry_date,profile
                from   dba_users
                where username in ('PEOPLE','SYSADM');
                
                
                
                USERNAM ACCOUN EXPIRY_D PROFILE
                ------- ------ -------- --------
                PEOPLE  OPEN            DEFAULT
                SYSADM  OPEN            DEFAULT
                ANd here is the specific error I am getting:
                Do you wish to see the error messages in the APPSRV.LOG file? (y/n) [n] :y
                
                PSADMIN.2386 (0) [02/28/11 03:58:05](0) Begin boot attempt on domain APPDOM
                PSAPPSRV.2399 (0) [02/28/11 03:58:15](0) PeopleTools Release 8.50.02 (Linux) starting. Tuxedo server is APPSRV(99)/1
                PSAPPSRV.2399 (0) [02/28/11 03:58:15](0) Cache Directory being used: /home/psadm2/ps/pt/8.50/appserv/APPDOM/CACHE/PSAPPSRV_1/
                PSAPPSRV.2399 (0) [02/28/11 03:58:15](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSHCM91 with user PS.
                PSAPPSRV.2399 (0) [02/28/11 03:58:15](0) Server failed to start
                PSADMIN.2386 (0) [02/28/11 03:58:23](0) End boot attempt on domain APPDOM
                And I can also log on to oracle using sysadm from App-Batch.
                • 6. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                  Nicolas.Gasparotto
                  Ok, you're working with previous PSOVM HCM version (not the latest one working on PT8.51.02).
                  Do you have a stdout and/or stderr file in $PS_CFG_HOME/appserv/APPDOM(/LOGS) ? What's the content of them ?

                  Nicolas.
                  • 8. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                    586608
                    Hi Nicholas,

                    I realized that you used the same version of OVM I used as well from your blog:
                    http://gasparotto.blogspot.com/2009/11/peoplesoft-vm-about-appbatch-image.html

                    OVM_EL5U2_X86_64_AB85002_HCM91_PVM

                    How did you get it to work?


                    I really need this to work, I've done the installation a couple of times thinking I did some mistakes but no I didn't.


                    Thanks.

                    Creems
                    • 9. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                      586608
                      And below is the tuxedo log file:
                      Do you wish to see the error messages in the TUXLOG.022811 file? (y/n) [n] :y
                      
                      052655.psoftappb.alliance.com!PSADMIN.2494: Begin  attempt on domain APPDOM
                      052659.psoftappb.alliance.com!tmadmin.2531.729595040.-2: TMADMIN_CAT:1330: INFO: Command: boot -A
                      052701.psoftappb.alliance.com!tmboot.2532.1713624608.-2: 02-28-2011: Tuxedo Version 10.3.0.0, 64-bit
                      052701.psoftappb.alliance.com!tmboot.2532.1713624608.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds
                      052701.psoftappb.alliance.com!tmboot.2532.1713624608.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
                      052703.psoftappb.alliance.com!BBL.2533.1728818272.0: 02-28-2011: Tuxedo Version 10.3.0.0, 64-bit, Patch Level (none)
                      052703.psoftappb.alliance.com!BBL.2533.1728818272.0: LIBTUX_CAT:262: INFO: Standard main starting
                      052705.psoftappb.alliance.com!tmboot.2536.985744928.-2: 02-28-2011: Tuxedo Version 10.3.0.0, 64-bit
                      052705.psoftappb.alliance.com!tmboot.2536.985744928.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds
                      052705.psoftappb.alliance.com!tmboot.2536.985744928.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
                      052705.psoftappb.alliance.com!PSWATCHSRV.2537.2082594400.-2: 02-28-2011: Tuxedo Version 10.3.0.0, 64-bit
                      052705.psoftappb.alliance.com!PSWATCHSRV.2537.2082594400.-2: LIBTUX_CAT:262: INFO: Standard main starting
                      052705.psoftappb.alliance.com!PSAPPSRV.2538.4109624272.0: 02-28-2011: Tuxedo Version 10.3.0.0, 64-bit
                      052705.psoftappb.alliance.com!PSAPPSRV.2538.4109624272.0: LIBTUX_CAT:262: INFO: Standard main starting
                      052706.psoftappb.alliance.com!PSAPPSRV.2538.4109624272.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
                      052706.psoftappb.alliance.com!tmboot.2536.985744928.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
                      052710.psoftappb.alliance.com!BBL.2533.1728818272.0: CMDTUX_CAT:26: INFO: The BBL is exiting system
                      052713.psoftappb.alliance.com!PSADMIN.2494: End boot attempt on domain APPDOM
                      • 10. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                        Nicolas.Gasparotto
                        Could you post the content of /etc/hosts from both apps and db servers ?

                        Nicolas.
                        • 11. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                          Nicolas.Gasparotto
                          And also, check ps.psdbowner in the db. Connect onto the db with user people, and check if you have access to psaccessprfl, psoprdefn.

                          Nicolas.
                          • 12. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                            Michel
                            Please set the logfence to 5 in the Appserver configuration and the TraceSQL to 15. That way we can find some more details on whats causing the error. I suspect that Nicolas is right about the psdbowner table.
                            • 13. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                              586608
                              Nicholas,

                              Please see below:

                              */etc/hosts*
                              
                              +*DB Server:*+
                              127.0.0.1       localhost.localdomain   localhost
                              ::1     localhost6.localdomain6 localhost6
                              192.168.0.30    psoft.alliance.com psoft
                              192.168.0.31    psoftappb.alliance.com psoftappb
                              
                              
                              +*App-Batch Server:*+
                              127.0.0.1       localhost.localdomain   localhost
                              ::1     localhost6.localdomain6 localhost6
                              192.168.0.31    psoftappb.alliance.com psoftappb
                              192.168.0.30    psoft.alliance.com psoft
                              +*Log on from App Serv with user people:*+
                              
                              PEOPLE@pshcm91> select * from ps.psdbowner;
                              
                              DBNAME     OWNERID
                              ------------     -------------
                              pshcm91     SYSADM
                              
                              
                              +*Describe and SELECT statement from psaccessprfl:*+
                              
                              PEOPLE@pshcm91> desc psaccessprfl
                              ERROR:
                              *ORA-04043: object psaccessprfl does not exist*
                              
                              
                              PEOPLE@pshcm91> select * from psaccessprfl;
                              select * from psaccessprfl
                                            *
                              ERROR at line 1:
                              *ORA-00942: table or view does not exist*
                              
                              
                              +*Describe and SELECT statement from psoprdefn:*+
                              
                              PEOPLE@pshcm91> desc psoprdefn
                              ERROR:
                              ORA-04043: object psoprdefn does not exist
                              
                              
                              PEOPLE@pshcm91> select * from psoprdefn;
                              select * from psoprdefn
                                            *
                              ERROR at line 1:
                              ORA-00942: table or view does not exist
                              Conclusion: User people cannot access any of those tables.


                              Where do I go from here please?


                              Thanks for your time.


                              Creems
                              • 14. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
                                Nicolas.Gasparotto
                                Something went wrong somewhere, but the dbname in PSDBOWNER must be in upper case. Try to update the table as following :
                                update ps.psdbowner set dbname=upper(dbname);
                                commit;
                                And retry to start your apps.

                                Nicolas.
                                1 2 Previous Next