Link to home
Start Free TrialLog in
Avatar of HKDev
HKDev

asked on

Oracle 10g Remote Reolocation issues - TNS Listner

I have just had to move a windows server to a collocated location and am having problems connecting to the Oracle 10g Database on that machine remotely from my development machine via SQL plus or OEM.

Error: TNS-12541: TNS:no listener

Pinging the remote database machine from my development machine is successful
TNSPing shows the no listener error
local tnsping behind firewall results "OK (10 msec)"

I have changed the tnsnames.ora to contain the new ip number on my development machine and opened the remote firewall for the port I am using.

Do I need to also update ora files on the Remote Database machine.

The remote setup is up and running fine with all connections to the Database fine in that location. (ie behind the firewall and on the local network)...

Currently:

Dev Machine (location 1) tnsnames.ora

BCS.GORDON =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ***.***.***.***)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bcs.gordon)
    )
  )

Remote Database (location 2) listener.ora

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER_GORDON =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = gordon)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

SID_LIST_LISTENER_GORDON =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )


Remote Database (location 2) tnsnames.ora

BCS.GORDON =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Gordon)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bcs.gordon)
    )
  )


Any guidance would be appreciated
Avatar of Qlemo
Qlemo
Flag of Germany image

Try to use (SID=bcs.gordon) instead of the service name in your local tnsnames.ora. If that helps, it is a global name or domain issue. You can try to disable NTS auth in remote sqlnet.ora, so no additional domain parts are added to the service name by Oracle.
 
BTW: With EasyConnect you can write a much more simple connection description as user/pwd@server/instance
Avatar of HKDev
HKDev

ASKER

Thanks for the reply. Is this what you mean for my local dev machine?

Dev Machine (location 1) tnsnames.ora

BCS.GORDON =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ***.***.***.***)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = bcs.gordon)
    )
  )
Avatar of HKDev

ASKER

I tried this with no success. Still the same error.

C:\Documents and Settings\ChrisL>sqlplus "sys@bcs.gordon/***** as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 4 16:24:16 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-12541: TNS:no listener
Enter user-name:
sqlplus sys@******/bcs.gordon

Avatar of HKDev

ASKER

Still no luck.

I cannot ping my Dev machine from the oracle machine? but I can ping the oracle machien from my dev machine.

What ports would need to be open on both firewalls ?
Avatar of HKDev

ASKER

I have attached a diagram to try and help explain the situation a little more.

OracleSetup.jpg
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial