DBCA problem

[Venkatesh_10]

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.

[Robert-Jan Goossens_1]

Check this thread.

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

Robert-Jan

[Jean-Luc Oudart]

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

[Indira Aramandla]

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

[Venkatesh_10]

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.

[Indira Aramandla]

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

[Eric Antunes]

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

[Venkatesh_10]

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