Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question.

Asked: October 27, 2006 - 9:21 pm UTC

Last updated: December 30, 2006 - 9:02 am UTC

Version: 2.1.0

Viewed 1000+ times

You Asked

Oracle Database 10g Express Edition always auto startup upon computer boot. May i know how i can remove the auto startup? I know manual shutdown is possible but it's too troublesome for an everyday activity.

Thanks in advance,
Ivan

and Tom said...

we use oradim to control that under windows

</code> http://docs.oracle.com/cd/B19306_01/win.102/b14304/create.htm#i1006533 <code>


C:\Documents and Settings\tkyte>oradim
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


specifically:


C:\Documents and Settings\tkyte>oradim -edit -sid XE -startmode manual

and later to start it:

C:\Documents and Settings\tkyte>oradim -startup -sid XE

C:\Documents and Settings\tkyte>





Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Or use Service Manager

A reader, October 29, 2006 - 1:05 pm UTC

Go to Control Panel -> Admnistrative Tools -> Services, select the Oracle services, double click them, and select "Manual" for startup.

You can also use NET START <servicename> to start it, and NET STOP <servicename> to stop it. In XP and 2003 there is the newer sc.exe command line tool to manage services.

Problems with Oradim

Toby, December 29, 2006 - 2:53 pm UTC

I tried your solution using Oradim, I've noticed this changes the ORA_XE_AUTOSTART key in HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE > KEY_XE

When I then restart my computer it doesn't fully boot up it hangs as soon as it eneters the desktop. I have to force shutdown and then it will boot but if I restart the computer again the same happens. Have you heard of this before? or has anyone else had this problem? If I change the setting back it stops happening.

Thanks
Tom Kyte
December 30, 2006 - 9:02 am UTC

nope, haven't heard of that.

A bit more about oradim

Stephan, December 30, 2006 - 4:36 pm UTC

Correct me if I'm wrong, Tom, but oradim does more than just put the service into a manual state - it also puts the instance within the service into manual.

Meaning, if you use oradim to put everything into manual, the service will be in manual, so it will not start with windows. In addition, the instance will be in manual - starting the service will not start the instance.

If you put the service into manual, the instance remains in auto - when you start the service, the instance starts automatically.

Hope that helps

Export from higher Version and import to lower version

Rahul Jain, January 16, 2007 - 5:15 am UTC

my main server is oracle 10g

and local server is oracle 8.1.6.0 means 8i

now i had exported dump from 10g,main server
and now i want to import it in 8i local server
but it is not possible.


so what can i do fo this
tell me the different ways through which i will get this result.

one dba tell that you have to install lower version client means 8i client on 10g database server.
i have tried this but at main 10g server it shows that only one home is possible,you cannot create the more than one home,if i install 8i client on same home then
Is it proper or not???????????????
Any error occured or not????????????
i think that it is risky ,because after installation any error occur then 10g not working then??????????????????????????????


please tell me the proper solution of that

or other wise give me the different way to export from higher version to import to lower version

please


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.