Setting up Preferred User for Oracle 19c on Windows Server 2019

Oracle 19c can run on Windows Server 2019. Oracle 19c is certified to run on several versions of Windows, including Windows Server 2019, which is part of the officially supported platforms for Oracle Database 19c. Here are some key points to consider:
Supported Operating Systems for Oracle 19c:

• Windows Server 2019 (Standard, Datacenter, and Essentials editions) is officially supported.
• Windows Server 2016 is also supported.
• Oracle 19c can run on both 64-bit versions of these Windows operating systems.

Minimum Requirements:

1. Hardware:
   • CPU: Intel or AMD x86-64 processor.
   • RAM: Minimum 2 GB of RAM for Oracle Grid Infrastructure (for a single node) and Oracle Database installations.
   • Disk Space: At least 10 GB of free disk space for a typical database installation.
2. Software:
   • Windows Server 2019 64-bit is required.
   • Install required patches for Windows Server if any, depending on Oracle's release notes.

Additional Considerations:

• Ensure you have the correct prerequisites installed (such as the correct versions of Microsoft Visual C++ Redistributables, if required).
• Use the Oracle Universal Installer (OUI), which will help guide you through the installation and verify that the system meets all necessary prerequisites for installation.

Installation Resources:

• Oracle provides official documentation and installation guides for installing Oracle 19c on Windows platforms, including Windows Server 2019.

In summary, Oracle 19c is fully compatible with Windows Server 2019, and you can run it on this version of Windows with the appropriate setup.

In Oracle 19c, the modern equivalent of Enterprise Manager for running batch jobs and managing database tasks is Oracle Enterprise Manager Cloud Control along with Oracle Scheduler.
Here’s how batch jobs are managed in Oracle 19c:

1. Oracle Enterprise Manager Cloud Control:
   • Enterprise Manager Cloud Control is the modern, comprehensive management tool for Oracle environments. It includes advanced features for monitoring, administering, and automating tasks across databases, applications, and servers.
   • You can schedule and manage batch jobs, database backups, patching, and more using the Job Activity page in Enterprise Manager Cloud Control.
   • Cloud Control has a graphical interface for defining and managing scheduled tasks across multiple databases and environments.
2. Oracle Scheduler:
   • Oracle Scheduler (part of Oracle Database 19c) is the dedicated tool for creating, scheduling, and managing batch jobs within the database.
   • You can define jobs, chains (a series of jobs with dependencies), and schedules to automate various tasks.
   • Oracle Scheduler allows you to execute PL/SQL scripts, run operating system-level scripts, or invoke Java programs, providing flexibility for running a wide variety of batch processes.
   
   Example to create a simple scheduled job in Oracle 19c:

      BEGIN
         DBMS_SCHEDULER.create_job (
            job_name        => 'my_batch_job',
            job_type        => 'PLSQL_BLOCK',
            job_action      => 'BEGIN my_procedure; END;',
            start_date      => SYSTIMESTAMP,
            repeat_interval => 'FREQ=DAILY; BYHOUR=10; BYMINUTE=0',
            enabled         => TRUE
         );
      END;
      /
      

3. DBMS_SCHEDULER vs. DBMS_JOB:
   • In Oracle 8i, the DBMS_JOB package was used to schedule jobs. However, DBMS_SCHEDULER is the modern and more feature-rich package introduced in later Oracle versions, including 19c, and it is preferred for scheduling jobs.
   • DBMS_SCHEDULER offers more sophisticated scheduling, monitoring, and error handling features than DBMS_JOB.

Modern Equivalent Overview:

• Oracle Enterprise Manager Cloud Control: The web-based management tool for centralized monitoring and task automation.
• Oracle Scheduler (DBMS_SCHEDULER): The built-in database tool for scheduling and running batch jobs, replacing the need for older tools like DBMS_JOB from Oracle 8i.

In Oracle 19c, Oracle Scheduler (DBMS_SCHEDULER) is the primary tool for batch job automation, while Enterprise Manager Cloud Control provides an advanced GUI for managing jobs across the enterprise.

Now that you are able to run the Enterprise Manager console remotely, you can look at all your database nodes and monitor their activity. But wouldn't it be great if the console emailed you when one of your databases needed attention? You can set this up by creating a batch job.
A batch job can be run at predetermined times or when certain thresholds are reached in the database. For example, a batch job could be set up to run whenever your tablespace becomes 80 percent filled. The job could send you an email so you could add more space to the tablespace before it runs out of space. Before you can create a job that sends email to you, you must prepare your system by doing three tasks:

1. Create a user that can run batch jobs on the Windows NT system where the Management Server is running.
2. Configure the Management Server to use this user for its batch jobs.
3. Configure the Enterprise Manager to send email to you.

You will learn how to do the first step in this lesson. The following lessons cover the other two steps.
Once all of these steps are completed, you will be ready to create a batch job that sends you emails. This final task is covered in the last lesson of this module. Run the simulation below to see how to create and configure a new user that the Management Server will use to run batch jobs. This simulation demonstrates the tasks required when using the Windows NT server system.
Now you have a user who can log in to the Windows NT system as a batch job. The next step is to get the Management Server to use that user for its batch jobs. The next lesson shows you how to configure the Management Server to use the new Windows NT user for batch jobs.