apps-fnd-01564 oracle error 1653 in summit others

CAUSE:

Typically occurs when writing a new record to oracle database, but there is not enough space to write it. The data file in oracle tablespace called APPS_TS_TX_DATA should be set to AUTOEXTEND. If it is not, Oracle will not auto-increase the size of the datafile, and will raise the above error.

SOLUTION:

If all the reports end in COMPLETE – NORMAL, means its work.

If not than follow below steps.

 Run a Concurrent Manager Recovery

1. Please stop Concurrent managers by adcmctl.sh.

2. If not stopped, please abort managers by adcmctl.sh.

adcmctl.sh abort apps/****

3. Please kill if a process remains.

4. relink all (ADADMIN)

5. Please retry Concurrent Manager Recovery.

Navigate:
Oracle Applications Manager > Concurrent Managers OR Concurrent Requests > Site Map > Diagnostics and Repair > Concurrent Manager Recovery.


OR



SOLUTION:

WARNING: This procedure should be performed by your ORACLE Database Administrator. 
The SYSTEM user should have required privileges to perform this task. 

Enable Autoextend on the APPS_TS_TX_DATA tablespace by executing the following Oracle PL/SQL command:

SQL > ALTER DATABASE DATAFILE '/u01/ORACLE/ORADATA/APPS_TS_TX_DATA.ORA' AUTOEXTEND ON NEXT 3072K

ORA-19588: archived log RECID 1003 STAMP 2001986 is no longer valid

Error in RMAN backup log

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d1 channel at 03/04/2018 23:16:26
ORA-19588: archived log RECID 1003 STAMP 2001986 is no longer valid

Recovery Manager complete.



SOLUTION:

This is not an error but a warning. The reason for this is archive logfile which this process is trying to take backup,
is already been backed up by another process and file is deleted

This error is mostly because of 2 reasons.

1. Either 2 backups like one full backup and one archive log backup are running in parallel.
And if the archivelog backup job tried to take backup of the archives, which were backed up and deleted by the full back
job running at the same time, then this warning will come.

So never schedule two backups at the same time

2. Another reason might be because of few invalid or deleted records in control file.

To clean up invalid records, crosscheck the archive log:



RMAN> CROSSCHECK ARCHIVELOG ALL;

RMAN> DELETE EXPIRED ARCHIVELOG ALL;


It is recommended to use delete input option while backing up archivelog.


RMAN> backup archivelog until time 'sysdate -1' delete input;


If we want to take backup of all archivelogs, then:
——————————————————————

RMAN> backup archivelog all delete input ;

Autoconfig Fails While Running Scripts "afdbprf.sh" and "adcrobj.sh" with 12.1 database

Upgraded database 11.1.0 for 12.1 database having AutoConfig Error

While implement and run AutoConfig form my newly upgraded database 11.1.0, getting the following errors

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
         


  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/sonu/db/tech_st/11.1.0/appsutil/install/sonu_visr12
      afdbprf.sh              INSTE8_PRF         1


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/sonu/db/tech_st/11.1.0/appsutil/install/sonu_visr12
      adcrobj.sh              INSTE8_APPLY       1




AutoConfig is exiting with status 2

After checking privileges on $ORACLE_HOME/oracore/zoneinfo, timezone.dat and timezlrg.dat are not present ...

Cause
The multiple timezlrg.* and timezone.* are present so a choice of timezone versions are available.

Solution
To resolve the problem, create links to one of the timezone_nn.dat files. Unless you have a requirement for a specific version, choose the latest ...

[dba@sonu bin]$ cd $ORACLE_HOME/oracore/zoneinfo

[dba@sonu zoneinfo]$ ln -s timezone_18.dat timezone.dat
[dba@sonu zoneinfo]$ ln -s timezone_18.dat timezlrg.dat

After the above steps, again initiated the script, and completed successfully.

[dba@sonu bin]$ perl adconfig.pl

Enter the full file path to the Context file: /u01/db/tech_st/12.1.0.2/appsutil/sonu.xml

Enter the APPS user password:

Using Context file          : /u01/db/tech_st/12.1.0.2/appsutil/sonu.xml


Context Value Management will now update the Context file


        Updating Context file...COMPLETED


        Attempting upload of Context file and templates to database...COMPLETED


Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

ORA-01804: failure to initialize timezone information

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


SP2-0152: ORACLE may not be functioning properly

Cause: -

The timezone information file was not properly read.

Solution:-

1. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:


$ export ORA_TZFILE=/home/oracle/app/oracle/product/12.1.0/oracore/zoneinfo/timezlrg_18.dat


[ora@sujeet ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 6 10:27:42 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>