sexta-feira, 19 de maio de 2023

[Oracle Autonomous JSON] Create new Instance on OCI Free Tier

Hello all!!!

How are you doing?

Today I'll show how you can create an Autonomous Database JSON instance on OCI Free Tier.

I'll use the instance in future posts about JSON and Oracle.

But always remember:
1) This step-by-step worked for me, but it may not work for you.
2) It's a basic and limited environment. The real life will be different, for sure.
3) This post is for study and testing as well, and has no concern for performance and security best practices.

So, let's get started!!!

1) Select "Oracle Database" in menu



2) Click on "Autonomous JSON Database"


3) Click on "Create Autonomous Database"


4) Select the Compartment - Never use the Root compartment, put other information (Display name, Database name) and password as well.






And now, I'm waiting for the conclusion of the process.



A few minutes later, the Instance is ready for use.





That's it my friend!! Easy!!!
I hope it helps you!

Regards
Mario

quinta-feira, 18 de maio de 2023

[Oracle 23c] How to install an Oracle 23c test environment on Linux 8 running on VirtualBox in five commands.

Hello all!!!

How are you doing?

Today I'll show how you can install Oracle 23c in a Linux 8 using VirtualBox.

If you need help to install Linux on VirtualBox, you can use this link: 

But always remember:
1) This step-by-step worked for me, but it may not work for you.
2) It's a basic and limited environment. The real life will be different, for sure.
3) This post is for study and testing as well, and has no concern for performance and security best practices.

So, let's get started!!!

1) We are run the dnf to install and configure pre-requirements using ROOT user.
dnf install -y oraclelinux-developer-release-el8
dnf install -y oracle-database-preinstall-23c

If you don't know what DNF is, it's a software package manager, the successor to famous YUM. The DNF check and install dependencies and determine some actions required to install this. Feel free to view this link and learn more about it: Using the DNF software package manager




2) I'll download the Oracle 23c software using WGET (or CURL).

wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm

or

curl -L -o oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm


3) Now, I'll install the Oracle 23c Software

dnf -y localinstall /root/oracle-database-free-23c-1.0-1.el8.x86_64.rpm


If I try to install using the Oracle user, I'll get this error:


4) It's time to create database in silent mode - using Oracle user

export DB_PASSWORD=SysOracle1106

(echo "${DB_PASSWORD}"; echo "${DB_PASSWORD}";) | /etc/init.d/oracle-free-23c configure



5) And finally, I'll enable the Oracle 23c on SYSTEMCTL

systemctl enable oracle-free-23c


The Oracle Env values are:
export ORACLE_HOME=/opt/oracle/product/23c/dbhomeFree
export PATH=$ORACLE_HOME/bin:$PATH

The credencials to connect will be:
-- CDB
sqlplus sys/SysOracle1106@//localhost:1521/free as sysdba

-- PDB
sqlplus sys/SysOracle1106@//localhost:1521/freepdb1 as sysdba

And finally, to start and stop the service, we can use:
/etc/init.d/oracle-free-23c stop
/etc/init.d/oracle-free-23c start



For this blog post, I used these great blogs:

And as Woody Woodpecker says: "That's all folks!!!"

I hope this helps you!!

Regards
Mario

segunda-feira, 8 de maio de 2023

[Oracle 23c] How to create and run an Oracle 23c test environment faster using Docker in four commands.

Hello all

How are you doing?

Today, I'll show how you can create and run a basic test environment with Oracle 23c using Docker with four commands.

Yes my friend, four commands!!!

But always remember:
1) This step-by-step worked for me, but it may not work for you.
2) It is a basic environment. Real life will be different, for sure.
3) This post is for study and testing only and has no concern for performance and security best practices.

As the UFC guy says, it's showtime!!!

1) Create New Container
docker run -d -p 1521:1522 -e ORACLE_PASSWORD=SysPassword1 -v oracle-volume=/opt/oracle/data gvenzl/oracle-free:latest


Important: If you have run it for the first time, the image download has been executed.  

2) List and rename the new container
docker ps
docker rename c814e75ee041 Oracle23c


3) Access the container Oracle23c
docker exec -it Oracle23c /bin/bash


And thats it!!! As simple as that!!

For this test, I used these fonts:

I hope this tip helps you!

Regards
Mario







Postagem em destaque

[ORACLE] Quick tips: Autonomous Health Framework (AHF) files cleanup.

Hello everyone.   How are you doing?   Today, I going to show you a quick tip about the AHF - Autonomous Health Framework.   In case your au...