virtual MACHINE CPU issue IN VIRTUALBOX AND VMWARE – smp: csd: Detected non-responsive CSD lock

Hi, this is a different post I decided to bring to the blog. Recently, I have purchased a new laptop and I've moved all virtual machines (my labs) from old laptop to this new laptop, where the processor is a intel core i5 11th. But, for some reason, no machine has worked fine as worked … Continue reading virtual MACHINE CPU issue IN VIRTUALBOX AND VMWARE – smp: csd: Detected non-responsive CSD lock

Oracle – O que é INITRANS? e MAXTRANS?

Resumo: número INIcial e MÁXimo de TRANSações permitidas em um bloco de dados concorrentemente. INITRANS O parâmetro INITRANS define a quantidade de ITL (Interested Transaction List) inicial quando um novo bloco de dados é criado. Um ITL slot é necessário para qualquer sessão que precise modificar um bloco de dados. O valor default do INITRANS … Continue reading Oracle – O que é INITRANS? e MAXTRANS?

Oracle – How to convert global index to local index

Hey there! Recently I had to do this task in our client, I've found this method. What you need to do is: Create the new index as local and invisible. But will this work in a already indexed column? Yes! since the index is another type (I mean, from global to local) and invisible, you … Continue reading Oracle – How to convert global index to local index

Reading mysqldump output file compressed with gzip on linux

I usually need to do it when I'm creating a slave. I need to be able to read a mysql dump file generated by mysqldump command compressed with gzip command. For example: mysqldump --single-transaction --events --quick --compress --routines --master-data=2 --databases sonda xi --add-drop-database | gzip > /backup/teste_backup.sql.gz When I am creating a slave, I use … Continue reading Reading mysqldump output file compressed with gzip on linux

ORA-39083 and ORA-01917 during grant role – import oracle

The error: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - ProductionMaster table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloadedStarting "SYS"."SYS_IMPORT_FULL_01": userid="/******** AS SYSDBA" directory=exp dumpfile=moot_%U.dmp logfile=importmoot.log parallel=4 full=y cluster=nProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTORA-39083: Object type ROLE_GRANT failed to create with error:ORA-01919: role 'ADMIN_MOOT' does not existFailing sql is: GRANT "ADMIN_MOOT" TO "MOOT"Processing … Continue reading ORA-39083 and ORA-01917 during grant role – import oracle

RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

This can happen during a duplicate database, for example: (dg1)(oracle@jupiter):admin> rman target sys/danilo123@jupiter auxiliary sys/danilo123@jupiterstb Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 10 18:10:58 2021 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: JUPITER (DBID=4201888259) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== … Continue reading RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Oracle script – Number of redo log groups by thread# and type

Just sharing other script in my blog. This script shows the number of redo log groups (online log and standby log) by thread# and type. --Written by: astoradba.wordpress.com select m.type,g.thread#,count(DISTINCT g.group#) NUMBER_OF_GROUPS from v$log g inner join v$logfile m on m.group#=g.group# group by m.type,g.thread# union all select m.type,g.thread#,count(DISTINCT g.group#) NUMBER_OF_GROUPS from v$standby_log g inner join … Continue reading Oracle script – Number of redo log groups by thread# and type

ORA-01111,ORA-01110,ORA-01157 in the physical standby database

This erro usually happen when the parameter standby_file_management is defined as manual. From SQL plus: show parameters standby_file_management From dgmgrl utility: show database your_standby_db StandbyFileManagement; Documentation.When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. STANDBY_FILE_MANAGEMENT is only applicable to physical standby databases.MANUAL - … Continue reading ORA-01111,ORA-01110,ORA-01157 in the physical standby database

ORA-10458,ORA-01152 and ORA-01110 after recover standby database from service

RMAN> recover standby database from service service_name_here; Starting recover at 05-MAR-21 using target database control file instead of recovery catalog Oracle instance started Total System Global Area 1291842528 bytes Fixed Size 8647648 bytes Variable Size 503316480 bytes Database Buffers 771751936 bytes Redo Buffers 8126464 bytes contents of Memory Script: { restore standby controlfile from service … Continue reading ORA-10458,ORA-01152 and ORA-01110 after recover standby database from service

ACFS – CRS-2552: There are no available instances of resource

First, if your environment are using serverpool, check the serverpool configuration as well. My environment does not use serverpool. root@rac2:~# srvctl config filesystem -d /dev/asm/u02-26 Volume device: /dev/asm/u02-26 Diskgroup name: data Volume name: u02 Canonical volume device: /dev/asm/u02-26 Accelerator volume devices: Mountpoint path: /u02/ Mount point owner: oracle Mount point group: oinstall Mount permissions: owner:oracle:rwx,pgrp:oinstall:rwx,other::r-x … Continue reading ACFS – CRS-2552: There are no available instances of resource

RMAN-10015 during rename file using RMAN

oracle@rac1:~$ tail -f rmanlogmothist.log set newname for datafile 3 to '+DGDATAMOTHIST/mothist/datafile/sysaux01.dbf'; set newname for datafile 4 to '+DGDATAMOTHIST/mothist/datafile/undotbs101.dbf'; set newname for datafile 5 to '+DGDATAMOTHIST/mothist/datafile/undotbs201.dbf'; set newname for datafile 7 to '+DGDATAMOTHIST/mothist/datafile/users01.dbf'; set newname for datafile 8 to '+DGDATAMOTHIST/mothist/datafile/size_monitor01.dbf'; set newname for tempfile 1 to '+DGDATAMOTHIST/mothist/datafile/temp01.dbf';... several renames ... sql "alter database rename file '+FRA/MOOTDB/ONLINELOG/group_1.297.1067716013' … Continue reading RMAN-10015 during rename file using RMAN

Script to list jobs created with DBMS_JOB

Hi, Just sharing another script. This script show all jobs created with dbms_job (not dbms_scheduler). Also, this script was made to be used with sqlplus, which the output is more organized. If you are using other tool such SQL Developer, just issue: select * from dba_jobs; with some condition, it's enough. There are four lines … Continue reading Script to list jobs created with DBMS_JOB