Very Computer

by **Nick Woodruf** » Wed, 19 Sep 2001 18:26:27

Installed Oracle 8.1.6 under Windows/2000 but don't want to start
Listener/Oracle services automatically from Win/2000 Services option and
would like to start via script without having to go into Win/2000 services
and start each service individually

I can start the listener manually via lsnrctl start command.

Is there a similar script to start the instance (svrmgrl??)

Thanks

by **Chuck Hamilto** » Wed, 19 Sep 2001 23:57:57

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Quote:> Installed Oracle 8.1.6 under Windows/2000 but don't want to start
> Listener/Oracle services automatically from Win/2000 Services
> option and would like to start via script without having to go into
> Win/2000 services and start each service individually

> I can start the listener manually via lsnrctl start command.

> Is there a similar script to start the instance (svrmgrl??)

startup.sql
===========
connect internal
startup
exit

startup.bat
===========

Hope this helps.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO6dg8mm5A4kkb4ZsEQLXAQCdE02lE7cpFQmTGA9tSBNW7vU07F8AniQu
4x+VGJgvLQuMpgGd0Von+gmC
=3ZJi
-----END PGP SIGNATURE-----

by **Oracle** » Fri, 21 Sep 2001 01:17:22

> Installed Oracle 8.1.6 under Windows/2000 but don't want to start
> Listener/Oracle services automatically from Win/2000 Services option and
> would like to start via script without having to go into Win/2000 services
> and start each service individually

> I can start the listener manually via lsnrctl start command.

> Is there a similar script to start the instance (svrmgrl??)

> Thanks

You can actually use the Windows commands to stop and start services
in your script or from the Command Prompt -

net stop OracleService<SID>
net start OracleService<SID>

Very Computer

How to start service under WIn/2000

How to start service under WIn/2000

How to start service under WIn/2000

How to start service under WIn/2000