Hi Frends ! Many time transcurred from the last post and I’m here again and some news.
Yeah , and many things as “Oracle Company Close my Facebook fanpage” because I had an a great community of friends from all word, 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 pendients , that we shared on my old community.
As How to migrate Oracle database to Postgres o solutions , tools about Kubernetes , docker or Terraforms plans, AWS, terragrount, openshift, many lots of tools and examples, troublshoting and more about those technologies.
Today I start with , how to install Anaconda in linux to start with build some solutions as create dashborads, analizate information and some works more from each day as big data analitc.
You could choise install on some platform 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 another linux linux distributions.
A few days ago, when the team performed some application deployment tasks, we noticed that the different schemas, created the datafiles, which belong to a TBS, were created at the destination of the CDB or PDB’s.
We start with the first task of verifying that the db_create_file_dest parameter was configured.
This parameter that differs in container paths as 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 datafiles, from the wrong paths, to the correct paths where the datafiles should be created.
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
------------------------------------ ----------- ------------------------------
Set the configuration for Container Database (CDB)
ALTER SYSTEM SET db_create_file_dest='/opt/oracle/oradata/ORCLCDB';
set line 150
col PARAMETER format a30
col DESCRIPTION format a60
col SESSION_VALUE format a10
col INSTANCE_VALUE format a10
SELECT a.ksppinm AS parameter,
a.ksppdesc AS description,
b.ksppstvl AS session_value,
c.ksppstvl AS instance_value
FROM x$ksppi a,
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/_%' ESCAPE '/'
ORDER BY a.ksppinm;
Now, after we save this list, is possible that we need started with an planificated 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.
It’s a minimal post to share this option to start, stop and restart the oracle databases as linux services.
If you remember on my last article oracle installation, we used the file oracledb_ORCLCDB-19c to configure and install the databases and containers, we will use the same script as operating system service.
We must run this script as root user ever, because will appear error as the follow:
You must be root user to run the configurations script. Login as root user and try again.