473,396 Members | 1,915 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Re: starting Oracle service automatically

Hi,

try M$S servicebug 3

regards

s.kapitza

al******@alumni.fdu.edu (Ahmad) wrote in message news:<4a**************************@posting.google. com>...
Hi

I am using Oracle8i Enterprise Edition Release 8.1.6.0.0. with
windows2000 professional. The problem is that the database does not
start automatically when I reboot the machine. The status in service
panel is indicating starting instead of started.

I delete the password file , and drop the OracleServiceMYDB service
then reboot the machine and recreate the password file and
OracleServiceMYDB.

C:\>orapwd file=C:\Oracle\Ora81\DATABASE\pwdMYDB.ora password=mydb
entries=5
C:\>ORADIM -NEW -SID MYDB -INTPWD mydb -STARTMODE a -PFILE
C:\Oracle\admin\MYDB\pfile\initMYDB.ora

The instance is started and connected to mydb database. now I am able
to connect and work with the database “The status in service
panel is indicating started for OracleServiceMYDB service” now
every thing is ok, but when I reboot the machine, I got
OracleServiceMYDB starting but never started and got my old problem.
The following parameter is introduced into my windows registry as I
drop and recreate the service using ORADIM utility

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

ORACLE_SID"="MYDB
ORA_mydb_AUTOSTART= TRUE
ORA_mydb_PFILE= C:\Oracle\admin\MYDB\pfile\initMYDB.ora
ORA_mydb_SHUTDOWN= TRUE
ORA_mydb_SHUTDOWNTYPE=i
ORA_mydb_SHUTDOWN_TIMEOUT=30

By default OracleServiceMYDB service use LOCALSYSTEM account to
login as a service.
When I change the service to login as administrator the service is
started when I reboot the machine and the problem is solved. but not
as localsystem account.
For OracleOraHome81TNSListener and other services the localsystem is
working very well.
why this happened ?
TIA

Ahmad A Alghaden
al******@alumni.fdu.edu
KSA
Jun 27 '08 #1
0 1434

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

38
by: Mike | last post by:
No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2. Since we're moving from non-relational to...
5
by: Nathan Sokalski | last post by:
I currently have Oracle 9i Personal Edition installed on my computer (I use Windows XP Professional). I want to stop Oracle from starting automatically at boot time to avoid having it take up so...
2
by: ceadtinneh | last post by:
Folks, We're implementing a software based mirroring solution. This solution requires that the SQL Server service on the target server be stopped while data is being replicated from the source...
2
by: Ginters | last post by:
Hello there, This is a bit of strange one. My local version of SQL Server fails to start when I boot yet if I start Enterprise Manager its started and working fine. ISQL or Query Analyzer is...
6
by: Arnie | last post by:
We're using the ServiceController class provided by the .NET Framework, programming in C#. We are using the Start() method to start a service from another service. This works fine most of the...
7
by: Peter S. | last post by:
I currently have created a C# program that automatically updates an SQL database once everyday. It's an application that I manually start. I want make it so that if the (Windows 2003) server...
9
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work....
4
by: Ashley Bryant | last post by:
I've created a Windows Service in vb.net that is set up to run automatically, but it never starts during system startup. I can start it manually, but I need the service to start without any user...
7
by: Joseph Geretz | last post by:
I have a Service which runs OK, but I'm abviously not starting it properly. In my OnStart event I commence a long running process which polls a database table and performs various processing. Since...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.