Home » Infrastructure » Windows » Oracle VSS Services (Windows Server 2016)
Oracle VSS Services [message #684522] Tue, 22 June 2021 09:53 Go to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
Hellow

Problem to Acronis 15 to backup Oracle 12c. Meesage: "No Oracle VSS Writer service is running. No database will be backed up".
Acronis suggests that you reinstall VSS. I've never done anything with VSS. Can you please reinstall VSS oracle? I do not see this option in the installer (for Windows).

[Updated on: Tue, 22 June 2021 09:54]

Report message to a moderator

Re: Oracle VSS Services [message #684523 is a reply to message #684522] Tue, 22 June 2021 15:44 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Perhaps the official docs?

(It was the first hit when I googled "how to start oracle vss writer service".)
Re: Oracle VSS Services [message #684524 is a reply to message #684523] Tue, 22 June 2021 16:12 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
VSS Write% SID% service is running. Only Acronis can't see her.
Acronis suggests that you reinstall VSS. I've never done anything with VSS.
Should I do:

oravssw /start ????

or
oravssw ODB /i



My SID : ODB


Uinstall: oravssw {ODB [/d]}

Message: Waiting for VSS events (press Ctrl-C to stop writer)

Install: oravssw {ODB [/i {/user:domain\Administrator /password:mypassword}]}

Message: Waiting for VSS events (press Ctrl-C to stop writer)

[Updated on: Tue, 22 June 2021 23:38]

Report message to a moderator

Re: Oracle VSS Services [message #684529 is a reply to message #684524] Wed, 23 June 2021 10:28 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
I've never had to deal directly with vss, and have never seen Acronis. That said, it sounds like an Acronis issue. At least that's where I'd start looking.

Acronis Support
Re: Oracle VSS Services [message #684530 is a reply to message #684522] Wed, 23 June 2021 11:05 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I cannot speak from experience of your particular problem, but I do know that frequently there are issues with the Windows accounts under which the various services are running. Is your VSS service running under the same account as the DB service? What account is running the Acronis service? Are you using local or domain accounts?
Re: Oracle VSS Services [message #684531 is a reply to message #684530] Wed, 23 June 2021 22:51 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
YES - VSS service running under the same account as the DB service (accound Admin domain).

Message Acronis: No Oracle VSS Writer service is running. No database will be backed up.

[Updated on: Wed, 23 June 2021 23:15]

Report message to a moderator

Re: Oracle VSS Services [message #684532 is a reply to message #684531] Thu, 24 June 2021 00:52 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
What account is running the Acronis service? Are you using local or domain accounts?
Re: Oracle VSS Services [message #684533 is a reply to message #684532] Thu, 24 June 2021 01:20 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
Domain Account.
Re: Oracle VSS Services [message #684534 is a reply to message #684533] Thu, 24 June 2021 01:40 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
What account is running the Acronis service?
Re: Oracle VSS Services [message #684535 is a reply to message #684534] Thu, 24 June 2021 01:42 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
domain\Administrator
Re: Oracle VSS Services [message #684536 is a reply to message #684535] Thu, 24 June 2021 01:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So your VSS service, your Oracle database service, and Acronis are ALL running as domain\Administrator? I have never seen that done before. I would create a new user specifically for running these services. Preferably a local user, and be sure to add him to the various local Oracle groups (all of them) and the Administrators group. If Acronis still (running as that user) still cannot see the VSS, then throw the problem back to them.
I know that domain users are considered better than local users, but often not for Oracle. Some people like to install Oracle under a virtual account, which introduces another set of problems. Are you sure you didn't do that?
Re: Oracle VSS Services [message #684537 is a reply to message #684536] Thu, 24 June 2021 02:06 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
Installed as Administrator domain via RDP.
Re: Oracle VSS Services [message #684538 is a reply to message #684537] Thu, 24 June 2021 03:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your answers are very brief, you know. I'll try again.

1. When you installed the Oracle home (never mind whom you were logged on to Windows as, it would have to be someone in the local Administrators group) you were prompted to supply a Windows user that would own the home. The current release suggests creating a virtual account. Earlier releases (and still my own choice) default to the local system account. What did you say to that prompt?

2. What account are the services running under? For example, for my orclz instance:
C:\Users\john>sc qc oracleserviceorclz
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: oracleserviceorclz
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : c:\app\oracle\product\19.3.0\bin\ORACLE.EXE ORCLZ
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : OracleServiceORCLZ
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

C:\Users\john>sc qc oraclevsswriterorclz
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: oraclevsswriterorclz
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : C:\app\oracle\product\19.3.0\bin\OraVSSW.exe ORCLZ
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : OracleVssWriterORCLZ
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

C:\Users\john>
3. As whom are you running the Acronis product? If you launch it from a CMD shell, who are you? For example:
C:\Users\john>whoami /all

USER INFORMATION
----------------

User Name SID
========= =============================================
jw\john   S-1-5-21-1889652306-443339906-4187214991-1001


GROUP INFORMATION
-----------------

Group Name                                                    Type             SID                                           Attributes
============================================================= ================ ============================================= ==================================================
Everyone                                                      Well-known group S-1-1-0                                       Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\Local account and member of Administrators group Well-known group S-1-5-114                                     Group used for deny only
jw\ORA_ASMADMIN                                               Alias            S-1-5-21-1889652306-443339906-4187214991-1017 Mandatory group, Enabled by default, Enabled group
jw\ORA_ASMDBA                                                 Alias            S-1-5-21-1889652306-443339906-4187214991-1014 Mandatory group, Enabled by default, Enabled group
jw\ORA_ASMOPER                                                Alias            S-1-5-21-1889652306-443339906-4187214991-1015 Mandatory group, Enabled by default, Enabled group
jw\ORA_CLIENT_LISTENERS                                       Alias            S-1-5-21-1889652306-443339906-4187214991-1010 Mandatory group, Enabled by default, Enabled group
jw\ora_dba                                                    Alias            S-1-5-21-1889652306-443339906-4187214991-1016 Mandatory group, Enabled by default, Enabled group
jw\ORA_GRID_LISTENERS                                         Alias            S-1-5-21-1889652306-443339906-4187214991-1008 Mandatory group, Enabled by default, Enabled group
jw\ORA_INSTALL                                                Alias            S-1-5-21-1889652306-443339906-4187214991-1005 Mandatory group, Enabled by default, Enabled group
jw\ORA_OPER                                                   Alias            S-1-5-21-1889652306-443339906-4187214991-1009 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home1_DBA                                       Alias            S-1-5-21-1889652306-443339906-4187214991-1006 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home1_OPER                                      Alias            S-1-5-21-1889652306-443339906-4187214991-1007 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home1_SYSBACKUP                                 Alias            S-1-5-21-1889652306-443339906-4187214991-1011 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home1_SYSDG                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1012 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home1_SYSKM                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1013 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home2_SYSBACKUP                                 Alias            S-1-5-21-1889652306-443339906-4187214991-1034 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home2_SYSDG                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1035 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB12Home2_SYSKM                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1036 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB19Home1_SYSBACKUP                                 Alias            S-1-5-21-1889652306-443339906-4187214991-1045 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB19Home1_SYSDG                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1046 Mandatory group, Enabled by default, Enabled group
jw\ORA_OraDB19Home1_SYSKM                                     Alias            S-1-5-21-1889652306-443339906-4187214991-1047 Mandatory group, Enabled by default, Enabled group
BUILTIN\Administrators                                        Alias            S-1-5-32-544                                  Group used for deny only
BUILTIN\Users                                                 Alias            S-1-5-32-545                                  Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\INTERACTIVE                                      Well-known group S-1-5-4                                       Mandatory group, Enabled by default, Enabled group
CONSOLE LOGON                                                 Well-known group S-1-2-1                                       Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\Authenticated Users                              Well-known group S-1-5-11                                      Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\This Organization                                Well-known group S-1-5-15                                      Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\Local account                                    Well-known group S-1-5-113                                     Mandatory group, Enabled by default, Enabled group
LOCAL                                                         Well-known group S-1-2-0                                       Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\NTLM Authentication                              Well-known group S-1-5-64-10                                   Mandatory group, Enabled by default, Enabled group
Mandatory Label\Medium Mandatory Level                        Label            S-1-16-8192


PRIVILEGES INFORMATION
----------------------

Privilege Name                Description                          State
============================= ==================================== ========
SeShutdownPrivilege           Shut down the system                 Disabled
SeChangeNotifyPrivilege       Bypass traverse checking             Enabled
SeUndockPrivilege             Remove computer from docking station Disabled
SeIncreaseWorkingSetPrivilege Increase a process working set       Disabled
SeTimeZonePrivilege           Change the time zone                 Disabled
4. Who owns the ORacle Home? For example,
C:\Users\john>
C:\Users\john>dir /q C:\app\oracle\product\19.3.0
 Volume in drive C is OS
 Volume Serial Number is 4454-E531

 Directory of C:\app\oracle\product\19.3.0

23/06/2021  12:49    <DIR>          BUILTIN\Administrators .
23/06/2021  12:49    <DIR>          BUILTIN\Administrators ..
14/08/2019  17:13    <DIR>          BUILTIN\Administrators addnode
30/05/2019  16:03    <DIR>          BUILTIN\Administrators admin
30/05/2019  16:05    <DIR>          BUILTIN\Administrators apex
30/05/2019  16:03    <DIR>          BUILTIN\Administrators ASP.NET
30/05/2019  16:03    <DIR>          BUILTIN\Administrators assistants
17/08/2020  08:45    <DIR>          BUILTIN\Administrators bin
03/02/2021  15:19    <DIR>          BUILTIN\Administrators cfgtoollogs
14/08/2019  17:13    <DIR>          BUILTIN\Administrators clone
Do you get the idea? Show what you are doing! Not just one line descriptions. When you copy/paste, please be sure to enclose the text within [code] tags, as described here,How to use [code] tags and make your code easier to read

Re: Oracle VSS Services [message #684540 is a reply to message #684538] Thu, 24 June 2021 04:32 Go to previous messageGo to next message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
sc qc oracleserviceodb

[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: oracleserviceodb
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : c:\oracle\product\12.1.0\dbhome_1\bin\ORACLE.EXE ODB
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : OracleServiceODB
        DEPENDENCIES       :
        SERVICE_START_NAME : mydomain\Administrator
whoami /all

USER INFORMATION
----------------

User Name          SID
================== =============================================
mydomain\administrator S-1-5-21-2575327843-4282392444-2475637581-500


GROUP INFORMATION
-----------------

Group Name                                             Type             SID                                             Attributes
====================================================== ================ =============================================== ===============================================================
mydomain\Administratorzy domeny                            Group            S-1-5-21-2575327843-4282392444-2475637581-512   Mandatory group, Enabled by default, Enabled group
Wszyscy                                                Well-known group S-1-1-0                                         Mandatory group, Enabled by default, Enabled group
BUILTIN\Administratorzy                                Alias            S-1-5-32-544                                    Mandatory group, Enabled by default, Enabled group, Group owner
BUILTIN\Użytkownicy                                    Alias            S-1-5-32-545                                    Mandatory group, Enabled by default, Enabled group
ZARZĄDZANIE NT\ZDALNE LOGOWANIE INTERAKCYJNE           Well-known group S-1-5-14                                        Mandatory group, Enabled by default, Enabled group
ZARZĄDZANIE NT\INTERAKTYWNA                            Well-known group S-1-5-4                                         Mandatory group, Enabled by default, Enabled group
ZARZĄDZANIE NT\Użytkownicy uwierzytelnieni             Well-known group S-1-5-11                                        Mandatory group, Enabled by default, Enabled group
ZARZĄDZANIE NT\Ta organizacja                          Well-known group S-1-5-15                                        Mandatory group, Enabled by default, Enabled group
LOKALNY                                                Well-known group S-1-2-0                                         Mandatory group, Enabled by default, Enabled group
mydomain\ORA_DBA                                           Group            S-1-5-21-2575327843-4282392444-2475637581-1338  Mandatory group, Enabled by default, Enabled group
mydomain\Twórcy-właściciele zasad grupy                    Group            S-1-5-21-2575327843-4282392444-2475637581-520   Mandatory group, Enabled by default, Enabled group
mydomain\KLAdmins                                          Group            S-1-5-21-2575327843-4282392444-2475637581-1233  Mandatory group, Enabled by default, Enabled group
mydomain\grupa_or                                          Group            S-1-5-21-2575327843-4282392444-2475637581-4768  Mandatory group, Enabled by default, Enabled group
mydomain\Administratorzy schematu                          Group            S-1-5-21-2575327843-4282392444-2475637581-518   Mandatory group, Enabled by default, Enabled group
mydomain\Administratorzy przedsiębiorstwa                  Group            S-1-5-21-2575327843-4282392444-2475637581-519   Mandatory group, Enabled by default, Enabled group
mydomain\WSS_RESTRICTED_WPG_V4                             Alias            S-1-5-21-2575327843-4282392444-2475637581-4209  Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\SERWER5 $ Acronis Remote Users                    Alias            S-1-5-21-2575327843-4282392444-2475637581-15165 Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\SERWER5 $ Acronis Centralized Admins              Alias            S-1-5-21-2575327843-4282392444-2475637581-15164 Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\IIS_WPG                                           Alias            S-1-5-21-2575327843-4282392444-2475637581-1173  Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\WSS_WPG                                           Alias            S-1-5-21-2575327843-4282392444-2475637581-4208  Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\Grupa bez replikacji haseł na kontrolerach RODC   Alias            S-1-5-21-2575327843-4282392444-2475637581-572   Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\WSS_ADMIN_WPG                                     Alias            S-1-5-21-2575327843-4282392444-2475637581-4207  Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\SERWER5 $ Acronis ApiGateway Users                Alias            S-1-5-21-2575327843-4282392444-2475637581-15163 Mandatory group, Enabled by default, Enabled group, Local Group
mydomain\SERWER3 $ Acronis Remote Users                    Alias            S-1-5-21-2575327843-4282392444-2475637581-4186  Mandatory group, Enabled by default, Enabled group, Local Group
Etykieta obowiązkowości\Poziom obowiązkowości — wysoki Label            S-1-16-12288                                    


PRIVILEGES INFORMATION
----------------------

Privilege Name                            Description                                                                  State
========================================= ============================================================================ ========
SeIncreaseQuotaPrivilege                  Dostosuj przydziały pamięci dla procesów                                     Disabled
SeSecurityPrivilege                       Zarządzaj dziennikami inspekcji i zabezpieczeń                               Disabled
SeTakeOwnershipPrivilege                  Przejmij na własność pliki lub inne obiekty                                  Disabled
SeLoadDriverPrivilege                     Ładuj i zwalniaj sterowniki urządzeń                                         Disabled
SeSystemProfilePrivilege                  Profiluj wydajność systemu                                                   Disabled
SeSystemtimePrivilege                     Zmień czas systemowy                                                         Disabled
SeProfileSingleProcessPrivilege           Profiluj pojedynczy proces                                                   Disabled
SeIncreaseBasePriorityPrivilege           Zwiększ priorytet planowania                                                 Disabled
SeCreatePagefilePrivilege                 Utwórz plik stronicowania                                                    Disabled
SeBackupPrivilege                         Wykonuj kopie zapasowe plików i katalogów                                    Disabled
SeRestorePrivilege                        Przywracaj pliki i katalogi                                                  Disabled
SeShutdownPrivilege                       Zamknij system                                                               Disabled
SeDebugPrivilege                          Debuguj programy                                                             Disabled
SeSystemEnvironmentPrivilege              Modyfikuj wartości środowiskowe oprogramowania układowego                    Disabled
SeChangeNotifyPrivilege                   Obejdź sprawdzanie przy przechodzeniu                                        Enabled
SeRemoteShutdownPrivilege                 Wymuszaj zamknięcie z systemu zdalnego                                       Disabled
SeUndockPrivilege                         Usuń komputer ze stacji dokującej                                            Disabled
SeManageVolumePrivilege                   Wykonuj zadania konserwacji woluminów                                        Disabled
SeImpersonatePrivilege                    Personifikuj klienta po uwierzytelnieniu                                     Enabled
SeCreateGlobalPrivilege                   Utwórz obiekty globalne                                                      Enabled
SeIncreaseWorkingSetPrivilege             Zwiększ zestaw roboczy procesu                                               Disabled
SeTimeZonePrivilege                       Zmień strefę czasową                                                         Disabled
SeCreateSymbolicLinkPrivilege             Utwórz linki symboliczne                                                     Disabled
SeDelegateSessionUserImpersonatePrivilege Uzyskaj token personifikacji dla innego użytkownika w ramach tej samej sesji Disabled


USER CLAIMS INFORMATION
-----------------------

User claims unknown.

Kerberos support for Dynamic Access Control on this device has been disabled.
dir /q C:\oracle\product\12.1.0

 Volume in drive C is SAS_oracle_redo_exp
 Volume Serial Number is 406A-2E52

 Directory of C:\oracle\product\12.1.0

17.06.2021  20:47    <DIR>          BUILTIN\Administratorzy.
17.06.2021  20:47    <DIR>          BUILTIN\Administratorzy..
23.06.2021  20:08    <DIR>          BUILTIN\Administratorzydbhome_1
16.06.2021  21:41    <DIR>          BUILTIN\Administratorzydbhome_2
               0 File(s)              0 bytes
               4 Dir(s)  443 959 177 216 bytes free

These are the query results from the Oracle server. The Acronic server is on a different machine.

[Updated on: Thu, 24 June 2021 05:11]

Report message to a moderator

Re: Oracle VSS Services [message #684543 is a reply to message #684540] Fri, 25 June 2021 03:06 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Received as a private message:

Quote:
Hellow,
I changed the service user and yesterday the error message was not there. I will confirm it today. I have oracle 12c - have retired Adobe Flash Player. Do you have any way to run the console in the browser (without installing the new version)?
I think this is saying that my suggestion was correct: the problem was incorrect use of Windows accounts.

Previous Topic: Help in procedure
Next Topic: Web Console - Oracle 12c
Goto Forum:
  


Current Time: Thu Mar 28 06:23:06 CDT 2024