Prepare an Oracle Windows Service - Exercise

Objective: Prepare and verify the Windows service for a new COIN lab instance before database creation.

This is a Windows-only preparation exercise for a supported Oracle Database installation. The Oracle AI Database 26ai manual creation sequence includes this step on Windows. Use the ORADIM executable from the installed database home and confirm its options with oradim -?. On another platform, submit a written plan and mark service creation as not applicable.

Use a new, unused SID, a prepared initialization file, and an authorized lab account. Do not recreate an existing service. Service creation alone does not create a CDB or its data files.

Instructions

Write a command for SID COIN, PFILE C:\oracle\admin\coin\pfile\initcoin.ora, manual instance startup, and demand-start Windows service. Adapt the path to your lab.
Explain the difference between -STARTMODE and -SRVCSTART, and why the instance should not attempt to mount an uncreated database.
Provide commands to inspect service configuration and status. If you ran the command, include a redacted status summary and the ORADIM log outcome; otherwise label it a proposed procedure. Do not submit passwords.

Self-assessment: 5 points

Compare your response with the model solution. This page does not automatically grade free-text answers.

Correct SID and absolute PFILE path (1 point).
Manual instance startup (1 point).
Demand service startup and distinction from instance startup (1 point).
Service configuration/status and log checks (1 point).
New-service prerequisite and truthful execution status (1 point).