I created an OCI compute Linux Instance with hostname = hostname_1. After a while, and based on the client request, I changed the above virtual machine hostname to be hostname_2.Client used this machine for a while, and then reboot it for some reason, but surprisingly, he found that the compute Instance hostname changed back to … Continue reading OCI Compute Instance Hostname keeps changing after reboot
error while loading shared libraries: libclntsh.so.19.1
While trying to run one of the Oracle Utilities (oratop), I received the following error:oratop: error while loading shared libraries: libclntsh.so.19.1: cannot open shared object file: No such file or directory. This error doesn't mean that the library doesn't exist, but in most cases, it is missing environment settings. Let us first check if this … Continue reading error while loading shared libraries: libclntsh.so.19.1
Oracle Database Hangs – FRA Space Issue
Although I feel (or claim) that I know how the FRA is working and I know much about the FRA mechanics, encountering FRA space issues consistently leads me to discover new insights and learn something new (very new). What was the issue? The Archiving process stopped working due to space shortage in the +FRA Disk … Continue reading Oracle Database Hangs – FRA Space Issue
SQL Developer Warning – could not install some modules
I have SQL Developer version 22.2 installed on my laptop, then I installed the latest version 23.1.1.Both of them are working fine, and I can run both of them simultaneously without any issue.I have also a separate installation for the Data Modeler version 23.1I restarted my laptop (I didn't restart it since more than one … Continue reading SQL Developer Warning – could not install some modules
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
Oracle Database 21c Documentation
Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation
Introduction to Oracle RAC One Node
Oracle Virtual Machines for Sale !
Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !
Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
Oracle Database 20c is now Generally Available
Oracle Database 20c is now Generally Available on the cloud two days ago, 14-Feb-2020. Oracle 20c is next major database release. It includes many new fetaures espcially in the following areas: BlockchainMachine LearningSecurityJSONIn-Memory For a quick introduction to this new release:https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release Also, for complete list of the new features, please refer to the:https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html Oracle Database … Continue reading Oracle Database 20c is now Generally Available
Ahmed AbdelFattah Blog ! 