cancel
Showing results for 
Search instead for 
Did you mean: 

DBCA problem

Venkatesh_10
Occasional Advisor

DBCA problem

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.
7 REPLIES
Robert-Jan Goossens_1
Honored Contributor
Jean-Luc Oudart
Honored Contributor

Re: DBCA problem

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
fiat lux
Indira Aramandla
Honored Contributor

Re: DBCA problem

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
Never give up, Keep Trying
Venkatesh_10
Occasional Advisor

Re: DBCA problem

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
Honored Contributor

Re: DBCA problem

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
Never give up, Keep Trying
Eric Antunes
Honored Contributor

Re: DBCA problem

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
Each and every day is a good day to learn.
Venkatesh_10
Occasional Advisor

Re: DBCA problem

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