?
Solved

I have created a new oracle service called Ariel on Triton and now I can't see it in Services

Posted on 2005-03-02
12
Medium Priority
?
700 Views
Last Modified: 2013-12-11
I have created a new oracle service called Ariel on Triton and now I can't see it in Services? We had a pc crash at the weekend (power cut) and now some of my services are not found?

any ideas how to recover them?
Etravels
0
Comment
Question by:Etravels
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 8

Expert Comment

by:gvsbnarayana
ID: 13438378
You can try to create the Oracle service using ORADIM
HTH
0
 
LVL 8

Expert Comment

by:Pierrick LOUBIER
ID: 13438431
It seems your registry has been damaged... Check if some keys can be restored : Start -> Execute... regedit
Expand HKEY_LOCAL_MACHINE\SYSTEM\
Services are described under CurrentControlSet\Services, and backups are stored in ControlSet001\Services and ControlSet002\Services
If you find some stuff here, you can export the key, edit the .reg file (replace ControlSetxxx with CurrentControlSet), then execute the reg file to import.
But remember to export the full registry first, and be careful : editing manually the registry can cause unrecoverable problems !
0
 

Author Comment

by:Etravels
ID: 13440565
Thanks but I can't see the service there, how can I recover the service?

I can see other services like IO & IO2 but I can't see Ariel or POLVER3


Can i recreate them using a replicate of the IO services?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 8

Expert Comment

by:Pierrick LOUBIER
ID: 13440680
I guess you're talking DB services, so you'd better use ORADIM (already mentioned by gvsbnarayana). This is a command line tool, so open a DOS window. Here is the syntax (for full syntax, enter oradim at the prompt) :

ORADIM -NEW -SRVC name_of_your_service
0
 

Author Comment

by:Etravels
ID: 13441159
C:\>ORADIM -NEW -SRVC XXXX;
DIM-00008: A valid service name is OracleService appended with a SID.
DIM-00008: A valid service name is OracleService appended with a SID.


IS THIS CORRECT, I DID EXACTLY THE ABOVE?

cHEERS
0
 
LVL 8

Expert Comment

by:Pierrick LOUBIER
ID: 13441189
ORADIM -NEW -SRVC OracleServiceXXXX
0
 

Author Comment

by:Etravels
ID: 13447506
thanks that has worked

however, when I log in as sysdba I get the following:

sys/xxxx@io as sysdba:

ora: 125000 Tnslistner failed to start a dedicated server process

I can see all services started includind TNSLISTNER in services?

i also have the TNSNAMES set up correctly!

Cheers & Thanks
Etravels
0
 

Author Comment

by:Etravels
ID: 13447536
BTW...I CAN TNSPING XXXX OK... BUT WHEN I LOG IN I GET THE ABOVE!

THANX
0
 
LVL 8

Expert Comment

by:Pierrick LOUBIER
ID: 13447602
Sorry, but you're talking about XXXX label ('tnsping xxxx'), and you try to log in using 'connect sys/xxxx@io as sysdba' ? Could you confirm ?
0
 

Author Comment

by:Etravels
ID: 13447630
YES, SORRY, it was sys/xxxx@xxxx as sysdba...

0
 
LVL 8

Accepted Solution

by:
Pierrick LOUBIER earned 500 total points
ID: 13447647
Try :

ORADIM -EDIT -SRVC OracleServiceXXXX -startmode auto
0
 

Author Comment

by:Etravels
ID: 13447738
Cool, thanks for this all working now!
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question