There are plenty of cases where DLP is having trouble connecting to the Oracle Listener where the JDBC or TNS connection string is at fault, the port hasn't been opened, the listener isn't up and so on. Often the notion that the Oracle RDBMS and the Oracle listener are two seperate processes is over looked.
This article provides some guidance on troubleshooting connectivity between RDBMS and the Listener.
1) Make sure that the listener.ora file has the correct information in it.
The two basic elements that need to be present are the hostname and the port number. The hostname must be able to resolve to the server IP. The server IP can be used, as well as, standard loop-back IP (127.0.0.1) or "local host" provided they resolve to the server IP.
2) Database registration with the listener.
The local_listener parameter for a DLP database ought to be set to a '(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=PROTECT)))' if the install/upgrade instructions were properly followed to close a security loophole. If this isn't the case, crack open the "Symantec DLP Oracle 11g Installation Upgrade Guide" and look up 'Configuring the TNS Listener'
Throw caution to the wind and stick the local host info in there:
for example, '(ADDRESS = (PROTOCOL=TCP)(HOST=Myhost)(PORT=1521))'
In either case, to actually SEE whats in there, log into sqlplus as sys as sysdba and:
SQL> show parameter local_listener
If it comes up blank, take the initative and modify it to be either of the above entries. Here's an example:
SQL> alter system set local_listener = '(ADDRESS = (PROTOCOL=TCP)(HOST=Myhost)(PORT=15321))';
THEN do the following:
SQL> alter system register;
This will force the registration of the listener with Oracle.
3) Still, not connecting? Try this:
edit the sqlnet.ora file and change the entry for
if it's set to "NONE" try setting it to "NTS", or vice versa. Either way the listener will require a bounce to load the new setting:
> lsnrctl reload
Imported Document ID: TECH220474
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe