topic Re: DBCA problem in Operating System - HP-UX

DBCA problem

Venkatesh_10 — Tue, 10 May 2005 07:54:07 GMT

after installing the Oracle S/W,i ran dbca to create the DB.i am getting error as in the attachement.
OS is HPUX-11i,DB is 9.2.
new kernel is built,libc patches are installed.
Space is available.pls guide me.

Re: DBCA problem

Robert-Jan Goossens_1 — Tue, 10 May 2005 08:03:04 GMT

Check this thread.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?admit=716493758+1115730118216+28353475&threadId=852991

Robert-Jan

Re: DBCA problem

Jean-Luc Oudart — Tue, 10 May 2005 10:23:04 GMT

Hi,

These messages are reference in Metalink doc id 189532.995
It is advised to review kernel parameters, especially SEMMNI and SEMMNS.

Please check other relevant kernel parameters.

Regards
Jean-Luc

Re: DBCA problem

Indira Aramandla — Tue, 10 May 2005 19:32:49 GMT

Hi Venkatest,

These error will occur if your init.ora - processes parameter is set too high, but the kernel is not configured to handle this.

Increase your kernel parameters specifically the semaphore related parameters such as SEMMNI and SEMMNS. Increase number of semaphores on operating system.

OR

Decrease the processes value in the init.ora and try restarting the instance.

Also, make sure that there are no 'hanging or dead ' processes that are consuming the shared memory and semaphore resources.

You can use the ipcs command for this.

Indira A

Re: DBCA problem

Venkatesh_10 — Wed, 11 May 2005 00:03:22 GMT

thanks to all.after tuning kernel it is working fine.
but now when i start the DB iam geeting
LRM-00109- could not open parameter file.
pls help.

Re: DBCA problem

Indira Aramandla — Wed, 11 May 2005 00:35:03 GMT

Hi,

In Oracle9i, Oracle has also introduced the 'SPFILE', which is a binary file stored on the database Server. Changes which are applied to the instance parameters may be persistent accross all startup/shutdown procedures.

In Oracle9i, you can startup the instance using either an spfile or an init.ora file.

An Oracle9i instance may be started by:
- default spfile --> spfile.ora
- default init.ora file --> init.ora

sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

Oracle first searches if the spfile.ora exists. If it does not, Oracle searchs for the spfile.ora parameter file. If neither spfile.ora nor spfile.ora exist, Oracle will use the init.ora parameter file.

If none of these files exist, you receive the following messages:

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORA901\DATABASE\INITORA901.ORA'

Indira A

Re: DBCA problem

Eric Antunes — Wed, 11 May 2005 04:18:30 GMT

Hi Venkatesh,

If you solved your issue, I recomend you to read this about ITRC forums:

http://forums1.itrc.hp.com/service/forums/helptips.do?#28

PS: no points for me please.

Best Regards,

Antunes

Re: DBCA problem

Venkatesh_10 — Wed, 11 May 2005 05:00:03 GMT

the problem is resolved.
the problem was in improper kernel tuning.
i changed parameters and followd other steps gave.
thanks a lot .