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

 Dear Folks,

We have experienced an issue connecting to apps user and getting following error.

NONPROD [*****@servername ~]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jun 29 07:56:15 2021

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

ERROR:

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

descriptor

======

Checked and found service ebs_klqbi missed while checking status of listener.

NONPROD [******@servername ~]$ lsnrctl status $ORACLE_SID

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-JUN-2021 08:27:40

Copyright (c) 1991, 2020, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servername.domain.tcs)(PORT=1551)))

STATUS of the LISTENER

  Instance "******", status READY, has 1 handler(s) for this service...

The command completed successfully

NONPROD [********@servername ~]$

 ===========

Fix

SQL> Alter session set container=*****;

Session altered.

SQL> BEGIN

DBMS_SERVICE.start_service(service_name => 'ebs_*****');

END;

/ 2 3 4

PL/SQL procedure successfully completed.

Now we are able to connect to apps user.

Thanks.

 

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

 Dear Followers.

        We have the below error when we ran auto-config on the database tier. 

Error from AC log file

+++++++++++++++++

Updating s_tnsmode to 'generateTNS'

UpdateContext exited with status: 0

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates

Instantiating Tools tnsnames.ora

Tools tnsnames.ora instantiated

Web tnsnames.ora instantiated

adgentns.pl exiting with status 2

ERRORCODE = 2 ERRORCODE_END

.end std out.

   Result             : FAILED

Enter value for 1: Enter value for 2: ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Unable to generate listener.ora from database

Using default listener.ora file

.end std out.

.end err out.

Error while generating listener.ora.

StackTrace:

java.lang.Exception: Error while generating listener.ora.

        at oracle.apps.ad.tools.configuration.NetServiceHandler.generateMiddleTierListener(NetServiceHandler.java:2497) 

 

Fix

==

Ran manually

NONPROD [*****@korladrekbs01 admin]$ perl  /u01/app/***/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl contextfile=$CONTEXT_FILE appspass=apps

=====================================================================================================================

Then Run AC. It should be fine.

Thanks.

ERROR: ORA-01804: failure to initialize timezone information - AUTOCONFIG

 Dear Folks.

Recently we have encountered an issue with auto-config on the database node (19c) that failed with the below error.

ERROR: ORA-01804: failure to initialize timezone information

SP2-0152: ORACLE may not be functioning properly

ERRORCODE = 1 ERRORCODE_END

Fix

==

NONPROD [*******@korladrekbs01 19.3.0]$ unset ORA_TZFILE

Change in below template file to point to correct timezone file and run auto-config.

NONPRD [****@korladrekbs01 zoneinfo]$ diff /u01/app/****/db/tech_st/19.3.0/appsutil/template/ad8idbux.env /u01/app/***/db/tech_st/19.3.0/appsutil/template/ad8idbux.env_old

140c140

<      ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg_32.dat"

---

>      ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"