Sql Server 2019 Cumulative patching [CV] [KB5011644] [15.0.4223.1] is failed with following error.

Error:

     The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory

 

Reason:-

Check the parameters of “DefaultLog” in the below path in the server registry.

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.EFTS\MSSQLServer

 

Update the correct path in the registry and retry the patching.

Always on database creation failed

 

Always on Database creation failed while adding the database in availability databases using "Full database and log backup" data synchronization preference.

Error:

The following required directories do not exist on replica test11\DRtest : D:\ Data\testdb,L:\ Data\testdb_logs. (Microsoft.SqlServer.Management.HadrModel)

 

------------------------------

Program Location:

 

   at Microsoft.SqlServer.Management.HadrModel.Validator.Validate(IExecutionPolicy policy, ScenarioValidatorHandler validationDelegate)

   at Microsoft.SqlServer.Management.Hadr.TestDatabaseFileLocationCompatibility.DoWork()

   at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run()

 

 

Reason:

Incorrect database default datafile & logfile location mentioned in the configuration. Change it in database default locations in “server properties”

 

ORA-27370 ORA-27300 ORA-27301 ORA-27302 ORA-27303

 Issue:- 

 Execute windows shell script[bat file] from oracle scheduler.

Error Code:-

ORA-27370: job slave failed to launch a job of type EXECUTABLE

ORA-27300: OS system dependent operation:accessing job scheduler service failed with status: 2

ORA-27301: OS failure message: The system cannot find the file specified.

ORA-27302: failure occurred at: sjsec 6a

ORA-27303: additional information: The system cannot find the file specified.

Reason for the issue:-

The scheduler job [OracleJobScheduler<dbname>] down and it should be up and running to run jobs in the database