This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Mar 6, 2011 9:22 AM by Nicolas.Gasparotto RSS

PeopleSoft HCM 9.1 Installation (OVM Templates)

586608 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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.
  • 3. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
    586608 Newbie
    Currently Being Moderated
    Thanks.

    Will do.
  • 4. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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.
  • 7. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
    586608 Newbie
    Currently Being Moderated
    Both are empty.
  • 8. Re: PeopleSoft HCM 9.1 Installation (OVM Templates)
    586608 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points