Oracle DB start failed

[Former Member]

Hi, Gurus,

I can't start my database from user devadm. I got error Terminating with error code 12. I read forums, but i didn't find solution. My database is Oracle and OS HP-UX.

And other problem, that i noticed i can't manualy start database from sqlplus

my steps:

1. su - oradev

2. sqlplus /nolog

3. connect /as sysdba

4. startup

error ORA-27121: unable to determine size of shared memory

HPUX-ia64 Error 13: Permission denied.

It seems that problem is with HP-UX permissions, but i can't find where.

I tried R3trans -x and i saw error with in trans.log file

ERROR=>connect failed with sql error '1034'

Please help me.

[Former Member]

Thank's all, i solved this question by adding perrmissions 6751

for bin files.

ORACLE/DEV/102_64/bin files perrmissions 6751

[Former Member]

Hi,

With respect to the Ora error 27121. may be you need the check the permissions in the segment level. Or contact oracle support mentioning the Ora error.

With regards

Sudha

[former_member204746]

add user devadm to the dba group.

you can do this by modifying file /etc/group or doing this through SAM.

[Former Member]

Any hanging shared memory processes could be the issue. You could ipcm to remove them. Some times reboot would be the only alternative.

[markus_doehr2]

Please check your oracle alert<SID>.log.

Was the database running before? What did you do prior to that error?

Markus

[Former Member]

I restored database from full offline backup.

[Former Member]

After this restore i got the same error. Terminating with error code 12.

[markus_doehr2]

What is in your Oracle alert log? Do you have the IPC kernel parameters for HP-UX set?

Markus

[Former Member]

Alert_DEV.log

Sun Jan 27 13:36:20 2008

Shutting down instance (abort)

Early this database worked, she stoped after i restored from backup.

[Former Member]

Hi,

Try to find out whether there are any shared memory segement still allocated to oracle instance? You can use "ipcm" to find out.

Regards,

Abhishek Thota