DBA Hub

📋Steps in this guide1/3

DBCA silent mode - Bright DBA

Create Database in silent mode 1. Overview 2. Set the Environment 3. Create Database using DBCA silent mode 4. Verify 1. Overview Usually to create database we will use DBCA graphical user interface. Some times may not have access to a graphical user interface then we can use the DBCA silent mode to create a … Continue reading DBCA silent mode →

oracle clusteringintermediate
by OracleDba
15 views
1

Overview

Create Database in silent mode 1. Overview 2. Set the Environment

Code/Command (click line numbers to comment):

1
2
3
Usually to create database we will use DBCA graphical user interface.

Some times may not have access to a graphical user interface then we can use the DBCA silent mode to create a database.
2

Section 2

2. Set the Environment 3. Create Database using DBCA silent mode dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName POCNDEV.rajasekhar.com -sid POCNDEV -sysPassword sys -systemPassword sys -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
[oracle@rac2 ~]$
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
[oracle@rac2 ~]$
export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac2 ~]$
which dbca
/u01/app/oracle/product/11.2.0.4/db_1/bin/dbca
[oracle@rac2 ~]$

[oracle@rac2 ~]$
mkdir -p /u01/app/oracle/oradata
[oracle@rac2 ~]$
-- No need to create folder POCNDEV, it will create automatically by dbca

[oracle@rac2 ~]$
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName POCNDEV.rajasekhar.com -sid POCNDEV -sysPassword sys -systemPassword sys -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8
Copying database files
1% complete
3% complete
35% complete
Creating and starting Oracle instance
37% complete
42% complete
47% complete
52% complete
53% complete
56% complete
58% complete
Registering database with Oracle Restart
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/POCNDEV/POCNDEV.log" for further details.
[oracle@rac2 ~]$
3

Section 3

4. Verify Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
[oracle@rac2 ~]$
cat /etc/oratab | grep -i POCNDEV
POCNDEV:/u01/app/oracle/product/11.2.0.4/db_1:N         # line added by Agent
[oracle@rac2 ~]$

[oracle@rac2 ~]$ . oraenv
ORACLE_SID = [oracle] ? POCNDEV
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 05:36:47 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
select name, open_mode from v$database;
NAME      OPEN_MODE
--------- --------------------
POCNDEV   READ WRITE

SQL>
archive log list
Database log mode
No Archive Mode
<---
Automatic archival
Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Current log sequence           5
SQL>
SQL>
select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/
POCNDEV
/users01.dbf
/u01/app/oracle/oradata/POCNDEV/undotbs01.dbf
/u01/app/oracle/oradata/POCNDEV/sysaux01.dbf
/u01/app/oracle/oradata/POCNDEV/system01.dbf

SQL>
select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/
POCNDEV
/temp01.dbf

SQL>

[oracle@rac2 ~]$
. oraenv
ORACLE_SID = [POCNDEV] ?
+ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2 ~]$
lsnrctl status LISTENER | grep -i POCNDEV
Service "POCNDEV.rajasekhar.com" has 1 instance(s).
  Instance "
POCNDEV
", status
READY
, has 1 handler(s) for this service...
Service "POCNDEVXDB.rajasekhar.com" has 1 instance(s).
  Instance "POCNDEV", status READY, has 1 handler(s) for this service...
[oracle@rac2 ~]$
TNS Entry Automatically will be added to TNSNAMES.ORA
POCNDEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2.rajasekhar.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = POCNDEV.rajasekhar.com)
    )
  )

Comments (0)

Please to add comments

No comments yet. Be the first to comment!