Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
?
706 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
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

569 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