Author: Robert Reid

Create Oracle DB user for Qualys Scanner

[ad#ad-post] Create User: CREATE PROFILE "QUALYS_PROFILE" LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_GRACE_TIME 10 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX 1; CREATE USER "QUALYS_SCAN" PROFILE "QUALYS_PROFILE" IDENTIFIED BY "<QUALYS_PASSWORD>" DEFAULT TABLESPACE "USERS" ACCOUNT UNLOCK; CREATE ROLE "QUALYS_ROLE"; GRANT "QUALYS_ROLE" TO "QUALYS_SCAN"; CREATE OR REPLACE VIEW...

Reset the SYSMAN password in OEM12c/13c

[ad#ad-post] Stop all the OMS $OMS_HOME/bin/emctl stop oms Modify the SYSMAN password $OMS_HOME/bin/emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys pwd> -new_pwd <new sysman pwd> Re-start all the OMS $OMS_HOME/bin/emctl stop oms -all $OMS_HOME/bin/emctl start oms [ad#ad-post]...

DataStage Designer, Admin or Manager clients: runtime error 457 – Reindex Datastage

  [ad#ad-post] Run-time error 457 logging into project in IBM InfoSphere DataStage from http://www-01.ibm.com/support/docview.wss?uid=swg21446213 Users cannot login to a particular project using DataStage clients (Designer, Director, or Manager) and encounter the error: “Run-time error ‘457’: This key is already associated with an element...

IBM InfoSphere Information Server DataStage 11.5 ODBC Connection Configuration for Microsoft SQL

[ad#ad-post] First, make sure to the latest ODBC drivers are installed from IBM Fix Central Note: The .odbc.ini file template defaults to an old driver. Make sure to use the latest driver. As of the time I updated this document, the...

SSH Key not working – Server refused our key

[ad#ad-post] I found this solution on https://adamwright.wordpress.com/2013/04/15/how-to-fix-server-refused-our-key-error-in-centos-6/ I received this error with Putty: “Server refused our key” SecureCRT gave me this error: “unable to authenticate using keys from the location “<ssh-agent>”. The error was: cannot find object or property.” [ad#ad-post] This appears to...

Notepad++ Silent Install Script

Similarly to the 7-zip silent install script, I also use the following script on my servers during their original build and patching: pushd "\\epmfileserver\share\utilities" npp.6.6.9.Installer.exe /S popd I’m not sure if any of you have ever used pushd and popd, but...