I read your note on SearchOracle about starting up databases on Windows. I am running and am wondering how to tell if the stsrttype=srvc,inst. The registry key ORA_<instance>_AUTOSTART=TRUE for each instance on the box and the ORA_<instance>_pfile points to the appropriate pfile for each DB. Is that where I look to check the answer or is there another place it is stored? Thanks.

    Requires Free Membership to View

The starttype option is used as a start option when using oradim to start the database. Here is the syntax for doing this:

oradim -STARTUP -SID SID [-USRPWD user_pwd] [-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename]
  • STARTUP indicates that you are starting an instance that already exists. This is a mandatory parameter.
  • SID SID is the name of the instance to start. This is a mandatory parameter.
  • USERPWD user_pwd is the password.
  • STARTTYPE srvc, inst indicates whether to start the service or the instance. One or both values can be specified. If it is not specified, then the registry is checked for the current setting.
  • PFILE filename is the initialization parameter file to be used with this instance. Ensure that you specify the complete path name of this file, including drive letter.

For more information on using the oradim utility to administer Oracle databases, look at the Oracle9i Database Release 2 (9.2) Administrator's Guide for Windows.

This was first published in June 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: