stopdb is not working

[Former Member]

Dear Experts,

one quick help.I am having a strange error..for my sidadm, Oracle is not available..as a result of which stopdb is not working throwing errors.I can shut DB from orasid using sqlplus in a normal way..in log file of stopdb its showing here oracle not available..please guide me..I gave full access to $ORACLE_HOME/bin/oracle..still same thing..

[former_member603052]

Hi,

You can stop database by using the command below

STOPSAP DB but you need to login with orasid user since this is related to db sidadm cant be used.

In Windows,there is no orasid user and both done by sidadm only.

Hope this helps you.

Regards,

Kalyan

[Former Member]

Hi,

Your $ORACLE_HOME/bin/oracle should have -rwsr-s--x permission. If not you can change it using chmod 6751 oracle.

Also check R3trans -d able to connect DB.

Regards,

Sachin Rane.

[Former Member]

Can sid<adm> run sqlplus?

Check the following:

Assuming you're Oracle:

NLS_LANG

ORA_NLS33.

Make sure they match for sidadm what they do for orasid.

Also, check the OPS$SAP<SID>.SAPUSER table and make sure the userid and password are populated.

If not, or if they are wrong, just put them in in plain text. They will be encrypted at next login.

[JPReyes]

I don't get you... if oracle is not available most likely is stopped already.... also, to stop oracle database from OS you should use "stopsap DB" from <sid>adm or in the case of windows you can use the MMC....

Can you please describe your scenario?

Regards

Juan

[former_member603052]

Hi,

What is your OS?

Regards,

Kalyan