CREATE_PIPES Issue while starting Transaction Manager in Oracle Apps 11i

Cause : 

create_pipes failed due to ORA-06550: line 1, column 19:
PLS-00302: component 'CREATE_PIPES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.

Solution :

1. Shutdown the CM and Application cleanly.
2. Shutdown the database.
3. Start the database and listener if it’s down.
4. Run Autoconfig in database tier and check it’s completing normal or not.
5. Run CMCLEAN.sql
6. Run Autoconfig in apps tier.
7. Through adadmin, please do the below.
a. Generate Product JAR files
b. Generate message files
c. Relink Application programs. (You may face the warning ld: warning: symbol `ui10144' has differing   sizes, which we can ignore.)
8. Start the Application and check, still you get the same error.

Change 11g Auto Jobs window time

Reference : How to Change The Default WINDOW_START_TIME of Automatic Statistics Collection On 11g [ID 1450173.1]

Run SQL Tuning advisor in SQL Prompt

Get SQL ID
===========
select distinct hash_value, sql_id, sql_text
from v$sql
where sql_text like '%pktable_cat%'
and sql_text not like 'select distinct hash_value, sql_id%';


Create Tuning Task:
===================
DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id => '0j3dqg3a8aj8c',
scope => 'COMPREHENSIVE',
time_limit => 3600,
task_name => 'my_sql_tuning_task_1',
description => 'Tune query using sqlid');
end;
/

Execute Tuning Task:
===================
BEGIN
DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'my_sql_tuning_task_1');
end;
/


SET LONG 100000
SET LONGCHUNKSIZE 1000
SET LINESIZE 100
set pagesize 100

--***************************
--TO GET SUMMARY INFORMATION
--***************************

SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'my_sql_tuning_task_1') from DUAL;

--***************************
--TO GET DETAILED INFORMATION
--***************************
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('my_sql_tuning_task_1','TEXT','ALL','ALL') FROM DUAL;


-- Accept the profile <<< If you get one...
DECLARE
my_sqlprofile_name VARCHAR2(30);
BEGIN
my_sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (
task_name => 'my_sql_tuning_task_1',
name => 'my_sql_profile');
END;
/


###

If necessary you can drop the tuning task.

begin
DBMS_SQLTUNE.DROP_TUNING_TASK('my_sql_tuning_task_1');
end;
/

If necessary (the profile does not help),
you can drop the profile.

BEGIN
DBMS_SQLTUNE.DROP_SQL_PROFILE ('MY_SQL_TUNING_TASK_1');
END;
/

REP-3000: Internal error starting Oracle Toolkit

Issue:
Recently we had issue with Concurrent requests which having print format of PDF or XML, and the exact error is.

REP-3000: Internal error starting Oracle Toolkit.

Solution:
1. Log on as root on the UNIX box.
2. Start The VNC server:
Example:
$ vncserver :0
If it's not installed on the box, have your Unix Admin's to install the VNC on the server.
3. Set the DISPLAY environment variable for Oracle Reports by performing the
following steps:
a. $ set DISPLAY=hostname:0; export DISPLAY
b. $ xhost +
c. Set the DISPLAY parameter in adcmctl.sh, adrepctl.sh,adfrmctl.sh
and gsmstart.sh to hostname:0
d. Restart concurrent manager and report server

How to Verify:
1. Login with system administrator responsibility
2. Concurrent – program-Define-Query Active Users-Change Print format to PDF- save
3. Run the Active Users Concurrent Request
4. It should be completed without any issue.

DATA GUARD LOG SHIPPING FAILS WITH ERROR ORA-16191 IN 11G

Issue:

PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191.
Sat Aug 06 02:06:52 2011
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191

Things Verified :

1. Create password file for sys in both primary and standby
2. Login as a sys from primary to standby and vice versa
Sqlplus sys@STANDBY as sysdba
3. tnsping also works from primary to standby and vice versa

Solution :

In 11g oracle comes with the strong password authentication, so we have to use ignorecase parameter while creating password file in both primary and standby, otherwise we have to set SEC_CASE_SENSITIVE_LOGON=FALSE (Dynamic parameter).

1. orapwd file=orapw$ORACLE_SID password=***** entries=5 ignorecase=Y
2. alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;

Issue while starting WF Mailer in Apps 11i

Issue:
exception = java.lang.NoClassDefFoundError: javax/jms/Connection

Here is the full error message :
[Jul 21, 2011 2:23:11 PM EDT]:1311272591539:Thread[Task Request Thread,5,main]:0:-1:oraappsdba.amestruetemper.com:10.80.1.135:-1:-1:UNEXPECTED:[fnd.wf.bes.ConnectionManager$1]:Failed to establish Java Business Event System control connection: databaseId = oradbdba_dba, ownerName = APPLSYS, queueName = WF_CONTROL, subscriberName = WFBESCL_13825, selector = null, exception = java.lang.NoClassDefFoundError: javax/jms/Connection

Solution:
1. Please set $JAVA_TOP/appsborg2.zip in the AF_CLASSPATH in $APPL_TOP/admin/adovars.env file.

Example of AF_CLASSPATH setting:
/local/java/jdk1.3.1/lib/dt.jar:/local/java/jdk1.3.1/lib/tools.jar:/slot05/appmgr/atgwfqacomn/java/
ppsborg2.zip:/slot05/appmgr/atgwfqaora/8.0.6/forms60/java:/slot05/appmgr/atgwfqacomn/java

2. Shutdown and restart the Concurrent Manager.

Refernce : Java.Lang.Noclassdeffounderror: Javax/Jms/Connection When Starting Workflow Mailer [ID 342700.1]

How to Tell if the Oracle Software is 32-Bit or 64-Bit

How to find if the Oracle Client Software is 32-Bit or 64-Bit ?

here you can have some ways to find it.

You can find whether Oracle Client Software is 32-Bit or 64-Bit by using the following :


1.Check the sqlplus binary

% file $ORACLE_HOME/bin/sqlplus

64-bit will show 64-bit.
32-bit will show 32-bit or not specify wordsize

2.Check for the directories :

$ORACLE_HOME/lib32
$ORACLE_HOME/lib

% ls -l $ORACLE_HOME/lib32
% ls -l $ORACLE_HOME/lib


If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib exist, then it is 64 bit client.
If you have only $ORACLE_HOME/lib you need to use method 1 as there are client versions (11.2)where $ORACLE_HOME/lib32 directory does not exist on 64-bit client installations.

Refernce:
How To Find If The Oracle Client Software Is 32-Bit Or 64-Bit on UNIX platforms [ID 434295.1]

NOTE:119707.1 - How to Tell if the Oracle Software is 32-Bit or 64-Bit