{"id":179,"date":"2009-12-30T16:55:48","date_gmt":"2009-12-30T16:55:48","guid":{"rendered":"http:\/\/www.muratyaman.co.uk\/wp\/?p=179"},"modified":"2020-04-01T12:45:14","modified_gmt":"2020-04-01T11:45:14","slug":"emergency-check-on-command-line-for-oracle-xe","status":"publish","type":"post","link":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/2009\/12\/emergency-check-on-command-line-for-oracle-xe\/","title":{"rendered":"Emergency check on command-line for Oracle XE"},"content":{"rendered":"<p>Go to your Oracle binaries folder and export environment variables, if they are not set already. Then, run SQL*Plus command line utility with option <strong>\/nolog<\/strong> .<\/p>\n<pre lang=\"bash\">\r\n[root@localhost \/]# cd \/usr\/lib\/oracle\/xe\/app\/oracle\/product\/10.2.0\/server\/bin\/\r\n\r\n[root@localhost bin]#. .\/oracle_env.sh\r\n\r\n[root@localhost bin]# sqlplus \/nolog\r\n\r\nSQL> connect myuser\/mypassword@localhost\/xe\r\n\r\nConnected.\r\n\r\nSQL> select count(*) as c from mytablespace.mytable\r\n  2    \/\r\n         C\r\n----------\r\n       123\r\n<\/pre>\n<p>I hope this helps some beginners.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go to your Oracle binaries folder and export environment variables, if they are not set already.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[126,38,33],"class_list":["post-179","post","type-post","status-publish","format-standard","hentry","category-technology","tag-linux","tag-oracle","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":7,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":960,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/179\/revisions\/960"}],"wp:attachment":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}