SQL tutorial 36: how to create database using database configuration assistant DBCA

Key Takeaways

what's up internet I'm Manish from rebellion writer.com and I'm back once again with another SQL tutorial actually it's more of an Oracle database tutorial and today we will learn how to create database using database configuration assistant dbca I plan to do this particular video at the end of SQL tutorial series but I have got so many requests for how to create database using dbca tutorial that I thought to do this now I love you all guys you people are so damn amazing keep on posting your suggestion I will try to make the video as soon as possible be based on your suggestion just on one condition hit the like button on my videos and don't forget to share and subscribe so let's start today's tutorial dbca database configuration assistant is a utility provided by Oracle to create and configure a database moreover dbca is an oracle recommended way for creating and configuring a database on your system you can find this database configuration assistant dbca utility with every regular Oracle database product like a standard and Enterprise version but if we are using Oracle Express Edition then I'm sorry guys you will not find this utility there as Oracle XC can only have maximum one database which comes pre-installed by the way I have done a video on how to install Oracle database 11g Express Edition the link to which is in the description box so there are two ways to open database configuration assistant DBC on your Windows machine I'll show you the both before that I'm assuming that you have installed Oracle database 10g or 11g on your system it doesn't matter whether you have 10g or 11g steps for creating database using dbca are same for both if you haven't installed then please watch my tutorial one on how to install orle database 11g all the links are in the description box so to launch this dbca utility go to your start menu and then all program here you should have a folder by the name of Oracle followed by home name here is mine Oracle orb 11g home 1 Click and expand it now go to configuration and migration tool and then database configuration assistant right click and select run as administrator or you can simply search for dbca in your start menu just before let's close this one now go to your start menu and here search for dvca here it is right click and select run as administrator this is the first way now let's take a look at the second way to open dbca utility before that let me close the previous dbca window okay now just go to your command prompt and here write dbca and hit enter this will open up the dbca utility for you but I highly recommend you to run dpca with administrator privileges otherwise you may get access denied directory error thus I will start the dbca with administrative privileges so right now we are into the dbca windows this is the welcome screen of dbca with lots of text describing what you can do with this utility if you want you can read it otherwise hit next now this will bring you to the database creation visor before starting let me clear on one thing your dbca windows screen may look different or you may have some extra option than mine that depends upon the Oracle database software so just don't worry step one this is the first step out of 11 for creating the database and these are the operation which you can perform with database configuration assistant dbca you can create a new database or configure the existing database delete a database and man template if you have any as we are creating a new database thus we will choose the first option here which is create a database now hit next step two database template here in step two of dbca we have to choose the template of our database which means that here we have to choose what kind of database we want to create here we have three option first one is general purpose or transaction processing you must have come across this kind of database these are the often used database such as retail Billing System general purpose database and ATM automatic teller machine which is a very good example of transaction processing database and the second one is custom database pretty similar to the general purpose one but it's bit more flexible here you can choose individual component of the database which you want to use such as as Oracle extension for net Oracle olab text lab security and Enterprise Manager repository etc etc you can even assign your desired table space to all these database component and the third one is Data Warehouse data warehouse is also a type of relational database which is basically used for cury and Analysis rather than for transaction processing so if you want to create a data warehouse then choose this one but we are creating a general purpose database thus we will select the first option which is general purpose or trans ction processing now hit next step three database identification here in step three you have to provide the global database name for your database Global database name is the full name of your database this helps you in uniquely identifying your database this should be in the form of database name. domain name this is also an oracle recommended format for Global database name but you can give whatever name you want for this demonstration I will write youtube. rebellionrider.com Here YouTube is our database name and Rebellion rider.com is the domain name in the second field you have to specify the Sid which stands for system identifier as you can see by default it takes Sid name from Global database name field which is YouTube in our case I have explained a lot about Sid in various video in the playlist but still if you want to read then please visit my blog on how to create database link is in the description box now hit Next Step step four management option here in this step you will choose whether you want to configure Enterprise Manager or not Oracle Enterprise Manager is a webbased management tool for individual database along with Enterprise Manager you can also configure your alerts Supply your email server details and this will send you all the alerts on your emils moreover you can also configure daily dis backup if you want but make sure automatic maintenance task must be enabled to know what it is you can read this text for this demo database creation all these default settings are good for me I'm not going to change anything but I recommend you to configure this Oracle Enterprise Manager this is a good tool hit next database credentials here you have to configure the security for all these account these are few administrative mandatory and by default configure accounts here you have two options either you can configure separate password for each of them or you can assign same password to all of them I will choose the second option and will assign same password to all these administrative accounts now hit next avoid this warning is just saying you should obey the Oracle standard for creating a password just simply hit yes step six database file location here in this step you have to specify the type of storage you would like your database to use in the stor type we have two options file system and ASM automatic storage management if you have configured ASM then I recommend you to choose the same otherwise go for the file system since I do not have ASM configured on this system thus I will choose the file system here after choosing a storage type you have to specify the storage location for storage location we have three options first one is use database file location from template by using this option you don't need to do anything instead dbca will create an oracle home directory for you second one is use common location for all database files here you can choose your own directory dbca will set that directory as your Oracle home and then all the database file will get created at this location last and the third one is use Oracle manage file this option instruct Oracle database to directly manage operating system wise it provides you with the flexible way for multiplexing online R locks and control file this is recommended for security purpose I will choose the default and the first one options now hit Next Step seven recovery configuration I highly recommend you to enable archiving and if you want to set your desirable location for flash recovery area then enable this checkbox which is already enabled and select the directory and specify the area size make sure flash recovery area size should at least be twice the database size but I'm good with the dbca default location for flash recovery area along with that also check this enable archiving I highly recommend you to enable the archiving I think everything is set and good to go if you want to know more about archive lcks then please watch my video tutorial next 9 link is in the description box now hit Next Step eight database content here in this step take this check boox if you want to install sample schema such as HR Scot OE and many more now hit Next Step n initialization parameter here in this step you can change the default initialization parameter settings such as memory sizing corre set and connection mode you can also click this all initialization parameter button to display a list of all the database initialization parameter and their current settings I'll go with all these default setting to know more about all these options please visit my blog and now hit Next Step 10 database storage this window will show you the summary of your database and its entire files like how many control files you have and where are they saved you can even see all the data files along with their location and many more here you can also check for all your Rog group and if you want then you can even create more redog group hit next here Step 11 creation option this is the last step where you have to tell dbca what you want to do either you want to create a database or save all these setting as template for feature use or you want to generate a database creation script you can also perform these three steps all together now hit finish this will show you your database creation summary press okay here if you need full in-depth knowledge on how to create database using dbca please visit my blog I have explained every step of database Creation in detail there you can find the link in the description box database creation using dbca may take time thus I'm going to fast forward this section of video as we have installed sample schemas thus here we can unlock some accounts such as HR to unlock the accounts click this password management button and now here select the account which you want to unlock let's unlock the HR account search for HR and here it is now here unselect this Lo account field and then Supply the password I will give HR here as password again confirm password now press okay avoid this warning it's just again saying that you should obey orle password standards just press yes and now click exit as soon as you click it all the windows get closed and your database gets created that's it your database is now created that's it for today's guys hope this video helps you with your database creation please do like and subscribe thank you for your time have a great day this is Manish from Rebellion Rider