Tuesday, June 12, 2012

Converting the PeopleTools OVM Template to VirtualBox

This post assumes you already have a working database as described in Converting PeopleSoft OVM Templates to VirtualBox Guests or some other PeopleSoft PT 8.52.03 database. It also assumes that you have the cloned starting point of a base OEL with the OVM functions (steps 1 through 22 from the prior post).

The PeopleTools Image (App, Web, and Prcs)

  1. Run through steps 1 through 3 as listed here. Notice that step 3 gives the PT image the IP address of 192.168.56.51. Update your network settings and hostname to match the /etc/hosts file and make sure it matches what is in the db image.
  2. Add the following to psadm2's .bash_profile (/home/psadm2/.bash_profile):
    # psft env vars
    export PS_APP_HOME=/opt/oracle/psft/pt/apptools
    export PS_CFG_HOME=/home/psadm2/psft/pt/8.52/FSCM912
    
    export ORACLE_BASE=/opt/oracle/psft/pt/oracle-client
    export ORACLE_HOME=$ORACLE_BASE/11.2.0.x
    export ORACLE_SID=FSCM912
    
    export TUXDIR=/opt/oracle/psft/pt/bea/tuxedo
    export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib
    
    . /opt/oracle/psft/pt/tools/psconfig.sh
    
    export PATH=$TUXDIR/bin:$PATH:$ORACLE_HOME/bin
    export LANG=C
    * Special thank you to Nicolas Gasparotto for his Installation Documents. My first handful of times through the script, my app server wouldn't start. I found three issues: TUXDIR, LANG, and PATH. TUXDIR and LANG are both documented in various places on Nicolas's blog.
  3. We need to copy a few files off the PT OVM system disk. Create a mount point for /dev/sdc2, mount it, and copy the files:
    mkdir /tmp/sdc2
    mount /dev/sdc2 /tmp/sdc2
    cp -R -p /tmp/sdc2/opt/oracle /opt/
  4. Create the PS_CFG_HOME directory:
    mkdir -p /home/psadm2/psft/pt/8.52/FSCM912
    chown -R psadm2:oracle /home/psadm2/psft
    
  5. Add the tools disk image to /etc/fstab
    /dev/sdb1              /opt/oracle/psft/pt      ext3    defaults        1 3
  6. Mount the tools disk:
    mount /opt/oracle/psft/pt
  7. Update the ulimits for Weblogic's sake. Add the following to the end of /etc/security/limits.conf. I copied these values out of the system OVM disk image:
    *  hard  nofile  65536
    *  soft  nofile  65536
    *  hard  nproc   65536
    *  hard  nproc   65536
    *  hard  core    unlimited
    *  soft  core    unlimited
    *  hard memlock 50000000
    *  soft memlock 50000000
  8. The scripts will generate an app server domain named APPDOM and a process scheduler domain named PRCSDOM. If that is not preferable to you, then edit /opt/oracle/psft/vm/oraclevm-template-utils.sh. Search for APPSRVDOM=APPDOM AND PRCSDOM=PRCSDOM. Replace APPDOM and PRCSDOM with your preferred values. I just accepted the defaults.
  9. Run the template script (I ran as root): move into the /opt/oracle/psft/vm directory, export DECOUPLE_USR_GROUP, and run oraclevm-template.sh:
    sudo -i
    cd /opt/oracle/psft/vm
    export DECOUPLE_USR_GROUP=appinst
    ./oraclevm-template.sh
  10. Here is the output my system generated when I ran the script. My answers to prompts are in bold.
    [root@fscm912pt vm]# ./oraclevm-template.sh 
    Creating
    ovm_configure_pre
    No
    Current
    
    Do you wish to configure the VM for Demo Purposes [y/n]:y
    
    Do you wish to configure a Decoupled Application Home [y/n]:y
    Default
     
    Do you wish to setup PeopleSoft Application Server on this VM [y|n]: y
    CreateVirtualEnvironment
    Enter the name of the database [TESTDB]:FSCM912
    CreateVirtualEnvironment
    Enter the name of the database [TESTDB]:FSCM912
    Enter the hostname for the database server [fscm912pt]:fscm912db
    Enter the port number for the database host [1521]:
    Are you happy with your answers [y|n] : y
    
    WARN: An
     
    If this VM is connecting to a PeopleSoft database created from an Oracle VM template 
    some additional setup may be required.  We can automate these steps for you.  If you 
    are connecting to a Database that has been used before you may wish to skip this step.
    
    Do you want this additional setup to be performed? [y|n]: y
    ChangeDBUserProfiles
    Running
    Running
    Copying application server configuration files...
    Copying [/opt/oracle/psft/pt/tools/appserv/small.cfx] to [/home/psadm2/psft/pt/8.52/FSCM912/appserv/APPDOM/psappsrv.cfg]
    Stripping Annotations...
    Copying [/opt/oracle/psft/pt/tools/appserv/small.cfx] to [/home/psadm2/psft/pt/8.52/FSCM912/appserv/APPDOM/psappsrv.cfx]
    Copying Jolt repository file...
    Domain created.
    Performing load prechecks ...
    Loading validation table...
      setting DBName=FSCM912
      setting DBType=ORACLE
      setting UserId=VP1
      setting UserPswd=VP1
      setting ConnectId=people
      setting ConnectPswd=peop1e
      setting ServerName=____
      setting Port=7000
      setting Port=9000
      setting Listener Port=9100
      setting Domain ID=APPDOM
      setting Add to PATH=.
    New CFG file written with modified Startup parameters
    
    Log Directory entry not found in configuration file.
    Setting Log Directory to the default... [PS_SERVDIR/LOGS]
    Spawning disabled for server PSAPPSRV.
    WARNING: PSSAMSRV is configured with Min instance set to 1. To avoid loss of service, configure Min instance to atleast 2.
    Configuration file successfully created.
    CFG setting changes completed, loading configuration...
    Domain configuration complete.
    Created
    Performing load prechecks ...
    Loading validation table...
    
    WARNING: PSSAMSRV and PSQRYSRV are configured with Min instance set to 1. To avoid loss of service, configure Min instance to atleast 2.
    Loading new configuration...
    Domain configuration complete.
    Domain
    Starting
    
    Archived a copy of the domain configuration to /home/psadm2/psft/pt/8.52/FSCM912/appserv/APPDOM/Archive/psappsrv.cfg 
    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, 64-bit, Patch Level 043
    
    Booting admin processes ...
    
    exec BBL -A :
            process id=4048 ... Started.
    1 process started.
    Attaching to active bulletin board.
    
    > Attempting to boot ... 
    INFO: Oracle Tuxedo, Version 10.3.0.0, 64-bit, Patch Level 043
    
    Booting server processes ...
    
    exec PSWATCHSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 141117 -D APPDOM -S PSWATCHSRV :
            process id=4052 ... Started.
    exec PSAPPSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psappsrv.lst -- -D APPDOM -S PSAPPSRV :
            process id=4053 ... Started.
    exec PSAPPSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psappsrv.lst -- -D APPDOM -S PSAPPSRV :
            process id=4059 ... Started.
    exec PSQRYSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psqrysrv.lst -- -D APPDOM -S PSQRYSRV :
            process id=4065 ... Started.
    exec PSSAMSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSSAMSRV :
            process id=4069 ... Started.
    exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
            process id=4072 ... Started.
    exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
            process id=4075 ... Started.
    exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
            process id=4078 ... Started.
    exec PSBRKHND -o ./LOGS/stdout -e ./LOGS/stderr -s PSBRKHND_dflt:BrkProcess -- -D APPDOM -S PSBRKHND_dflt :
            process id=4081 ... Started.
    exec PSBRKDSP -o ./LOGS/stdout -e ./LOGS/stderr -s PSBRKDSP_dflt:Dispatch -- -D APPDOM -S PSBRKDSP_dflt :
            process id=4084 ... Started.
    exec PSPUBHND -o ./LOGS/stdout -e ./LOGS/stderr -s PSPUBHND_dflt:PubConProcess -- -D APPDOM -S PSPUBHND_dflt :
            process id=4087 ... Started.
    exec PSPUBDSP -o ./LOGS/stdout -e ./LOGS/stderr -s PSPUBDSP_dflt:Dispatch -- -D APPDOM -S PSPUBDSP_dflt :
            process id=4091 ... Started.
    exec PSSUBHND -o ./LOGS/stdout -e ./LOGS/stderr -s PSSUBHND_dflt:SubConProcess -- -D APPDOM -S PSSUBHND_dflt :
            process id=4103 ... Started.
    exec PSSUBDSP -o ./LOGS/stdout -e ./LOGS/stderr -s PSSUBDSP_dflt:Dispatch -- -D APPDOM -S PSSUBDSP_dflt :
            process id=4106 ... Started.
    exec PSMONITORSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 141117 -D APPDOM -S PSMONITORSRV :
            process id=4109 ... Started.
    exec JSL -o ./LOGS/stdout -e ./LOGS/stderr -A -- -n //fscm912pt:9000 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 1000000 -w JSH :
            process id=4113 ... Started.
    exec JREPSVR -o ./LOGS/stdout -e ./LOGS/stderr -A -- -W -P /home/psadm2/psft/pt/8.52/FSCM912/appserv/APPDOM/jrepository :
            process id=4119 ... Started.
    17 processes started.
    Domain
    Creating Process Scheduler Server for Database PRCSDOM...
    Copying Process Scheduler Server configuration file(s)...
    Stripping Annotations...
    Process Scheduler Server configuration created.
    Loading validation table...
      setting DBName=FSCM912
      setting DBType=ORACLE
      setting UserId=VP1
      setting UserPswd=VP1
      setting ConnectId=people
      setting ConnectPswd=peop1e
      setting ServerName=fscm912db
      setting PrcsServerName=PRCS936
      setting Log/Output Directory=%PS_SERVDIR%/log_output
      setting Add to PATH=.
      setting SQRBIN=%PS_HOME%/bin/sqr/%PS_DB%/bin
    New CFG file written with modified Startup parameters
    
    Log Directory entry not found in configuration file.
    Setting Log Directory to the default... [PS_SERVDIR/LOGS]
    Spawning enabled for server PSDSTSRV.
    WARNING: PSDSTSRV is configured with Min instance set to 1. To avoid loss of service, configure Min instance to atleast 2.
    Configuration file successfully created.
    CFG setting changes completed, loading configuration...
    Process Scheduler Server configuration complete.
    Created
    Loading validation table...
    
    Log Directory entry not found in configuration file.
    Setting Log Directory to the default... [PS_SERVDIR/LOGS]
    Spawning enabled for server PSDSTSRV.
    WARNING: PSDSTSRV is configured with Min instance set to 1. To avoid loss of service, configure Min instance to atleast 2.
    Configuration file successfully created.
    CFG setting changes completed, loading configuration...
    Domain configuration complete.
    Process Scheduler Server configuration complete.
    Domain
    Starting
    
    Archived a copy of the domain configuration to /home/psadm2/psft/pt/8.52/FSCM912/appserv/prcs/PRCSDOM/Archive/psprcs.cfg 
    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, 64-bit, Patch Level 043
    
    Booting admin processes ...
    
    exec BBL -A :
            process id=4347 ... Started.
    1 process started.
    Attaching to active bulletin board.
    
    > Attempting to boot ... 
    INFO: Oracle Tuxedo, Version 10.3.0.0, 64-bit, Patch Level 043
    
    Booting server processes ...
    
    exec PSMSTPRC -o ./LOGS/stdout -e ./LOGS/stderr -A -- -CD FSCM912 -PS PRCS936 -A start -S PSMSTPRC :
            process id=4351 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=4356 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=4360 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=4364 ... Started.
    exec PSDSTSRV -o ./LOGS/stdout -e ./LOGS/stderr -p 1,600:1,1 -sPostReport -- -CD FSCM912 -PS PRCS936 -A start -S PSDSTSRV :
            process id=4368 ... Started.
    exec PSPRCSRV -o ./LOGS/stdout -e ./LOGS/stderr -sInitiateRequest -- -CD FSCM912 -PS PRCS936 -A start -S PSPRCSRV :
            process id=4373 ... Started.
    exec PSMONITORSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 72323 -PS PRCS936 -S PSMONITORSRV :
            process id=4381 ... Started.
    7 processes started.
    Domain
    
    Do you wish to setup PeopleSoft Pure Internet Architecture on this VM [y|n]: y
    CreateVirtualEnvironment
    Doing PIA silent install
    Setting temporary directory /opt/oracle/psft/pt/tools/tmp/IA.4502
    Executing setup.linux LAX_VM /opt/oracle/psft/pt/tools/jre/bin/java  -i silent -DRES_FILE_PATH=/opt/oracle/psft/pt/tools/tmp/install.properties -DCOMP_NAME=fscm912pt -DPS_UMASK=0022
    Preparing to install...
    Extracting the installation resources from the installer archive...
    Configuring the installer for this system's environment...
    
    Launching installer...
    
    Preparing SILENT Mode Installation...
    
    ===============================================================================
    PeopleSoft Internet Architecture                 (created with InstallAnywhere)
    -------------------------------------------------------------------------------
    
    
    
    
    ===============================================================================
    Installing...
    -------------
    
     [==================|==================|==================|==================]
     [------------------|------------------|------------------|------------------]
    
    Installation Complete.
    
    Enter the connect string for the AppServer domain.  This is the host:port on 
    which the Application Server domain will listen for incoming connections.  
    You may provide failover and load balancing rules using the format described 
    in the PeopleBooks.  Hit Enter to use the default [fscm912pt:9000]: 
    Are you happy with your answers [y|n] : y
    Updated
    Ownership
     
    Attempting to start WebLogic Server PIA
    No activity will be logged to this window.
    Server activity will be logged to /home/psadm2/psft/pt/8.52/FSCM912/webserv/peoplesoft/servers/PIA/logs/PIA_*
    PID for WebLogic Server PIA is: 5065
    PIA
    
    You are running both AppBatch and PeopleSoft Internet Architecture in the 
    same VM.  This means that some additional automated setup can be done. 
    Report Nodes, integrations etc. can be created due to the presence of 
    multiple tiers in the same host. 
    Note:  you may not wish to do this if connecting to an existing database
    This is a step typically taken in demo environment with a clean database
    
    Do you wish for this additional setup to be performed [y|n]: y
    
    User
    SetupPRCSReportNodes
    Running
    Process
    SetupIntegrationBroker
    Running
    Updated
    Integration
    Stopping
    Stopping
    Shutdown will wait for each process to complete current job...
    
    Shutting down all admin and server processes in /home/psadm2/psft/pt/8.52/FSCM912/appserv/prcs/PRCSDOM/PSTUXCFG
    
    Shutting down server processes ...
    
            Server Id = 1 Group Id = MONITOR Machine = fscm912pt:   shutdown succeeded
            Server Id = 101 Group Id = BASE Machine = fscm912pt:    shutdown succeeded
            Server Id = 103 Group Id = BASE Machine = fscm912pt:    shutdown succeeded
            Server Id = 3 Group Id = AESRV Machine = fscm912pt:     shutdown succeeded
            Server Id = 2 Group Id = AESRV Machine = fscm912pt:     shutdown succeeded
            Server Id = 1 Group Id = AESRV Machine = fscm912pt:     shutdown succeeded
            Server Id = 102 Group Id = BASE Machine = fscm912pt:    shutdown succeeded
    
    Shutting down admin processes ...
    
            Server Id = 0 Group Id = fscm912pt Machine = fscm912pt: shutdown succeeded
    8 processes stopped.
    Starting
    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, 64-bit, Patch Level 043
    
    Booting admin processes ...
    
    exec BBL -A :
            process id=5846 ... Started.
    1 process started.
    Attaching to active bulletin board.
    
    > Attempting to boot ... 
    INFO: Oracle Tuxedo, Version 10.3.0.0, 64-bit, Patch Level 043
    
    Booting server processes ...
    
    exec PSMSTPRC -o ./LOGS/stdout -e ./LOGS/stderr -A -- -CD FSCM912 -PS PRCS936 -A start -S PSMSTPRC :
            process id=5850 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=5855 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=5859 ... Started.
    exec PSAESRV -o ./LOGS/stdout -e ./LOGS/stderr -- -CD FSCM912 -S PSAESRV :
            process id=5863 ... Started.
    exec PSDSTSRV -o ./LOGS/stdout -e ./LOGS/stderr -p 1,600:1,1 -sPostReport -- -CD FSCM912 -PS PRCS936 -A start -S PSDSTSRV :
            process id=5867 ... Started.
    exec PSPRCSRV -o ./LOGS/stdout -e ./LOGS/stderr -sInitiateRequest -- -CD FSCM912 -PS PRCS936 -A start -S PSPRCSRV :
            process id=5872 ... Started.
    exec PSMONITORSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 72323 -PS PRCS936 -S PSMONITORSRV :
            process id=5880 ... Started.
    7 processes started.
    Domain
    ovm_configure_post
  11. The script nfs mounted the apptools directory from the database image. Upon reboot, that mount will disappear. To persist this mount point, add the following to /etc/fstab
    FSCM912DB:/opt/oracle/psft/ptdb/apptools /opt/oracle/psft/pt/apptools nfs    rsize=8192,wsize=8192,timeo=14,intr
  12. If you want to App Designer to connect in 3-tier, then: #1 become psadm2 (sudo -u psadm2 -i), #2 psadmin, #3 configure the domain and turn on option 6, #4 restart the domain.
  13. Add an entry to your Windows hosts file (c:\windows\system32\drivers\etc\hosts) to point to your VBox guest.

When all was said and done, I logged into my PeopleSoft instance, ran XFRWIN, and watched it post. If you used the same names as I did, your server will be running at http://fscm912pt:8000/ps/signon.html.

Seriously, this was the fastest install ever. I didn't have to install Tuxedo, Oracle client, Weblogic. I didn't have to configure report nodes, pub/sub, etc. The script took care of everything.

Please let me know if you have any questions or notice any omissions in my steps. I tried to document as I was executing them, but you know how that goes...

So what next? I was thinking it would be really cool to run these images in lxc. According to this post, Oracle has all the scripts, etc to run OVM images in lxc. Perhaps it can run the JeOS images created by the PeopleTools team?

36 comments:

Jimmy Hunter said...

Jim, thanks for another great post!

I was able to get this FSCM 9.1 appliance running but without a decoupled app home -- the nfs mount failed. I must have something wrong with networking but with your detailed instructions I should be able to figure it out.

I had to "skinny" down the VMs since I am running on a 4GB RAM laptop but was still able to boot everything and log in, run a process, etc.

I had to change the kernel parameter msgmni to 1024 to boot the app server on the PIA/AppBatch VM.

Jim, again a HUGE thanks and also a shout out to Chris Malek for alerting me to these OVMs, Nick Gasparotto for his tireless posting and especially to Mark Johnston and the folks at Oracle for providing the OVMs and other documentation. I hope they keep coming!

Jim Marion said...

@Jimmy, thank you for the validation. I'll take a look at my msgmni kernel parameter.

I spent a lot of time on Nicolas's site pouring over his installation documents. I would not have this working without him.

Gasparotto Nicolas said...

Thank you guys for the kind words. Glad to see posting help people.

And again, very nice Jim, your blog entries about the Peoplesoft OVM in VirtualBox are really great and nicely detailed and explained.

Jim, if you are ok, I can add these two entries in a sticky post on top of the OTN Peoplesoft OVM forum's page as a reference. Let me know.

Nicolas.

Jim Marion said...

@Nicolas, thank you. A sticky post would be great!

Kevin Cocilo said...

Hi Jim. I followed your steps to the letter, but am having troubles starting my AppServer as well. I went through th eentire install(even after my Appserver failed to start). Since then, I now login to OS as psadm2, and attempt to run psadmin script.
Again, fails upon Appserver Start(2nd process).
I think my env is set correctly(TUXDIR, LD_LIBRARY_PATH , LANG).
Any pointers?

Jim Marion said...

Posting this for Kevin from this comment on the other PeopleSoft OVM template blog post:

Jim, success is sweet. Here's what I did to get hings running.
1.Found that I needed to change my DB username to VP1/VP1, instead of QEDMO.
2. configged kernel params per this article.. http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/troubles-starting-app-server-1580126
3. manually start as psadm2
4. manually start startPIA as root.
Thanks so much for pioneering this!

AnveshRaju said...

Hi..Thanks for such a good post.
Can you please guide me in configuring Nodes and connectors in peoplesoft as I am gettign few errors while testing CI_TL_EMPL_DATA service in Peoplesoft( errors occured are due to wrong configurations in Nodes, connectors) Kindly guide me in this regard

Jim Marion said...

@Anvesh, I suggest posting your question along with the full error on the Oracle PeopleSoft General forum

JB said...

Jim:
Good stuff here.. and I'm a noob at the Linux stuff mostly. Long time psft developer so I had to give this a try but ran into trouble on running the template script. I'm getting an error where it can't find "press_anykey" which totally messes up the script. I didn't catch it at first and so it ran, and pretty much messed things up. I think I'm going to have to re-extract the database file and just start all over, although that takes a while to get through just those parts. Any help on why it can't find "press_anykey" ?

Jim Marion said...

@JB, that is a good one. I'm not familiar with press_anykey and don't have an instance running in front of me. You might try a grep press_anykey * within the template directory to see if it shows any results.

Another option is to post on the OVM forum.

You should not have to start over. The template script will do a full re-initialization each time. I don't remember how many times I accidentally renamed my SID while trying to figure it out.

aLuN said...

Just curious, can I still have my windows 7 OS for my laptop? or I must changed it to Linux OS in order to have PS Template on VirtualBox?

Jim Marion said...

@aLuN, yes, absolutely. VirtualBox is different from OVM. VirtualBox is an application that runs in Windows, Linux, etc in a manner similar to VMWare. Just download and install VirtualBox for your host operating system.

aLuN said...

Thanks alot Jim. I will proceed to download the template for HCM and give a try then.
I'm totally new to this VM thing, so might be posting lots of questions later on.
Your kind assistance is greatly appreciated.

Regards,
aLuN

Jim Marion said...

@aLuN, My pleasure. Just be sure to start with OEL 5.x and use the Oracle public yum repository to get current on OEL 5 as well as install Oracle Validated. Those with Linux experience have reported very, very good success. If you read through the comments, you will see that some people have reported problems. Be sure to check out this meta-post with links to OVM/VirtualBox conversion documentation.

JB said...

Jim:
Getting back to this, finally gettin gthe database up and running, painfully, I might add. Running the template script for App/Batch/Web.. Looks like there's a premissions issue, See below, were it says "ERROR:Unable".. then it asks me a question that wasn't covered in your steps.
Any Help there?
Thanks
JB



[root@fscmpt91 pt]# sudo -i
[root@fscmpt91 ~]# cd /opt/oracle/psft/vm
[root@fscmpt91 vm]# export DECOUPLE_USR_GROUP=appinst
[root@fscmpt91 vm]# ./oraclevm-template.sh
Creating
ovm_configure_pre
No
Current
Setting
./oraclevm-template.sh: line 379: ovm_configure_network: command not found

Do you wish to configure the VM for Demo Purposes [y/n]:y

Do you wish to configure a Decoupled Application Home [y/n]:y
Default

Do you wish to setup PeopleSoft Application Server on this VM [y|n]: y
CreateVirtualEnvironment
Enter the name of the database [TESTDB]:FSCM
Enter the hostname for the database server [fscmpt91.example.com]:
Enter the port number for the database host [1521]:
Are you happy with your answers [y|n] : y
ERROR: Unable

You have chosen to configure a Decoupled Application Home.
Decoupled Application Home is configured on the VM by mounting the
remote directory where the Application VCD is installed. Administrators
will install the Application VCD typically on a File Server. You will be
prompted to provide the full path of the remote directory including the
mount point where the Application VCD is installed. For example:
rtdc1008nap:/vol/apps/HR91.

Enter the full path of the remote Application Home directory:

Jim Marion said...

@JB, a friend used my rough outline to create a guide with lots of details. You can find it here: Running Oracle VM Templates on Oracle Linux guide (Part 1 of 6). Take a look at it and see if it answers your questions.

JB said...

Jim:
I have been all over that since you posted a link about it. That's what got me started again on this. I have been bouncing back and forth between the two. I think the root of my problem is that the script can't find "ovm_configure_network", which is KINDA important. I'm trying to search for that to see where it is.
JB

JB said...

Jim:
I think I finally found one of the problems that's causing me so much grief. /usr/lib/oraclevm-template/functions is an actual file full of delivered functions that are used in the templates. When I was following your examples (and the other one) we edited that file and added stuff to it. Well it was blank when I edited it. It's not supposed to be. That's where Press_Anykey (a previous post problem) is located, as well as ovm_comfigure_network. Do you have anything that shows the contents of that file, other than what we added to it?
Thanks
JB

Jim Marion said...

@JB, since we are using Oracle Linux, not OVM, that file didn't exist when we started. I created the file and added function "stubs" for only the functions required to run the OVM script. I do not know what normally comes with that file.

You can comment out the network configuration portion of the script. You configured the network when you configured your VM in VirtualBox. The network and password configuration portions aren't required for this installation. You can ignore the errors those two steps throw and just continue.

The part about the remote application home directory is used by the script to NFS mount the db image's PS_APP_HOME into the PeopleTools image. I do remember that step, but like you said, neither of the bloggers on this topic blogged that step. Unfortunately, I can't remember what I entered at that step. The NFS mount is covered in step 11, so you could mount the remote app directory in advance, CD into the mount point and make sure you can read the files. If all is well, go ahead and run the script.

JB said...

Shockingly, I have finally gotten through it and have it working. I built a demo on my laptop on SQLServer in ALOT let time than this, but then again, I didn't know Linux and I have learned some stuff, so that's a good thing.
Thanks again for all the help.
JB

Jim Marion said...

@JB, glad to hear it is working for now. Once you get the hang of it, you can do a full OVM/VirtualBox conversion in about 15 minutes. If you perform a manual install, think it takes longer than that to just install one of the PeopleTools dependencies (WebLogic, Tuxedo, etc). Fortunately, once 9.2 and PT 8.53 release, we won't have to deal with this. We can just use one of the PUM VirtualBox images.

Debo said...

@Jim and @JB

Thanks for the great post.

I am running into the same error :

“ERROR: Unable

Enter the full path of the remote Application Home directory”

I am a noob in this field. If you guys provide a detail steps to resolve this problem, that will be great.

Jim Marion said...

@Debo, I wish I could provide you with more guidance in that piece. My entire trace is listed in the blog posts, along with all of the questions and answers. It is possible that we are working from different versions of the VM templates. NFS mounting the PS_APP_HOME is described in step 11, so, worst case, you can grep grep the scripts directory for that portion and comment it out.

You might also try posting your question/error in the PeopleSoft OVM Template forum.

Hank Zhang said...

I experienced the same error “ERROR: Unable

Enter the full path of the remote Application Home directory”, and it prompts me to enter a path for remote PS_APP_HOME. I just used the value of $PS_APP_HOME configured for user psadm2.
Later on the log showed that tuxedo hadn't got started up.
After the script oraclevm-template.sh finished (no other errors/exceptions encountered), I switched to user psadm2, and cd to $PS_HOME/appserv/, then ran ./psadmin to administer the Application Server (I didn't change the App's domain, so it remains APPDOM).
The only change I made, is to reconfigure the domain - updated UserID (PS), UserPswd (PS), and ServerName (fscm912pt). After this I updated UserID (PS) and UserPswd (PS) for the process scheduler as well.

And I can see this new process scheduler in Process Monitor, but it shows:
--- (Under "Server List" tab)
Server: PRCS6632
Hostname: fscm912pt.example.com
Last Update Date/Time: 04/07/2013 7:53:46PM
Dist Node:
Master: Y
CPU(%): 6
Memory(%): 59
Active: 0
Status: Running With No Report Node
Details: Details
---
Next I'm going to re-configure the dist node.

Francisco Amores said...

Hi,

congrats for the blog!

I´m running the oraclevm-template configuration and would like to know how long should take this step

Do you want this additional setup to be performed? [y|n]: y
ChangeDBUserProfiles
Running

for me, it seems that the script get stuck on that.

Thanks!

Jim Marion said...

@Francisco, what version are you using? I don't recall that step.

Francisco Amores said...

Hi,

OVM_EL5U2_X86_64_FSCMDB_9_1_2_PVM
OVM_EL5U7_X86_64_TOOLS8_52_03_PVM

with OEL 5.6

That is part of the output of oraclevm-template.sh

You have also that part with two "Running" messages although mine get stuck on the first one (no errors, no messages...)

I´m going to restart the process using OEL 5.2 as you did.

Regards

Jim Marion said...

@Francisco, ah... right, I see it in the output up there. I think the items there under "running" are SQL, so you may be able to look through the SQL scripts to see if you can figure out why they are taking so long to run.

It sounds like your instance was fine, and that there was nothing wrong with your OS, app, or tools installation. Just long running SQL's?

Francisco Amores said...

Hi Jim,

Finally I got it working. I could see the login page but when I used VP1/VP1 it said the App server was down.

Is there any script to start the application server?

Regards

Francisco Amores said...

Actually I´m able to run startPIA.sh but when I try to login at fscm912pt:8000 with VP1/VP1 I see in the logon page

The application server is down at this time.
CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ServiceException: Invalid Session

Any ideas? Do i have to execute any other script?

Thanks

Francisco Amores said...

For some reason I´m not reaching step where it says:

You are running both AppBatch and PeopleSoft Internet Architecture in the
same VM. This means that some additional automated setup can be done.
Report Nodes, integrations etc. can be created due to the presence of
multiple tiers in the same host.
Note: you may not wish to do this if connecting to an existing database
This is a step typically taken in demo environment with a clean database

Do you wish for this additional setup to be performed [y|n]:


and my script ends with:


PID for WebLogic Server PIA is: 9835
PIA
ovm_configure_post
[root@fscm912pt vm]#



if I look to the output of oraclevm-template script I can see that there is a fatal error when trying to start server processes


> INFO: Oracle Tuxedo, Version 10.3.0.0, 64-bit, Patch Level 043

Booting server processes ...

exec PSWATCHSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 138383 -D APPDOM -S PSWATCHSRV :
process id=8588 ... Started.
exec PSAPPSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psappsrv.lst -- -D APPDOM -S PSAPPSRV :
process id=8589 ... Started.
exec PSAPPSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psappsrv.lst -- -D APPDOM -S PSAPPSRV :
process id=8595 ... Started.
exec PSQRYSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psqrysrv.lst -- -D APPDOM -S PSQRYSRV :
process id=8601 ... Started.
exec PSSAMSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSSAMSRV :
process id=8605 ... Started.
exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
process id=8608 ... Started.
exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
process id=8611 ... Started.
exec PSANALYTICSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -D APPDOM -S PSANALYTICSRV :
Failed.

tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler

exec tmshutdown -qy

Jim Marion said...

@Francisco, when it works, it is great, when it doesn't... well... then troubleshooting can be a pain. There is a Forum for this, so you might want to ask some of your questions there as well. Here is the link to the forum: Forum: PeopleSoft OVM Templates. There is also another step-by-step tutorial on this that might show more details: Running Oracle VM Templates on Oracle Linux guide

Francisco Amores said...

Hi

finaly solved following these steps:

Step 1: Change the directory loacation to /etc/.
Step 2: Open the file vi sysctl.conf.
Step 3: Compile the sysctl.conf file using sysctl -P.
Step 3: Add the following limit perameters to that file under the # Controls the maximum size of a message, in bytes.
kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024
Step 5: Boot the apps server, Now it will work fine.


http://sarathypsadmin.blogspot.com.es/2012/10/libtuxcat681-error-failure-to-create.html

Jim Marion said...

@Francisco, thank you for the information. Did you install oracle-validated prior to running the vm scripts?

Francisco Amores said...

Yes, it was installed

successfully deployed the two images but I once I shutdown the machines I only know how to start PIA (Webserver)

/home/psadm2/psft/pt/8.52/FSCM912/webserv/peoplesoft/bin/startPIA.sh

What about application server, which scripts do I have to launch?

Currently I´m only able to navigate to PSFT but when I logon I get message Application server is down.

Thanks in advance!!!

Jim Marion said...

@Francisco, thank you for the information. I would have thought oracle-validated would have set those parameters for you.

In regards to starting the app server, when I first started, I would just su - to psadm2 and then run psadmin to start/stop the app server. As an alternative, however, there is a daemon start/stop script in /opt/oracle/psft/vm called appbatch-start. You can symlink this into /etc/init.d and use chkconfig to set the run levels. You should also be able be able to run this script from its current location with the parameters start or stop.