topic Re: Oracle 8i on HP-UX 11i Create Database Error in Operating System - HP-UX

Oracle 8i on HP-UX 11i Create Database Error

Andrew Coulthard — Mon, 20 Aug 2001 13:25:25 GMT

I'm running Oracle 8i (64bit) on HP-UX 11i (64 bit).
I have installed patch PHSS_23441 but am still getting the ORA-03113 error when trying to use the "srvmgrl" to create the oracle database.

I have checked the HP-UX parameters and they all seem to agree with what Oracle (or this forum suggests)

Can any one tell me if there are other HP-UX patches I need to apply before going back to the Oracle Technical Support ?

Thanks

Re: Oracle 8i on HP-UX 11i Create Database Error

Steve Slade — Mon, 20 Aug 2001 14:09:51 GMT

I think that this might be an Oracle installation problem. I have seen this on Oracle 8.1.7 on HPUX 11.0. The problem occured when we installed a specific Oracle patchset.

In our case the problem occured whenever you attempted to open the database. If you tried to create a new database, the database is created and mounted, but is not opened. Instead you get the ora error message. (It does not tell you that it has created the instance and the mounted the db files.

In our case, we did not find the actual cause, as the patchset did work on another machine. We eventually cured the problem by re-installing - not a nice thing with the new 'improved?' Oracle Universal Installer. Before, this I would suggest trying to relink all the Oracle code again - there is a relinkall script, but I have forgotten where it is ORACLE_HOME/bin or maybe orainventory/bin?

Good luck.

Re: Oracle 8i on HP-UX 11i Create Database Error

Andrew Coulthard — Mon, 20 Aug 2001 14:14:09 GMT

Thanks for the help.

There is a relink script in the \bin directory
I have executed this after any changes have been made without any apparent changes.

The best I've got from Oracle so far is that this is a HP-UX 11i problem solved by applying specifc patches, however the patch list they gave me was for HP-UX 11.00.

There are different patches for 11i.

Re: Oracle 8i on HP-UX 11i Create Database Error

ajax13 — Mon, 20 Aug 2001 15:25:44 GMT

Hi,
I got this error before when I had the environment variables not set correctly. Another thing may cause this error if the dbs directory does not exist($ORACLE_HOME/dbs).

Thanks

Re: Oracle 8i on HP-UX 11i Create Database Error

David Reno — Mon, 20 Aug 2001 15:45:44 GMT

My experience in this area is that the kernel tunables are not set high enough. Try the following:

STRMSGSZ 65535
dnlc_hash_locks 512
eqmemsize 512
max_async_ports 1024
max_thread_proc 9100
maxdsiz 0X20000000
maxdsiz_64bit 0X40000000
maxfiles 512
maxfiles_lim 512
maxssiz 0X10000000
maxssiz_64bit 0X800000
maxswapchunks 10240
maxtsiz 0X4000000
maxtsiz_64bit 0X40000000
maxuprc 256
nfile 5000
nflocks 4500
ninode 5000
nproc 2512
nstrpty 60
semmni 2048
semmns 2048
shmmax 0X40000000
shmmni 800

Re: Oracle 8i on HP-UX 11i Create Database Error

Jon Finley — Mon, 20 Aug 2001 18:51:28 GMT

From ORacle's web site:
-----------------------
Problem Description
===================

Creating a database using the Configuration Assistant fails with an ORA-03113
when trying to create the datafiles. The directories exist, the permissions
seem to be correct, and the environment is set correctly.

In addition, when you try to connect to Server Manager or SQL*Plus, it fails
immediately with an ORA-03113.

Solution Description
====================

It seems that for some reason the "$ORACLE_HOME/dbs" directory is not there or
is a symbolic link. This is remedied by creating the "dbs" (using the Unix
command: mkdir dbs) directory under the $ORACLE_HOME directory even if it is
empty. This will allow Server Manager and SQL*Plus to connect; in addition, it
allows the Dbassist script to create the database.

Explanation
===========

There will not be any trace file nor any core dump. The reason is that if the
"dbs" directory is missing (thus your control file cannot be found by SQL*Plus
or Server Manager), Server Manager will not be able to get information about
your "core_dump_dest".

If you have an empty "dbs" directory, Server Manager will not return the
ORA-03113 error. Only when the directory is missing does Server Manager return
the error.

Re: Oracle 8i on HP-UX 11i Create Database Error

Andrew Coulthard — Wed, 22 Aug 2001 11:52:30 GMT

Thanks for all the replies so far.

I'm no nearer sorting out the problem.

I have checked the configuration parameters for HP-UX and all seems to agree with what I need.
The /dbs directory exists as expected.
The Oracle relink all executes successfully.
The install was done with the Oracle Universal installer.

I think I may be back to looking at patches from HP and/or Oracle

Any more ideas ?

Re: Oracle 8i on HP-UX 11i Create Database Error

Thwing Havens_1 — Thu, 23 Aug 2001 19:54:56 GMT

The error is due to you not setting the sticky bit on the oracle exe itself. Look at the post-installation instructions for tasks that need to be done by root. You need to do as root:

chmod 6751 $ORACLE_HOME/bin/oracle

Re: Oracle 8i on HP-UX 11i Create Database Error

Pornsak Lamaimuang — Fri, 24 Aug 2001 10:18:17 GMT

I think you may receive same error when you run
SQL*Plus. Pls issue "ls $ORACLE_HOME/bin/oracle". If you see the size of file is 0 (zero).
Try increase kernel parameters named "maxdsiz" and "maxdsiz_64bit" to 1GB and reboot your machine. Then, reinstall oracle (not good thing) or relink only "oracle" binary.
The problem is there are not enough memory during the relink phase of the installation. You may see on "Out of memory" error.

Hope to solve your problem.

Enjoys,
Pornsak Lamaimuang