on 09-28-2007 12:41 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.