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.ora
For some reason, I want to change the parameter file to be:
M:\app\oracle\database\initPROD.ora
{Actually, I’m preparing this database to be part of a Fail Safe environment, and I need the parameter file to be located on a shared disk, so as it will be accessible by the database instance on the other node}.

So, how we can do that?
This can be done using the “oradim” utility as follows:
oradim -EDIT -SID PROD –pfile D:\app\oracle\database\initPROD.ora

This will do the job.

To query about all options available for the oradim utility, use the following command:
oradim -help

Another example, if you want to create a new service for a new database, use the following command:
oradim –new –sid ORCL –startmode manual –pfile D:\app\db193\WINDOWS.X64_193000_db_home\database\initORCL.ora

Donate to support our blogging work

Donate to support our blogging work

$1.00

Thanks
Ahmed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s