Skip to Content
author's profile photo Former Member
Former Member

stopdb is not working

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..

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Feb 25, 2009 at 06:29 AM

    Hi,

    What is your OS?

    Regards,

    Kalyan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2009 at 10:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 03:31 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 11:12 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2009 at 07:15 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.