Help - Search - Members - Calendar
Full Version: How to create Oracle service with ORADIM command/
Oracle DBA Forums > Oracle > Oracle Forum
julia
Hi,
Can anybody help me how to create Oracle service with ORADIM command?
We use Oracle 9i version 2.
We need this for cold standby" - only one system is actively accessing the database files, in case of a failure the database is restarted on the other system.

Thank you
Julia
dave
just type oradim at the command line, it gives you all the options you need

CODE
ORADIM: <command> [options].  Refer to manual.
Enter one of the following command:
Create an instance by specifying the following options:
    -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
[-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
[-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
    -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
[-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
[-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
    -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Startup services and instance by specifying the following options:
    -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
[-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Shutdown service and instance by specifying the following options:
    -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
[-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
Query for help by specifying the following parameters: -? | -h | -help
burleson
smile.gif

Hi,

Dave Moore has complete details in his "Oracle Utilities" book, and here are directions:

http://www.dba-oracle.com/tips_oradim_utility.htm

Also, Mike Ault has some good stuff on oradim:

http://www.dba-oracle.com/art_dbazine_ault_start_stop_db.htm

CODE
C:\oracle9i\bin\oradim -startup -sid ORCL92 –usrpwd manager
-starttype SRVC,INST -pfile C:\oracle9i\admin\ORCL92\pfile\init.ora

startup — Indicates that the specified instance should be started.
sid — The SID of the database to start.
usrpwd — The password for the database user.
starttype — Specifies whether to start the instance, the service, or both (SRVC, INST).
ramkk
Don...is it possible to create multiple services on a single SID? My interpretation of service vs sid is probably wrong. Could you help me understand?

Can you correct me here - On RAC, say 3 instances (on 3 separate physical machines) , can I create different combinations of services using 3 instances? (srvone - using 1+2+3, srvtwo - using 1+3, srvthree - using 1+3 with different timeout setting like that...)

As I said, may be I am completely wrong relation between Service and SID

Thanks for your services to Oracle community!
dave
you are wrong in your interpretation - a service = a sid in the simplest terms

a service is only needed for autostarting the database in windows
burleson
Hi,

>> is it possible to create multiple services on a single SID? My interpretation of service vs sid is probably wrong. Could you help me understand?

The whole idea of "services" is part of the Windows crapware architecture.

On a real OS, Oracle spawns numerous background processes (SMON, PMON, &c) to control the instance.

Because Windows is garbage, all background processes must be encapsulated into a "service", the only processing mode that this crummy PC OS can support.

So, no, each instance has one and only one Oracle service (oracle.exe).



ramkk
Thanks Don for the note...that was helpful.Just one more clarification...

I many time noticed few of tns entries have SERVICE_NAME, and others have SID in the description. Are both just interchangeable and there is not difference between both entries?

Just like...

DEVORA=
(DESCRIPTION =
....
(CONNECT_DATA =
(SERVICE_NAME = devora10g)
)
)

if there is a same entry, except SID replacing SERVICE_NAME in it...

Thanks!
burleson
>> there is a same entry, except SID replacing SERVICE_NAME in it...

Usually, SID and service_name are the same, but in a distributed environment you can have many instances with the same ORACLE_SID.

Hence, distinct SERVICE_NAMES must be created . . .
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.