How to install Anaconda in fedora 33

Hi Frends ! Many time transcurred from the last post and I’m here again and some news.

Anaconda Navigator

Yeah, and many things such as «Oracle Company Close my Facebook fan page» because I had a great community of friends from all world, shared knowledge and friendly solutions.

Obviously, at the «oracle style», without previous notification and a legal letter.

Today, I start with a list of many pendants, that we shared in my old community.

As How to migrate Oracle database to Postgres, solutions, tools about Kubernetes , docker or Terraforms plans, AWS, terragrount, openshift, many lots of tools and examples, troubleshooting and more about those technologies.

Today I start with, how to install Anaconda in Linux to start with building some solutions such as creating dashboards, analysing information and some work from each day as big data analytics.

Installing Anaconda

You could choose to install it on some platforms such as windows, mac and Linux.

On this, I will explain the process to install in Linux fedora, but is the same process to install on other Linux distributions.

Seguir leyendo «How to install Anaconda in fedora 33»

How to move online tablespace in Oracle 19c

A few days ago, when the team performed some application deployment tasks, we noticed that the different schemas created in the datafiles, which belong to a TBS, were created at the destination of the CDB or PDBs.

We start with the first task of verifying that the db_create_file_dest parameter was configured.

This parameter which differs in container paths from PDB is the one that guarantees that, through the OMF utility, the datafiles are created in the correct paths.

A demo was made, to understand the problem with developers, DevOps and dbas.
So that the importance of setting these values and the impact of not having their configuration is understood.

Likewise, we proceeded to move the data files, from the wrong paths to the correct paths where the data files should be created.

Hands-on

Check and configure the db_create_file_dest.

Check the default configuration

show parameter db_create_file_dest
SQL> show parameter db_create_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string
SQL>

It’s empty.

Set the configuration for Container Database (CDB)

ALTER SYSTEM SET db_create_file_dest='/opt/oracle/oradata/ORCLCDB';
Seguir leyendo «How to move online tablespace in Oracle 19c»

How to find Hidden Parameters in Oracle

The oracle database has hundreds of hidden parameters, and a lot of those parameters are not documented.

Knowing about those parameters is important for dbas involved in database migrations and upgrades.

Many parameters have a high-performance improvement on different systems.

Here, I share how to query and change the oracle hidden parameters.

Query to find hidden parameters in oracle 12c , 18c and 19c

 set line 150
 col PARAMETER format a30
 col DESCRIPTION format a60
 col SESSION_VALUE format a10
 col INSTANCE_VALUE format a10
 spool HIDDEN_parameter_database.log


 SELECT a.ksppinm AS parameter,
        a.ksppdesc AS description,
        b.ksppstvl AS session_value,
        c.ksppstvl AS instance_value
 FROM   x$ksppi a,
        x$ksppcv b,
        x$ksppsv c
 WHERE  a.indx = b.indx
 AND    a.indx = c.indx
 AND    a.ksppinm LIKE '/_%' ESCAPE '/'
 ORDER BY a.ksppinm;

spool off

Now, after we save this list, is possible that we need to start with a pontificated change.

Hidden ParameHow can I set the value of a hidden parameter?

alter system set "_report_capture_cycle_time"=0 scope=spfile sid='*';

Remember, the importance that these parameters must be recommendations of the oracle support, because it can change the behavior of the engine and can leave us in the situation of not having support.

How to identified issues with ADRCI

In oracle 19 the previously version ADRCI (Automatic Diagnostic Repository Command Interpreter) is a great tool to solve issues and deal with Oracle Errors and Trace files

We could verify in the alert the oracle error :

Here, we will review quickly and easily and introduction to know the most basic commands to start.

I will start, as common with an alert log file:

tail -f /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/alert_ORCL.log
Alert log evidence

For years, Oracle has provided us with the possibility of reviewing in the alert log, the most critical movements such as the behaviour of database engine processes.

Hands-on

Now, we start how to ADRCI we help us to understand our issue.

oracle@DSORA02:~/JuanAndresMercado $ adrci

Seguir leyendo «How to identified issues with ADRCI»

Delete archivelog until time

Many, but many times people have problems with the archive logs. And call our team to save you…. The FRA is full.

So… we discovered that they did not take policies and controls about the databases when they have 100 o more databases to admin.

Here… the script to clean… but remember… this is not the solution.

The solution is planning and automatization. Happy delete!

All:

delete archivelog all;

The Last Day:

delete archivelog until time 'SYSDATE-1';

Specific Sequence or Between Sequence:

delete archivelog until sequence 456;

delete archivelog from sequence 456 until sequence 1000;

Specific Time:

delete archivelog until time "to_date('SEP 21 2018 20:00:00','Mon DD YYYY HH24:MI:SS')";

Oracle Database 19c, Now Available !

Oracle 19c

Hi Friends !

I’m come back to share the last recently news about the Oracle Databases.

Oracle Database 19c is the long-term support version of the Oracle Database 12c and 18c family of products, which is available to Premier and Extended Support customers through March 2023 and March 2026, respectively.

It is available on Linux, Windows, Solaris, HP / UX and AIX platforms, as well as Oracle Cloud.

Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their analytical and operational workloads.

Oracle 19 c : https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html

Day 2: Download Release 18c for Oracle Exadata Database Machine

How to Download Oracle Database Release 18c

En el dia de hoy comenzamos con el download del software para poder realizar el despliegue en nuestra maquina de computo.

Para ello podemos realizar una descarga publica desde el sitio de OTN o desde el sitio de descargas con acceso por medio de cuenta Oracle Support.

En este caso, use mi cuenta personal, por que realizamos el download para ser desplegado en la maquina de computo.

Nos dirijimos al site edelivery de Oracle.

Luego de haber ingresado nuestras credenciales correspondientes, realice la busqueda por Oracle Database 12c Enterprise Edition. (Debemos recordar que es una la ultima release de 12c, adaptada al nombre y nomenclatura del año en curso).

Al escoger Oracle Database Enterprise Edition 18.0.0.0.0, nos muestra como opcion los siguientes packages:

V974949-01.zip
V974951-01.zip
V974952-01.zip
V974953-01.zip

Seleccionamos :

Oracle Database Release 18.0.0.0.0

El tipo de Arquitectura de Sistema Operativo compatible, en nuestro caso x86-64.

Seleccionamos Continue,  y nos encontraremos proximos al download. Seguir leyendo «Day 2: Download Release 18c for Oracle Exadata Database Machine»