Solved

Oracle 12 în a windows environment not working


Userlevel 2
Badge +7

I am facing the same issue but in our case neither of the jobs are working. We have Oracle 12 în a windows environment. Oracle services are running as localsystem.

So how do these conditions change if the oracle services are running using the windows built in account (Localsystem)?  from https://documentation.commvault.com/commvault/v11/article?p=100015.htm

The user that runs the Oracle services must have full permissions at the Commvault folder level and the Commvault registry.

If you use a local administrator as the OS user in the Oracle Instance Properties dialog box, then you must have the following permissions for that user:

  • The local administrator must be part of the ORA_DBA group.
  • The local administrator must have full permissions at the Commvault folder level and the Commvault registry.
  • The local administrator must have full permissions for the ORACLE_HOME folder.
icon

Best answer by neuwiesener 22 March 2021, 09:26

View original

10 replies

Userlevel 2
Badge +7

@Gowri Shankar  any advice on this?

Userlevel 7
Badge +23

Hey @neuwiesener !  Gowri is out today, so I’m looking into this for you.

Userlevel 7
Badge +23

@neuwiesener , do you mind sharing the exact RMAN log error for your job(s)?

Userlevel 4
Badge +12

Good day @neuwiesener,

 

New oracle iDA install on windows needs a reboot. If the server is not rebooted after the agent is installed then plan for a downtime and reboot the server.

 

For oracle 12c or above following the steps recommended in documentation https://documentation.commvault.com/commvault/v11/article?p=20309.htm

 

After the above steps are performed verify the oracle status from Commvault console, from Commvault console navigate to the oracle machine expand the client expand oracle agent right click the oracle instance and click on properties. Click on the refresh button and make sure the database status is shown as open.

Verify the connect string in the details tab. You can either use local connect “/” or use a full connect string using a oracle user which has either sysdba or sysbackup privileges.

 

Share the rman log if the issue still persists.

 

 

Userlevel 2
Badge +7

@Gowri Shankar  Thanks a lot. Will try these steps and let you know.

Userlevel 2
Badge +7

This is the log. Not yet tried Gowris steps: @Mike Struening 

 


c:\Schedule\CVTest\CommvaultScripts\TEST>rman target=sys/cvtest@cvtest msgno cmdfile='rmanparams.txt'

Recovery Manager: Release 12.2.0.1.0 - Production on Di Mrz 9 11:38:09 2021

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN-06005: Mit Zieldatenbank verbunden: CVTEST (DBID=2589047670)

RMAN> run {
2> allocate channel ch1 type 'sbt_tape';
3> allocate channel ch2 type 'sbt_tape';
4> allocate channel ch3 type 'sbt_tape';
5> allocate channel ch4 type 'sbt_tape';
6> setlimit channel ch1 maxopenfiles 8;
7> setlimit channel ch2 maxopenfiles 8;
8> setlimit channel ch3 maxopenfiles 8;
9> setlimit channel ch4 maxopenfiles 8;
10> backup incremental level = 0
11> filesperset = 4 format '%d_%U_%t'
12> database include current controlfile;
13> }
14>
RMAN-06009: Kontrolldatei der Zieldatenbank wird anstelle des Recovery-Katalogs verwendet
RMAN-08030: Zugewiesener Kanal: ch1
RMAN-08500: Kanal ch1: SID=270, Gerõtetyp=SBT_TAPE
RMAN-08526: Kanal ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

RMAN-06908: Warnung: Vorgang wird nicht parallel in den zugeordneten Kanõlen ausgef³hrt
RMAN-06909: Warnung: Parallelitõt erfordert Enterprise Edition
RMAN-08030: Zugewiesener Kanal: ch2
RMAN-08500: Kanal ch2: SID=26, Gerõtetyp=SBT_TAPE
RMAN-08526: Kanal ch2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

RMAN-08030: Zugewiesener Kanal: ch3
RMAN-08500: Kanal ch3: SID=269, Gerõtetyp=SBT_TAPE
RMAN-08526: Kanal ch3: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

RMAN-08030: Zugewiesener Kanal: ch4
RMAN-08500: Kanal ch4: SID=27, Gerõtetyp=SBT_TAPE
RMAN-08526: Kanal ch4: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

RMAN-03090: backup wird gestartet bei 09-MRZ-21
RMAN-08048: Kanal ch1: Backupset von Datendatei auf inkrementeller Ebene 0 wird begonnen
RMAN-08010: Kanal ch1: Datendateien in Backup Set werden angegeben
RMAN-08522: Dateinummer der Eingabedate=00001, Name=D:\ORACLEDATABASE\CVTEST\SYSTEM01.DBF
RMAN-08038: Kanal ch1: Piece 1 wird auf 09-MRZ-21 begonnen
RMAN-08031: Freigegebener Kanal: ch1
RMAN-08031: Freigegebener Kanal: ch2
RMAN-08031: Freigegebener Kanal: ch3
RMAN-08031: Freigegebener Kanal: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: Fehler bei Befehl backup auf Kanal ch1 bei 03/09/2021 11:38:13
ORA-19506: Fehler beim Erstellen der sequentiellen Datei, Name="CVTEST_0mvpa6l4_1_1_1066736292", Parameter=""
ORA-27028: skgfqcre: sbtbackup hat Fehler zur³ckgegeben
ORA-19511: Kein RMAN-, sondern Media Manager- oder herstellerspezifischer Fehler, Fehlertext:
   CreateOraObject20:

Recovery Manager abgeschlossen.

Userlevel 7
Badge +23

Appreciate the share!  I’ll defer to @Gowri Shankar and his wisdom!

Userlevel 4
Badge +12

ORA-19511: Kein RMAN-, sondern Media Manager- oder herstellerspezifischer Fehler, Fehlertext:
   CreateOraObject20:

This indicate a permissions issue.

 

Dont think you will need to reboot the server as the channels are allocated without any issues

 

RMAN-08030: Zugewiesener Kanal: ch2
RMAN-08500: Kanal ch2: SID=26, Gerõtetyp=SBT_TAPE
RMAN-08526: Kanal ch2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

 

Follow the  doc link recommended earlier -

 

For oracle 12c or above following the steps recommended in documentation https://documentation.commvault.com/commvault/v11/article?p=20309.htm

 

Let us know if the issue still persists 

 

Userlevel 2
Badge +7

@Gowri Shankar Well the reboot seems to have helped. The permissions were already granted as I had mentioned in my initial post.

Userlevel 7
Badge +23

@neuwiesener , that’s good, though we should probably hold off on celebrating just yet :joy:  Would prefer to see it works consistently first, though I’ll defer to judgement.

I’ll keep an eye here though feel free to mark any reply as the Best Answer once you’re satisfied this is resolved!

Reply