Category Archives: 9i

ORA-29832, ORA-29844 When Running catpatch.sql

Problem: When running catpatch.sql as part of Oracle Database 9.2.0.8 upgrade, the following errors occur:

ORA-29832: cannot drop or replace an indextype with dependent indexes 
ORA-29844: duplicate operator name specified

Solution: These errors can be ignored.

Reference: Ora-29832 And Ora-29844 Errors Running Catpatch.sql [ID 781203.1]

SQL Developer Vendor Code 17002

Problem:

When connect to an 11i E-Business Suite database using SQL Developer, the following error appears:

An error was encountered performing the requested operation:

IO Error: Connection reset

Vendor code 17002

Sometimes, the error reads:

An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Issuing the tnsping command against the instance returns the following:

C:>tnsping vis3

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:OracleDevSuiteHomenetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain)
(PORT=1524)) (CONNECT_DATA= (SID=VIS3)))
TNS-12537: TNS:connection closed

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.

Solution:

AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:

tcp.validnode_checking = yes
tcp.invited_nodes=(OEL5VIS3.localdomain)

This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.

[amazon asin=1847196268&template=iframe image&chan=default]     [amazon asin=0071484744&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]

ORA-00604, ORA-01882 While Connecting With SQL Developer

Problem:

While trying to connect to an Oracle 9.2.0.3 database on EBS 11.5.9 (running on Red Hat Enterprise Linux AS release 4) using SQL Developer 3.0.04, the following message appears:

An error was encountered performing the requested operations:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
OO604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement 
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack 
can be corrected, do so; otherwise contact Oracle Support
Vendor code 604

Solution:

Change the timezone variable in sqldeveloper.conf to a valid one for the database.

Read more »

AC-30202: Unrecognized action specified, Context Value Management Failed

Problem:

After sourcing APPSORA.env on and 11.5.10.2 environment and running AutoConfig, the following error appeared:

$ ./adautocfg.sh appspass=password

The log file for this session is located at: /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using APPL_TOP location     : /u01/test3/test3appl
        Classpath                   : /u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u01/test3/test3comn/java/appsborg2.zip:/u01/test3/test3comn/java

promptmsg=hide - AC-30202: Unrecognized action specified. Exiting.

ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:
    /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log
$

Solution:

After unsetting LD_ASSUME_KERNEL and applying patch 6365595, applied patch 5903765 (Applications Technology 11i.ATG_PF.H.delta.6). After patch completed, ran AutoConfig without problems.

 

ORA-00600, ORA-27301 When Creating 9i Database

Problem:

When creating a new Oracle 9i database using dbca (Database Configuration Assistant), the following error appears when the database is being created (at the ‘Creating and starting Oracle instance (46 %)’ step).

ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], []
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper

Solution:

Change the semaphore settings.

Read more »

Enabling Archivelog Mode in Oracle9i

Problem:

How do I enable archivelog in an Oracle9i database?

Solution:

After logging into the running Oracle9i instance as the SYS user (sqlplus “/ as sysdba”), check the log_archive parameters:

show parameter log_archive

Set the archive log destination directory (note that these commands assume that the database uses the spfile):

alter system set log_archive_start=TRUE scope=spfile;
alter system set log_archive_dest_1='location=/u01/archive/ORCL/' scope=spfile;
alter system set log_archive_format='arch_%t_%s.arc' scope=spfile;

Then shutdown and mount the database, and enable archivelog:

shutdown immediate;
startup mount;
archive log start;
alter database archivelog;
alter database open;

Reference:
http://www.oracle-base.com/articles/9i/ArchivelogModeOnRAC9i.php

[amazon asin=0071496610&template=iframe image&chan=default]     [amazon asin=1849687307&template=iframe image&chan=default]     [amazon asin=0071598758&template=iframe image&chan=default]

 

SQL Code Not Running In EBS

Problem: The following code runs in SQL Developer and SQL*Plus from the server:

SELECT person_name,
  employee_number,
  date_from,
  date_to,
  segment_details
FROM apps.hrfg_detailed_special_info
WHERE to_date('&1', 'RRRR/MM/DD HH24:MI:SS') BETWEEN date_from AND date_to
 AND information_type = 'ABC Full Time Payroll Remarks'
 AND segment_name = 'Remarks'
ORDER BY person_name
/

However, when it is registered as a concurrent program and run, no output appears.

Solution: The apps_initialize subroutine must be called before running the script.

Read more »

Printer No Longer Prints After Changing Ribbon

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

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

Upgrading 11i EBS 9i Database to 10g

This document shows how to upgrade the 9i database in 11i E-Business Suite to 10g on Linux.

Metalink Reference:

Doc ID:  362203.1 (Subject:  Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0))

Section 1: Upgrading an 11i Database to Oracle Database 10g Release 2 (10.2.0)

Ignore steps 1 – 5 in the Metalink document.

Begin at Step 6.

Step 6:        Prepare to create the 10.2.0 Oracle home

Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86

10201_database_linux32.zip (668,734,007 bytes) (cksum – 2737423041)

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html

http://www.oracle.com/technology/documentation/database10gr2.html

http://www.oracle.com/technology/support/metalink/index.html

Step 7:        Install the base 10.2.0 software

Install Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86

Refer to chapter 3, Oracle Database Installation Guide 10g Release 2 (10.2)

Unzip 10201_database_linux32.zip

Create directory: /u01/oracle/visdb/10.2.0

Ensure OS meets requirements for 10g

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Begin installation (./runInstaller)

  • Advanced installation
  • Choose Enterprise Edition installation type
  • Do not upgrade existing database
  • Install database software only

Note: You may need to increase the swap file to 4GB before installing 10g.

Step 8:        Install Oracle Database 10g Products from the 10g Companion CD

Refer to section 3.5, “Installing Oracle Database 10g Products” in the Oracle Database Companion CD Installation Guide

Unzip 10201_companion_linux32.zip

Ensure OS meets requirements for 10g (should be in place)

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Begin installation (./runInstaller)

  • Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
  • Choose the 10g Home

Step 9:        Perform 10.2.0.4 patch set pre-installation tasks

Oracle® Database Patch Set Notes

10g Release 2 (10.2.0.4) Patch Set 3 for Linux x86

Metalink Doc ID: 316900.1

Download patch 6810189 (p6810189_10204_Linux-x86.zip)

Unzip p6810189_10204_Linux-x86.zip

Ensure OS meets requirements for 10g (should be in place)

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Stop all processes (dbconsole, iSQL*Plus, database listener)

Backup Oracle Inventory, Oracle database, Oracle Home

Begin installation (./runInstaller)

  • Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
  • Choose the 10g Home

Perform 10.2.0.4 patch set pre-installation tasks

On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the 10.2.0.4 patch set file for your platform. Read the patch set notes (usually README.html). Make sure you thoroughly understand the upgrade and patch set installation process before you begin. Check OracleMetaLink or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle E-Business Suite.

Perform the tasks in the “Preinstallation Tasks” section of the patch set notes (if they apply to your system).

Step 10:   Perform 10.2.0.4 patch set installation tasks

On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the “Installing the Oracle Database 10g Patch Set Interactively” section of the patch set notes. Make sure that:

The ORACLE_HOME environment variable points to the new 10.2.0 Oracle home.

The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).

The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.

The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/<perl version> and $ORACLE_HOME/perl/lib/site_perl/<perl version>)

You use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.

Step 11:    Create nls/data/9idata directory

Run: perl $ORACLE_HOME/nls/data/old/cr9idata.pl script

Modify set10g.env:

export ORA_NLS10= ORACLE_HOME/nls/data/9idata

Step 12:   Apply additional 10.2.0.4 RDBMS patches

Download from Metalink and apply:

6880880 or the latest OPatch version.

6521934

6600051

7496636

7497678

cd $ORACLE_HOME

unzip /u01/patches/p6880880_102000_LINUX.zip