Q

Info on starttype option

I am running 9.2.0.7.0 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?

I read your note on SearchOracle about starting up databases on Windows. I am running 9.2.0.7.0 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.

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]
where:
  • 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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close