 | |
Oracle 10gR2 Installation on RedHat Linux 5
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Oracle 10gR2 Installation on RedHat Linux 5 -
01-28-2009
, 07:14 PM
|
Ora_DBA schrieb: On Jan 28, 4:55 am, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) 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.
#12
| |||
| |||
|
|
On Jan 28, 2:12 pm, Maxim Demenko <mdeme... (AT) gmail (DOT) com> wrote: Ora_DBA schrieb: On Jan 28, 4:55 am, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) 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. |
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
#13
| |||
| |||
|
|
On 29 Jan., 02:14, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote: On Jan 28, 2:12 pm, Maxim Demenko <mdeme... (AT) gmail (DOT) com> wrote: Ora_DBA schrieb: On Jan 28, 4:55 am, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) 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 - |
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.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.