Some useful sql commands and knowledge in sqlplus

1. When you access sqlplus with sysdba withought password to check system tables sqlplus / as sysdba 2. When you access sqlplus with anonymous, only use sqlplus command without any privileges sqlplus /nolog 3. To check sid information we need to check tnsnames.ora file in network folder 4. Display cache commands: l or run 1) […]

Read More

Difference start commands between selenium1 and selenium3

For start selenium1: java -jar selenium-server.jar -port portnumber e.g. java -jar selenium-server.jar -port 4444 For start selenium3 # Run selenium server and default node register port is 4444 # for exmple java -jar selenium-server-standalone-3.141.5.jar -role hub # If you run higher FF version, please run gecko driver node # Note sometimes need selenium jar and […]

Read More

Run hashicorp nomad in localhost steps

Nomad is a tool of deploy cluster scheduler. Sometimes we need to install localhost to try how to use it,here are some steps for linux ubuntu18.04 installation: 1) Download nomad with binary version Download nomad,then need to add bin path to execute. 2) Then we need to a server config file to start nomad server, below […]

Read More

Migration issue fix from Selenium1 to Selenium3

For migration, because the old system needs to run to new browser and keep test automation running normally, so facing new browser, csv command parse code also needs to be adjusted. Below are some issues happened during testing, and solutions: 1. Because run too faster on v63 When WebDriverWait function can’t work for waiting time, […]

Read More

Migrate commands from selenium v1 to selenium v3 in Java

  Selenium v1 means use java package com.thoughtworks.selenium to call/test csv, run Selenium, Selenium v3 means use java package org.seleniumhq.selenium, support Remote Selenium WebDriver Later will explain how to difference for starting. These 2 different selenium versions also support different browser versions, e.g. Firefox Tested in selenium v1 on FFv3, and selenium v2 on FFv63 Here will […]

Read More

DevOps : Build your docker repository for example

1. Install docker on Ubuntu Please refer to https://linuxconfig.org/how-to-install-docker-on-ubuntu-18-04-bionic-beaver 2.  Check and Download JavaSimpleProject.zip  include dockerfile and java code Zip file includes: src/main maven project folder Dockerfile for docker build including maven,tomcat installation pom.xml for maven build start.sh start tomcat to run java application Note, in Dockerfile, you can change FROM ubuntu:latest into FROM ubuntu:18.04 3. Change to your […]

Read More

DevOps : Linux commands with scenarios

DevOps Linux commands # Sometimes only access linux system using terminal,  and need to check which linux version is, lsb_release -a   # Open terminal and run  one application/scripts with long console output, and try to search some keyword text in GUI,not impacted by previous command output, avoid to re-open new terminal to re-run, so […]

Read More

DevOps Git Operations: create new branch and merge to remote

DevOps Git to manage branch This is supposed as development/test operations. For a research team, suppose to make a new branch to test/development, but not master branch instead, create and merge for steps below: # clone remote git branch git clone –single-branch -b remote-branch-name https://github…/remote.git #check current branch if remote-branch-name git branch #create new branch […]

Read More

Import VirtualBox vmdk file into VMWare Fusion On Mac Guide

If you have virtualbox vmdk file, and want to import into vmware fusion, here are some steps. Skip to say how to install virtualbox and vmware fustion. The virtualbox vm status should be power off, then check and record vm gerneral settings: CPU,Memory,Network Adapters etc. Open VMWare Fustion(v10.1.3)  Click + New… See picture below Then […]

Read More