title: How to access Oracle database over network?
body: <p>I am trying to accessing my Oracle database over Network. I have Google a lot and found many solutions, but those doesn't work for me.</p>
  
  <blockquote>
    <p>The problem is that, I want to access my Oracle Database from One Computer to another Computer over my Local Network.</p>
  </blockquote>
  
  <p>What I did is....</p>
  
  <ol>
  <li>I found a Solution to modify <strong>listener.ora</strong> file with </li>
  </ol>
  
  <p><code>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbp.devProject.com)(PORT=1521)))</code></p>
  
  <p>When I modify this file and tried to run and access the Database nothing will happens, and it throws an Error, the port number you have specified is used by another listener, so i have changed port Number but I am not able to access Database.
  2. I have configure a new listener with the help of oracle's tool <strong>Net Manager</strong>, which made a Listener for me, but it does not make accessible database over Network.</p>
  
  <p>Here Some required results.</p>
  
  <blockquote>
    <ol>
    <li><strong>lsnrctl status</strong> : Listener using listener name LISTENER has already been started.</li>
    <li><strong>Connection String</strong> : jdbc:oracle:thin:@dbp.devProject.com:4541:myDB</li>
    <li><strong>Database Version</strong> : 
    <ol>
    <li>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</li>
    <li>PL/SQL Release 11.2.0.1.0 - Production</li>
    <li>CORE 11.2.0.1.0  Production</li>
    <li>TNS for 64-bit Windows: Version 11.2.0.1.0 - Production</li>
    <li>NLSRTL Version 11.2.0.1.0 - Production</li>
    </ol></li>
    </ol>
  </blockquote>
  
  <p>status shows me this. </p>
  
  <blockquote>
    <p>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))</p>
    
    <p>STATUS of the LISTENER</p>
    
    <p>Alias :                     LISTENER</p>
    
    <p>Version :                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production</p>
    
    <p>Start Date :                14-MAY-2015 11:58:05</p>
    
    <p>Uptime :                    0 days 2 hr. 29 min. 50 sec</p>
    
    <p>Trace Level :               off</p>
    
    <p>Security :                  ON: Local OS Authentication</p>
    
    <p>SNMP :                      OFF</p>
    
    <p>Listener Parameter File :   product\11.2.0\dbhome_1\network\admin\listener.ora</p>
    
    <p>Listener Log File :         \listener\alert\log.xml</p>
    
    <p>Listening Endpoints Summary...</p>
  </blockquote>
  
  <pre><code>1. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  2. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  </code></pre>
  
  <p>Someone please Help me. 
  Thanks for your Help..</p>