dbca静默安装及建库

rdbms 11.2.0.4

-- 静默安装过程

[oracle@testdb database]$ ./runInstaller -silent -force -showProgress -ignoreSysPrereqs -waitForCompletion -responseFile /home/oracle/database/response/db_install.rsp -ignorePrereq
Starting Oracle Universal Installer...
 
Checking Temp space: must be greater than 120 MB.   Actual 31392 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 16383 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-06-23_03-21-13PM. Please wait ...You can find the log of this install session at:
 /test/app/oraInventory/logs/installActions2022-06-23_03-21-13PM.log
 
Prepare in progress.
..................................................   9% Done.
 
Prepare successful.
 
Copy files in progress.
..................................................   14% Done.
..................................................   20% Done.
..................................................   26% Done.
..................................................   31% Done.
..................................................   36% Done.
..................................................   41% Done.
..................................................   46% Done.
..................................................   51% Done.
..................................................   56% Done.
..................................................   63% Done.
..................................................   68% Done.
..................................................   73% Done.
..................................................   78% Done.
..................................................   83% Done.
..............................
Copy files successful.
 
Link binaries in progress.
..........
Link binaries successful.
 
Setup files in progress.
..................................................   88% Done.
..................................................   94% Done.
 
Setup files successful.
The installation of Oracle Database 11g was successful.
Please check '/test/app/oraInventory/logs/silentInstall2022-06-23_03-21-13PM.log' for more details.
 
Execute Root Scripts in progress.
 
As a root user, execute the following script(s):
        1. /test/app/oraInventory/orainstRoot.sh
        2. /test/app/oracle/product/11.2.0/db_1/root.sh
 
 
..................................................   100% Done.
 
Execute Root Scripts successful.
Successfully Setup Software.
[oracle@testdb database]$ 

-- 安装监听,没有配置netca.rep响应文件 

netca -silent -responsefile /home/oracle/database/response/netca.rsp
 
[oracle@testdb bin]$ ./netca -silent -responsefile /home/oracle/database/response/netca.rsp
 
Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /home/oracle/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /test/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@testdb bin]$ 

-- dbca建库
dbca -silent -responseFile /tmp/database/response/dbca.rsp   -- 没有用这个 

-- 使用下面的dbca命令建库 

dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-responseFile NO_VALUE \
-gdbname prod \
-sid prod \
-sysPassword oracle \
-systemPassword oracle \
-redoLogFileSize 2048 \
-storageType FS \
-datafileDestination /test/app/oradata \
-characterSet AL32UTF8 \
-nationalCharacterSet AL16UTF16 \
-emConfiguration NONE \
-automaticMemoryManagement false \
-totalMemory 4096 \
-databaseType OLTP

-- 过程

[oracle@testdb oradata]$ dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -responseFile NO_VALUE \
> -gdbname prod \
> -sid prod \
> -sysPassword oracle \
> -systemPassword oracle \
> -redoLogFileSize 2048 \
> -storageType FS \
> -datafileDestination /test/app/oradata \
> -characterSet AL32UTF8 \
> -nationalCharacterSet AL16UTF16 \
> -emConfiguration NONE \
> -automaticMemoryManagement false \
> -totalMemory 4096 \
> -databaseType OLTP
 
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
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/test/app/oracle/cfgtoollogs/dbca/prod/prod.log" for further details.
[oracle@testdb oradata]$ 
[oracle@testdb oradata]$ 

-- log信息

[oracle@testdb oradata]$ more /test/app/oracle/cfgtoollogs/dbca/prod/prod.log
Copying database files
File "/etc/oratab" is not accessible. 
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 26%
DBCA_PROGRESS : 37%
Creating and starting Oracle instance
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 56%
DBCA_PROGRESS : 60%
DBCA_PROGRESS : 62%
Completing Database Creation
DBCA_PROGRESS : 66%
DBCA_PROGRESS : 70%
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 85%
DBCA_PROGRESS : 96%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
 /test/app/oracle/cfgtoollogs/dbca/prod.
Database Information:
Global Database Name:prod
System Identifier(SID):prod
[oracle@testdb oradata]$ 

这个很快，主要慢的地方是配置响应文件。

END