Ask the Community
Groups
Oracle DB's not showing but instance shows in UI - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>When attempting to back up an oracle instance, the server shows Oracle is installed, but the databases will not show.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>When attempting to back up an oracle instance, the server shows Oracle is installed, but the databases will not show.<br><br>The event log shows something along the lines of:<br><br>Sep 21 19:04:10 : Logon as user: 'administrator'; domain: 'server'<br>Sep 21 19:04:10 : User account credentials are not valid (server\administrator):<br> <br>Sep 21 19:04:10 : - Returned HRESULT = 0x80070569<br> Sep 21 19:04:10 : GetToken failed.<br>Sep 21 19:04:10 : <ERROR>: Failed to execute command.<br> Sep 21 19:04:10 : - Returned HRESULT = 0x80070057<br> Sep 21 19:04:10 : - Error text: Parameter incorrect.<br><br> </p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p>You need to grant login as a service right to the user you are using with the credentials in the UI for the oracle server.<br><br>Follow the below steps to set <b>Log on As Service right </b>via Local Security Policy<br><br>1. Open the Run window by pressing '<b>Windows'</b> + '<b>R' </b>keys.<br>2. Type the command <b>secpol.msc </b>in the text box and click OK.<br><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fus.v-cdn.net%2F6032361%2Fuploads%2Fmigrated%2FSKQAKOBYW2NF%2Fset-or-grant-logon-as-a-service.png"><img alt="Set Logon As A Service right to User by Command Prompt, C#, Powershell and VBScript" border="0" height="176" src="https://us.v-cdn.net/6032361/uploads/migrated/SKQAKOBYW2NF/set-or-grant-logon-as-a-service.png" title="Set Logon As A Service right to User by Command Prompt, C#, Powershell and VBScript" width="320" class="embedImage-img importedEmbed-img"></img></a><br>3. Now the <b>Local Security Policy</b> window will be open, in that window navigate to the node <b>User Rights Assignment</b> (<b>Security Settings -> Local Polices ->User Rights Assignment</b>). In right side pane, search and select the policy <b>Log on as a service.</b><br><br><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fus.v-cdn.net%2F6032361%2Fuploads%2Fmigrated%2FK7HX0Z4HTOUC%2Fset-or-grant-logon-as-a-service-1.png"><img alt="Set Logon As A Service rights to User by Command Line, C#, Powershell and VBScript" border="0" height="152" src="https://us.v-cdn.net/6032361/uploads/migrated/K7HX0Z4HTOUC/set-or-grant-logon-as-a-service-1.png" title="Set Logon As A Service right to User by Command Prompt, C#, Powershell and VBScript" width="320" class="embedImage-img importedEmbed-img"></img></a><br>4. Double-click on the policy <b>Log on as a service, </b>in the opened windows click the button <b>Add User or Group,</b>select the user which you want to <b>set logon as a service right </b>and click OK, and click <b>Apply</b> button to finish.<br><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fus.v-cdn.net%2F6032361%2Fuploads%2Fmigrated%2FAD1I86PWBW56%2Fset-or-grant-logon-as-a-service-2.png"><img alt="Set Log on As A Service right to User by Powershell, Command Prompt, C# and VBScript" border="0" height="252" src="https://us.v-cdn.net/6032361/uploads/migrated/AD1I86PWBW56/set-or-grant-logon-as-a-service-2.png" title="Set Logon As A Service rights to User by Command Prompt, C#, Powershell and VBScript" width="320" class="embedImage-img importedEmbed-img"></img></a><br> </p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>Returned HRESULT = 0x80070569 is the key here, as </p> <h1 data-id="0x80070569-logon-failure-the-user-has-not-been-granted-the-requested-logon-type-at-this-computer">0x80070569: Logon failure: the user has not been granted the requested logon type at this computer.</h1> </article> </main>