{"id":2296,"date":"2013-07-12T16:30:58","date_gmt":"2013-07-12T08:30:58","guid":{"rendered":"http:\/\/rmohan.com\/?p=2296"},"modified":"2013-07-12T16:30:58","modified_gmt":"2013-07-12T08:30:58","slug":"how-to-install-oracle-db-client-2","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2296","title":{"rendered":"How to install Oracle DB Client"},"content":{"rendered":"<div>Installing Oracle database Client to access DB<\/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<p># rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm<\/p>\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<p>From the console we can use a Client called\u00a0sqlplus<\/p>\n<p>$ sqlplus \/nolog\u00a0\u00a0&#8212;&#8211; It starts sqlplus without logging in to a database.<\/p>\n<p>$ connect \/ as sysdba\u00a0\u00a0\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\u00a0&#8212;&#8212;&#8212;&#8211; Sets silent mode which suppresses the display of the SQL*Plus banner, prompts, and echoing of commands.<\/p>\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<p>&nbsp;<\/p>\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\u00a0&#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 <\/p>\n<p># rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm<\/p>\n<p> 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\/2296"}],"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=2296"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2296\/revisions"}],"predecessor-version":[{"id":2298,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2296\/revisions\/2298"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}