Weblogic: password reset for console admin account

For times when you need to login to your webserver console but forgot the passwords, before doing a full install below are the steps to perform password reset

1. Backup the security directory
cd //webserv/
tar -cvf security.tar security

2. Delete the authenticator file
cd //webserv//security
rm -rf DefaultAuthenticatorInit.ldift

3. Set environment variables
cd //webserv//bin
. ./setEnv.sh

4. Reset the password
java weblogic.security.utils.AdminAccount operator password //webserv//security

5. Update the boot.properties file with the new password
vi //webserv//servers/PIA/security/boot.properties



6. Cleanup ldap directory
rm -rf //webserv//servers/PIA/data/ldap/*

7. Bounce your weblogic instance.


Nvision: Unsupported FileFormat 

The change in the filename extension of microsoft excel from .xls to .xlsx resulted into issue with when peoplesoft nvision. If your setup is now using the new office version, you might have encontered the following error message:

An OpenXml error occured. Microsoft Excel 2003 Format Layouts are not supported. Unsupported FileFormat

Ofcourse if it’s just for a single layout, you can simply open the layout in excel and use the “save as” functionality. But what if you are using hundreds of nvision layout for your peoplesoft nvision? You might find the process time consuming. Here’s the steps to perform mass conversion of your layout:

1. Download and install Microsoft OMPM here http://www.microsoft.com/en-us/download/details.aspx?id=21888

2. perform mass rename of the layout file (.xnv). Go to the nvision layout directory and run the following command in the command line

ren *.xnv *.xls

3. On your OMPM installation, go to ..\OMPM\TOOLS

4. Open ofc.ini and edit the following section, where fldr is the layout directory



; The Converter will attempt to convert all supported files in the specified folders

; (do not include if specifying FileListFolder)

;fldr=C:\Documents and Settings\Administrator\My Documents



5. under ofc.ini, the DestinationPathTemplate=*1\*2\*3\Converted is the location of the converted files

6. after saving ofc.ini, execute OFC.exe via command line.

7. The files under Converted directory will now have the following filenames:

            .xlsx for regular nvision template

            .xlxm for nvision template with macro

8. perform the mass rename again

            ren *.xlsx *.xnv

            ren *.xlsm *.xnv

9. Congratulation, you have a layout that is not Supported file Format

You can follow the same steps to mass convert other office document as well e.g .doc to .docx