{"id":345,"date":"2016-02-11T20:12:39","date_gmt":"2016-02-11T14:42:39","guid":{"rendered":"http:\/\/www.middlewareprimer.com\/blog\/?p=345"},"modified":"2016-02-11T20:12:39","modified_gmt":"2016-02-11T14:42:39","slug":"dbping-utiity-in-weblogicserver","status":"publish","type":"post","link":"http:\/\/www.middlewareprimer.com\/blog\/2016\/02\/11\/dbping-utiity-in-weblogicserver\/","title":{"rendered":"DBPing Utility In Weblogic Server"},"content":{"rendered":"<p>DBPing Utility In Weblogic Server,<\/p>\n<p>The dbping command-line utility tests the connection between a DBMS and your client machine via a JDBC driver.<\/p>\n<p><strong><u>Syntax<\/u><\/strong><\/p>\n<p>$ java utils.dbping ORACLE_THIN USERNAME PASSWORD IP:PORT:SID<\/p>\n<p><strong><u>Example<\/u><\/strong><\/p>\n<p>[oracle@oracle ~]$ bin<br \/>\n[oracle@oracle bin]$ pwd<br \/>\n\/&lt;user_projects&gt;\/domains\/basedomain\/bin<br \/>\n[oracle@oracle bin]$ ll<br \/>\ntotal 2.1M<br \/>\ndrwxr-x&#8212; 2 oracle oracle 1.0K Jul 20 02:17 nodemanager<br \/>\ndrwxr-x&#8212; 2 oracle oracle 80 Jul 20 02:17 server_migration<br \/>\ndrwxr-x&#8212; 2 oracle oracle 80 Jul 20 02:17 service_migration<br \/>\n-rwxr-x&#8212; 1 oracle oracle 2.0K Jul 20 02:17 secureWebLogic.sh<br \/>\n-rwxr-x&#8212; 1 oracle oracle 2.0K Jul 20 02:17 stopWebLogic.sh<br \/>\n-rwxr-x&#8212; 1 oracle oracle 3.2K Jul 20 02:17 startManagedWebLogic.sh<br \/>\n-rwxr-x&#8212; 1 oracle oracle 2.4K Jul 20 02:17 stopManagedWebLogic.sh<br \/>\n-rwxr-x&#8212; 1 oracle oracle 17K Jul 20 02:17 setDomainEnv.sh<br \/>\n-rwxr-x&#8212; 1 oracle oracle 5.7K Jul 20 02:17 startWebLogic.sh<br \/>\n-rw&#8212;&#8212;- 1 oracle oracle 686K Aug 7 02:25 nohup.out<br \/>\n[oracle@oracle bin]$ . .\/setDomainEnv.sh<br \/>\n[oracle@oracle basedomain]$ java utils.dbping ORACLE_THIN PRD_IPM PRD_IPM <strong>&lt;DB IP&gt;<\/strong>:1521\/xe<\/p>\n<p><strong><u>OUTPUT<\/u><\/strong><\/p>\n<p>**** Success!!! ****<\/p>\n<p>You can connect to the database in your app using:<\/p>\n<p>java.util.Properties props = new java.util.Properties();<br \/>\nprops.put(&#8220;user&#8221;, &#8220;PRD_IPM&#8221;);<br \/>\nprops.put(&#8220;password&#8221;, &#8220;PRD_IPM&#8221;);<br \/>\njava.sql.Driver d =<br \/>\nClass.forName(&#8220;oracle.jdbc.OracleDriver&#8221;).newInstance();<br \/>\njava.sql.Connection conn =<br \/>\nDriver.connect(&#8220;jdbc:oracle:thin:@&lt;DB IP&gt;:1521\/xe&#8221;, props);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBPing Utility In Weblogic Server, The dbping command-line utility tests the connection between a DBMS and your client machine via a JDBC driver. Syntax $ java utils.dbping ORACLE_THIN USERNAME PASSWORD IP:PORT:SID Example [oracle@oracle ~]$ bin [oracle@oracle bin]$ pwd \/&lt;user_projects&gt;\/domains\/basedomain\/bin [oracle@oracle bin]$ ll total 2.1M drwxr-x&#8212; 2 oracle oracle 1.0K Jul 20 02:17 nodemanager drwxr-x&#8212; 2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[99],"tags":[103,102],"class_list":["post-345","post","type-post","status-publish","format-standard","hentry","category-weblogic","tag-dbping","tag-weblogic"],"_links":{"self":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":3,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/345\/revisions"}],"predecessor-version":[{"id":417,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/345\/revisions\/417"}],"wp:attachment":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/media?parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/categories?post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/tags?post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}