{"id":447,"date":"2009-02-13T11:06:45","date_gmt":"2009-02-13T16:06:45","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=447"},"modified":"2009-02-13T11:08:13","modified_gmt":"2009-02-13T16:08:13","slug":"reinstall-oracle-db","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=447","title":{"rendered":"Reinstall Oracle db"},"content":{"rendered":"<p>Reinstall Oracle db<br \/>\n-$find \/ -name *<sid>*<br \/>\n-delete all files belonging to <sid><br \/>\n-remove <sid> entry in oratab.ora <\/p>\n<p>-use $ORACLE_HOME\/bin\/dbassist to delete database<br \/>\n-if REMOTE_LOGIN_PASSWORDFILE=<br \/>\nexclusive in pfile, use orapwd to recreate password file:<br \/>\norapwd file=\/u01\/app\/oracle\/product\/8.1.5\/dbs\/orapwlimsod1 password=lims entries=30<br \/>\n(none|shared)<br \/>\n-rerun scripts<\/p>\n<p>OR<br \/>\n-delete $ORACLE_BASE\/admin\/<sid> directory<br \/>\n-delete all ctr\/log\/dbf files belonging to <sid><br \/>\n-use dbassist to recreate db scripts<br \/>\n-run db scripts to recreate db<\/p>\n<p>\u00a7Remove Legato<br \/>\n\u2022shutdown all instances<br \/>\n\u2022cd $ORACLE_HOME\/lib<br \/>\nrm libobk.so<br \/>\nrm liblsm.so<br \/>\nln -s libdsbtsh8.so libobk.so<br \/>\n\u2022restart all instances<br \/>\n\u2022log in as root and<br \/>\n\u2022nsm_shutdown<br \/>\n\u2022pkgrm ORCLman ORCLserv ORCLnode ORCLdrvr ORCLclnt<br \/>\n\u2022rm -rf \/nsr\/* \/nsr<\/p>\n<p>\u2022Remove failed Oracle installation<br \/>\n-use universal installer to delete all oracle installations<br \/>\n-remove all files in $ORACLE_HOME<br \/>\n-remove \/var\/opt\/oracle directory<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Reinstall Oracle db -$find \/ -name ** -delete all files belonging to -remove entry in oratab.ora -use $ORACLE_HOME\/bin\/dbassist to delete database -if REMOTE_LOGIN_PASSWORDFILE= exclusive in pfile, use orapwd to recreate password file: orapwd file=\/u01\/app\/oracle\/product\/8.1.5\/dbs\/orapwlimsod1 password=lims entries=30 (none|shared) -rerun scripts OR &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=447\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[35],"tags":[],"class_list":["post-447","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-7d","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=447"}],"version-history":[{"count":3,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/447\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/447\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}