Tag Archives: TNS Listener

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS

Posted by on July 5, 2012 No comments

Problem:

In R12, after a concurrent request is run and the log file is viewed, when Tools –> Copy File is selected, a browser window opens and displays the following message:

An error occurred while attempting to establish an Applications File Server 
connection with the node FNDFS_. There may be a network configuration problem, 
or the TNS listener on node FNDFS_ may not be running. Please contact your 
system administrator.

Solution:

Set the RRA: Enabled system profile to Yes at the site level, log off and then log back on.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

SQL Developer Vendor Code 17002

Posted by on May 2, 2012 1 comment

Problem:

When connect to an 11i E-Business Suite database using SQL Developer, the following error appears:

An error was encountered performing the requested operation:

IO Error: Connection reset

Vendor code 17002

Sometimes, the error reads:

An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Issuing the tnsping command against the instance returns the following:

C:>tnsping vis3

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:OracleDevSuiteHomenetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain)
(PORT=1524)) (CONNECT_DATA= (SID=VIS3)))
TNS-12537: TNS:connection closed

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.

Solution:

AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:

tcp.validnode_checking = yes
tcp.invited_nodes=(OEL5VIS3.localdomain)

This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.

[amazon asin=1847196268&template=iframe image&chan=default]     [amazon asin=0071484744&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]

ORA-12518: TNS:listener could not hand off client connection

Posted by on March 27, 2012 2 comments

Problem:

Unable to connect to SQL:

F:oracleVIS12dbtech_st11.1.0>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 11:31:04 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection

Solution:

Increase PROCESSES initialization parameter.

Use the following command to check the value of the PROCESSES initialization parameter in SQL*Plus:

show parameter processes

If the database was started using an spfile, then the following command can be used to change the PROCESSES initialization parameter to 500:

alter system set processes=500 scope=spfile;

If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.

[amazon asin=0071780262&template=iframe image&chan=default]     [amazon asin=1565922379&template=iframe image&chan=default]     [amazon asin=1430236620&template=iframe image&chan=default]

netca Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Posted by on August 24, 2011 1 comment

Problem: When configuring the TNS settings using the Oracle Net Configuration Assistant, the follow error appears:

Connecting… ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. The test did not succeed.

Solution: Mismatch between hostnames in tnsnames.ora and listener.ora.

Read more »

R12 Log File Locations

Posted by on November 5, 2009 No comments

Concurrent Manager Log: %APPLCSF%%APPLLOG%

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog

%APPLCSF%%APPLLOG%

%APPLCSF%%APPLOUT%

Application TNS Listener executable:

G:oracleVIS12appstech_st10.1.2BINTNSLSNR

Application TNS Listener config file:

G:oracleVIS12instappsVIS12_appswindows3ora10.1.2networkadminlistener.ora

Location of dbc file (VIS12.dbc):

G:oracleVIS12instappsVIS12_appswindows3applfnd12.0.0secure

Apache Root:

G:oracleVIS12appstech_st10.1.2ApacheApache

adalnctl.sh: exiting with status 127

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the apps listener exits with status 127.

Solution: Apply operating system patch 3830807

Metalink Reference:

Subject:  Attempt To Start Listener Exits With Status 127

Doc ID:  299810.1

ORA-12162: TNS:net service name is incorrectly specified

Posted by on August 30, 2009 No comments

Problem: When attempting to log on to SQL*Plus as ”/ as sysdba’, the following error appears:

ERROR:
ORA-12162: TNS:net service name is incorrectly specified

Solution: Set ORACLE_SID=ORCL

export ORACLE_SID=ORCL

Unable to connect from client machine to new 11.5.10.2 instance

Posted by on December 12, 2008 No comments

Problem:

After configuring TNS names on the client, tried to connect to new 11.5.10.2 instance but failed.

Solution:

Managed SQL Access enabled. To disable, follow these steps:

Step 1:        Login to E-Business Suite with the ‘System Administrator’ Responsibility.

Step 2:        Go to : Profile –> System

Step 3:        Query the Profile “SQLNet Access’ at Site Level.

Step 4:        Set the Profile with the Value : ALLOW_ALL

Step 5:        Save and Exit Oracle Applications

Step 6:        Run Autoconfig on the 9i ORACLE_HOME

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

adautocfg.sh

Step 7:        Bounce the 9i SQLNet Listener :

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

addlnctl.sh stop <SID>

addlnctl.sh start <SID>

Metalink Reference:

Subject:  11.5.10 New Features : Managed SQL*Net Access from Hosts

Doc ID:  Note:291897.1

ServiceAliasException: Could not initialize Service Alias: TNS-04404

Posted by on October 17, 2008 No comments

Problem:

After installing Oracle Database 10g (10.2.0.1) and upgrading it to 10.2.0.2, the listener service was not created. When attempting to create using netca (from the Command Prompt), the following error appears:

ServiceAliasException: Could not initialize Service Alias: TNS-04404

Solution:

In the C:oracleproduct10.2.0db_1networkADMIN directory, rename the listener.ora, sqlnet.ora and tnsnames.ora to listener.ora.bak, sqlnet.ora.bak and tnsnames.ora.bak.

Then rerun netca (Net Configuration Assistant) to recreate the sqlnet.ora (second option on the menu), listener.ora (first option) and tnsnames.ora (third option).

After exiting netca, start the listener by issuing the command ‘lsnrctl start’.

TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Posted by on September 22, 2008 No comments

Problem:

When running AutoConfig, it fails at 50% with the following error:

ERROR

ORA-12224: TNS:no listener

Solution:

Run the following, and then restart AutoConfig.

perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem

Reference:

Subject:  TNS Connectivity With Database Breaks After Running Autoconfig

Doc ID:  Note:377764.1

1020  unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

1021  . /u0/oracle/testappl/APPSTEST_ebusinesstest.env

1022  cd /u0/oracle/testora/iAS/appsoui/setup/

1023  perl OUIsetup.pl

1024  perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem

1025  cd /u0/oracle/testcomn/clone/bin/

1026  perl adcfgclone.pl appsTier