IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: March 2008

ORA-12705: Cannot access NLS data files or invalid environment specified

3 Comments Posted by on March 31, 2008

While running autoconfig in oracle apps on database side, you might encounter this error. Also you can see this when you do sqlplus from command prompt. Cause:  Either your NLS_LANG parameter is not set correctly or NLS_ORA10 parameter is not set correctly. Solution : check $ORA_NLS10 path. This should point to ORACLE_HOME/nls/data/9idata if this is [...]

ORA Errors ,

ORA-00600: internal error code, arguments: [kcratr1_lastbwr]

17 Comments Posted by on March 31, 2008

Some time we encounter this error while starting the database. Below is the solution for recovering through this error. Error: SQL> startup ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 1264916 bytes Variable Size 264241900 bytes Database Buffers 801112064 bytes Redo Buffers 7122944 bytes Database mounted. ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [...]

ORA Errors

Using Net::LDAP perl Module

Leave a Comment Posted by on March 26, 2008

Hi All, this post is related to using Net::LDAP perl module to register, search and delete the users in OID (oracle internet directory). I have been struggling to get this perl code for me. Finally I was able to create a perl script for doing the same. Initially I tried the same thing using ldapadd [...]

Oracle Middleware , , ,

Creating Oracle Home Inventory – Oracle Database 10g

4 Comments Posted by on March 21, 2008

Some times you clone an oracle home manually using OS level commands and this might cause problem in your existing inventory. Your new ORACLE_HOME will not be registered in your existing registry. As far as running of database is concerned, we wont face any problem, trouble comes when in future you want to apply a [...]

Oracle Database 10g , ,

Using TABLE_TO_COMMA in PLSQL

2 Comments Posted by on March 13, 2008

Some times the situation arises where we want to output the result from the table as a comma separated string. This situation can be answered using many methods. The most efficient method, however, is using TABLE_TO_COMMA procedure of DBMS_UTILITY package. Below is the example that I encountered. set echo on serveroutput on declare cursor c1 [...]

Oracle Database 10g ,

Creating users in OID (Oracle Internet Directory) – Oracle Collabsuite 10g

2 Comments Posted by on March 11, 2008

Introduction: his port is regarding creation of users in central OID (Oracle Internet Directory) instance. We call it a central because of its architecture. Usually for any business setup, there will be many instances of application and a single installation of OCS or Oracle AS. Either of these techstack is having OID as one of [...]

Oracle Middleware

Installing OCS (Oracle Collabsuite) 10g – Linux

Leave a Comment Posted by on March 7, 2008

Introduction:This document gives a step by step approach for installing OCS (Oracle Collabsuite) 10g. This is created from the Oracle documentation available on OTN. This serves as a simple guide for installation of OCS 10g. Setup Details: OS Detail : bash-2.05b$ uname -a Linux ap6059rt 2.4.21-37.0.0.1.4.ELhugemem #1 SMP Fri Feb 24 18:01:54 PST 2006 i686 [...]

Oracle Middleware

Compiling JSPs in Oracle Applications

1 Comment Posted by on March 5, 2008

Many times we faces an issue which needs JSPs to be compiled, specially in case of development. Also for example, if some of the class files are missing then, in that case we can compile the JSPs and get the required class files. In Oracle Applications (11i as well as R12), we have a utility [...]

Oracle Application R12, Oracle Applications 11i

Upgrading Oracle Application 11i to E-Business Suite R12

23 Comments Posted by on March 4, 2008

Overview of upgrade to R12 Upgrading an application from 11i to R12 involves, upgrading the database side, upgrading the middleware techstack and upgrading the application side. Supported upgrade path for application side upgrade is as given below. In case of database upgrade, you have to upgrade the database to 10gR2 (10.2.0). Because application R12 can [...]

Oracle Applications 11i , ,

Follow

Get every new post delivered to your Inbox.

Join 130 other followers