I spent quite a time searching for a way to restart an oracle server yesterday… without being root.
For the record, here is what I did:
Start the listener:
/home/ORACLE/product/9.2.0/bin/lsnrctl start |
Start the instance:
sqlplus /nolog SQL> conn /AS sysdba Connected to an idle instance. SQL> startup ORACLE instance started. |
I checked that it runs via :
ps -ef |grep smon myUser 25942 1 0 16:24:48 ? 0:00 ora_smon_NAMEOFTABLESPACE myUser 26297 9609 0 16:31:14 pts/4 0:00 grep smon |