Automatic start of database instance with Oracle 8i on Windows 2000 server

Published: 03 Sep 2004

We have an Oracle 8i database running on Windows 2000 server. I want to put the database instance starting automaticaly on Windows startup. The Oracle database service and TNS listener service are starting automatically at startup, but the instance is not starting. What could be the problem?

Check your alert log. If there are no errors there, then the service probably isn't set to start the instance automatically. On oradim, there's an option for the startmode. You may need to edit that with some syntax similar to this (not sure if this is it exactly since I don't run Oracle on Windows):

oradim -edit -SID SIDNAME -startmode srvc,inst

Dig Deeper on Oracle database installation, upgrades and patches

Cannot create services in Oracle 9i I am trying to create a database manually in Oracle 9i. I successfully created a password file but am unable to create services.

Could not resolve service name I've installed Oracle9i in Windows XP, and when I try to connect through SQL*Plus it gives me an error: "TNS:Could not resolve Service name." I connected using scott and tiger. I even tried through svrmgrl in the command prompt. There it gives me the error as "Message 4505 not found; No message file for product=RDBMS, Facility=MGR. ORA-12560:TNS:Protocol Adapter Error."

"Oradim.exe has encountered a problem" error I am having some problems with running my Oracle instance. Anytime I try restarting the service, I get this error: "oradim.exe has encountered a problem and needs to close. We are sorry for the inconvenience." The listener and agent cache are both running fine. The error started while I was trying to import a database dump into my database.

Have to reinstall Oracle8i on Windows XP each time I restart Whenever I install Oracle8i on my computer when in the Windows XP OS, it works well, but only for that time until I shut down my computer, after which it disconnects and I have to re-install it again, every time I start the computer. How should I configure it to remain connected throughout?

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?

DIM-00019 error I have installed Oracle9i on Windows 2000. When I start the Oracle Database Assistant I am getting the "DIM-00019: message 19 not found" error.

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Automatic start of database instance with Oracle 8i on Windows 2000 server

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Why reducing hiring bias isn't easy

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.