Oracle 9 restart on solaris

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.