César Carvalho cesardba
cesardba
/ dblink_postgresql_dn
Last active
August 19, 2022 20:31
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ####### DBLink Oracle to PostgreSQL####### | |
| We will use a native technology of Oracle database the Heterogeneous Services (HS) to create a dblink with PostgreSQL. | |
| - Bancos | |
| 192.168.0.1 - Server Origin Oracle database | |
| 192.168.0.2 - PostgreSQL destination server, banks we will use: ODBC and COPGEO. | |
| ####### PostgreSQL ####### |
cesardba
/ dblink_postgresql_br
Last active
August 19, 2022 20:32
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ####### DBLink Oracle para PostgreSQL ####### | |
| Iremos utilizar uma tecnologia nativa do Oracle database o Heterogeneous Services (HS) para criação de um dblink com PostgreSQL. | |
| - Bancos | |
| 192.168.0.1 - Servidor Origem Oracle database | |
| 192.168.0.2 - Servidor destino PostgreSQL, bancos que iremos usar: ODBC e COPGEO. | |
| ####### PostgreSQL ####### |
cesardba
/ dblink_mysql_en
Last active
September 11, 2022 20:47
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| We will use a native technology of the Oracle database, the Heterogeneous Services (HS). | |
| - Bancos | |
| 192.168.0.11 - Banco de Origem Oracle database | |
| 192.168.0.84 - Banco de destino Mysql | |
| - Create a user with the necessary read permissions in the MYSQL environment. | |
| Usuario: USR_CONSULTA | |
| Snhea: P!!2012300 |
cesardba
/ dblink_mysql_ptbr
Created
June 16, 2022 13:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Iremos utilizar uma tecnologia nativa do Oracle database o Heterogeneous Services (HS). | |
| - Bancos | |
| 10.16.0.11 - Banco de Origem Oracle database | |
| 10.16.2.84 - Banco de destino Mysql | |
| - Criar um usuario com as permissões necessárias de leitura no ambiente MYSQL. | |
| Usuario: USR_CONSULTA | |
| Snhea: P!!2012300 |
cesardba
/ dblibk_tres_sqlserver_english
Created
June 16, 2022 13:35
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| We will use a native technology of the Oracle database, the Heterogeneous Services (HS). | |
| - Databases | |
| 10.16.0.11 - Source Database Oracle database | |
| 10.16.0.15 - SQL Server target database | |
| - Create a user with the necessary read permissions in the SQL Server environment. | |
| Usuario: USR_CONSULTA | |
| Snhea: P!!2012300 |
cesardba
/ dblibk_tres_sqlserver
Last active
June 16, 2022 13:30
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Iremos utilizar uma tecnologia nativa do Oracle database o Heterogeneous Services (HS). | |
| - Bancos | |
| 10.16.0.11 - Banco de Origem Oracle database | |
| 10.16.0.15 - Banco de destino SQL Server | |
| - Criar um usuario com as permissões necessárias de leitura no ambiente SQL Server. | |
| Usuario: USR_CONSULTA | |
| Snhea: P!!2012300 |
cesardba
/ applying_exacc_domu_patch_dataguard_ptbr
Created
June 9, 2022 04:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #### Iremos aplicar o patch em um ambiente RAC. #### | |
| #### Realizando o backup do Oracle Home dos nós do RAC. #### | |
| [oracle@srv01 ~]$ echo $ORACLE_HOME | |
| /u02/app/oracle/product/11.2.0/dbhome_2 | |
| #### Node 1 #### | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/oracle_home_srv01.tar dbhome_2 | |
| [root@srv01 ~]$ cd /u01/app/ | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/srv01_oraInventory.tar oraInventory | |
| #### Node 2 #### | |
| [root@srv02 ~]$ tar -pcvf /backup/cesar_update/oracle_home_srv02.tar dbhome_2 |
cesardba
/ applying_exacc_domu_patch_dataguard
Created
June 9, 2022 04:40
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #### We will apply the patch in a RAC environment. #### | |
| #### Performing Oracle Home backup of RAC nodes. #### | |
| [oracle@srv01 ~]$ echo $ORACLE_HOME | |
| /u02/app/oracle/product/11.2.0/dbhome_2 | |
| #### Node 1 #### | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/oracle_home_srv01.tar dbhome_2 | |
| [root@srv01 ~]$ cd /u01/app/ | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/srv01_oraInventory.tar oraInventory |
cesardba
/ add_service_portugues
Created
June 3, 2022 13:08
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1 - Verificar serviços usados atualmente. | |
| SQL> select inst_id,name from gv$services order by inst_id,name; | |
| INST_ID NAME | |
| ---------- ------------------------------ | |
| 1 SME | |
| 1 SMP | |
| 1 SYS$BACKGROUND | |
| 1 SYS$USERS | |
| 1 smc |
cesardba
/ applying_exacc_domu_patch
Last active
June 11, 2022 04:16
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #### We will apply the patch in a RAC environment. #### | |
| #### Performing Oracle Home backup of RAC nodes. #### | |
| [oracle@srv01 ~]$ echo $ORACLE_HOME | |
| /u02/app/oracle/product/11.2.0/dbhome_2 | |
| #### Node 1 #### | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/oracle_home_srv01.tar dbhome_2 | |
| [root@srv01 ~]$ cd /u01/app/ | |
| [root@srv01 ~]$ tar -pcvf /backup/cesar_update/srv01_oraInventory.tar oraInventory |
NewerOlder