Use DBCA (database configuration assistant) in linux to create an oracle database and dbcaoracle

Use DBCA (database configuration assistant) in linux to create an oracle database and dbcaoracle

Prerequisites: switch to the graphic interface

Go to the bin directory of Oracle and run dbca as the oracle user. The effect is the same as that of windows.

 

If garbled characters appear

Export LANG = "en_US: UTF-8"
How to start oracle database configuration assistant in linux

Enter export DISPLAY =: 0.0 and xhost + for the root user and oracle user respectively.
Enter dbca for the oracle user

In linux, how does one use dbca to create an oracle 10 Gb database?

1. Graphic Interface: log in with an oracle user and run dbca. The Wizard prompts you to create, modify, and delete a database.
2. Command Line: switch from su-oracle to oracle users. You can create and delete databases in silent mode.
A) execute the following command to use DBCA to silently create a database
$ Dbca-silent-createdatabase-responseFile/tmp/dbca. rsp
Copy dbca. rsp under the response directory in the Oracle installation disk to the local machine and modify necessary parameters.
B) Use a dba user to delete a database
Dbca-silent-deleteDatabase-sourceDB orcl-sid orcl-sysDBAUserName sys
-SysDBAPassword password