PeopleSoft PUM Image Maintenance
The PeopleSoft PUM Image VMs seems to work pretty well once installed. There is very little maintenance that I have had to perform on these environments and I can always start over by rebuilding the VM if I really break something. Still, there have been some small issues recently that have required digging into the these environments so here are some notes to help. Database Administration The Oracle Database runs within the same VM and can be accessed using TNS with SQLPlus, SQL Developer, or most other Oracle-compatible tools. However, I recently needed to make some adjustments to the SYSADM privileges. For this I needed to connect as SYSDBA. 1. Login to the VM as root (this account was setup when you installed the image) 2. Switch to the oracle account. This is the database owner. su - oracle 3. You then need to know the database name to connect to. The easiest way is to look for the pmon process. In the example be...