Tuesday, January 31, 2017

Utility to change password for multiple databases

Begin with story what motivated me to create the utility:

As people may have multiple databases in their environments its difficult to remember passwords every database as they expire certain days (may be not be true in your case). One of my client asked  is there way to create a utility to change passwords all at once with same password for all dbs.

As I reviewed my options, MS-DOS the little tool which I learned at school. Quickly started developing using DOS and it came out pretty good. below is the snapshot

(sorry had to mask some places). as shown above Welcome {username} automatically gets from machine name. (in our case system user name and db name are same). Once database selected it will ask for current user name and new password. Once its login successful, it will go ahead and change the password (using alter user..).

This utility depends on Oracle client(sqlplus.exe) and system without Oracle client will not be able to use this.

So I've decide to use something else (like Javascript,nodeJs,xojo..etc) nothing really worked out.

Hmm why don't I use java using JDBC.. ? (I knew Java well enough) ok.. using Swings ..? nope dont want to spend too much time on this. JavaFX.........................Yessssssssssssss..

Quickly gone through the API (couple of hours) and started developing next day.. woohoo the output on the same day...

                  It uses Oracle JDBC library. platform independent.
                  No need Oracle client to be installed on machine (like mine).
                  Can be modified easily to environment specific needs.
                  Database name configured using .properties file.

Structure of Project:

                        Oracle Utility

dbnames.properties file


Monday, May 2, 2016

PTF 8.54 calling a Process and wait for Success

Two different ways to call a process 
1. Static
2. Dynamic (By Creating Model Test case)

           Type: Process
           Action: Run
           Recognition: prcsname=AEMINITEST
           Parameters: prctype=Application Engine;wait=true;outtype=Web;outformat=TXT;expected=Success;ret=true

2.Dynamic :
 By creating model test case for process monitor and pass variable to that test case. This way we can re-use this test case for any kind of process.

 1.Create a new test case with PRCSMONITOR
           Type: Process
           Action: Run
           Recognition: prcsname=&pn
           Parameters: prctype=Application Engine;wait=true;outtype=Web;outformat=TXT;expected=Success;ret=true

    (note: &pn is the variable which we going to create in main test case.)
 2.Create step with Variable:
  Type: Variable
  Action: Set_value
  Recognition: &pn 

 3.Create a test case to call PRCSMONITOR Model test case.      


Sunday, February 14, 2016

Peoplesoft 9.2 with Tools 8.55.01 Image #16 using DPK

With Image#16 Oracle changed the way installing Peoplesoft in virtual machine and also support for installation in Native windows OS.

Brief Overview of Installing Image #16 using DPK(Deployment Packages) in Virtual Box image.

  1. Download all the zip files from oracle (total 15 files)
  2. Extract all zip folder into one folder (e.g.: DPK_INSTALL)
  3. Import VBOX_8_55_01_SHELL.ova into virtual box
  4. Once imported add DPK_INSTALL as shared folder in virtual box (mandatory)
  5. Start virtual machine and prompts for various input option db name, ip address, host name ..etc.

when compared to earlier images using DPK the installation took significantly more time(5 to 6 hours
with my config : MBP 2012, I7, 16GB , 750GB

Disable / Stop OSWatcher in PeopleSoft Virtualbox

To see OSwatcher currently running use the following command
       $>ps -e;f |grep PSWatcher

To Disable temporarily

      $> cd /usr/local/ops/os-watcher/bin
      $> ./stopOSWbb.sh

To Remove from startup

      To see current status
          $> chkconfig --list oswbb

          $>chkconfig oswbb off

Thursday, February 4, 2016

SendMaster Fail to Start With Error "java.lang.IllegalArgumentException: No attributes are implemented

SendMaster Fail to Start With Error "java.lang.IllegalArgumentException: No attributes are implemented"

Steps to resolve the issue:

If PS_HOME directory not present in your  local system, do the below

1.      Copy jre, secvault, sendmaster folders from ps_home location to your local location


2.      Go to sendmaster folder and edit file StartSendMaster.bat with notepad.
Set PS_HOME = {folder name}
                         In my case c:\sendmaster


3.      Inside sendmaster folder and look for lib folder,remove xerces.jar from it
For eg:  C:\sendmaster\sendmaster\lib

With above steps you should be able to open sendmaster