Home » Infrastructure » Windows » Oracle VSS Services (Windows Server 2016)
Oracle VSS Services [message #684522] |
Tue, 22 June 2021 09:53 |
|
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 #684524 is a reply to message #684523] |
Tue, 22 June 2021 16:12 |
|
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 #684530 is a reply to message #684522] |
Wed, 23 June 2021 11:05 |
John Watson
Messages: 8963 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 #684536 is a reply to message #684535] |
Thu, 24 June 2021 01:51 |
John Watson
Messages: 8963 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 #684538 is a reply to message #684537] |
Thu, 24 June 2021 03:53 |
John Watson
Messages: 8963 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 |
|
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 |
John Watson
Messages: 8963 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.
|
|
|
Goto Forum:
Current Time: Mon Jan 20 15:57:33 CST 2025
|