Autoconfig errored out in db tier

Post date: Feb 20, 2010 1:44:58 PM

Autoconfig errored out in 10.2.0.4 database on Linux server. The following is the sample output from adconfig.log.

/oracle/product/10.2.0.4/<SID>/appsutil/install/<SID_hostname>/afdbprf.sh

ERROR:

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

Solution:

Ensure that the following two parameters in the database tier context file match each other.

s_global_database_name

s_dbService

Sometimes this is a source of listener problems.

Also check for the service_name parameter in init.ora. Its value should be SID.Domain_name.

If it is non-RAC database, ensure that the following parameters are disabled in init.ora

local_listener

remote_listener