KAGAYA's Blog

Install Python on Ubuntu 22.04

Rather than Default Python 3.10.6, install another Python version:

1. install prerequisite

sudo apt update -y
sudo apt upgrade -y
sudo apt install -y build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev libssl-dev libsqlite3-dev libreadline-dev libffi-dev curl libbz2-dev -y

2. prepare installer

cd ~/Downloads
curl -O https://www.python.org/ftp/python/3.8.9/Python-3.8.9.tar.xz
tar -xf Python-3.8.9.tar.xz
cd Python-3.8.9

3. configure the python build

./configure --enable-optimizations

4. compile and install python

sudo make -j $(nproc)
sudo make altinstall

5. If it is successful, you can check the version

python3.8 --version

6.Set the newly installed Python version

sudo update-alternatives --install /usr/bin/python3.8.9 python3.8.9 /usr/local/bin/python3.8 1

7. update pip

python3.8.9 -m ensurepip --default-pip
python3.8.9 -m pip install --upgrade pip

8. If you want to remove it

sudo rm /usr/local/bin/python3.8
sudo rm /usr/local/bin/pip3.8
sudo rm -rf /usr/local/lib/python3.8
sudo update-alternatives --remove python /usr/local/bin/python3.8

Initialize Oracle 21 Configure for Spotfire

make tnsnames.ora:

ORCLPDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclpdb)
    )
  )

make listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\oracle

Then restart Listener:

lsnrctl stop
lsnrctl start

Then change the state of the pluggable databases:

sqlplus / as sysdba

/* check the sate: */ 
SQL> select con_id,name,open_mode from v$pdbs;

/* opens the pluggable database named ORCLPDB */ 
SQL> alter pluggable database ORCLPDB open;
/* sets the current session's container context to the ORCLPDB pluggable database */ 
SQL> alter session set container=ORCLPDB;
SQL> commit;

/* check the connected container: */ 
SQL> show con_name;

/* check the pdb name: */ 
SQL> select pdb_name from cdb_pdbs;

/* connect to the pdb: */ 
SQL> alter session set container = ORCLPDB;

/* to keep it starts with the windows server startup, you need to save the PDB’s state: */ 
SQL> alter pluggable database orclpdb save state;

edit the create_databases.bat, eg:

set SPOTFIREDB_ROOTFOLDER=C:\app\oracle\oradata\ORCL\orclpdb
set DBSERVER_CONNECTIDENTIFIER=//[yourDBIP]/ORCLPDB

install wiregui client on ubuntu 22

sudo apt install wireguard wireguard-tools wireguard-dkms
sudo apt install resolvconf
sudo dpkg -i wiregui_1.8.1_amd64.deb
sudo mkdir /etc/wireguard
sudo cp yourConfig.conf /etc/wireguard/yourConfig.conf
sudo chmod 400 /etc/wireguard/yourConfig.conf

you can run by:

sudo wg-quick up yourConfig
sudo wg-quick down yourConfig

or use wiregui

Install Japanese Input for Pop!_OS

environment:

Operating System: Pop!_OS 22.04 LTS                 
Kernel: Linux 6.2.6-76060206-generic
Architecture: x86-64

Install the required packages:

sudo apt update -y
sudo apt install fcitx fcitx-mozc fcitx-config-gtk kde-config-fcitx fcitx-frontend-qt5 libfcitx-qt5-1
echo 'export GTK_IM_MODULE=fcitx' >> ~/.profile
echo 'export QT_IM_MODULE=fcitx' >> ~/.profile
echo 'export XMODIFIERS="@im=fcitx"' >> ~/.profile
sudo reboot

solve chrome issue:

cp /usr/share/applications/google-chrome.desktop ~/.local/share/applications/
echo 'Exec=env QT_IM_MODULE=fcitx XMODIFIERS="@im=fcitx" /usr/bin/google-chrome-stable %U' >> ~/.local/share/applications/google-chrome.desktop
sudo reboot

for Chinese input, then install this:

sudo apt install fcitx-sunpinyin

Install Microsoft Edge on Pop!_OS

Install Microsoft Edge on Pop!_OS 22.04|20.04|21.04

sudo apt update -y
sudo apt upgrade -y
curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > microsoft.gpg
sudo install -o root -g root -m 644 microsoft.gpg /etc/apt/trusted.gpg.d/
sudo sh -c 'echo "deb [arch=amd64] https://packages.microsoft.com/repos/edge stable main" > /etc/apt/sources.list.d/microsoft-edge-dev.list'
sudo apt update -y
sudo apt install microsoft-edge-dev -y

Install Prerequisite of Spotfire Webplayer, Python Service 12.3 on Pop!_OS

go to the spotfire-bin folder and run the command:

Error opening Information Designer on TIBCO Spotfire Analyst

./config.sh export-config --force
./config.sh set-config-prop --name="information-services.external-process.port" --value="9445"
./config.sh import-config -c "changeInformationLinkPort"

install dot-net 6.0 and xvfb, libjpeg62-dev:

Install .NET SDK or .NET Runtime on Ubuntu 22.04

sudo apt update -y
sudo apt-get update &&   sudo apt-get install -y dotnet-sdk-6.0
sudo apt-get -y install xvfb
sudo apt-get install libjpeg62-dev

then reboot Webplayer.

For Python Service:

sudo apt-get install libffi-dev -y

Ubuntu 20.04でlibffi.so.6がない

sudo ln -s /usr/lib/x86_64-linux-gnu/libffi.so.8.1.0 /usr/lib/x86_64-linux-gnu/libffi.so.6

Install GoLand on Pop!_OS

Download the GoLand tarball from the JetBrains website: https://www.jetbrains.com/go/download/

extract it, then move it to /opt/:

tar -xzf <path_to_tarball>/goland-<version>.tar.gz
sudo mv <extracted_directory> /opt/

Create a desktop entry for GoLand by creating a file named goland.desktop in /usr/share/applications/ with the following content:

[Desktop Entry]
Version=<version>
Type=Application
Name=GoLand
Icon=/opt/goland-<version>/bin/goland.png
Exec="/opt/goland-<version>/bin/goland.sh" %f
Comment=The GoLand IDE
Categories=Development;IDE;
Terminal=false
StartupWMClass=jetbrains-goland

sudo chmod +x /usr/share/applications/goland.desktop

use Wireshark on ubuntu

first, install Wireshark:

sudo apt update -y
sudo apt install wireshark -y
sudo usermod -aG wireshark youLinuxUserName

Then log in to GUI, eg:

wireshark  -f 'tcp port 8086'
ip.addr == 130.56.246.232 && !(ssh)

Spotfire DB switch Oracle → SqlServer

To run this command, please turn off any online service.

You need to create Sqlserver DB for the same version of Spotfire first. Then run

C:\tibco\tss\12.0.3\tomcat\spotfire-bin>config migrate-db --tool-password=spotfire --target-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver --target-database-url=jdbc:sqlserver://hostName:1433;DatabaseName=yourSpotfireDBName --target-username=sa --target-password=yourPassword

The log is below:

Connecting to the source database
Connecting to the target database

Database versioning verified.
Database consistency verified.
Warning! This operation will wipe out all the tables from the target database.
Do you wish to continue (Y/N)? Y

Deleting existing data in target table 'ACTIVITY'...Done in 00:00:00
Deleting existing data in target table 'SITE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'SCHEDULED_UPDATES_SETTINGS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_ORIGIN'...Done in 00:00:00
Deleting existing data in target table 'ACTIVE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ACCESS'...Done in 00:00:00
Deleting existing data in target table 'PERSISTENT_SESSIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_AUTH_REQUEST'...Done in 00:00:00
Deleting existing data in target table 'INVITES'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_REFRESH_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'LIB_UNRESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTION_CONTENTS'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_USERS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_ACCESS_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_KEYS'...Done in 00:00:00
Deleting existing data in target table 'KEYSTORE_PASSWORDS'...Done in 00:00:00
Deleting existing data in target table 'CONFIG_HISTORY'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'JOBS_LATEST'...Done in 00:00:00
Deleting existing data in target table 'EXCLUDED_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'CUSTOMIZED_LICENSES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_VALUES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_KEYS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREA_ALLOWED_GRP'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_NONVER'...Done in 00:00:00
Deleting existing data in target table 'NODE_STATUS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'LIB_VISIBLE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_BLOCKED_USERS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVER_INFO'...Done in 00:00:00
Deleting existing data in target table 'SERVER_CONFIGURATIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_RESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'LIB_WORDS'...Done in 00:00:00
Deleting existing data in target table 'NODE_EVENT_BUS'...Done in 00:00:00
Deleting existing data in target table 'JOB_TASKS'...Done in 00:00:00
Deleting existing data in target table 'CONSENTED_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'LIFECYCLE_EVENTS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_PKGS'...Done in 00:00:00
Deleting existing data in target table 'DEP_PACKAGES'...Done in 00:00:00
Deleting existing data in target table 'SN_VERSION'...Done in 00:00:00
Deleting existing data in target table 'RULES_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_OBJECTS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_AUTH_CODES'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CT_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CERTIFICATES'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CERTS'...Done in 00:00:00
Deleting existing data in target table 'GROUP_MEMBERS'...Done in 00:00:00
Deleting existing data in target table 'CT_THIRD_PARTY_ROOTCERTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PRINCIPAL_PROPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_APPLICATIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES'...Done in 00:00:00
Deleting existing data in target table 'NODES'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS_DEF'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_EXTCERTS'...Done in 00:00:00
Deleting existing data in target table 'JMX_USERS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_NAMES'...Done in 00:00:00
Deleting existing data in target table 'CT_CERTS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CONSENT'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CLIENTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_VER'...Done in 00:00:00
Deleting existing data in target table 'JOB_INSTANCES'...Done in 00:00:00
Deleting existing data in target table 'ROUTING_RULES'...Done in 00:00:00
Deleting existing data in target table 'RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'JOB_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'SITES'...Done in 00:00:00
Deleting existing data in target table 'LIB_CURRENT_ITEMS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_VERSIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_DATA'...Done in 00:00:00
Deleting existing data in target table 'LIB_CHARACTER_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_TYPES'...Done in 00:00:00
Deleting existing data in target table 'USERS'...Done in 00:00:00
Deleting existing data in target table 'GROUPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_TYPES'...Done in 00:00:00

Copying table LIB_ITEM_TYPES
Table LIB_ITEM_TYPES done. Copied 26 rows in 00:00:00

Copying table GROUPS
Table GROUPS done. Copied 13 rows in 00:00:00

Copying table USERS
Table USERS done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_TYPES
Table LIB_CONTENT_TYPES done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_ENCODINGS
Table LIB_CONTENT_ENCODINGS done. Copied 2 rows in 00:00:00

Copying table LIB_CHARACTER_ENCODINGS
Table LIB_CHARACTER_ENCODINGS done. Copied 1 rows in 00:00:00

Copying table LIB_DATA
Table LIB_DATA done. Copied 22 rows in 00:00:00

Copying table LIB_ITEM_VERSIONS
Table LIB_ITEM_VERSIONS done. Copied 22 rows in 00:00:00

Copying table LIB_CURRENT_ITEMS
Table LIB_CURRENT_ITEMS done. Copied 15 rows in 00:00:00

Copying table SITES
Table SITES done. Copied 1 rows in 00:00:00

Copying table JOB_SCHEDULES
Table JOB_SCHEDULES done. Copied 0 rows in 00:00:00

Copying table RESOURCE_POOLS
Table RESOURCE_POOLS done. Copied 0 rows in 00:00:00

Copying table ROUTING_RULES
Table ROUTING_RULES done. Copied 0 rows in 00:00:00

Copying table JOB_INSTANCES
Table JOB_INSTANCES done. Copied 0 rows in 00:00:00

Copying table LIB_PROPERTIES_VER
Table LIB_PROPERTIES_VER done. Copied 268 rows in 00:00:00

Copying table OAUTH2_CLIENTS
Table OAUTH2_CLIENTS done. Copied 5 rows in 00:00:00

Copying table OAUTH2_CONSENT
Table OAUTH2_CONSENT done. Copied 0 rows in 00:00:00

Copying table CT_CERTS
Table CT_CERTS done. Copied 1 rows in 00:00:00

Copying table LICENSE_NAMES
Table LICENSE_NAMES done. Copied 10 rows in 00:00:00

Copying table LICENSE_FUNCTIONS
Table LICENSE_FUNCTIONS done. Copied 261 rows in 00:00:00

Copying table JMX_USERS
Table JMX_USERS done. Copied 0 rows in 00:00:00

Copying table CT_EXTCERTS
Table CT_EXTCERTS done. Copied 0 rows in 00:00:00

Copying table NODE_SERVICE_TYPES
Table NODE_SERVICE_TYPES done. Copied 2 rows in 00:00:00

Copying table DEP_AREAS_DEF
Table DEP_AREAS_DEF done. Copied 1 rows in 00:00:00

Copying table NODES
Table NODES done. Copied 2 rows in 00:00:00

Copying table NODE_SERVICES
Table NODE_SERVICES done. Copied 3 rows in 00:00:00

Copying table SERVICE_ATTRIBUTES
Table SERVICE_ATTRIBUTES done. Copied 22 rows in 00:00:00

Copying table NODE_SERVICES_ATTRIBUTES
Table NODE_SERVICES_ATTRIBUTES done. Copied 17 rows in 00:00:00

Copying table LIB_APPLICATIONS
Table LIB_APPLICATIONS done. Copied 29 rows in 00:00:00

Copying table LIB_PRINCIPAL_PROPS
Table LIB_PRINCIPAL_PROPS done. Copied 0 rows in 00:00:00

Copying table CT_THIRD_PARTY_ROOTCERTS
Table CT_THIRD_PARTY_ROOTCERTS done. Copied 0 rows in 00:00:00

Copying table GROUP_MEMBERS
Table GROUP_MEMBERS done. Copied 11 rows in 00:00:00

Copying table TRUSTED_CERTS
Table TRUSTED_CERTS done. Copied 0 rows in 00:00:00

Copying table CERTIFICATES
Table CERTIFICATES done. Copied 4 rows in 00:00:00

Copying table CT_CODE_ENTITIES
Table CT_CODE_ENTITIES done. Copied 0 rows in 00:00:00

Copying table TRUSTED_CODE_ENTITIES
Table TRUSTED_CODE_ENTITIES done. Copied 0 rows in 00:00:00

Copying table OAUTH2_AUTH_CODES
Table OAUTH2_AUTH_CODES done. Copied 0 rows in 00:00:00

Copying table PREFERENCE_OBJECTS
Table PREFERENCE_OBJECTS done. Copied 0 rows in 00:00:00

Copying table RULES_SCHEDULES
Table RULES_SCHEDULES done. Copied 0 rows in 00:00:00

Copying table SN_VERSION
Table SN_VERSION done. Copied 1 rows in 00:00:00

Copying table DEP_PACKAGES
Table DEP_PACKAGES done. Copied 125 rows in 00:00:34

Copying table NODE_SERVICES_PKGS
Table NODE_SERVICES_PKGS done. Copied 148 rows in 00:00:00

Copying table DEP_DISTRIBUTIONS
Table DEP_DISTRIBUTIONS done. Copied 1 rows in 00:00:00

Copying table DEP_AREAS
Table DEP_AREAS done. Copied 1 rows in 00:00:00

Copying table LIFECYCLE_EVENTS
Table LIFECYCLE_EVENTS done. Copied 11 rows in 00:00:00

Copying table CONSENTED_ENTITIES
Table CONSENTED_ENTITIES done. Copied 0 rows in 00:00:00

Copying table JOB_TASKS
Table JOB_TASKS done. Copied 0 rows in 00:00:00

Copying table NODE_EVENT_BUS
Table NODE_EVENT_BUS done. Copied 465 rows in 00:00:00

Copying table LIB_WORDS
Table LIB_WORDS done. Copied 72 rows in 00:00:00

Copying table LIB_RESOLVED_DEPEND_VER
Table LIB_RESOLVED_DEPEND_VER done. Copied 2 rows in 00:00:00

Copying table SERVER_CONFIGURATIONS
Table SERVER_CONFIGURATIONS done. Copied 2 rows in 00:00:00

Copying table NODE_SERVER_INFO
Table NODE_SERVER_INFO done. Copied 3 rows in 00:00:00

Copying table CT_BLOCKED_USERS
Table CT_BLOCKED_USERS done. Copied 0 rows in 00:00:00

Copying table LIB_VISIBLE_TYPES
Table LIB_VISIBLE_TYPES done. Copied 189 rows in 00:00:00

Copying table NODE_SERVICES_RESOURCE_POOLS
Table NODE_SERVICES_RESOURCE_POOLS done. Copied 0 rows in 00:00:00

Copying table NODE_STATUS
Table NODE_STATUS done. Copied 4 rows in 00:00:00

Copying table LIB_PROPERTIES_NONVER
Table LIB_PROPERTIES_NONVER done. Copied 38 rows in 00:00:00

Copying table DEP_AREA_ALLOWED_GRP
Table DEP_AREA_ALLOWED_GRP done. Copied 0 rows in 00:00:00

Copying table PREFERENCE_KEYS
Table PREFERENCE_KEYS done. Copied 15 rows in 00:00:00

Copying table PREFERENCE_VALUES
Table PREFERENCE_VALUES done. Copied 15 rows in 00:00:00

Copying table CUSTOMIZED_LICENSES
Table CUSTOMIZED_LICENSES done. Copied 13 rows in 00:00:00

Copying table EXCLUDED_FUNCTIONS
Table EXCLUDED_FUNCTIONS done. Copied 32 rows in 00:00:00

Copying table JOBS_LATEST
Table JOBS_LATEST done. Copied 0 rows in 00:00:00

Copying table SERVICE_CONFIGS
Table SERVICE_CONFIGS done. Copied 3 rows in 00:00:00

Copying table CONFIG_HISTORY
Table CONFIG_HISTORY done. Copied 2 rows in 00:00:00

Copying table KEYSTORE_PASSWORDS
Table KEYSTORE_PASSWORDS done. Copied 1 rows in 00:00:00

Copying table OAUTH2_KEYS
Table OAUTH2_KEYS done. Copied 1 rows in 00:00:00

Copying table OAUTH2_ACCESS_TOKENS
Table OAUTH2_ACCESS_TOKENS done. Copied 0 rows in 00:00:00

Copying table TRUSTED_USERS
Table TRUSTED_USERS done. Copied 0 rows in 00:00:00

Copying table DEP_DISTRIBUTION_CONTENTS
Table DEP_DISTRIBUTION_CONTENTS done. Copied 125 rows in 00:00:00

Copying table LIB_UNRESOLVED_DEPEND_VER
Table LIB_UNRESOLVED_DEPEND_VER done. Copied 0 rows in 00:00:00

Copying table OAUTH2_REFRESH_TOKENS
Table OAUTH2_REFRESH_TOKENS done. Copied 4 rows in 00:00:00

Copying table INVITES
Table INVITES done. Copied 0 rows in 00:00:00

Copying table NODE_AUTH_REQUEST
Table NODE_AUTH_REQUEST done. Copied 0 rows in 00:00:00

Copying table PERSISTENT_SESSIONS
Table PERSISTENT_SESSIONS done. Copied 0 rows in 00:00:00

Copying table LIB_ACCESS
Table LIB_ACCESS done. Copied 8 rows in 00:00:00

Copying table ACTIVE_SERVICE_CONFIGS
Table ACTIVE_SERVICE_CONFIGS done. Copied 2 rows in 00:00:00

Copying table LICENSE_ORIGIN
Table LICENSE_ORIGIN done. Copied 706 rows in 00:00:00

Copying table SCHEDULED_UPDATES_SETTINGS
Table SCHEDULED_UPDATES_SETTINGS done. Copied 0 rows in 00:00:00

Copying table SITE_SERVICE_CONFIGS
Table SITE_SERVICE_CONFIGS done. Copied 0 rows in 00:00:00

Copying table ACTIVITY
Table ACTIVITY done. Copied 0 rows in 00:00:00

Migration completed.

Please run the 'update-bootstrap' command in order to update the existing bootstrap configuration file(s) with new (target) database configs.

To do this for the action log:

C:\tibco\tss\12.0.3\tomcat\spotfire-bin>config migrate-action-db --source-driver-class=oracle.jdbc.OracleDriver --source-database-url=jdbc:oracle:thin:@//hostname:1521/orcl --source-username=spotfire_actionlog --source-password=spotfire --target-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver --target-database-url=jdbc:sqlserver://hostname:1433;DatabaseName=yourSpotfireDBName --target-username=yourSpotfireActionDBUserName --target-password=yourPassword

Connecting to the source database
Connecting to the target database
Copying table ACTIONLOG

Table ACTIONLOG done. Copied 143072 rows in 00:00:09

Migration completed

test on win server 2022, Spotfire 12.0 LTS, oracle 19.3, SqlServer 2019 Standard

Spotfire DB switch Oracle → PostgreSQL

To run this command, please turn off any online service.

You need to create PostgreSQL DB for the same version of Spotfire first. Then run

C:\tibco\tss\12.0.3\tomcat\spotfire-bin>config migrate-db --tool-password=yourPassword --target-driver-class=org.postgresql.Driver --target-database-url=jdbc:postgresql://hostName:5432/yourSpotfireDBName --target-username=yourUsername --target-password=yourPassword

The log is below:

Connecting to the source database
Connecting to the target database

Database versioning verified.
Database consistency verified.
Warning! This operation will wipe out all the tables from the target database.
Do you wish to continue (Y/N)? Y

Deleting existing data in target table 'ACTIVITY'...Done in 00:00:00
Deleting existing data in target table 'SITE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'SCHEDULED_UPDATES_SETTINGS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_ORIGIN'...Done in 00:00:00
Deleting existing data in target table 'ACTIVE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ACCESS'...Done in 00:00:00
Deleting existing data in target table 'INVITES'...Done in 00:00:00
Deleting existing data in target table 'PERSISTENT_SESSIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_AUTH_REQUEST'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_REFRESH_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'LIB_UNRESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTION_CONTENTS'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_USERS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_ACCESS_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_KEYS'...Done in 00:00:00
Deleting existing data in target table 'KEYSTORE_PASSWORDS'...Done in 00:00:00
Deleting existing data in target table 'CONFIG_HISTORY'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'JOBS_LATEST'...Done in 00:00:00
Deleting existing data in target table 'EXCLUDED_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'CUSTOMIZED_LICENSES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_VALUES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_KEYS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREA_ALLOWED_GRP'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_NONVER'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'NODE_STATUS'...Done in 00:00:00
Deleting existing data in target table 'LIB_VISIBLE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_BLOCKED_USERS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVER_INFO'...Done in 00:00:00
Deleting existing data in target table 'SERVER_CONFIGURATIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_RESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'LIB_WORDS'...Done in 00:00:00
Deleting existing data in target table 'NODE_EVENT_BUS'...Done in 00:00:00
Deleting existing data in target table 'JOB_TASKS'...Done in 00:00:00
Deleting existing data in target table 'CONSENTED_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'LIFECYCLE_EVENTS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_PKGS'...Done in 00:00:00
Deleting existing data in target table 'DEP_PACKAGES'...Done in 00:00:00
Deleting existing data in target table 'SN_VERSION'...Done in 00:00:00
Deleting existing data in target table 'RULES_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_OBJECTS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_AUTH_CODES'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CT_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CERTIFICATES'...Done in 00:00:00
Deleting existing data in target table 'GROUP_MEMBERS'...Done in 00:00:00
Deleting existing data in target table 'CT_THIRD_PARTY_ROOTCERTS'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CERTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PRINCIPAL_PROPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_APPLICATIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES'...Done in 00:00:00
Deleting existing data in target table 'NODES'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS_DEF'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_EXTCERTS'...Done in 00:00:00
Deleting existing data in target table 'JMX_USERS'...Done in 00:00:00
Deleting existing data in target table 'CT_CERTS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_NAMES'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CONSENT'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CLIENTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_VER'...Done in 00:00:00
Deleting existing data in target table 'JOB_INSTANCES'...Done in 00:00:00
Deleting existing data in target table 'ROUTING_RULES'...Done in 00:00:00
Deleting existing data in target table 'RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'JOB_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'SITES'...Done in 00:00:00
Deleting existing data in target table 'LIB_CURRENT_ITEMS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_VERSIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_DATA'...Done in 00:00:00
Deleting existing data in target table 'LIB_CHARACTER_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_TYPES'...Done in 00:00:00
Deleting existing data in target table 'USERS'...Done in 00:00:00
Deleting existing data in target table 'GROUPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_TYPES'...Done in 00:00:00

Copying table LIB_ITEM_TYPES
Table LIB_ITEM_TYPES done. Copied 26 rows in 00:00:00

Copying table GROUPS
Table GROUPS done. Copied 13 rows in 00:00:00

Copying table USERS
Table USERS done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_TYPES
Table LIB_CONTENT_TYPES done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_ENCODINGS
Table LIB_CONTENT_ENCODINGS done. Copied 2 rows in 00:00:00

Copying table LIB_CHARACTER_ENCODINGS
Table LIB_CHARACTER_ENCODINGS done. Copied 1 rows in 00:00:00

Copying table LIB_DATA
Table LIB_DATA done. Copied 22 rows in 00:00:01