Rogerio Antonio

I created a VM with 10G disk, after the Linux 7 installation, and the first upgrade, decided was better to increase the disk to 50GB. This post , i'm sharing the steps and commands I ran to increase the disk size. Software : Host : Windows 10 Pro , Oracle VM 6.1.2 Guest : Red Hat Enterprise Linux Server release 7.1 (Maipo) / Oracle Linux Server release 7.1 Ok - the first step is to resize the *vdi disk on the host side. Open a PowerShell console in the VM folder (Left Shift + Mouse Right Click on Windows) Quick list and check on the files. PS D:\VMs\OracleLinux7_MSSQL> ls Directory: D:\VMs\OracleLinux7_MSSQL Mode LastWriteTime Length Name ---- ------------- ------ ---- d----- 09/02/2020 18:40 Logs -a---- 09/02/2020 18:41 5689 OracleLinux7_MSSQL.vbox -a---- 09/02/2020 18:41 5688 OracleLinux7_MSSQL.vbox-prev -a---- 09/02/2020 18:40 9268363264 OracleL...

Versão Portuguesa Sometimes is useful to have two operative systems in the laptop, is possible to get that creating two partitions in th disk, and to install the OS in the respective partition. But this post is not about that - this post is about .. after have the installation is done. After install Linux, is expectable to have a menu to select the operative system. That didn't happened in my latptop, it's loading directly the Linux .. upss Windows 10 "has gone" !!! This post is about that .. feature

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-...

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

Versao Portuguesa The aim of this post is to show how to install the Oracle Fusion Middleware Infrastructure in a fast and easy way - this approach could be also used for the automation

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

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).

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.

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

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.

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...

Versão Portuguesa This post was made initially to cover - how to setup an Oracle 11g Database - is reviewed for 12c - were added extra validations.