Service Start Up – Automatic (Delayed) July 15, 2009
Posted by Tipster in Administration, Infrastructure, Windows.add a comment
I’ve been spending a little time putting together a VM using Windows Server 2008 and was pleasantly surprised to see that there is a new start-up type when configuring the PIA, App Server and Process Scheduler to start as services.
As well as Automatic, Manual and Disabled, there is now an Automatic (Delayed) option.
David Kurtz has spoken about using service dependencies, but I just want my App Server and Process Scheduler to start after the intial flurry of start-up activity has finished and everything else has calmed down.
Services that have a delayed start still start automatically, they just wait until all the services that aren’t delayed to finish before firing up.
It works a treat!
VMWare Player and IP Ranges June 30, 2008
Posted by Tipster in Administration, Oracle, PeopleSoft, PeopleTools, Virtualisation.1 comment so far
I’ve been doing some work with VMWare Server and VMWare Player. They’re both free tools (download links can be found on the Applications page) and can be invaluable when you need a sandbox environment.
VMWare Server is great for creating the VMs, and you need it while you’re adding virtual disks etc. However once the VM is in place it may be worthwhile switching to VMWare Player. The Player is slightly faster but you can’t perform maintenance like add disks when using it. Also, they don’t co-exist on the same client machine, it’s either one or the other. To be honest, I just uninstall and install as it doesn’t take that long.
The issue I faced, and the reason for this post is that VMWare Server lets the user configure the IP Address assignments and DHCP ranges from within the application, while VMWare player doesn’t. This is a bit of an issue if you have a VM that you’ve configured with a static IP address in a non-default range, then when you switch to VMWare Player the static IP isn’t in the default range.
The secret to know is that the ability is still there, you just have to go looking for it. The utility you need is ‘vmnetcfg.exe’ and it’s under the VMWare Player install directory (i.e. ‘C:\Program Files\VMware\VMware Player’). From here you can configure the IP Ranges to be whatever you wish.
SysInternals hosted May 29, 2008
Posted by Tipster in Administration.add a comment
I’d wager just about everyone involved in PeopleSoft technically has – at some point or other – resorted to using one of SysInternal’s utilities before to troubleshoot an issue with either a Windows server or a client PC. Whether it’s AutoRuns, Contig (useful for defragmenting large VM disk files), diskmon, filemon, regmon, handle, portmon (just which port is that process using), or even the Blue Screen of Death screensaver …
There was a bit of a clamour when Microsoft bought them out, but it appears these must-have tools are still available for free. They’re now hosted in a file share for easy access:
REN Server Ports on Multi-App Installations February 7, 2008
Posted by Tipster in Administration, Infrastructure, Oracle, PS Admin, PeopleSoft, PeopleTools.2 comments
When you have more than one App Server on a single machine – and they both need to run a Ren Server process – you need to adjust the port number in the same way you do for other processes (although the REN Server is easy to miss – like I did – as it’s near the bottom away from the other port numbers).
If you do boot the App Server without changing the port you’ll get an error message:
exec PSRENSRV -A -- -C psappsrv.cfg -D PADMO -S PSRENSRV : CMDTUX_CAT:1685: ERROR: Application initialization failure
tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
tmshutdown -qy
OK, you think. I know what that is, it must be a port clash. So you reconfigure the port in PSADMIN and then try to boot it again. Same error. Checking the REN Server log gives the following clue:
(ERROR) nssock: Cannot listen on port 7180. The port may already be in use.
It’s still looking on port 7180, not the new port!
The missing step is to update the database, as the port is stored there also:
UPDATE PSREN SET PORT_NUM = 7185, SSLPORT_NUM = 7148
You should then find you App Server and Ren Server boot fine.
Fixing up PSAdmin and Services October 26, 2007
Posted by Tipster in Administration, PS Admin, PeopleTools.add a comment
I’ve just stumbled across what looks like a great new product by the Grey Sparling guys. Most (Windows) PeopleSoft DBAs and consultants who run VMs on their laptops will have been frustrated on many an occasion by the (kind of clunky) PSAdmin utility. Sure, it does what we need it to, but shouldn’t we have something better by now?
Using the PIA Welcome Message June 13, 2007
Posted by Tipster in Administration, PIA, PeopleSoft, SQL.26 comments
The PIA Welcome message, or Portal Greeting is a pretty simple piece of functionality, but I’ve not seen it used on a single client site. For those that haven’t seen it before, it looks like this:
The welcome message is stored on a per user basis, it is set using the ‘Personalize Content’ link on the Homepage, and it is stored in the table PSPRUHDEFN. If updated via SQL, it won’t appear instantly unless you either bounce the App Server (and clear the cache) or increment the versions in PSVERSION and PSLOCK. There is an (Oracle) sql script to update the message – so it appears instantly – at the foot of this post.
A more constructive use of the greeting would be to alter it slightly. Particularly during development and testing it would be useful to display the logged on user and the environment name. An extremely simple change to a Tools object (yes, I know, but it’s such a small change that the upgrade implications will be minimal) allows this.
There are two steps, output the user/database in the greeting and make the message appear on every page, not just the Homepage.
Clearing the Process Scheduler Cache – without a Reboot June 11, 2007
Posted by Tipster in Administration, Application Engine, PeopleSoft, SQL.2 comments
I subscribe to a couple of PeopleSoft technical mailing lists / websites and I came across an interesting tip tonight that I thought I’d pass on.
The post was on IT Toolbox (peoplesoft.ittoolbox.com) and the poster was a guy called Neil Pak (at least that’s what the email said, I guess his real name could be anything).
The issue being discussed was one that’ll be familiar to all developers who’ve written a few App Engines in their time – needing to bounce the Process Scheduler to clear the cache, to get the Process Scheduler to use the latest changes. Sometimes it picks them up, sometimes it doesn’t, particularly if you’re changing an existing object – and for me this has happened mostly with SQL Objects. (more…)
PeopleTools 8.49 April 24, 2007
Posted by Tipster in Administration, PeopleSoft.add a comment
I heard a mention earlier today that Tools 8.49 is expected before the end of the month.
Having a quick browse on Customer Connection it looks as though it’s a release to get 3rd party software up to date, rather than to introduce new functionality (in the way that Tools 8.48 did).
Details of software requirements here:
http://www4.peoplesoft.com/psdb.nsf/0/74DAD3F64698E696882571EE0083C128?OpenDocument
(customer connection logon needed)
Update:
Tools 8.49 has been released. Details here:
http://www.peoplesoft.com/corp/en/support/roadmap/documents.jsp?doc=7E371AF2B1AAE3CC882570D0007E6E5C
Moving PeopleSoft Config between Environments April 12, 2007
Posted by Tipster in Administration, Data Mover, PeopleSoft.5 comments
During PeopleSoft implementations it’s a fairly common task to need to move Configuration (i.e. setup data) between environments. Larger implementations may even have a separate Config environment which serves as the master for config data, and from where you’d need to migrate out config into other environments on a regular basis.
There are a number of tools you could use to achieve this, be it data mover, raw SQL or even an SQR or App Engine. All of these would need to be custom written. An alternative solution is to use the Manage Configuration Set functionality. It’s a delivered component (at least on more recent versions of the Application) that lets you choose the modules you wish to export config for, and it builds the DMS files (Data Mover Scripts) for you.
(more…)
Get up and running with the Tuxedo Administration Console April 2, 2007
Posted by Tipster in Administration, Infrastructure, PS Admin, PeopleSoft, Tuxedo.24 comments
I think I’ve stumbled across a better way of remotely administering servers than using remote control software and PSADMIN. There’s a tool called the ‘Tuxedo Administration Console’ (or sometimes ‘WebGUI’) which does the job also.
It looks like this:
Once you’ve done a little bit of config (no more than 15 minutes, and it’s just config, there’s nothing additional to install) you just point the web browser on your client PC to a URL and it loads up the above screen.
You drop down the Domain menu to choose which App Server or Process Scheduler to administer, then use it to start and stop the domain, or you can do individual processes if you prefer. (For example, on my current client site we have a developer who frequently hangs the domain by using all of the PSAPPSERV processes during debugging. Using this tool, we could change the Max App Servers setting and then boot a couple of extra App Servers, all in a few clicks and without rebooting the domain.)
