HPUX - Oracle Database installation/creation problem.

[Vilas]

Hi,

I get error ORA-03114: not connected to Oracle, when try to create database on HPUX B.11.
All the oracle parameters like ORACLE_HOME, etc are set properly , also all the memory related parameters like shmmax, shmmni, etc are set properly. We installed all the required patches also. But when I run 'installprep.sh' script, it complains about the following patches.

Required OS Patch Verification
______________________________

The following OS Patches listed, if any, are required to be installed:
Required OS package PHKL_24268 is not installed
Required OS package PHKL_25525 is not installed
Required OS package PHNE_24715 is not installed
Required OS package PHSS_23670 is not installed
Required OS package PHSS_24301 is not installed
Required OS package PHSS_24303 is not installed
Required OS package PHSS_24627 is not installed
Required OS package PHSS_22868 is not installed

Also, swlist doesn't list these patches. But this is because,
when you pull them up, they will give you a recommended replacement patch; because half of them have been replaced by other patches
. For example, PHKL_25525 is replaced by PHKL-28766 and in the same way PHNE_24715 is replaced by PHNE-28538.

One more thing, while installing patch PHSS_22868, it displays following message,
NOTE: The patch fileset "PHSS_22868.ACXX-STDLIB,r=1.0" may only be
installed upon a previously installed base fileset. The
specification for this base fileset is
"ACXX.ACXX-STDLIB,fr=C.03.27,v=HP". Since there is no
fileset on the target or selected from the source which
matches this specification, fileset "PHSS_22868.ACXX-
STDLIB,r=1.0" will be excluded.
So, is this patch required; If yes then how to get it installed?

We did create all the required groups like, oinstall, dba, etc.

I am using jdk131_09. Is it mandatory to have it installed under /var/opt ? I installed it under some other directory but have mentioned JAVA_HOME and also included $JAVA_HOME/bin in the path.

So, how should we fix the problem?

Thanks,

Vilas

[Martin Johnson]

Try starting oracle manually and see if you get any errors:

su - oracle
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/svrmgrl
SVRMGR> connect internal
SVRMGR> startup
SVRMGR> exit

If you get no errors, try creating the DB again.

HTH
Marty

[Brian Crabtree]

When are you getting the error? Initially right after trying to login with svrmgrl, or after you try and create the database. If it is initially, it is a kernel/memory/software problem. If it is after the create statement, then there is an incorrect setting in your init.ora. You should be able to look in the background_dump_dest for the alert.log, and see what error it is. I would recommend checking that your "compatible" parameter is set correctly.

Thanks,

Brian

[Steven E. Protter]

So long as you install the recommended patch or the one that superseds it, you should be okay.

If you did this after the Oracle install, return to start and install again.

oinstall is just for big shops that have a bunch of folks dedicated to installations. Make dba the group that the database owner is in and make all oracle components, ias or whatever part of dba group.

Make sure the java is current with all required patches, listed on http://www.hp.com/go/java prior to installation. The list is extensive.

SEP