In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Wednesday, May 13, 2009

creating database with dbca

creation of database using database configuration assitant(DBCA):
steps for creating a database using dbca in a oracle server for both windows and linux environment follow the same procedure.
for linux:
open the terminal type dbca in the terminal
[oracle@localhost ~]$dbca
welcome screen will appear if not
[oracle@localhost ~]$$ORACLE_HOME/bin/dbca
for windows open command prompt and type dbca, welcome screen will appear
step 1:
click NEXT to proceed.
step 2:

select create a database option, by default it will be create a database only and click NEXT to proceed.
step 3:
select General Purpose and then click NEXT to proceed.
step 4:
Enter your new database name eg:demo and click NEXT to proceed.
step 4:
step 5:
step 6:
step 7:
step 8:
step 9:
step 10:
step 11:
step 12:
click FINISH

now you can connect and work with your new database
[oracle@localhost ~]ORACLE_SID=demo
[oracle@localhost ~]sqlplus '/as sysdba'
SQL*Plus: Release - Production on Wed May 13 00:45:19 2009

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

SQL> select name from v$database;



Anonymous said...

Good Initiative Action,apart from installation and others, request you to post some other queries in oracle,more inner
keep the god work

Anonymous said...

Its good you posted screenshots.
Its turned out very useful for me today

Thank you very much

Vijay said...

Hi Vishwa,

Nice one... Could you please post the screenshots of DB creation with ASM storage? Thanks :)