Friday, September 30, 2011

How to run dbca in text mode

How to run dbca in text mode ?
Or how to comfortably create db having only telnet connection to db server,without any vnc and X-server ?

My example:

[oracle@telecom dev]$ dbca -silent -createDatabase      \
> -templateName /oracle/db_1/assistants/dbca/templates/General_Purpose.dbc   \
> -gdbName    dev                     \
> -sysPassword oracle                 \
> -systemPassword oracle              \
> -emConfiguration NONE               \
> -disableSecurityConfiguration ALL   \
> -storageType FS                     \
> -datafileDestination /oracle/dev \
> -characterset  AL32UTF8             \
> -nationalCharacterSet AL16UTF16     \
> -sampleschema true                  \
> -memoryPercentage 25
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
57% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/oracle/cfgtoollogs/dbca/dev/dev.log" for further details.


Here is the result: 

[oracle@telecom dev]$ ls -l

-rw-r----- 1 ora11g dba   9748480 Sep 30 12:26 control01.ctl
-rw-r----- 1 ora11g dba 328343552 Sep 30 12:14 example01.dbf
-rw-r----- 1 ora11g dba  52429312 Sep 30 12:14 redo01.log
-rw-r----- 1 ora11g dba  52429312 Sep 30 12:25 redo02.log
-rw-r----- 1 ora11g dba  52429312 Sep 30 12:14 redo03.log
-rw-r----- 1 ora11g dba 513810432 Sep 30 12:19 sysaux01.dbf
-rw-r----- 1 ora11g dba 744497152 Sep 30 12:25 system01.dbf
-rw-r----- 1 ora11g dba  30416896 Sep 30 12:13 temp01.dbf
-rw-r----- 1 ora11g dba  94380032 Sep 30 12:25 undotbs01.dbf
-rw-r----- 1 ora11g dba   5251072 Sep 30 12:14 users01.dbf

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...