Re: Oracle 10gR2 Installation on RedHat Linux 5
From: Ora_DBA <sanjaydharmadhikari_at_gmail.com>
Date: Sat, 31 Jan 2009 07:09:14 -0800 (PST)
Message-ID: <34dc018c-1e78-4ae4-ae10-ee1283a42347_at_e1g2000pra.googlegroups.com>
On Jan 29, 2:27 am, Maxim <mdeme..._at_gmail.com> wrote:
> On 29 Jan., 02:14, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
>
>
>
>
>
> > On Jan 28, 2:12 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
>
> > > Ora_DBA schrieb:
>
> > > > On Jan 28, 4:55 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
> > > > wrote:
> > > >> Ora_DBA wrote:
> > > >>> I am trying to install Oracle database 10g R2 on RedHat Linux 5.
> > > >>> The installation goes fine till the Oracle Net Configuration Assistant
> > > >>> but the DBCA hangs. I have selected to create a starter database with
> > > >>> sample schemas. I waited for about 4 hours to let DBCA finish its
> > > >>> work. The "top" command shows that the oracle user process is taking
> > > >>> about 1% of the CPU. It just gets stuck.
> > > >>> I checked all the Hardware/Software requirements, Kernel parameter
> > > >>> configuration etc. All the requirements specified in the Installation
> > > >>> guide have been met.
> > > >>> If anyone on this forum has encountered the same problem, could you
> > > >>> please let me know how you resolved it ?
> > > >>> Thanks in advance.
> > > >> I started off with V5.2, and it definitely did not support Oracle.
> > > >> RH 6.0 and 6.2 were a RPITA to get Oracle running.
> > > >> I suspect you are running something else - Fedora 6, perhaps?
> > > >> ES 5.0?
>
> > > >> Did you check the Linux/Oracle installation wizard site?
> > > >> It's athttp://www.puschitz.com/InstallingOracle9i.shtml
> > > >> --
>
> > > >> Regards,
> > > >> Frank van Bortel- Hide quoted text -
>
> > > >> - Show quoted text -
>
> > > > Yes, I checked the Linux installation wizard site. Everything looks
> > > > fine as far as Kernel parameters and the overall setup is concerned.
>
> > > > Thanks.
>
> > > Still it is not quite clear, at which step the database setup hang.
> > > As already mentioned by Robert, in general Oracle 10g setup on Cent OS
> > > 5.2 runs smoothly, so you have probably, at some place, done settings,
> > > which don't conform with Oracle requirements. If i would troubleshoot
> > > such kind of problem, i would probably first consult all generated log
> > > files and then recheck the most common pitfalls, such as
> > > 1) verify , all required packages are installed
> > > 2) network settings ( no dhcp, no IPv6, hostname resolved in /etc/hosts)
> > > 3) kernel parameters and security parameters ( selinux disabled, right
> > > values in limits.conf)
>
> > > Best regards
>
> > > Maxim- Hide quoted text -
>
> > - Show quoted text -
>
> > It hangs while running DBCA to create starter database with sample
> > schemas.
>
> > I will check all the parameters, packages and network settings.
>
> > Thanks.
>
> Well, that may be the issue. I have just generated the scripts for
> custom database creation with sample schemas (to verify my guess) -
> the script responsible for that is called sampleSchema.sql, which
> calls in turn $ORACLE_HOME/demo/schema/mksample.sql - and that script
> has an EXIT command at the end. So, because sqlplus will be exited,
> the database creation has no chance to be completed ( the mksample.sql
> is not the last in the chain, some other scripts have to be run).
> The workaround is of course very simple - either you create your
> starter database without sample schemas and after that configure it
> with dbca and add sample schemas, or you can temporarily comment out
> the EXIT statement in the mksample.sql ( note, if you leave this
> script with commented EXIT statement, then you get another problem,
> namely by configuring database and add sample schemas will fail, to be
> precise, schemas will be created, but sqlplus session won't be
> leaved).
>
> Best regards
>
> Maxim- Hide quoted text -
>
> - Show quoted text -
Date: Sat, 31 Jan 2009 07:09:14 -0800 (PST)
Message-ID: <34dc018c-1e78-4ae4-ae10-ee1283a42347_at_e1g2000pra.googlegroups.com>
On Jan 29, 2:27 am, Maxim <mdeme..._at_gmail.com> wrote:
> On 29 Jan., 02:14, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
>
>
>
>
>
> > On Jan 28, 2:12 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
>
> > > Ora_DBA schrieb:
>
> > > > On Jan 28, 4:55 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
> > > > wrote:
> > > >> Ora_DBA wrote:
> > > >>> I am trying to install Oracle database 10g R2 on RedHat Linux 5.
> > > >>> The installation goes fine till the Oracle Net Configuration Assistant
> > > >>> but the DBCA hangs. I have selected to create a starter database with
> > > >>> sample schemas. I waited for about 4 hours to let DBCA finish its
> > > >>> work. The "top" command shows that the oracle user process is taking
> > > >>> about 1% of the CPU. It just gets stuck.
> > > >>> I checked all the Hardware/Software requirements, Kernel parameter
> > > >>> configuration etc. All the requirements specified in the Installation
> > > >>> guide have been met.
> > > >>> If anyone on this forum has encountered the same problem, could you
> > > >>> please let me know how you resolved it ?
> > > >>> Thanks in advance.
> > > >> I started off with V5.2, and it definitely did not support Oracle.
> > > >> RH 6.0 and 6.2 were a RPITA to get Oracle running.
> > > >> I suspect you are running something else - Fedora 6, perhaps?
> > > >> ES 5.0?
>
> > > >> Did you check the Linux/Oracle installation wizard site?
> > > >> It's athttp://www.puschitz.com/InstallingOracle9i.shtml
> > > >> --
>
> > > >> Regards,
> > > >> Frank van Bortel- Hide quoted text -
>
> > > >> - Show quoted text -
>
> > > > Yes, I checked the Linux installation wizard site. Everything looks
> > > > fine as far as Kernel parameters and the overall setup is concerned.
>
> > > > Thanks.
>
> > > Still it is not quite clear, at which step the database setup hang.
> > > As already mentioned by Robert, in general Oracle 10g setup on Cent OS
> > > 5.2 runs smoothly, so you have probably, at some place, done settings,
> > > which don't conform with Oracle requirements. If i would troubleshoot
> > > such kind of problem, i would probably first consult all generated log
> > > files and then recheck the most common pitfalls, such as
> > > 1) verify , all required packages are installed
> > > 2) network settings ( no dhcp, no IPv6, hostname resolved in /etc/hosts)
> > > 3) kernel parameters and security parameters ( selinux disabled, right
> > > values in limits.conf)
>
> > > Best regards
>
> > > Maxim- Hide quoted text -
>
> > - Show quoted text -
>
> > It hangs while running DBCA to create starter database with sample
> > schemas.
>
> > I will check all the parameters, packages and network settings.
>
> > Thanks.
>
> Well, that may be the issue. I have just generated the scripts for
> custom database creation with sample schemas (to verify my guess) -
> the script responsible for that is called sampleSchema.sql, which
> calls in turn $ORACLE_HOME/demo/schema/mksample.sql - and that script
> has an EXIT command at the end. So, because sqlplus will be exited,
> the database creation has no chance to be completed ( the mksample.sql
> is not the last in the chain, some other scripts have to be run).
> The workaround is of course very simple - either you create your
> starter database without sample schemas and after that configure it
> with dbca and add sample schemas, or you can temporarily comment out
> the EXIT statement in the mksample.sql ( note, if you leave this
> script with commented EXIT statement, then you get another problem,
> namely by configuring database and add sample schemas will fail, to be
> precise, schemas will be created, but sqlplus session won't be
> leaved).
>
> Best regards
>
> Maxim- Hide quoted text -
>
> - Show quoted text -
The problem has been fixed. Used -ignoreSysPreReqs flag with runInstaller and used character set AL32UTF8. It may be the combination of these two that worked. But I think that it was the character set that made the difference. In prior installation I used the default character set West European.
Thanks everyone. Received on Sat Jan 31 2009 - 09:09:14 CST