Re: dbca not working in Linux

linuxquestion_at_yahoo.com wrote:

> Hi all,
>
> I've installed oracle 9.2 on Suse Linux Personal 8.2.
> The database didn't install correctly when I installed
> the oracle software.
>
> And now the database configuration assistant doesn't work
> either.
>
> I did the following in a console window. However, it
> also didn't run, in the "run" window. I'm sure this
> is some kind of setup issue.
>
> I tried adding some paths to CLASSPATH, but no luck.
> This was run as the oracle user.
>
> Any ideas?
>
> Thanks
>

Yep, got a few ideas, and I have Oracle 9.2 installed on a SuSE 8.1 OS.

First, if you have Oracle installed and cannot get a database installed, this could be due to the pathing in those darned configuration files. If you failed to get Oracle installed correctly, then the problem can be two items of interest.

First, you need glibc-locale.rpm installed on the SuSE version. It's a must have.

Next, when you start the install, you will get an error message (something about plsql). When this happens, log on as root on another screen, and go to $ORACLE_HOME/bin. Edit the file genclntsh, find the line beginning with SYSLIBS. Edit this line by adding -lgcc -L /usr/lib/gcc-lib/i486-suse-linux/3.2/

write and quit.

If you install Oracle in anything other than the default directory, you got all kinds of pathing issues. The same holds true for the databases you create. If you are a Linux user, you can edit pathing in the genelntsh file by changing the EXPORTed variable paths.

After you create the (if other than the default path), you need to copy the init[dbname].ora from the database home directory to the [oraclehome]/dba directory. When you edit the startup scripts to start the database, this is where it will look for the initialization parameters for the db.

Good Luck,

dan kirk
 PS: unless you are looking to get deep into Oracle and Linux, I suggest just using the default install parameters. It was set up according to some d*&%med group's 'ideal' of a universal database structure. Useless, and worse than useless when you want your executable stuff on one drive and your actual data files on another as with a data warehouse. Received on Fri Nov 07 2003 - 08:21:20 CST