I am studying oracle DBA (on my home computer) and I have pretty much tried almost all aspect of DB Administration and they work great. I am running Oracle 8i(8.1.5) Enterprise edition on NT. But lately, I have been hearing the word ORADIM a lot. Can any body please tell me what it is and its purpose? And how come I have missed it though, I think I have practised all aspects of DB Administration.
If a db is created upon install of Oracle, it creates the service to the db by itself. If you were to create a db from scratch, you have to create a service to the db, before you actually create the db.
huh?? I wonder who said that there is no Oradim in 8i. I have a few 815 dbs on NT. All services to the db have been created using Oradim. I would think that w/o Oradim, one cannot create a service to the db.
Can you please explain ORADIM to me? I am really getting confused on this. I have been using Database config Assistant to create the databases so I have never had to use Oradim. Can you please explain step by step when it has to be used, why it has to be used, etc. Also if there is any link or url that has information on Oradim, can you give it to me?
Ok, let me see if I can explain this in a good way. Oradim is an Oracle utility that creates a Service to a db. If a db is created upon install, or if you use Database Assistant to create a db, it will automatically use this utility to create a service to the db upon creation of the db. If you double click on the Services icon in Control Panel, you will see all the services that are available to the machine. If a machine has a db running on it, you will see a service by the name of OracleService(SID) with a manual or automatic startup type. If the startup is set to automatic, the db will shutdown/startup whenever the machine is restarted, else you will have to shutdown/startup manually.
Example of Oradim to create a service for an 8i db:(to be typed at command prompt) --->
ORADIM -NEW -SID (DB_NAME) -INTPWD ORACLE -STARTMODE AUTO -PFILE (PATH_OF_PFILE) ---> This creates a service to a db with an automatic startup.