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\d b_1\networ k\admin\li stener.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\d b_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\d b_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
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\d
# 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\d
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\d
(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
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
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)
)
)
Dev Machine (location 1) tnsnames.ora
BCS.GORDON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ***.***.***.***)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bcs.gordon)
)
)
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:
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
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 ?
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 ?
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.