【Oracle】How to fix ORA-65096 at creating user

2020/05/09

Ovewivew I encountered ORA-65096 when I tried to create user at Oracle 18c Express Edition. This is a example to fix ORA-65096. Environments OS : Windows10Oracle : 18c Express Edition Error SQL> CREATE USER user01 identified by password01 default tablespace USERS; ORA-65096: ORA-65096: invalid common user or role name Step1 : Checking database Oracle has two databases ,’CDB’ and ‘PDB’. It seems it’s not possible to create local user on CDB, so we have to check which database are used. SQL> show con_name; CON_NAME —————————— CDB$ROOT If you find CDB lie the above, It’s good to try change it to … Rundeck installation on CentOS7 2020/05/09 Overview Rundeck is functional Open Source Software for job management. It is more useful than cron because it can realize workflow, scheduling and so on. Following shows how to install Rundeck on CenOS and access it from a web browser. Rundeck https://www.rundeck.com/open-source Environment OS : CentOS7JDK : Openjdk8Rundeck : 3.0.13 Step1 : Installation of JDK At first you have to install JRE because Rundeck requires java runtime environment. This is a example to install JDK for it. #Installation of jdk$ sudo yum -y install java-1.8.0-openjdk java-1.8.0-openjdk-devel #Adding JAVA_HOME path in .bash_profile $vim .bash_profile export JAVA_HOME=/lib/jvm/java-1.8.0-openjdk-1.8.0.191.b12-1.el7_6.x86_64 export PATH=$PATH:$JAVA_HOME/bin export PATH=$PATH:\$JAVA_HOME/jre/bin …

【Python】Changing images periodically with tkinter

2020/05/03

Overview There is a good library in python to make GUI, that is tkinter. It can display images too. Here, we are trying to change images periodically with tkinter. Python library to be used Following three libraries are used. tkinter ‘tkinter’ is used to make GUI. PIL(pillow) ‘PIL’ is used to deal with images in the python. threading ‘threading’ is used to change images automatically. Detail about that will be explained later. By the way, if you are using anaconda which contains these three libraries already , you don’t have to install them with pip command. Step1 : Display a …

Cleaning up Rundeck database

2020/05/03

Overivew As a result of mistake of crontab setting for a job, Over 200 thousands of activity log was created. Somehow it’s not possible to delete project. Maybe it has too much activity and it takes too much time more than accepted. In the following , There are procedure to delete whole MySQL database for rundeck and clean all jobs and activities so on. Environments OS : CentOS7MySQL：Ver. 15.1Rundeck：Ver. 3.0.13 Step1 : Backup of jobs If you drop the MySQL database for rundeck all jobs are removed. So you have to export the important jobs for you beforehand.The procedure is …

Anaconda installation on CentOS

2020/04/29

Overview Anaconda package is very useful tool for data analysis by python language. This article shows how to install it on CentOS. Environments OS:CentOS7Anaconda3：3-5.3.1 What is Anaconda Nowadays the usage of python language is being more popular than before for the purpose of machine learning or processing data. Anaconda package is consists of not only python engine but also IDE, web-base editor or some useful tools. When you just install anaconda, you can use these bundled useful tools. CentOS7 has python 2 as a default but in this example we use Anaconda with python3. Step1 : pyenvのインストール At first let’s …

Developing Oracle from VS Code

2020/04/29

Overview Since My favorite code editor is MS VS Code, for developing oracle database understanding how to install plugin for oracle. Enviroments OS：Windows 10 64bitVScode ：1.44.2Oracle ：Oracle 18c XE Step1 : Installation of “Oracle Developer Tools for VS Code” Open your VS Code and find plugin ‘Oracle Developer Tools for VS Code’ and click the install button. You may get this warning at this time. Because this plugin needs .Net core Runtime, you have to get it from the following website. https://www.oracle.com/database/technologies/appdev/dotnet/install-dotnetcore-windows.html You have to reboot VS Code after installation of .Net core runtime. If you don’t get this message, …

Metabase installation on Windows

2020/04/29

Overview Metabase is a kind of Business Intelligence tool and Open Source Software itself. Here it shows how to install Metabase on windows with OpenJDK. Environments OS : Windows10JDK : OpenJDK 13.0.2Metabase : version 0.33.4 Step1 : Installation of JDK According to Metabase website、Metabase works with OpenJDK or OracleJDK. This example uses OpenJDK13 from following URL. https://jdk.java.net/archive/ After downloding OpenJDK13 zip file, decompress and put it in the any folder. This is a example path to java.exe in case you make the metabace folder at c:\ . C:\metabaseopenjdk-13.0.2_windows-x64_bin\jdk-13.0.2bin\java.exe Step2 : Downloading Metabase You can get metabase.jar file from following URL. …

Rundeck installation on Windows

2020/04/27

Goal Rundeck is excellent Open Source Software to execute some scripts instead of cron. The purpose here is establishing Rundeck server on windows. Environments OS : windows10JDK : Openjdk8Rundeck : 3.1.0 Step1 : Installation of JDK Move to OpenJDK and install openjdk8. If you use other versions of jdk, it may not work properly , please note it. https://openjdk.java.net/ After you downloaded zip file in your local folder , decompressed it.You can find java.exe in the decompressed folder and you have to add path to your user environmental variable. Step2 : Installation of Rundeck Next, let’s install runeck. You can …