Monthly Archives: November 2009

ORA-1654: unable to extend index

This documentation shows the SQL*Plus output for resolving the ORA-01654 error.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and Settingsoracle>f:
F:>cd oraclePRODdbtech_st10.2.0
F:oraclePRODdbtech_st10.2.0>PROD_mainfinsrv1.cmd
ECHO is off.
ECHO is off.
Thu 11/12/2009 08:04 PM
PROD_mainfinsrv1.cmd exiting with status 0
F:oraclePRODdbtech_st10.2.0>cd adminPROD_mainfinsrv1bdump
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>tail -40 alert_prod.log
Thu Nov 12 19:54:51 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
Thu Nov 12 19:55:21 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>sqlplus apps/apps
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 12 20:05:07 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc dba_indexes
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
UNIQUENESS VARCHAR2(9)
COMPRESSION VARCHAR2(8)
PREFIX_LENGTH NUMBER
TABLESPACE_NAME VARCHAR2(30)
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
PCT_THRESHOLD NUMBER
INCLUDE_COLUMN NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
PCT_FREE NUMBER
LOGGING VARCHAR2(3)
BLEVEL NUMBER
LEAF_BLOCKS NUMBER
DISTINCT_KEYS NUMBER
AVG_LEAF_BLOCKS_PER_KEY NUMBER
AVG_DATA_BLOCKS_PER_KEY NUMBER
CLUSTERING_FACTOR NUMBER
STATUS VARCHAR2(8)
NUM_ROWS NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
PARTITIONED VARCHAR2(3)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
BUFFER_POOL VARCHAR2(7)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
PCT_DIRECT_ACCESS NUMBER
ITYP_OWNER VARCHAR2(30)
ITYP_NAME VARCHAR2(30)
PARAMETERS VARCHAR2(1000)
GLOBAL_STATS VARCHAR2(3)
DOMIDX_STATUS VARCHAR2(12)
DOMIDX_OPSTATUS VARCHAR2(6)
FUNCIDX_STATUS VARCHAR2(8)
JOIN_INDEX VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
DROPPED VARCHAR2(3)
SQL> select owner, index_name, index_type, tablespace_name, initial_extent, next_extent,
min_Extents, max_extents from dba_indexes where index_name = 'FND_CRM_HISTORY_U2';
OWNER INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE TABLESPACE_NAME INITIAL_EXTENT
--------------------------- ------------------------------ --------------
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
----------- ----------- -----------
APPLSYS FND_CRM_HISTORY_U2
NORMAL APPS_TS_TX_IDX 131072
131072 1 2147483645
SQL> DESC DBA_DATA_FILES
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> SELECT FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'APPS_TS_TX_IDX';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND05.DBF
APPS_TS_TX_IDX 1273
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND04.DBF
APPS_TS_TX_IDX 1287
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND03.DBF
APPS_TS_TX_IDX 1577
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND02.DBF
APPS_TS_TX_IDX 1200
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND01.DBF
APPS_TS_TX_IDX 1200
SQL> ALTER TABLESPACE APPS_TS_TX_IDX
2 ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M;
ALTER TABLESPACE APPS_TS_TX_IDX
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> CONNECT SYSTEM/MANAGER
Connected.
SQL> L
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
SQL> R
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
Tablespace altered.
SQL> DISC
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> EXIT
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>

After R12 Vision Installation, Concurrent Manager Not Starting

Problem: Oracle E-Business Suite R12 was installed on appswindows3. After installation, the Concurrent Manager is not starting.

Solution: Checked Event Viewer. The following messages appear:

Restart ICM (Retries left:0)
ICM process exited with error(1)
FNDLIBR Stopped(1)

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=591003&start=15&tstart=0

Checked directory: %APPLCSF%%APPLLOG%
G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>type CM_VIS12_appswindows3.log

List of errors encountered:
………………………………………………………..

_ 1 _
Routine AFPCAL received a return code of failure from routine spiini.

Review your concurrent request log file for more information.
………………………………………………………..

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

Type CM_VIS12_appswindows3.log:
Routine AFPCAL received a return code of failure from routine spiini.

To reproduce error, source apps environment and run:

FNDCPUCF apps/apps 0 Y %AD_TOP%admintemplateadctxinf.tmp

Metalink Reference:
Subject: Concurrent Manager Service Fails To Start With Error Code 1067
Doc ID: 434444.1

Cause
The issue is caused because of uninitialized string (New Value #1) in the registry under APPL_CONFIG.

The uninitialized key is causing Concurrent Managers not to come up. In the Task manager FNDLIBR.exe comes up briefly and dies.

Solution
To implement the solution, please execute the following steps:

1. Go into the registry

2. Delete uninitialized key under APPL_CONFIG

3. Retest the issue by starting concurrent manager service

Ran AutoConfig on the database tier:

The above did not work, as there was no uninitialized key under APPL_CONFIG.

Stopped all Oracle application tier services and ran AutoConfig:
cd G:oracleVIS12instappsVIS12_appswindows3adminscripts
adautocfg.cmd

[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: G:oracleVIS12instappsVIS12_appswindows3admininstall
afcpctx.cmd INSTE8_PRF 1

AutoConfig is exiting with status 1

Metalink Reference:
Bug No: 3815440 (AFCPCTX.CMD FAILS WHEN AUTOCONFIG IS RUN)

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: 11i : Oracle Application Object Library Concurrent Manager Setup Test
Doc ID: 200360.1

Subject: Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release 11i Troubleshooting
Doc ID: 216208.1

R12 Log File Locations

Concurrent Manager Log: %APPLCSF%%APPLLOG%

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog

%APPLCSF%%APPLLOG%

%APPLCSF%%APPLOUT%

Application TNS Listener executable:

G:oracleVIS12appstech_st10.1.2BINTNSLSNR

Application TNS Listener config file:

G:oracleVIS12instappsVIS12_appswindows3ora10.1.2networkadminlistener.ora

Location of dbc file (VIS12.dbc):

G:oracleVIS12instappsVIS12_appswindows3applfnd12.0.0secure

Apache Root:

G:oracleVIS12appstech_st10.1.2ApacheApache

Wiping R12 and reinstalling

Step 1:       Stop all Oracle processes and the Distributed Transaction Coordinator service.

Step 2:       Run regedit and delete the following entries:

 HKEY_LOCAL_MACHINESOFTWAREORACLE
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet003ServicesOracle*

Exit regedit, and then reboot.

 Step 3:Delete the Oracle directory (x:oracleVIS12) and C:Program Filesoracle.

 Empty the recycle bin, and then reboot the computer once more.

 Step 4:Clean up the Program Menu for Oracle entries

 Step 5:Run Rapid Wizard to restart the R12 installation.

Metalink Reference:

Doc ID: 567507.1 (How to Remove an Oracle E-Business Suite Release 12.x Windows Environment)


Running AutoConfig on the Application Tier

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12appsapps_stappl
G:oracleVIS12appsapps_stappl>appsinf.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
appsinf.cmd exiting with status 0
ERRORCODE = 0 ERRORCODE_END
G:oracleVIS12appsapps_stappl>APPSVIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
ECHO is off.
ECHO is off.
Setting environment for using Microsoft Visual Studio 2005 x86 tools.
APPSORA.cmd exiting with status 0
G:oracleVIS12appsapps_stappl>cd ..
G:oracleVIS12apps>cd oracleVIS12instappsVIS12_appswindows3adminscripts
G:oracleVIS12instappsVIS12_appswindows3adminscripts>dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12instappsVIS12_appswindows3adminscripts
10/30/2009  05:06 PM    <DIR>          .
10/30/2009  05:06 PM    <DIR>          ..
10/30/2009  05:06 PM             4,504 adalnctl.cmd
10/30/2009  05:06 PM             4,759 adapcctl.cmd
10/30/2009  05:06 PM             2,704 adautocfg.cmd
10/30/2009  05:06 PM             4,831 adcmctl.cmd
10/30/2009  05:06 PM             7,086 adexecsql.pl
10/30/2009  05:06 PM             4,901 adformsctl.cmd
10/30/2009  05:06 PM             4,767 adoacorectl.cmd
10/30/2009  05:06 PM             4,758 adoafmctl.cmd
10/30/2009  05:06 PM             4,467 adopmnctl.cmd
10/30/2009  05:06 PM            15,084 adpreclone.pl
10/30/2009  05:06 PM             5,399 adstpall.cmd
10/30/2009  05:06 PM             5,520 adstrtal.cmd
10/30/2009  05:06 PM             1,695 gsmstart.cmd
10/30/2009  02:20 PM    <DIR>          ieo
10/30/2009  05:06 PM             1,656 java.cmd
10/30/2009  05:07 PM             1,426 jtffmctl.cmd
10/30/2009  05:07 PM             6,535 mwactl.cmd
10/30/2009  05:07 PM             2,415 mwactlwrpr.cmd
17 File(s)         82,507 bytes
3 Dir(s)   1,052,397,568 bytes free
G:oracleVIS12instappsVIS12_appswindows3adminscripts>adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:41 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12instappsVIS12_app
swindows3adminlog11031241adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location     : G:oracleVIS12instappsVIS12_appswin
dows3
Classpath                   : G:oracleVIS12appsapps_stcomnjavalib
appsborg2.zip;G:oracleVIS12appsapps_stcomnjavaclasses
Using Context file          : G:oracleVIS12instappsVIS12_appswindow
s3appladminVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:41 PM
1 file(s) copied.
Script Success, Applications Context update complete.
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed with errors.
Completed execution of AutoConfig
G:oracleVIS12instappsVIS12_appswindows3adminscripts>

Running AutoConfig on the Database Tier

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12dbtech_st10.2.0
G:oracleVIS12dbtech_st10.2.0>VIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:32 PM
VIS12_appswindows3.cmd exiting with status 0
G:oracleVIS12dbtech_st10.2.0>cd appsutilscriptsVIS12_appswindows3
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3
10/30/2009  03:08 PM    <DIR>          .
10/30/2009  03:08 PM    <DIR>          ..
10/30/2009  03:08 PM             2,690 adautocfg.cmd
10/30/2009  03:08 PM             5,262 adchknls.pl
10/30/2009  03:08 PM             3,420 addbctl.cmd
10/30/2009  03:08 PM             3,932 addlnctl.cmd
10/30/2009  03:08 PM             7,089 adexecsql.pl
10/30/2009  03:08 PM             3,441 adlsnodes.cmd
10/30/2009  03:08 PM            14,953 adpreclone.pl
10/30/2009  03:08 PM               837 adstopdb.sql
10/30/2009  03:08 PM             1,251 adstrtdb.sql
9 File(s)         42,875 bytes
2 Dir(s)   1,052,569,600 bytes free
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:34 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12dbtech_st10.2.0a
ppsutillogVIS12_appswindows311031234adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : G:oracleVIS12dbtech_st10.2.0
Classpath                   : ;G:oracleVIS12dbtech_st10.2.0jdbclibojdbc14.jar;G:oracleVIS12dbtech_st10.2.0appsutiljavaxmlparserv2.jar;G:oracleVIS12dbtech_st10.2.0appsutiljava;G:oracleVIS12dbtech_st10.2.0jlibnetcfg.jar;G:oracleVIS12dbtech_st10.2.0jlibldapjclnt10.jar
Using Context file          : G:oracleVIS12dbtech_st10.2.0appsutilVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Completed execution of AutoConfig
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3>