{"id":178,"date":"2011-10-08T22:37:16","date_gmt":"2011-10-08T19:37:16","guid":{"rendered":"http:\/\/fatihacar.com\/blog\/?p=178"},"modified":"2011-10-08T22:55:19","modified_gmt":"2011-10-08T19:55:19","slug":"locations-of-critical-important-files-in-oracle","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/locations-of-critical-important-files-in-oracle\/","title":{"rendered":"Locations of Critical (important) Files in Oracle"},"content":{"rendered":"<p><strong>SPFILE<\/strong><\/p>\n<blockquote><p>\non filesystems<br \/>\nYou can find spfile location with show parameter command.<br \/>\nSQL>show parameter spfile;<br \/>\nSpfile generally holds in \\u01\\app\\oracle\\product\\10.2.0\\dbhome_1\\dbs\\spfileorcl.ora on filesystems.<\/p>\n<p>on ASM<br \/>\nSQL>show parameter spfile;<br \/>\n+DATA\\orcl\\spfileorcl.ora\n<\/p><\/blockquote>\n<p><strong>CONTROLFILE<\/strong><\/p>\n<blockquote><p>\non filesystem<br \/>\nYou can find controlfile location with show parameter command.<br \/>\nSQL>show parameter control_files;<br \/>\nControlFile generally holds in \\u01\\app\\oracle\\product\\10.2.0\\oradata\\orcl\\control01.ctl on filesystems.<br \/>\nOracle has three control file on filesystem.<\/p>\n<p>on ASM<br \/>\nSQL>show parameter control_files;<br \/>\n+DATA\\orcl\\spfileorcl.ora<br \/>\n+FRA\\orcl\\control\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>SPFILE on filesystems You can find spfile location with show parameter command. SQL>show parameter spfile; Spfile generally holds in \\u01\\app\\oracle\\product\\10.2.0\\dbhome_1\\dbs\\spfileorcl.ora on filesystems. on ASM SQL>show parameter spfile; +DATA\\orcl\\spfileorcl.ora CONTROLFILE on filesystem You can find controlfile location with show parameter command. SQL>show parameter control_files; ControlFile generally holds in \\u01\\app\\oracle\\product\\10.2.0\\oradata\\orcl\\control01.ctl on filesystems. Oracle has three control file&#8230;<\/p>\n","protected":false},"author":37,"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_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[14,90],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-administration","tag-database-administration","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-2S","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=178"}],"version-history":[{"count":3,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":180,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/178\/revisions\/180"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}