Thursday, September 23, 2010

Autoconfig errored out in db tier

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

No comments:

Post a Comment