Oracle database installation hangs at 78%

[darren_lee]

Hi

has anyone encountered this before?

when installing the database server, it hangs at the dbca stage and at 78%. There is no error messages shown.

cheers

[Oviwan]

Hey

have you ignored some pre-requirements?

Regards

[darren_lee]

Hi

Have made the required changes to the kernel according to the installation manual.

For the patches PHSS_29658 and PHSS_29960, it shows that the base is not installed therefore not required.

All steps are based on the quick installation guide attached.

[Oviwan]

If you have an account on metalink check note ID: 334563.1 and download the validate script. this script checks the whole system for the oracle installation

[darren_lee]

Thanks

have downloaded the validate check and ran it.

the only errors i got are for ExtjobOK user and the patches.

user should be created when root.sh file is ran whereas the patches can be ignored?

210 Got OS patches? FAILED = PHKL_32632 or it's successor
PHKL_33656 or it's successor PHKL_33807 not installed
PHKL_32645 not installed
PHKL_33552 or it's successor PHKL_33563 not installed
PHSS_31850 or it's successor PHSS_34040 not installed
PHSS_31854 or it's successor PHSS_33357 or it's successor PHSS_34045 not installed
PHSS_31855 or it's successor PHSS_33350 or it's successor PHSS_34041 not installed
PHSS_33275 or it's successor PHSS_33349 or it's successor PHSS_34040 not installed
PHSS_33276 or it's successor PHSS_34042 not installed
PHSS_33277 not installed
PHSS_33278 not installed
PHCO_31553 or it's successor PHCO_33675
not installed

thanks

[Oviwan]

which OS and oracle version have you?

here an article which patches are required for what. note ID: 169706.1

[darren_lee]

OS: 11.23 v2 Itanium
Oracle: 10.1.0.2.0

have already verified, the above should be ok.

so far, only errors i got is the patches.
this has been the case when installing application server but it still manages to install and works properly.

[Fred Ruffet]

does it hangs on install or binding ?

Regards,

[darren_lee]

it hangs at clone database creation process.

please see attached for screen.

[Yogeeraj_1]

hi,

can you verify that there are no other screens open in the background and which is waiting for an input.

revert
kind regards
yogeeraj

[Milton Lin_3]

Darren,
Check for OraIn* directories under the /tmp directory. The install or de-install of Oracle software has hanged before in the past with me and removing these temporary directories and re-doing it worked.

[Patti Johnson · Accepted solution]

take a look in the $ORACLE_BASE/admin//bdump directory - the alert.log may show issues with the database creation.
Worse case you can cancel the installation and use DBCA to create the database - or create your instance manually.

Patti

[darren_lee]

Hi

1. There are no other screens waiting for input.

2. tried installing without starter database and ran dbca. It hangs at the same place.

3. alert log does show some errors towards the end where it hangs. please see attached for more information.

----errors -----
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
---- end ---------

[darren_lee]

Just an update

Have managed to create the database.

What was done: created the database with dbca without specifying the flash_recovery_area.

Still looking to find the reason why it won't work using normal installation.

[TwoProc]

FWIW,

dbca is a nice tool, but use it generate the scripts to generate the database, don't just let dbca actually run the creation itself. You can optionally save the scripts in files. Then go in and edit them (like add missing components as you saw),to put in missing storage clauses, destination drive areas, etc. Then when you run it you can see very clearly what your scripts are doing and what they are hanging on.

Also, I tend not to let the database creation script "do everything" at once. I tend to let it create a very basic database, and then pull out the tablespace creation, running of libraries, etc. into separate steps. I do this go try and get some control over errors and make the installation at least get to solid stopping points.

[darren_lee]

Thank you to all who have taken your time to help.

Have managed to install the database as mentioned earlier. Oracle has also suggested to change the flash_recovery_area location to another location while installation. It works successfully now.