Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
ORA-12541: TNS:no listener 12541. 00000 - "TNS:no listener" *Cause: The connection request could not be completed because the listener is not running. *Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine. Vendor code 12541
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl.mycompany.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) AS400 = (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=orcl.mycompany.com)(port=1521)) (CONNECT_DATA = (SID = AS400) ) (HS=OK) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = orcl.mycompany.com)(PORT = 1521)) ) ) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=AS400) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe) (PROGRAM=dg4odbc) (ENVS=LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib:/opt/ibm/iSeriesAccess/lib) ) ) LISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=orcl.mycompany.com)(PORT= 1521)) ) DEFAULT_SERVICE_LISTENER = (XE)
[root@orcl admin]# cat /etc/odbc.ini [AS400] Description = iSeries Access ODBC Driver Driver = iSeries Access ODBC Driver System = 192.168.3.5 UserID = username Password = userpass Naming = 0 DefaultLibraries = RAPFILE Database = ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 1 DefaultPkgLibrary = QGPL DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar = 0 ForceTranslation = 0 Trace = 1 DSN = AS400
[iSeries Access ODBC Driver] Description = iSeries Access for Linux ODBC Driver Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so NOTE1 = If using unixODBC 2.2.11 or later and you want the 32 and 64-bit ODBC drivers to share DSN's, NOTE2 = the following Driver64/Setup64 keywords will provide that support. Driver64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so Threading = 2 DontDLClose = 1 UsageCount = 1 [iSeries Access ODBC Driver 64-bit] Description = iSeries Access for Linux 64-bit ODBC Driver Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so Threading = 2 DontDLClose = 1 UsageCount = 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Trying connecting to SQL server 2016 from sql developer using Third Party JDBC Drivers,||2||46|
|having some issue on pl sql procedure||1||41|
|oracle spooling query into csv eliminating new line character||9||52|
|Oracle Date add||9||28|
Join the community of 500,000 technology professionals and ask your questions.