Usage of Adpatch and Adctrl

NLS Language Patche Installation Issues:

Issue:

--------

While running adadmin for maintain multilingual table it shows 8 workers failed.

Solution:

------------------

appljr12@server1 # vi $APPL_TOP/admin/jr12/log/adworker001.log

it shows

Issue 1

MESG

--------------------------------------------------------------------------------

LANGUAGE=AMERICAN

PACKAGE=FND_DESCR_FLEX_COL_USAGE_PKG

SQLERRM=ORA-01652: unable to extend temp segment by 16 in tablespace APPS_TS_SEED

select to_date('ERROR') * ERROR at line 1:

ORA-01858: a non-numeric character was found where a numeric was expected

--------------------------------------------------------------------------------------

[root@server1 ~]# su - orajr12

[orajr12@server1 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Jul 1 02:04:37 2012

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select file_name from dba_data_files where tablespace_name='APPS_TS_SEED';

FILE_NAME

--------------------------------------------------------------------------------

/jr12/d02/oracle/jr12/db/apps_st/data/reference1.dbf

/jr12/d02/oracle/jr12/db/apps_st/data/reference2.dbf

/jr12/d02/oracle/jr12/db/apps_st/data/reference3.dbf

SQL> ALTER TABLESPACE APPS_TS_SEED ADD DATAFILE'/jr12/d02/oracle/jr12/db/apps_st/data/reference4.dbf' size 1024M;

Tablespace altered.

appljr12@server1 # adctrl

1. Tell worker to restart a failed job

Issue 2

MESG

--------------------------------------------------------------------------------

LANGUAGE=AMERICAN

PACKAGE=FND_DESCR_FLEX_COL_USAGE_PKG

SQLERRM=ORA-12801: error signaled in parallel query server P004

ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_SEED

select to_date('ERROR') * ERROR at line 1:

ORA-01858: a non-numeric character was found where a numeric was expected

SQL> ALTER TABLESPACE APPS_TS_SEED ADD DATAFILE'/jr12/d02/oracle/jr12/db/apps_st/data/reference4.dbf' size 1024M INITIAL 128M AUTOEXTENDON;

appljr12@server1 # adctrl

1. Tell worker to restart a failed job

Issue 3

MESG

--------------------------------------------------------------------------------

LANGUAGE=AMERICAN

PACKAGE=WF_MESSAGE_ATTRIBUTES_PKG

SQLERRM=ORA-01654: unable to extend index APPLSYS.WF_MESSAGE_ATTRIBUTES_TL_PK by 16 in tablespace APPS_TS_SEED

select to_date('ERROR') * ERROR at line 1:

ORA-01858: a non-numeric character was found where a numeric was expected

SQL> select file_name, bytes, autoextensible, maxbytes from dba_data_files wheretablespace_name='APPS_TS_SEED';

SQL> ALTER TABLESPACE APPS_TS_SEED ADD DATAFILE'/jr12/d02/oracle/jr12/db/apps_st/data/reference5.dbf' size 1024m autoextend on next 200mmaxsize 1024m;

Tablespace altered.

appljr12@server1 # adctrl

1. Tell worker to restart a failed job

Now applied patches successfully..........