In Oracle Applications 11.5.10, there is a security feature which prevents users from logging on to the database using SQL tools such as SQL*Plus or TOAD. Refer to Note: 291897.1 (11.5.10 New Features: Managed SQL*Net Access from Hosts) for information on resolving this problem.

To get information pertaining to the host, log on to Oracle Applications Manager, click on Site Map, Administration, and then Hosts. Click the Show link to see the host name, domain and IP address. To determine the port numbers associated with the instance, click View Configuration.

All information is available to place entries into the TNSNAMES.ORA.

NEWTEST = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1521))
                (CONNECT_DATA=(SID=PROD))
            )
FNDFS_ORACLESERVER=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )