ORACLE 12C

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