Wednesday, February 20, 2013

Oracle: Create First Database

Reference: http://dba-onweb.blogspot.ca/2008/03/oracle-11g-creating-database-with-asm.html

login as oracle
cd /opt/oracle/product//11.2.0/dbhome_1/bin
dbca

control file: *.ctl
oracle@expc2042:/opt/oracle/product/11.2.0/dbhome_1/dbs> pwd
/opt/oracle/product/11.2.0/dbhome_1/dbs
oracle@expc2042:/opt/oracle/product/11.2.0/dbhome_1/dbs> ls
hc_aniu.dat  hc_DBUA0.dat  hc_expc2042.dat  init.ora  lkANIU  lkEXPC2042  orapwaniu  orapwexpc2042  spfileaniu.ora  spfileexpc2042.ora

cd /opt/oracle
 find . -name "*.ctl" -exec ls -l {} \;

-rw-r----- 1 oracle oradba 9748480 Feb 20 15:48 ./flash_recovery_area/aniu/control02.ctl
-rw-r----- 1 oracle oradba 9748480 Feb 20 15:48 ./oradata/aniu/control01.ctl

redo log
oracle@expc2042:/opt/oracle> find . -name "*.log" -exec ls -l {} \; |grep redo
-rw-r----- 1 oracle oradba 52429312 Feb 20 15:31 ./oradata/aniu/redo02.log
-rw-r----- 1 oracle oradba 52429312 Feb 20 15:50 ./oradata/aniu/redo01.log
-rw-r----- 1 oracle oradba 52429312 Feb 20 15:32 ./oradata/aniu/redo03.log

No comments:

Post a Comment