cancel
Showing results for 
Search instead for 
Did you mean: 

Stop Oracle under Solaris (SQLPLUS)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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