How can I start and stop Oracle server manually in windows?

FAQ

Memberlist

Usergroups

Profile

Preferences

· nixdoc.net

· man pages

· Linux HOWTOs

· FreeBSD Tips

· Forums

Forum index » Databases » Oracle

How can I start and stop Oracle server manually in windows?

Page 1 of 1 [10 Posts]

View previous topic :: View next topic

Author

Message

Rauf Sarwar
*nix forums Guru

Joined: 03 May 2005
Posts: 353

Posted: Tue Feb 15, 2005 4:40 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

Turkbear wrote:

Quote:

"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

Turkbear wrote:
"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

deanbrown3d@yahoo.com wrote:
Hi there,

A few people in my office use laptops that do demos of stuff
that
uses
oracle. Right now they have oracle server start up and shut
down
with
the operating system. If they want to stop the server manually,
they
go
to the window's Services and shut down the Oracle-related
services
one
by one.

I would like to stop the server from loading automatically, and
like
in
Linux do something like dbstart or dbstop, so that it only
launches
when I want it to.

Thanks for any tips. We are using 10g and 9 and 8, if that's
important.

Dean B.

1) Set the services that you want to start manually to "Manual"
from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown
the
database. Type oradim without any parameters to see usage.

Regards
/Rauf
Depending on the installation, shutting down the service before
shutting down the database instance it controls can be
bad...It is a good practice to do a shutdown immediate ( or
shutdown
abort..startup restricted .. shutdown normal) before
stopping the underlying Oracle windows services..

I would agree with you in general because I do exactly that out of
force of habit... even on my latop, however, Stopping the service
from
services or net stop calls the oradim.exe, which in turn shuts down
the
database depending on the SHUTDOWNTYPE flag in the registry i.e. i
for
Immediate etc. Unless you are against using oradim... service
shutdown
will follow the same steps that you have described.

Regards
/Rauf

No problem with oradim's method of shutdown, IF the registry is
correct - Not always the case...Using the database commands
to shut it down does not rely on the registry so I find it more
universally applicable.

We both agree in general to do this on Win* as you would on *nix But
try explaining that to the road warriors as in OP's case where these
are demo databases on laptops... they usually like simple procedures,
click to start and click to stop. I say that from personal experience
:)

Regards
/Rauf

Turkbear
*nix forums addict

Joined: 13 May 2005
Posts: 97

Posted: Tue Feb 15, 2005 3:42 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

Quote:

Turkbear wrote:
"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

deanbrown3d@yahoo.com wrote:
Hi there,

A few people in my office use laptops that do demos of stuff that
uses
oracle. Right now they have oracle server start up and shut down
with
the operating system. If they want to stop the server manually,
they
go
to the window's Services and shut down the Oracle-related services
one
by one.

I would like to stop the server from loading automatically, and
like
in
Linux do something like dbstart or dbstop, so that it only
launches
when I want it to.

Thanks for any tips. We are using 10g and 9 and 8, if that's
important.

Dean B.

1) Set the services that you want to start manually to "Manual" from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown the
database. Type oradim without any parameters to see usage.

Regards
/Rauf
Depending on the installation, shutting down the service before
shutting down the database instance it controls can be
bad...It is a good practice to do a shutdown immediate ( or shutdown
abort..startup restricted .. shutdown normal) before
stopping the underlying Oracle windows services..

I would agree with you in general because I do exactly that out of
force of habit... even on my latop, however, Stopping the service from
services or net stop calls the oradim.exe, which in turn shuts down the
database depending on the SHUTDOWNTYPE flag in the registry i.e. i for
Immediate etc. Unless you are against using oradim... service shutdown
will follow the same steps that you have described.

Regards
/Rauf

No problem with oradim's method of shutdown, IF the registry is correct - Not always the case...Using the database commands
to shut it down does not rely on the registry so I find it more universally applicable.

David Aldridge
*nix forums beginner

Joined: 03 Feb 2005
Posts: 46

Posted: Tue Feb 15, 2005 3:22 pm Post subject: Re: How can I start and stop Oracle server manually in windows?

I'd second that -- it's a neat way of getting an ordered start and stop to the system, and works for the listener, scheduler (10g), database, and any other service-based components.

Norman Dunbar
*nix forums beginner

Joined: 09 Feb 2005
Posts: 24

Posted: Tue Feb 15, 2005 3:17 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

Rauf Sarwar wrote:

Quote:

I assume you mean SID and not SID_NAME as in,
(CONNECT_DATA = (SID = ...)

Regards
/Rauf

I did indeed - thanks for reminding me. I tend to use SERVICE_NAME these
days and obviously forgot the correct syntax.

Cheers,
Norm.

Rauf Sarwar
*nix forums Guru

Joined: 03 May 2005
Posts: 353

Posted: Tue Feb 15, 2005 2:57 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

Norman Dunbar wrote:

Quote:

Rauf Sarwar wrote:

1) Set the services that you want to start manually to "Manual"
from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown
the
database. Type oradim without any parameters to see usage.

You can also also use ORADIM to set the shutdown mode as well - A for

abort, I for immediate or N for normal. Once set, the NET STOP
command
will use that shutdown mode when you want to shut things down.

I would also suggest starting the listener first (if you are using
one)
in order that 9i and 10g databases can register themselves with the
listener on startup. You'll only need this if your tnsnames.ora file
uses SERVICE_NAME instead of SID_NAME in the CONNECT_DATA.

I assume you mean SID and not SID_NAME as in,
(CONNECT_DATA = (SID = ...)

Regards
/Rauf

Rauf Sarwar
*nix forums Guru

Joined: 03 May 2005
Posts: 353

Posted: Tue Feb 15, 2005 2:33 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

Turkbear wrote:

Quote:

"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

deanbrown3d@yahoo.com wrote:
Hi there,

A few people in my office use laptops that do demos of stuff that
uses
oracle. Right now they have oracle server start up and shut down
with
the operating system. If they want to stop the server manually,
they
go
to the window's Services and shut down the Oracle-related services
one
by one.

I would like to stop the server from loading automatically, and
like
in
Linux do something like dbstart or dbstop, so that it only
launches
when I want it to.

Thanks for any tips. We are using 10g and 9 and 8, if that's
important.

Dean B.

1) Set the services that you want to start manually to "Manual" from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown the
database. Type oradim without any parameters to see usage.

Regards
/Rauf
Depending on the installation, shutting down the service before
shutting down the database instance it controls can be
bad...It is a good practice to do a shutdown immediate ( or shutdown
abort..startup restricted .. shutdown normal) before
stopping the underlying Oracle windows services..

I would agree with you in general because I do exactly that out of
force of habit... even on my latop, however, Stopping the service from
services or net stop calls the oradim.exe, which in turn shuts down the
database depending on the SHUTDOWNTYPE flag in the registry i.e. i for
Immediate etc. Unless you are against using oradim... service shutdown
will follow the same steps that you have described.

Regards
/Rauf

Turkbear
*nix forums addict

Joined: 13 May 2005
Posts: 97

Posted: Tue Feb 15, 2005 2:19 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

"Rauf Sarwar" <rs_arwar@hotmail.com> wrote:

Quote:

deanbrown3d@yahoo.com wrote:
Hi there,

A few people in my office use laptops that do demos of stuff that
uses
oracle. Right now they have oracle server start up and shut down with
the operating system. If they want to stop the server manually, they
go
to the window's Services and shut down the Oracle-related services
one
by one.

I would like to stop the server from loading automatically, and like
in
Linux do something like dbstart or dbstop, so that it only launches
when I want it to.

Thanks for any tips. We are using 10g and 9 and 8, if that's
important.

Dean B.

1) Set the services that you want to start manually to "Manual" from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown the
database. Type oradim without any parameters to see usage.

Regards
/Rauf
Depending on the installation, shutting down the service before shutting down the database instance it controls can be

bad...It is a good practice to do a shutdown immediate ( or shutdown abort..startup restricted .. shutdown normal) before
stopping the underlying Oracle windows services..

Rauf Sarwar
*nix forums Guru

Joined: 03 May 2005
Posts: 353

Posted: Tue Feb 15, 2005 2:07 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

deanbrown3d@yahoo.com wrote:

Quote:

Hi there,

A few people in my office use laptops that do demos of stuff that
uses
oracle. Right now they have oracle server start up and shut down with
the operating system. If they want to stop the server manually, they
go
to the window's Services and shut down the Oracle-related services
one
by one.

I would like to stop the server from loading automatically, and like
in
Linux do something like dbstart or dbstop, so that it only launches
when I want it to.

Thanks for any tips. We are using 10g and 9 and 8, if that's
important.

Dean B.

1) Set the services that you want to start manually to "Manual" from
Control Panel --> Services --> Start Type.
2) Create a batch script and use command "net start" to start the
service e.g.
C:\> net start OracleServiceORCL
C:\> net start SomeOtherService
Opposite of net start is net stop.

You can also use ORACLE_HOME\bin\oradim.exe to start or shutdown the
database. Type oradim without any parameters to see usage.

Regards
/Rauf

Norman Dunbar
*nix forums beginner

Joined: 09 Feb 2005
Posts: 24

Posted: Tue Feb 15, 2005 1:45 pm Post subject: Note

Re: How can I start and stop Oracle server manually in windows?

Rauf Sarwar wrote:

Quote:

You can also also use ORADIM to set the shutdown mode as well - A for
abort, I for immediate or N for normal. Once set, the NET STOP command
will use that shutdown mode when you want to shut things down.

I would also suggest starting the listener first (if you are using one)
in order that 9i and 10g databases can register themselves with the
listener on startup. You'll only need this if your tnsnames.ora file
uses SERVICE_NAME instead of SID_NAME in the CONNECT_DATA.

Cheers,
Norm.

deanbrown3d@yahoo.com
*nix forums Guru Wannabe

Joined: 04 Mar 2005
Posts: 144

Posted: Tue Feb 15, 2005 1:45 pm Post subject: How can I start and stop Oracle server manually in windows?

Hi there, A few people in my office use laptops that do demos of stuff that uses oracle. Right now they have oracle server start up and shut down with the operating system. If they want to stop the server manually, they go to the window's Services and shut down the Oracle-related services one by one. I would like to stop the server from loading automatically, and like in Linux do something like dbstart or dbstop, so that it only launches when I want it to. Thanks for any tips. We are using 10g and 9 and 8, if that's important. Dean B.

Google

Display posts from previous:

Page 1 of 1 [10 Posts]

View previous topic :: View next topic

The time now is Thu Jan 08, 2009 2:46 am | All times are GMT

Forum index » Databases » Oracle

Jump to:

Topic		Author	Forum	Replies	Last Post
Similar Topics
	Transfer qmail email account to postfix server	tallman	Postfix	0	Thu Jun 05, 2008 12:43 pm
	NFS server on Solaris 10	gurgle	Solaris	0	Tue Sep 04, 2007 7:05 pm
	Help required for configuring the VPN Server in Linux	SHERDIL	security	0	Sun Nov 19, 2006 2:22 pm
	Move Oracle 10g database to another location	Selt	Server	0	Fri Jul 21, 2006 2:14 pm
	Need Help with Program in Perl on a Netware Server	fhadzocos@gmail.com	Perl	3	Fri Jul 21, 2006 1:57 pm

Best Search Engine | Watch Naruto Online | Credit Cards | Personal Finance | Remortgages

Other DeniX Solutions sites: Unix/Linux blog | electronics forum | medicine forum | science forum |

[ Time: 0.2214s ][ Queries: 20 (0.1079s) ][ GZIP on - Debug on ]