Tag Archives: Troubleshooting

Java HotSpot(TM) Client VM Error When Running dbua

Posted by on October 4, 2011 No comments

Problem:

After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:

[applmgr@centos53server ~]$ dbua
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C  [libnnz11.so+0x3c4d4]
#
# An error report file with more information is saved as hs_err_pid3662.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#
Aborted

 

Solution:

Apply patch p8670579_112010_LINUX.zip.

Read more »

FRM-92050: Failed to connect to the Server: /forms/lservlet: -1

Posted by on September 19, 2011 2 comments

Problem:

After installing E-Business Suite R12.1.3 on Windows Server 2003 Standard Edition, logged into R12 on the server and launched forms.

The following error appeared:

FRM-92050: Failed to connect to the Server: /forms/lservlet: -1

Solution:

The security settings on the Internet Explorer browser on Windows Server 2003 is set higher by default.

Added the name of the server to the Local Intranet group in IE’s security settings.

Reset Local Intranet security level to Medium-Low.

Reference:

Error – FRM-92050 java.io.IOException: Negative content-length Unable to Launch Forms Successfully [ID 1248215.1]

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

Oracle Forms objects not generating in Patch 9239090 (R12.1.3 RUP)

Posted by on September 15, 2011 No comments

Problem: While running R12.1.3 patch (9239090), the following error appears:

The following Oracle Forms objects did not generate successfully:

au      resource        OKEKAULN.pll
au      resource        OKLCSASD.pll
au      resource        OKSAUCVT.pll
au      resource        OKSAUDET.pll
au      resource        CSCUTILS.pll
au      resource        OKCEXPOR.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Solution:

Manually regenerate the forms, and then continue patch 9239090.

Read more »

admsi.pl Not Running on Windows

Posted by on September 14, 2011 No comments

Problem:

After sourcing the apps environment and running admsi.pl from Command Prompt, admsi.pl opens in Notepad instead of launching the Java forms patch wizard.

Solution:

Set the DISPLAY parameter and run the script from Perl.

D:patches9239089>which admsi.pl
/cygdrive/g/oracle/VIS12/apps/apps_st/appl/ad/12.0.0/bin/admsi.pl

D:patches9239089>%AD_TOP%binadmsi.pl

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....
Please set the DISPLAY variable and re-run this script

D:patches9239089>echo $DISPLAY
$DISPLAY

D:patches9239089>echo %DISPLAY%
%DISPLAY%

D:patches9239089>set DISPLAY=.0:0

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....

602-Diskette Boot Record Error

Posted by on September 12, 2011 No comments

Problem:

When rebooting an HP ML350 G3 server, the following message appears on the screen:

602-Diskette Boot Record Error

This message appears while starting up before checking the CD, so I am unable to boot into the Windows Installation CD to repair the system.

Solution:

Remove attached external hard drive from the server and reboot.

EXEC FND_CONC_STAT.COLLECT Parameter Appearing in Concurrent Report Output

Posted by on July 6, 2011 No comments

Problem: After SQL*Plus concurrent job is registered and run, the concurrent job completes in error and the following message appears in the output:

Enter value for 10: EXEC FND_CONC_STAT.COLLECT;
Enter value for 20:
Enter value for 30: EXIT
     peed.start_date between to_date('EXEC FND_CONC_STAT.COLLECT;', 'RRRR/MM/DD HH24:MI:SS') and  to_date('','RRRR/MM/DD HH24:MI:SS')
                                     *
ERROR at line 18:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Solution: The parameters in the SQL script must be changed from ‘&P_Start_Date’, ‘&P_End_Date’ and ‘&P_Payroll’ to ‘&1’, ‘&2’ and ‘&3’.

Read more »

Printer No Longer Prints After Changing Ribbon

Posted by on June 29, 2011 1 comment

Problem: After changing the printer ribbon for the dot-matrix printer, E-Business Suite can no longer print to the printer.

Solution: The printer must be re-enabled under Linux. Log on as the root user to the machine with the Reports Server and issue the command ‘cupsenable PRINTERNAME’, where PRINTERNAME is the name of the printer as it is registered under Linux.

[amazon asin=0131855158&template=iframe image&chan=default]     [amazon asin=1449316697&template=iframe image&chan=default]     [amazon asin=0596006403&template=iframe image&chan=default]

ORA-12913: Cannot create dictionary managed tablespace

Posted by on May 25, 2011 No comments

Problem: While creating a dictionary managed tablespace in Oracle 9i, the following error appears:

SQL> r
 1  CREATE TABLESPACE data01
 2  DATAFILE '$HOME/oradata/ORCL/data01.dbf' SIZE 2M
 3* EXTENT MANAGEMENT DICTIONARY
 CREATE TABLESPACE data01
 *
 ERROR at line 1:
 ORA-12913: Cannot create dictionary managed tablespace
 Solution:

Consulting the Oracle 9i online documentation, the following cause and action is found:

Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

Action: Create a locally managed tablespace.

As a result, the dictionary managed tablespace cannot be created in this Oracle 9i database.

Reference:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/e12700.htm

ORA-1654: unable to extend index

Posted by on November 12, 2009 No comments

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>

oracle.forms.net.ConnectionException: Forms session failed during startup: no response from runtime process

Posted by on October 21, 2009 No comments

Problem: oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process

Solution: Applications were not linked properly during install. Manually relink applications using adadmin.