Hello.

My goal is to create a new Oracle database instance with a specific name.
I called it 'orcl'. But after adding a new instance to the database, you need to restart this new database instance.

All anything, only the following commands that I found to achieve a similar operation work only 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 that "why did you deploy the database server on it?" etc., so I answer right away: for now it is very convenient to study technologies through Windows, because unlike * nix, this OS is easy to use, but when I’m going to raise the server in a real task, then only on Linux / Unix.

I tried to use these commands in the Windows command line, but they also do not work ("srvctl" is not an internal or external command, an executable program, or a batch file.).

Question: How else can you stop and then restart the 'orcl' instance?

Maybe there is another way to restart the database instance? If there is, then I beg 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 from the command line and restart my database instance 'orcl' through it? And then something Google gives me only info about installing a database instance for Linux / Unix users.

1 answer 1

On Windows, log in as a user who is in the ORA_DBA group. If you installed Oracle, then you must be in this group. Call the command interpreter and go to sqlplus there:

 sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 19:31:36 2016 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 820236288 bytes Fixed Size 1339628 bytes Variable Size 662703892 bytes Database Buffers 150994944 bytes Redo Buffers 5197824 bytes Database mounted. Database opened. SQL> SQL> -- теперь остановим SQL> SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down.
  • Thanks for the answer, otherwise I began to create a separate group in windows (for ASM and DB), while simply forgetting the name of the group to which authentication should be made to the default database :-D - Minion Skywalker
  • You are welcome! Why not ssyotlochki ssylochku in the comments? It seems everything is described there. - 0xdb