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
No comments:
Post a Comment