V
V
Vaper672016-07-23 15:07:40
Oracle
Vaper67, 2016-07-23 15:07:40

How to stop and then restart an Oracle database instance with a specific name?

Hello. There is one more moment.
My goal is to create a new Oracle database instance with a specific name. I named it 'orcl'. But after adding a new instance to the database, this new database instance must also be restarted.
Everything is fine, only the following commands that I found to achieve a similar operation only work in Linux/Unix:
$srvctl stop database -d orcl
$srvctl start database -d orcl
And my Oracle database server is installed on Windows: I know in advance that you will say, like, "why did you deploy the database server on it?" etc. , so I answer right away: For now it is very convenient for me to study technologies through Windows, since unlike Linux and Unix, this OS is easy to use, but when I raise the server in a real task, then only on Linux / Unix.
I tried to use these commands on the Windows command line, but they don't work either ("srvctl" is not an internal or external
command, operable program or batch file.).
So, please tell me: how else can you stop and then restart an instance of 'orcl' ? Maybe there is another way to restart the database instance? If there is, then I beg you to describe it in detail.
If not, then please tell me: how to install the srvctl service on Windows so that I can start it there from the command line and restart my instance of the 'orcl' database through it? And then something Google gives me only information about installing a database instance for Linux / Unix users.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2016-07-24
@idShura

On Windows, this can be done like this:
NET STOP OracleServiceORCL
NET START OracleServiceORCL
OracleService SID - SID is the name of the desired instance, in your case it is ORCL.
To manage an instance in windows, you should read about the ORADIM utility (in Russian, you can read for example here )

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question