Oracle 12g Database Creation on
centos with DBCA Utility.
Install oracle 12c using xmanager.
create a database named orcl. Binaries should be installed inside /u01
Datafiles should be under /data01
Redolog files should be stored inside /redoA , /redoB , /redoC .Three different mount point for 3 diff groups.
All group must have 2 members in different mount point.
undo tablespace should be stored in /undotbs
create a database named orcl. Binaries should be installed inside /u01
Datafiles should be under /data01
Redolog files should be stored inside /redoA , /redoB , /redoC .Three different mount point for 3 diff groups.
All group must have 2 members in different mount point.
undo tablespace should be stored in /undotbs
*(.Create all mount point
in OS level.)
Create a
Listner with netca
Open a Xmanager graphical interface
Fire a command on oracle user[root@ab ~]# su - oracle
Fallow the step one by one
Give the Listner name
Select TCP protocol
Click on next
click on next
Select listener we want to start .Click on next
Just Click on Finish
Oracle 12g Database Creation on
centos with DBCA Utility.
Fire a command on oracle user
[root@ab ~]# su - oracle
[root@ab ~]#dbca
Click On Advanced Mode
Select template
Give the global database name and click on next
Uncheck the EM the next
select administrator
password to all account then next
chose the listener to want then next
select common location of all database and set the datafiles
location
select sample sehemas
Set the memory size above 60%
Click on Coustomize storage
location
Click on control files and set the location u want and then
click on apply
Click on data files and set the location u want and then
click on apply
Click on Redo log group 1
and set the location u want and then click on apply
Click on Redo log group 2
and set the location u want and then click on apply
Click on Redo log group 3
and set the location u want and then click on apply
Now affter customize the location click on on next
Click on finish
Database creation progress. and waiting for complete and
then click on close
Now Perform a some task on database.
How to know the how many database in our
machine.
[root@ab ~]# cat /etc/oratab
#
# This file is used by ORACLE
utilities. It is created by root.sh
# and updated by either Database
Configuration Assistant while creating
# a database or ASM Configuration
Assistant while creating ASM instance.
# A colon, ':', is used as the field
terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are
comments.
#
# Entries are of the form:
#
$ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the
system identifier and home
# directory of the database
respectively. The third field indicates
# to the dbstart utility that the
database should , "Y", or should not,
# "N", be brought up at system
boot time.
#
# Multiple entries with the same
$ORACLE_SID are not allowed.
#
#
dborcl:/u01/app/oracle/product/12.1.0/db_1:N
orcl:/u01/app/oracle/product/12.1.0/db_1:N
Connect with oracle user
[root@ab ~]# su - oracle
[oracle@ab ~]$ export
ORACLE_SID=orcl
[oracle@ab ~]$ sqlplus / as
sysdba
SQL*Plus:
Release 12.1.0.1.0 Production on Mon Mar 16 08:55:41 2015
Copyright
(c) 1982, 2013, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Advanced Analytics and Real Application Testing options
How to know the status of
current Instance
SQL> select status from
v$instance;
STATUS
------------
OPEN
How to know the name of database
SQL> select name from
v$database;
NAME
---------
ORCL
How to know the control file location.
SQL> show parameter
control_files;
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
control_files string /data01/orcl/control01.ctl, /u
01/app/oracle/fast_recovery_ar
ea/orcl/control02.ctl
How to know the log file members.
SQL> column member format a30;
SQL> select group#,member from
v$logfile;
GROUP# MEMBER
----------
------------------------------
3 /redoC/orcl/redoc1.log
3 /redoc/orcl/redoc2.log
2 /redoB/orcl/redob2.log
2 /redoB/orcl/redob1.log
1 /redoA/orcl/redoa1.log
1 /redoA/orcl/redoa2/log
6 rows selected.
How to know the tablespaces datafiles
location.
SQL> column tablespace_name format
a40;
SQL> select
file_name,tablespace_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
----------------------------------------
/data01/orcl/users01.dbf
USERS
/undotbs/orcl/undotbs01.dbf
UNDOTBS1
/data01/orcl/sysaux01.dbf
SYSAUX
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
----------------------------------------
/data01/orcl/system01.dbf
SYSTEM
/data01/orcl/example01.dbf
EXAMPLE
How to know the temporary tablespace
location.
SQL> select file_name,tablespace_name from
dba_temp_files;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
----------------------------------------
/temptbs/orcl/temp01.dbf
TEMP
