on 02-22-2010 12:32 PM
Dear All,
I am getting error in starting the OracleServiceDQA in windows it is given below error
could not start the oracleserviceDQA service on Local Computer
Error 1053: The service did not respond to the start or control request in a timely fashion.
It has come suddenly
Please suggest how to solve it
Regards,
Kumar
Hi,
Add OracleServiceDQA user in Administrators group and restart the service..
Regards.
Rajesh Narkhede
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks,all
The problem I have face after apply patchset of oracle .I am login as admin and the OracleServiceDQA user in Administrators group already.
Oracle listener service is stared.
There are 2 error in event log
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 2/23/2010
Time: 9:29:08 AM
User: N/A
Computer: *****
Description:
Timeout (30000 milliseconds) waiting for the OracleServiceDQA service to connect.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 2/23/2010
Time: 9:29:08 AM
User: N/A
Computer: *****
Description:
The OracleServiceDQA service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
regards,
Hi Kumar
Try the followings
1.Login to the database server with <SID>ADM user
2. Open the command prompt. Browse to ORACLE_HOME
3. Run command : Oradim u2013DELETE u2013SRVC OracleService<SID>
4. Restart your server
5. Open the command prompt . Browse to ORACLE_HOME
6. Run the command: oradim u2013 NEW u2013 SID <SID>
Your Oracle_Home, Oracle_SID should be defined in the environment variables of SIDADM user
You can also take the help of OSS 551542
Regards
ANindya
Edited by: Anindya Bose on Feb 23, 2010 5:56 PM
HI
when you are trying to register the service what is the error message you are getting from the command prompt?
Is it throwing any error message in command prompt? If the service is created properly you should get a message
"Instance Created
Exiting Oradim with 0"
Can you try to delete and recreate the service once again?
Command to re-create the service: oradim -new -sid <SID> -srvc OracleService<SID>
Once the service is created go to service properties and change the start up mode to "Automatic"
Regards
Anindya
Hi,
It is giving below error. Please suggest.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>F:
F:\>cd F:\oracle\ora92\bin
F:\oracle\ora92\bin>oradim -new -sid DQA -srvc OracleServiceDQA
DIM-00019: Create Service Error.
Regards,
Kumar
Hi Kumar
I can see you have logged on as Administrator not <SID>ADM
Just logon as SIDADM user, check whether SIDADM is a member of Administrator, ORA_SID_DBA, ORA_DBA and ORA_SID_OPER group. ( From my computer, right click "Manage"--> User)
Perform deletion and creation of the service once again with SIDADM.
No need to go to oracle bin directory. Just login-->open command prompt and run all those steps I mentioned in my previous post.
Regards
Anindya
Hi Anindya,
Sorry ,for late update I have tried by SIDADM login but the same error.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\dqaadm>oradim -delete -sid DQA
C:\Documents and Settings\dqaadm>oradim -new -sid DQA
DIM-00019: Create Service Error.
C:\Documents and Settings\dqaadm>
Please help
Regards,
Kumar
Hi Kumar
What is the message you are getting when you are trying to delete the Service?
It should say "Instance Deleted. First delete the service with the command I mentioned. You should get "Exiting with 0" message.
That message confirms that the service has been deleted successfully. Only after successful deletion of the previous service you can create a new one.
Go to run ---> Type "Services.msc" and check whether the service still exist. ( it should not exist)
Then only create the service once again. If the previous one is not deleted properly, you can not create a new service with the same name.
Please also go to My Computer>right click "Manage">"Local User and Groups">"User"->DQAADM > Double click on it->"Member of" tab .....................which are the groups for this user id?
Follow the below steps.
1.Login to the database server with DQAADM user
2. Open the command prompt
3. Run command : Oradim u2013DELETE u2013SRVC OracleServiceDQA
4. Restart your server
5. Open the command prompt
6. Run the command: oradim u2013NEW u2013SID DQA
Can you please tell me the path of your SPILE and PFILE?
Regards
Anindya
Hi Mohan,
In the kernel folder run the application starting with vcredist*.msi( as per the configuration of your system). This should solve the problem and start the service. It mainly occurs because of some missing dll file and running this application would sort it and the above solution worked for me.
Regards,
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is it a new installation? Can you check if service owner user is in all admin authorization groups?
Can you start database manually with commands?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Delete the OLD service. Command to delete Oradim u2013DELETE u2013SRVC OracleServiceSID
Restart Windows
Create new service Command to create * oradim u2013 NEW u2013 SID SID*
This should help you
Edited by: Anindya Bose on Feb 22, 2010 6:28 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the Windows Event Viewer for any errors. Do you get any error there?
What is the status of Oracle listener service ?
Under which user account the Service is trying to start ?
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.