permission problem

[Former Member]

i have a problem that;

ORA-01034: ORACLE not available

ORA-27121 unable to determine size of shared memory segment

Error :13: Permission denied.

thanks in advance

ferhan

[Former Member]

Hi

Check the Environment variables :

ORACLE_SID

ORACLE_HOME

ORACLE_BASE LD_LIBRARY_PATH etc.

All of these should be set in order to bring Oracle DB.

Regards

Chandra

[Former Member]

i set them and these are true.

[Former Member]

Is is unix system? if yes

check the permisions of ORACLE_HOME/bin/oracle

you can do chmod 6751 $ORACLE_HOME/bin/oracle

Edited by: Chandra B. on Aug 8, 2009 2:41 PM

[Former Member]

i set 777

my friend said maybe sap trans? wha's sap trans?

ferhan

[Former Member]

trans is a folder, it is having all customized and workbench request with datas and cos,

are u able login to sql now?

[Former Member]

i was login but i run the startsap that startdb failed.

[Former Member]

post here trace files

[Former Member]

after my friend upgrade kernell on system(aix), i have a error on db ....

then hi resolved that. but i don't no how to resolved that.

thanks for advinced.

ferhan

[Former Member]

it may be the listener problem, but if see the logs we can tell that what exact issue

[Former Member]

which logs?

[Former Member]

\oracle\<SID>\saptrace\background\alert_<SID>.log

[anindya_bose]

Hi Ferhan

https://service.sap.com/sap/support/notes/583861 might help you. Check the note , analyse the error message,you will be able to solve the problem

Best of Luck

[fidel_vales]

>

> i set 777 
> my friend said maybe sap trans? wha's sap trans?
> 
> ferhan

I join late the conversation, but as usual I do have a "nice" question.

Chandra B told you to set $ORACLE_HOME/bin/oracle authorizations to 6751.

And you simply ignore the advice and you set it to 777, that is plain worng.

If you are not going to

1) search for SAP notes

2) search for other forum entries

3) follow the advices that are given by other people in the forum

then, why you ask?

Not only that, looking at that actitude, other people can think it is not worth to help YOU and/or help others, therefore the quality of the responses can decrease.

If the authorizations of the oracle binarie are wrong, you can start the DB with ora<sid> or <sid>adm, but afterwards the other user does NOT have authorizations to connect to the shared memory already allocated.

Please, follow the recommendation that Chandra B gave you. This recommendation is based on the SAP Note 583861 - UNIX: Errors due to Oracle executable.

This is the ONLY note that is returned if you search for the ERROR you provided in your Original post. Also gaven by Anindya Bose.

I hope that, with all those indications (3 different people telling you to do the same) you will do it.

I also hope that you learn how to use the note search from SAP (http://service.sap.com/notes)

I also hope that you learn how to use the search in the community network (you know, that white rectangle that appears on the top right of this page)

[Former Member]

i update the oras' patch for the upgrade's kernel... and the system is normal.

thanks a lot of all.

ferhan