How to create database through Graphical tool "DBCA" Database Configuration Assistant

Step 1) You need to go to the ORACLE_HOME/bin location manually to run the DBCA utility

Example: - 

[oracle@prod bin]$ cd /u01/app/oracle/product/11.2.0/db_1/bin
[oracle@prod bin]$

Step 2) Now run dbca utility through below command

Example: - ./dbca

Click on below "Next" button to proceed further


Step 3) Click on "Create a Database" tab to proceed further


Step 4) Click on "General Purpose or Transaction Processing" tab because we are using for practice purpose but in real environment  choose options as per the requirement


Step 5) Put the name of Database which you need to create, in my case it is "orcl"


Step 6) Check the "Configure Enterprise Manager" tab and "Automatic Maintenance Tasks" tab, but make sure your listener is up and running, otherwise, you need to uncheck "Configure Enterprise Manager" tab to proceed further


Step 7) Put all the password for below-listed accounts, you have options to put passwords of all the account separately or also have options to put the same password for all the accounts


Step 8) Under storage options you can choose "File System" because we are using a file system to build the database, not ASM (Automatic Storage Management)



Step 9) Check the "Fast Recovery Area" tab if you want to put your backups in a single location


Step 10) If you want to create some schema's by default like HR, Online Catalog etc then you can check the "Sample Schema" option


Step 11) Choose memory options as "Typical" to give SGA and PGA together through AMM (Automatic Memory Management) and choose the default value for rest of the options


Step 12) Click on "Finish" tab to create a database


Comments

Post a Comment

Popular posts from this blog

How to Add, Resize, Drop and Rename of a datafile in Tablespace

Image
                                       How to Add, Resize, Drop and Rename a datafile in Tablespace In order to create a data file first, need to create a tablespace, To know how to create a tablespace  Click here To demonstrate, I will use USERS tablespace to Add,  Resize, Drop and Rename a data file. First, we can check how many data files are present under USERS tablespace through below command. Command: - select name from v$datafile; We can see from above output only a single data file is present under USERS tablespace. Addition of Datafile: - Command to add a datafile: - alter tablespace users add datafile '/u01/app/oracle/oradata/prod/users02.dbf' size 50m; The new data file has been added to my USERS tablespace. Resize of a Datafile: - Command to resize the datafile: - alter database datafile '/u01/app/oracle/oradata/prod/users02.dbf' resize 20m; Renaming of a Datafile: - We have a few steps to rename a data file: -
Read more

How to do "Multiplexing of Control Files" through spfile ( server parameter file) in Oracle 11g

Image
Step 1)  To perform "Multiplexing of Control Files" through spfile ( server parameter file)" first we need to create spfile from pfile. Example to create spfile from pfile: -                                       Step 2) Copy the control files in physical location from 'cp' command. Note: - At present, I have 2 control files,  I will add one more Control files in the same location. Example: -  Now you can see from above output control04.ctl file has been physically added successfully under /u01/app/oracle/oradata/prod/control04.ctl location. Step 3)  Now you need to set the same through alter command. a)  first shut down the database                                          b)  Startup (Start the database through spfile)                                                                         Step 4) Now through SQL prompt alter the changes. Example: - Step 5) Now shutdown and start the database again and check
Read more

Oracle "Redo log Groups addition/deletion" | Karan Rajpoot

Image
                    Oracle "Redo log Groups addition/deletion" Step 1) To add redo log group first we will check the log groups, members details, location, and size. Example: - From the above output, we can see we have 3 groups and inside every group, we have 1 member each of size 50 MB and the location is /u01/app/oracle/oradata/karan/ Step 2) Now we will add one group and check the status of that group. Example: - Now again we can check the details of log groups and member. Now the 4th group and a member of 50 MB has been added successfully. Step 3) Now I will add one more member to the 4th log group. Example: - We can see from the above output that in group 4, now 2 members are there. Steps to drop the latest added group and member Note: - We cannot drop CURRENT members as shown in the above output, So I will add a new member in group 3 and then I will drop that member. Step 1)  Addition of new
Read more