Skip to Content
avatar image
Former Member

Stop Oracle under Solaris (SQLPLUS)

Hello!

I would like to stop the Oracle DB.

I get the following error:

Connected to an idle instance.

alter system switch logfile

*

ERROR at line 1:

ORA-01034: ORACLE not available

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment

SVR4 Error: 13: Permission denied

Disconnected

With wich user (ora<SID>, <sid>adm) should I log on onto the Operating system and what are the commandos to execute for stopping db?

If I execute

>sqlplus /nolog

I get the error

sqlplus command not found

If I try to execute the stopdb command from

<b>/usr/sap/<SID>/SYS/exe/run/stopdb</b>

I get the error

<b>permission denied

Cannot find executable sqlplus</b>

Thank you very much!

regards

Thom

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 28, 2007 at 11:55 AM

    hello,

    the database is maybe not up. You can startup database e.g. like that

    ora<sid>

    sqlplus /nolog

    SQL> connect / as sysdba

    Connected to an idle instance (if the database is not up or the environments are not set)

    SQLL> startup;

    You can stop database e.g. like that:

    sqlplus /nolog

    SQL> connect / as sysdba

    SQL> shutdown immediate;

    Maybe your environment settings are not set correct. You can start and stop the database with <sid>adm and ora<sid> users, if they belong to dba group and environment settings are set, like ORACLE_SID, ORACLE_HOME and PATH:$ORACLE_HOME/bin etc...

    best regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2007 at 12:37 PM

    if the database is down, you can't execute this command

    alter system switch logfile

    Please check if the database is up and which status the database has after setting environments.

    ps -ef | grep ora_ | grep <b><sid</b>> (<i>on UNIX</i>)

    select status from v$instance

    Add comment
    10|10000 characters needed characters exceeded