Simple Way to display Tabular data in Python

Posted on by Ahmed Abdel Fattah

Here below is a simple program to display data (list or list of dictionaries) in a tabular format using the "tabulate" package. This is the required output: Prerequisites: If you don't have the "tabulate" package installed, you can install it using: pip install tabulate The Program: Following is the program code: Sample Run: Following is … Continue reading Simple Way to display Tabular data in Python

Advertisement

ORA-01017: invalid username/password; logon denied

Posted on by Ahmed Abdel Fattah

I have a virtual machine with Oracle Database 19c installed. I downloaded this machine from Oracle. {If you are interested, you can download it from the following url: https://www.oracle.com/downloads/developer-vm/community-downloads.html } I started the virtual machine, login as oracle user, and ensured that the environment is set correctly: Then, I tried to login to the database … Continue reading ORA-01017: invalid username/password; logon denied

Oracle Database Cloud Service Provisioning is very slow

Posted on by Ahmed Abdel Fattah

While creating an oracle Database cloud service (or the new name “Oracle Base Database”): and after passing all the required information, and then clicking “Create DB System”, it started to provision the database system: The problem here is that it takes very long time to provision, I waited for 1 hours, 2,3,4 hours without luck. I … Continue reading Oracle Database Cloud Service Provisioning is very slow

How to Download Oracle software to VM in a private OCI subnet?

Posted on by Ahmed Abdel Fattah

I have a virtual machine located in an OCI private subnet. I need to install an Oracle software (e.g. Oracle ODI) in this VM.How I can download the software to this VM?We have a couple of options: 1- Download the software to your laptop, then sftp it to the VM (connecting through VPN and your … Continue reading How to Download Oracle software to VM in a private OCI subnet?

Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”

Posted on by Ahmed Abdel Fattah

While creating an oracle Database cloud service (or the new name "Oracle Base Database"), and after passing all the required information, and then clicking "Create DB System", I received the following error:Cannot access Object Storage using the subnet with the following OCID: ocid1.subnet.ocx.zz-yyy-xxxxxx-1.aaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx. Review your VCN configuration. If you need further assistance, contact Oracle Support. … Continue reading Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”

New and Updated OCI Courses

Posted on by Ahmed Abdel Fattah

The following OCI courses have new content updates. You can get the latest updates on the New Features being added on an ongoing basis to keep your learning current. Oracle Cloud Infrastructure DevOps Professional Developing Cloud Native Applications on OCI Oracle Cloud Infrastructure Architect Associate Build Visual Applications using Oracle Visual Builder Studio Introducing Content Management … Continue reading New and Updated OCI Courses

Installing Oracle Database Sample Schemas (21c)

Posted on by Ahmed Abdel Fattah

In this post, I’m going to explain how to install Oracle database sample schemas on Oracle database version 21c. Download the Scripts: Starting from Oracle database 12.2 ,the sample schemas setup scripts are now available from GitHub. Pick the release that matches your database release: https://github.com/oracle/db-sample-schemas/releases Extract the files: Extract the file “db-sample-schemas-21.1.zip” directly into $ORACLE_HOME/demo/schema, … Continue reading Installing Oracle Database Sample Schemas (21c)