dbca missing on 9.2.0 installation
Today I was asked to install a new server to host an old Oracle 9.2.0.5 database.
This installation is done on OEL 4.8 using NOTE : Requirements for Installing Oracle 9iR2 on RHEL 4 [ID 303859.1]
Shortly after installing and trying to find DBCA to create a database is was suprised to not find this binairy under ORACLE_HOME/bin.
When backtracking the situation , I found this error where user interaction had chosen to continue which resulted in skipping this component.
The installation log shows the following error :
name = ORACLE_BASE
Query returned :
Setting value of s_mountPoint to /oradata
*** Error Dialog: Error: You do not have sufficient privileges to write to the specified path. in component Database Configuration Assistant 9.2.0.1.0 . Installation cannot continue for this component. ***
User selected: Stop installation of this component only.
At this point the installer tries to install DBCA among other binairies. When skipped the DBCA is not available after the installer completes.
To deal with this , you need to set a proper ORACLE_BASE before the Installer is started. If no valid ORACLE_BASE is provided , the installer will try to use /oradata which in most cases the oracle user is not allowed to create
.

Comments are closed.