Oracle
All UxOra articles related to Oracle database 11g/12c and SQL/PLSQL will be published under this category.
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article shows how to manually create a Oracle database, known aswell as Oracle Instance, in command line with sqlplus.
For the laziest, there is a custom shell script for download which does all the creation database steps.
Another way to create database is to use dbca as explain here.
(ora_create_sid.sh zip file is attached in this article)
- Details
- Written by Michel VONGVILAY
- Category: DBA
This article will show how to create a Oracle database, known aswell as Oracle Instance, in command line with dbca silent option.
DBCA is for DataBase Configuration Assistant, this is a tool to create/delete Oracle databases.
It can be used as GUI or as command line.
Another way to create database is to use CREATE DATABASE sql statement as explained here.
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will show how to configure Oracle ASM in command line with silent option (for non cluster environement).
ASM Configuration Assistant (ASMCA) is use to create and manage ASM instance, ASM disk group and ASM Cluster File System (ACFS).
It can be used in GUI or in command line.
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 3 / 5
This article will show an installation of Oracle Enterprise Manager Cloud Control 12c in silent mode (no GUI, command line only).
OEM Cloud Control 12c is a centralised management software for administrating and monitoring all oracle's products, especially oracle database.
It is quite powerful and it becomes very handy when you manage many databases, and its base features are free of charge to use.
- Details
- Written by Michel VONGVILAY
- Category: DBA
User Rating: 1 / 5
This article will show an installation of Oracle Grid Infrastructure 12cR1 in silent mode.
The Oracle Grid Infrastructure is the Oracle software that provides system support for Oracle Automatic Storage Management (Oracle ASM), Oracle Restart (for Standalone server only) and Clusterware (for Cluster only). You must install Oracle Grid Infrastructure before installing your database.
