I have been creating a database manually using bare devices in Oracle 10 Gb. Today I try to create a database manually using bare devices in oracle 9i, but after some trouble, finally, the solution is solved. The detailed record is as follows.
I have been creating a database manually using bare devices at oracle10G. Today I tried to create a database manually using bare devices at oracle9i. I encountered some trouble. However, after some hard work, I finally solved the problem, detailed records are as follows.
First, create the bare device file required for oracle9i under the volume group vg00, log on to the graphical interface as an oracle user, and open the dbca program, you can manually specify the raw device file and path to create data files, control files, and log files. The system reports the following error during installation:
The message prompted by this error is that the system does not use a bare device, but directly uses the file system to create a database. Therefore, the prompt is insufficient space, the result can only be a failure.
There is a difference between using dbca to install databases in oracle10G and oracle9i. In oracle10G, the system will explicitly ask you, whether to use a file system or a bare device when creating a database, as shown in:
In this figure, if "file system" is selected, it indicates that the database is installed as a file system. This method is generally used for experiments, which is convenient. In the production environment, most databases are created using bare devices, that is, raw devices ". After selection, you can use map to write the name of the table to be created and the path of the corresponding bare device to the text file, then, the tablespace is divided by ing the content in the file. Another way is to manually specify the table space. This method is widely used.
So there is no such option in oracle9i, But oracle does not officially say that the 9i cannot use bare devices to create databases. What should I do? I have to mention a parameter named "DBCA_RAW_CONFIG" here. You can define the value of this parameter in the operating system to correspond to the ing file, and then write this value to the oracle user's environment variable, in this way, bare devices can be used for installation during database creation.