{"id":1018,"date":"2012-08-15T15:43:17","date_gmt":"2012-08-15T07:43:17","guid":{"rendered":"http:\/\/rmohan.com\/?p=1018"},"modified":"2012-08-15T15:43:17","modified_gmt":"2012-08-15T07:43:17","slug":"how-to-install-oracle-db-client","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=1018","title":{"rendered":"How to install Oracle DB Client"},"content":{"rendered":"<div><strong>Installing Oracle database Client to access DB<\/strong><\/div>\n<div><\/div>\n<div>Either you can use sqldeveloper as oracle client or you can execute it from the command line using # sqlplus<\/div>\n<div><\/div>\n<div>\u00a0We can access oracle server graphically by using a package called sqldeveloper.<\/div>\n<div>sqldeveloper-2.1.1.64.45-1.noarch.rpm<\/div>\n<h3>\n# rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm<\/h3>\n<div>if the front end not getting install the jdk package and try&#8230;<\/div>\n<div><\/div>\n<div># or install jdk on root and put the package in user account and run the .\/sqldeveloper.sh from user account. if it shows any permission problem give 777 permission for .sh file and install and tell the jdk installed path while asking. Also included path in \/etc\/profile and if needed add it in .bashrc file<\/div>\n<h3>\nFrom the console we can use a Client called sqlplus<\/p>\n<p>$ sqlplus \/nolog\u00a0 &#8212;&#8211; It starts sqlplus without logging in to a database.<\/p>\n<p>$ connect \/ as sysdba \u00a0 &#8212;&#8212; Connecting as an administrative user,No password is required. This is equivalent to the desupported &#8220;connect internal&#8221; method.<\/p>\n<p>$ sqlplus -s \/nolog &#8212;&#8212;&#8212;&#8211; Sets silent mode which suppresses the display of the SQL*Plus banner, prompts, and echoing of commands.<\/h3>\n<div><\/div>\n<div>\u00a0$ SQLPLUS [ { username[\/passward][@connect_identifier] | \/ } [ AS { SYSDBA | SYSOPER } ] | \/NOLOG ]<\/p>\n<p>\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_1\/network\/admin\/tnsnames.ora ( In this path we are defining the connect_identifier, Using connect<\/p><\/div>\n<h3><\/h3>\n<div>using identifier we can access the db and tables of another system. To do so define the hostname,port,connect_identifier etc in tnsnames.ora file(copy the contents and edit the files)<\/div>\n<div><\/div>\n<div>$ sqlplus system\/oracle@pfdb (connect_identifier)<\/div>\n<div>we can connect to remote machine using this OR We can give the remote machine details in<\/div>\n<div>tnsnames.ora, else connect using ipaddress and port\/ We can give any connect_identifier name.<\/div>\n<div><\/div>\n<div>$ sqlplus system\/oracle@orcl &#8212;&#8212; Give the connection details in tnsnames.ora<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Installing Oracle database Client to access DB Either you can use sqldeveloper as oracle client or you can execute it from the command line using # sqlplus We can access oracle server graphically by using a package called sqldeveloper. sqldeveloper-2.1.1.64.45-1.noarch.rpm # rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm if the front end not getting install the jdk package and [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1018"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1018"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions\/1019"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}