So lets it begin: start DBCA, run
# /u01/app/oracle/product/10g_2/hilandco/bin/dbca
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1gCu03kbsm4YJzkEbPsBd1WXUeXwhwJcktptiY3TlXXHlMFz96rk4Ry-IKK9nOQOyr5dr9sthOkj8-KFLz1wDu-eHbmDSjhBmzam-fJ5OWypxj_B0MzqAzn30bnT66YkkmdiYMYHWVuU_/s400/001.png)
... click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRcecKTTTlYPPvqa9m2ofXnXudvy5d1EhPQwOOpU6iaKUckRaj7r0NRu-0ZnKQXSoShvqWg8d8Cby24Dr8AwJWzDOAcab0RdOLW24hc_JSg9HXVcB7Y7Y1X9mYmIn-0fcyfoZQJCWYgsQc/s400/002.png)
... select the radio button next to Create a Database and click next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8uCeLlBwSW2Ojy8gWrpgOqxnK0rN9N8SG7QBGRWWMrDUuuvorNAX_iAoEAyR-P1PswkzMGPTPuRS3pWmr0xVzKmILbUTlTOJFj5pFQ4T_v55KwMZ7v553CuRXXUFFuAs_R3J2yKAAZwut/s400/003.png)
... select General Purpose so that way you'll create the db from template, an click on Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdDVSiKdna94r7tlZmisNrY4DHnTFRwrTUzJYPjcJzFcSvVSpIW9hHdn1s0e-GlNAUqIEr5l7wi_6EpakFf6dNGrpUjZLZOZX8pByLBp3x8giaC27284Pl39PI_GrZb8T0IwNu6dmavA8W/s400/004.png)
... set the name and SID for you db ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8cY4AhjQlX_PhjrtuK8bXgcZ4vkbH5gtcmpXacDKopE6md6sLAjqUtYHBbtyv8Da8MZFgHNYD_Bj38xcdNWLSCNIcwWhguS4iiXqIjSzUH3n0MF1N7kb0sH6ElnYOeahAZQiPr_s5W2v0/s400/005.png)
... just leave everything on default a Click on next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinq4vI7y6re0WSG9mMKAsWys1wi4G8F9HUBeRCV6FyuzjlWPt6Kmlfqtt5T92zZ0IHxxF1YrTHxPWnsAymwpHEEhAWehK3RPwgSFfr6NDOiUh-w1Zm0fUKCauNN_sVVlWTYhx0D1DEzWDO/s400/006.png)
... I'll prefer to set for default users same password, but you can set it one by one, anyway when you set click on Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggXpO2ZHMQYJ1LpwCTkB8y6apGoFJjz6j64E8qqzmBDJf_OQEBXdqxdOK1v68tDF3A_QZW4gd8Xio74VB-19pZgpLYV8bsVZtEbuEd2CSI7r1jMmVfTwifwK3xUoFmYiLikxOwbJ57dACd/s400/007.png)
... select File System for storage mechanism and click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMX6Nkztcox9_v2yuoXCj0nwgJJd66OIYv-Une4g2L3Q_6ijbWf9massqyP_YbR_bOlFeLVb_2eX2ojBKFFoakYyuhm_JTdqCUiBnaxHsZiJiF79oOmZGkvcS3LRl0qr58tkqY0JCP2F4W/s400/008.png)
... Use Database File Location From Template and click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIXQzL7XLkNLpQL20xOG9U415YIL15ejVZdcDBzByzz3uLwPPpdXfLiduATUapTOUPqWyTNVGpekLC0DQfkUDY4-JdugtfaPfI1MQ5DFQECrYLYY6G3mQnbB82hKKHgLQ6FaueFRsM6ITH/s400/009.png)
... Flash Recovery Area is new to oracle, it was introduced by Oracle 10g; just leave the default and click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS3iCleEiQgWS7dpgACtORqG14BTKDU8FSpuF-djgC9CirMozk6J4zWwh9GvfCziL4sSOg-3IsG0XfPgILC4QJzPrRNsK5PcVAXaBp3IghyphenhyphenKWV084issZWPr6TNvpaVHB2bPt1kRrBTuJv/s400/010.png)
... if you to want install sample schemas, if not leave the check box unchecked and click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1MoBzSjrs-GjEqzGbXnvTFSrwuH7Q1Syj5lwdfG85xDU1xTZsv3PVNo1TRflZySy93Lkk4p-8tqm4IP3mCi62hTAUArI3PTpvJpLfsSdOgTLnowUGKdfEP776IHW5MzEKWg7F9XuYnnQa/s400/011.png)
... you can set the memory allocation by hand or leave it to DBCA to decide it, and click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnIOreznkvW20iS1fmPNHsMRz3q_Tkoz4t0hO4O2i_7v8np-3a1Rq6FPWqZLZov_pTNlPGBphkPZ48r4-FbRHk2wWPyhe0JoIgxGyaQsC8hOtCj4QjXewxuwPIv2En3no2C8dk13CEP0Jt/s400/012.png)
... here you can add/delete some db files, click Next ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAGNU0_Fxf_iiBv0fHJRSU21L8GVTpaiO8JnIK0WnS6v8nqwrKXMpiEQtAzu-knWG9vtsEI-MveJojgHb4M1bxzKe1vzo-Ew_gj0W232_CZtTL9CNT6bit-AVeMbBVuo8yd7m4-3aOlBES/s400/013.png)
... keep eye on, so you can track the translational process ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0UZpmweKSXm9t1Da6i_KzdLYZYk2vsSxsCaBvsaqJdfV6ES7E50TqNV4jQzDlQlvzh2bI29jlW5NWCRS0d971-cxs-Y8mnIgmXLtIXj7JLXkEFvPRG81_QU8zEB_zzlPoEFMZf_KFlPDU/s400/014.png)
... click on Password Management if you want to change password or lock/unlock users ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbKyzUtJm0aZ-q0gWCa77hqJIyL-GRM8Y8II_jKNH1Khi8He6EYs_9sEz1tlVJzP26zWg1VZ8V-e5xwaGSQpym47ktWt-26YlSVG-7uylqS-nrTrOxC5vKTh46O_rKzn3HhgYQzyvO8NrZ/s400/015.png)
... click Ok to leave the Password Management window than click Exit to exit from DBCA.
janos ujvari
June 03, 2008