Skip to main content

Liquibase

liquibase
.........
/workspaces/he-catalog/install/database/liquibase
cd /export/home/portal/he-frontend_prod_8080/install/database/liquibase/

##rollback

java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml  rollbackSQL version_1.7.0 >> rollback.sql
-- inspect rollback.sql to make sure the database changes to be made look correct; compare rollback.sql with futureRollbackSQL.sql (they should be equivalent); have DBA review if needed
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml rollback version_1.7.0 >> rollback.log



##install

java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml  futureRollbackSQL >> futureRollbackSQL.sql
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml updateSQL >> updateSQL.sql
-- inspect updateSQL.sql to make sure the database changes to be made look correct; have DBA review if needed
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml update >> update.log

Comments

Post a Comment

Popular posts from this blog

Oracle Database 12c installation on Ubuntu 16.04

This article describes how to install Oracle 12c 64bit database on Ubuntu 16.04 64bit. Download software  Download the Oracle software from OTN or MOS or get a downloaded zip file. OTN: Oracle Database 12c Release 1 (12.1.0.2) Software (64-bit). edelivery: Oracle Database 12c Release 1 (12.1.0.2) Software (64-bit)   Unpacking  You should have following two files downloaded now. linuxamd64_12102_database_1of2.zip linuxamd64_12102_database_2of2.zip Unzip and copy them to \tmp\databases NOTE: you might have to merge two unzipped folders to create a single folder. Create new groups and users Open a terminal and execute following commands. you might need root permission. groupadd -g 502 oinstall groupadd -g 503 dba groupadd -g 504 oper groupadd -g 505 asmadmin Now create the oracle user useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle You will prompt to set to password. set a momorable password and write it down. ...
9 comments
Read more

DBCA : No Protocol specified

when trying to execute dbca from linux terminal got this error message. now execute the command xhost, you probably receiving No protocol specified xhost:  unable to open display ":0" issue is your user is not allowed to access the x server. You can use xhost to limit access for X server for security reasons. probably you are logged in as oracle user. switch back to default user and execute xhost again. you should see something like SI:localuser:nuwan solution is adding the oracle to access control list xhost +SI:localuser:oracle now go back to oracle user and try dbca it should be working
2 comments
Read more

Slow CPU after resume / Ubuntu 16.04 LTS too slow after suspend and resume

you might experience a slow performance in ubuntu 16.04 after resuming back from a sleep or hibernate. reason for this is it doesn't move away from powersave mode automatically. intel_pstate driver is the one making this problem, so we have to disable it and use acpi-cpufreq  driver. first lets check weather your competer is on powersave.  cat /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor If your answer is powersave we have to move it to performance state. get your cpu info by cat /proc/cpuinfo | grep MHz  probabaly you seeing 4 cores lets update scaling governers     echo 'performance' > /sys/devices/system/cpu/cpu0/cpufreq/scaling_governor     echo 'performance' > /sys/devices/system/cpu/cpu1/cpufreq/scaling_governor     echo 'performance' > /sys/devices/system/cpu/cpu2/cpufreq/scaling_governor     echo 'performance' > /sys/devices/system/cpu/cpu3/cpufreq/scaling_g...
Post a Comment
Read more