Posts

Showing posts with the label Database

DB - Setup do ambiente + levantar BD e Listener

EnglishVersion Inicialmente este post foi feito para 11g - como arrancar uma base de dados - foi entretanto revisto para 12c, foram adicionadas algumas validadores.
Post a Comment
Read more

OS - yum - pre install tasks

Versao Portuguesa Installing the Oracle Preinstallation RPM From Unbreakable Linux Network Oracle requires some RPMs in the system - it would to be a bit painful to install all the requirements Oracle Linux comes with the yum configured and ready to use - using it makes life easier on that task bellow the example. [root@dbserver ~]# yum install oracle-rdbms-server-12cR1-preinstall Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-7.el7 will be installed --> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-...
Post a Comment
Read more

OS - yum - preinstall

English Version Install pre reqs para Oracle DB Uma das pre tasks necessarias para base de dados Oracle e installar previamente uma lista enorme de packages. Oracle Linux  vem com os repositorios do yum  , o que facilita muito a tarefa de preparar o servidor para Oracle. [root@dbserver ~]# yum install oracle-rdbms-server-12cR1-preinstall Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-7.el7 will be installed --> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 --> Processing De...
Post a Comment
Read more

FMW - Repository Creation Utility (RCU) schemas - for Oracle Forms

Versao Portuguesa This post is about how to create database schema for Oracle Fusion Middleware, using the Repository Creation Utility (RCU). In Command line - This bellow reproach can be used for automation
Post a Comment
Read more

FMW - Repository Creation Utility (RCU) schemas - Oracle Forms

English Version Este post e sobre a criacao do repositorio pra produtos Oracle Fusion Middleware, usando o utilitario Repository Creation Utility (RCU), em linha de comando - silent mode - esta abordagem pode ser usada pa automacao.
Post a Comment
Read more

DB - Flashback Database

EnglishVersion Neste post partilho como como usar tecnologia flashback - neste caso flashback database Como exemplo vou mostar como ajuda num dos piores cenarios - num truncate O Truncate e muito usado para limpar as tabelas, nao so os dados mas os segmentos. para recuperar de um trunncate e necessario restaurar a base de dados. Importante flashback database e necessario para operacoes de failover do data guard. Activar flashback database Requisitos para flashback database - A base de dados em archivelog mode - tradicional archive redo logs - Feature flashback activada - stream the logs / flashback logs Para isso e necessario reiniciar a base de dados de uma forma consistente Vou criar tambem um RESTORE POINT com opcao GUARANTEE FLASHBACK DATABASE -- As '/ as sysdba', SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 849530880 byt...
Post a Comment
Read more

DB - Hack password

Versao Portuguesa In this post i'm sharing how to unlock database accounts  - even when the password is not known.
Post a Comment
Read more

VM - Shared Folder Windows - Linux

Image
Versao Portuguesa When we work with VMs we need to make files available eg. software binaries, it has a few ways to do that, this post is about how to make share Windows (Host) folders in a Linux server (Guest).
Post a Comment
Read more

DB - Data Guard 12c - Create Physical Standby

Versao Portuguesa Have been thinking for awile to post about Data Guard,  more specifically about  to created a physical standby.  So, today is the day, the aim of this post is not to destille  Data Guard, for better undestanding lets recap some Data Guard concepts. Data Guard allows database replication sending  and applying redo log info from a site to another, keeping in that way the data replicated and available  in the case the main site is not available.
Post a Comment
Read more

DB - Transportable Tablespaces x-Platforms

EnglishVersion Neste post parilho como copiar dados entre bases de dados em diferentes plataformas. Como nao tenho uma maquina HP-UX .. vou ter que criar datafile para HP-UX, e depois o inverso
Post a Comment
Read more

DB - Transportable Tablespaces x-Platforms

Versao Portuguesa In this post i'm sharing how to copy data /tablespaces between databases in different platforms as I've no HP-UX here at home .. I will have to convert a tablespace to HP-UX, then to convert the datafile back to Linux
Post a Comment
Read more

DB - Transportable Tablespaces

EnglishVersion A Oracle disponibiliza uma forma interessante de copiar aplicacoes / dados entre as bases de dados, chama-se TTS ( Transportable Tablespace). Basicamente exporta-se um dump com metadata do tablespace. Com esse dump + data file (s) e possivel carregar os dados noutra base de dados.
Post a Comment
Read more

DB - Transportable Tablespaces

EnglishVersion Oracle allows a nice way to copy aplication / data between databases, is known as TTS ( Transportable Tablespace). Basically is to export a dump with tablespace's metadata and copy the datafile(s). With that dump + data file (s) associated to the tablespace is possible to attach the tablespace to another database.
Post a Comment
Read more

DB - Data Guard 12c - Criar uma Physical Standby

EnglishVersion Ha algum tempo que andava para publicar um post sobre a solucao de disaster/recover da Oracle, Data Guard (DG). O objectivo deste post nao e destilar o Data Guard, mas para entender melhor e necessario  rever algums conceitos. Recap,   Data Guard permite enviar a informacao de log de site/data center  – principal para  outro dedicado a recovery, protegendo dessa forma os dados em caso de indisponiblilidade ou perca do site principal.
Post a Comment
Read more

VM - Partilhar Pastas Windows - Linux

Image
EnglishVersion Neste post escrevo como partillar uma pastas entre Windows (Host) e uma VM Linux (Guest), Ha muitas formas de fazer isto, esta parece me a mais facil.
Post a Comment
Read more

DB - Password Hack

EnglishVersion Neste post escrevo como restaurar contas "lockadas" - mesmo quando nao se sabe a password do utilizador.
Post a Comment
Read more

RIB - Inventory Adjustments

English Version Neste post mostro como encontrar  queue tables ( inventory adjustments neste caso) e o estado das mensagens.
Post a Comment
Read more

DB - Flashback Drop

English Version   Apos um drop table (excepto se foi usado purge), Oracle move a tabela para o recyclebin, neste post partilho como recuperar uma tabela depois de um  drop table, - e possivel tambem consultar o contedudo de tabelas no recycle bin.
Post a Comment
Read more

DB - Flashback Query

English Version   Neste post partilho como ver alterações nos dados e recuperar dados alterados pos commit, se foram alterados recentemente e possível recupar esses dados facilmente usando flasback query e flashback query version.
Post a Comment
Read more

DB - Flashback Database

EnglishVersion This post is about using flashback technology for recover a database, using as example, how to recover a table after truncate. Truncate is used to clean the tables, it also cleans the table segments. To recover trucated data requires to .. recover the database. Important note : flashback database is a must in case of failover in data guard operations. Flashback requirements It have some requirements for flashback database - The DB needs to be in archive log mode -the traditional archive redo logs - Feature flashback ON - it will activate the stream the logs / flashback logs For all this work the database needs to be mounted in a consitant maner To help with demo I will also create a RESTORE POINT with GUARANTEE FLASHBACK DATABASE -- As '/ as sysdba', SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global...
Post a Comment
Read more