In this quick demo, I'll explain to you the steps to export one schema called OE using expdp utility. Please note that you should already created a directory to hold the dump files and log files, using the following steps: https://www.youtube.com/watch?v=FOAlULoHrqA ThanksAhmed
Oracle Fail Safe 4.2.1 Implementation Plan on Windows 2016 and Oracle 12cR2
Following is the high level plan of Fail Safe 4.2.1 implementation on Windows 2016 and Oracle Database 12cR2 (12.2.0.1). System Administrator Activities: Database Administrator Activities: ThanksAhmed
OPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 "Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714" on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will attempt to re-lock. Solution: I opened another command window as Administrator, and applied the patch again. This time, it completed successfully without errors: For Windows platform, … Continue reading OPatch error : “Unable to lock Central Inventory”
How to Modify an Oracle Database Windows Service?
This is a quick post about how we can change some parameters for one database winodws service. Background:I have a database called PROD with version 19.3, running on Windows. Its service looks like: This Windows service was configured with the parameter file:D:\app\db193\WINDOWS.X64_193000_db_home\database\initPROD.oraFor some reason, I want to change the parameter file to be:M:\app\oracle\database\initPROD.ora{Actually, I'm preparing … Continue reading How to Modify an Oracle Database Windows Service?
What is Oracle Home User in Oracle Database 12c?
In this post, I'm documenting some valuable information from different resources, about the "Oracle Home User" that is introduced in Oracle 12.1, and the difference between the "Oracle Home User" and the "Oracle Installation User"? ThanksAhmed
Which User should I use for an Oracle Fail Safe Installation?
In Summary: when you are installing Oracle Fail Safe environment with Oracle 12c database, you need to operating system users: 1- Domain User with Administrative privileges on all the cluster nodes. This user will be used to configure Microsoft Failover cluster, Oracle Database Installation and Oracle Fail Safe Installation. 2- Domain User without Administrative privileges. … Continue reading Which User should I use for an Oracle Fail Safe Installation?
[INS-32101] While installing Oracle Database on Windows in a Fail Safe Environment
Background: I'm installing Oracle Database 12c R2 (12.2.0.1) software on Windows, as part of installing and configuring an Oracle Failsafe 4.2.1 environment. What is the problem? While installing Oracle Database 12.2.0.1 software on Windows, and at step number 5 "Oracle Home User", I specified a domain user in the form:company.local\abc-oinstallerBut, when I clicked "Next", I … Continue reading [INS-32101] While installing Oracle Database on Windows in a Fail Safe Environment
Ahmed AbdelFattah Blog ! 