{"id":42,"date":"2009-01-06T13:15:29","date_gmt":"2009-01-06T11:15:29","guid":{"rendered":"http:\/\/demeringo.ovh.org\/blog\/?p=42"},"modified":"2009-01-06T13:15:29","modified_gmt":"2009-01-06T11:15:29","slug":"oracle-9-restart-on-solaris","status":"publish","type":"post","link":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/?p=42","title":{"rendered":"Oracle 9 restart on solaris"},"content":{"rendered":"<p>I spent quite a time searching for a way to restart an oracle server yesterday&#8230; without being root.<\/p>\n<p>For the record, here is what I did:<\/p>\n<p><strong>Start the listener:<\/strong><\/p>\n<pre lang=\"BASH\">\/home\/ORACLE\/product\/9.2.0\/bin\/lsnrctl start<\/pre>\n<p><strong>Start the instance:<\/strong><\/p>\n<pre lang=\"BASH\">sqlplus \/nolog\nSQL&gt; conn \/AS sysdba\nConnected to an idle instance.\nSQL&gt; startup\nORACLE instance started.<\/pre>\n<p>I checked that it runs via :<\/p>\n<pre lang=\"BASH\">ps -ef |grep smon\nmyUser 25942\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 16:24:48 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0:00 ora_smon_NAMEOFTABLESPACE\nmyUser 26297\u00a0 9609\u00a0 0 16:31:14 pts\/4\u00a0\u00a0\u00a0 0:00 grep smon<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>I spent quite a time searching for a way to restart an oracle server yesterday&#8230; 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&gt; conn \/AS sysdba Connected to an idle instance. SQL&gt; startup ORACLE instance started. I checked that it runs &hellip; <a href=\"https:\/\/le-moulin-de-verre.com\/fieldnotes\/?p=42\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Oracle 9 restart on solaris&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[14],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5WcEf-G","_links":{"self":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/42"}],"collection":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=42"}],"version-history":[{"count":0,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/42\/revisions"}],"wp:attachment":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}