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
- 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
AUTOEXTEND ON;
appljr12@server1
# adctrl
- 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 where
tablespace_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 200m maxsize 1024m;
Tablespace altered.
appljr12@server1
# adctrl
- Tell worker to restart a failed job
Now applied patches successfully..........
No comments:
Post a Comment