https://www.youtube.com/watch?v=5rOkLCdbIE4 For more info:https://ahmedfattah.com/2020/09/03/oracle-rac-one-node-training-course/ Ahmed
Blog
ORA-01017: invalid username/password; logon denied
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
Introduction to Unix/Linux Administration
Oracle Database Cloud Service Provisioning is very slow
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?
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”
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
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)
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)
ORA-01031 when using JSON Data Guide
What is JSON Data Guide? A JSON data guide lets you discover information about the structure and content of JSON documents stored in Oracle Database. Some ways that you can use this information include: Generating a JSON Schema document that describes the set of JSON documents. Creating views that you can use to perform SQL … Continue reading ORA-01031 when using JSON Data Guide
sqlcl java errors under different database homes
When trying to run the sqlcl version 22.1 on my new laptop (Windows 11 with many oracle database homes), I got the following errors: I have many oracle homes on my machine (Oracle Database 12cR1, 12cR2, 18c, 19c & 21c). After long research, it looks like that sqlcl pick the JRE under the environment ORACLE_HOME. … Continue reading sqlcl java errors under different database homes
Auditing Individual Functions/Procedures inside a PL/SQL Package
I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package
Ahmed AbdelFattah Blog ! 