INST_TOP

Oracle Application R12

Advertisements

Req IMPORT slow

Oracle Financials : Oracle Purchasing : 11.5.10.2

Requisition Import is very slow.

root.sh fails during 11gR2 Grid infrastructure installation

Whenever the root.sh script fails for the first time, do not run it again. Do the following steps and clusterware will be healthy up and running.

It happened that root.sh failed, when I did 11gR2 Rac Cluster set up on Sun Solaris and Enterprise Linux boxes. I could find the errors recorded in the logs.

Deconfigure and Reconfigure of Grid Infrastructure Cluster:

Identify cause of root.sh failure by reviewing logs in $GRID_HOME/cfgtoollogs/crsconfig and $GRID_HOME/log, once cause is identified, deconfigure and reconfigure with steps below – please keep in mind that you will need wait till each step finishes successfully before move to next one:

For Step1 and 2, you can skip node(s) on which you didn’t execute root.sh yet.

Step 1: As root, run “$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force” on all nodes, except the last one.

Step 2: As root, run “$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode” on last node. This command will zero out OCR and VD disk also.

Step 3: As root, run $GRID_HOME/root.sh on first node

Step 4: As root, run $GRID_HOME/root.sh on all other node(s), except last one.

Step 5: As root, run $GRID_HOME/root.sh on last node.

Eevrything is working now.

Reference : ID 942166.1

  1. Deinstall of Grid Infrastructure Cluster
  2. Deinstall of Grid Infrastructure Standalone Server
  3. Deconfigure and Reconfigure of Standalone Server (Oracle Restart)

If there is a firewall between the nodes , then disable it between nodes, and refer to note 942166.1 or note 969254.1
to proceed further.

undefined symbol: _intel_fast_memcpy

Applies to Oracle Application Server 10g (10.1.2)

HTTP server not up after patching database 10.2.0.4.4 to 10.2.0.5.

Make sure you have taken backups of all Oracle homes and Oracle Inventory

[INFRA_HOME]@:/u01/oracle/product/infra/Apache/Apache/libexec$ opmnctl status

Processes in Instance: infra.cdb………….
.——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
DSA                | DSA                |     N/A | Down
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |    5377 | Alive
OC4J               | OC4J_SECURITY      |    3584 | Alive
HTTP_Server        | HTTP_Server        |     N/A | Down
OID                | OID                |    3477 | Alive

[INFRA_HOME]@:/u01/oracle/product/infra/Apache/Apache/bin$ ./.apachectl start
Syntax error on line 195 of /u01/oracle/product/infra/Apache/Apache/conf/httpd.conf:
Cannot load /u01/oracle/product/infra/Apache/Apache/libexec/mod_onsint.so into server: /u01/oracle/product/infra/lib/libons.so: undefined symbol: _intel_fast_memcpy
./apachectl start: httpd could not be started

Check sum of the file :
[INFRA_HOME]@:/u01/oracle/product/infra/Apache/Apache/bin$ cd /u01/oracle/product/infra/lib
[INFRA_HOME]@:/u01/oracle/product/infra/lib$ cksum libons.so
3968940677 56709 libons.so

Check sum in backup file:
[CDB10_HOME]@:/home/oracle/product/cdb10/lib$ cd /m/cdb1-export1/cdb1-export-dump/infra_home/lib/
[CDB10_HOME]@:/m/cdb1-export1/cdb1-export-dump/infra_home/lib$ cksum libons.so
1584054319 59561 libons.so

There was difference.
[CDB10_HOME]@:/m/cdb1-export1/cdb1-export-dump/infra_home/lib$ cd /u01/oracle/product/infra/lib
[CDB10_HOME]@:/u01/oracle/product/infra/lib$ cp libons.so libons.so.250610.bkp
[CDB10_HOME]@:/u01/oracle/product/infra/lib$ cp /m/cdb1-export1/cdb1-export-dump/infra_home/lib/libons.so .
[CDB10_HOME]@:/u01/oracle/product/infra/lib$ cksum libons.so
1584054319 59561 libons.so
[CDB10_HOME]@:/u01/oracle/product/infra/lib$ cd ../Apache/Apache/bin/
[CDB10_HOME]@:/u01/oracle/product/infra/Apache/Apache/bin$ ./.apachectl start
./apachectl start: httpd started

HTTP Server is now up and running. Startup sequence : OID -> HTTP_Server-> OC4J_SECURITY

[INFRA_HOME]@:/home/oracle$ opmnctl status

Processes in Instance: infra.cdb1……………
——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
DSA                | DSA                |     N/A | Down
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |   17263 | Alive
OC4J               | OC4J_SECURITY      |   16969 | Alive
HTTP_Server        | HTTP_Server        |   16865 | Alive
OID                | OID                |   16698 | Alive

Problem with libraries linking when starting up HTTP. Incorrect values picked up during runtime. Middle Tier had a different version of libons.so and that the infra version of this file did not match that of the last valid backup, even though the infra home had not been recently updated.

TNS Linux Error: 29: Illegal seek

[DB_HOME]@:/home/oracle$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.4.2 – Production on 24-JUN-2010 16:46:42

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting /home/oracle/product/infra/

bin/tnslsnr: please wait…

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek

Oracle Net Services – Version: 10.1.0.0 to 10.2.0.2
This problem can occur on any platform.

I tried setting tcp.validnode_checking = no in sqlnet.ora

There was no output for : netstat -an | grep 1521

I checked /etc/hosts file for the entry 127.0.0.1 localhost.localdomain localhost

Cause

TNS Listener fails while attempting to initiate subscription to ONS node down event.

Level 16 TNS Listener trace shows the last action:


[01-JUL-2005 10:16:59:727] nsglonsinit: Initiated subscription for node down event

Same symptoms and corrective action found in Bug 4227455 OCS_MAIN_SOLARIS_050304 – UNABLE TO START THE SECOND LISTENER of if OS User is unable to read the /etc/hosts file.
Solution

To implement the solution, please execute the following steps:

1. Explicitly disable the 10g TNS Listener’s subscrition to ONS by editing the listener.ora file and add the parameter below:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

where <listener_name> would be replaced with the actual listener name configured in the listener.ora file.

For example, if the listener name is LISTENER (default), the parameter would be:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

– Save the listener.ora file

2. Start the TNS Listener from a new LSNRCTL prompt:

lsnrctl <return>

LSNRCTL> start

References :
Note:315720.1
Note 284602.1

RMAN-03002 RMAN-11003 ORA-19906

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/19/2010 14:44:57
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘/u02/oracle/oraarch/TOTEMD/archivelog/2010_05_19/o1_mf_1_26104_5z7ttqww_.arc’
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery

The database refresh failed during recovery. Restore went all good.
Cause:
The backup control file is picking up the wrong incarnation
Solution:
list incarnation;
#Change the database incarnation
RESET DATABASE TO INCARNATION <x>;
recover database until cancel using backup controlfile;
alter database open resetlogs;

ORA-07445 [kkqctdrvJPPD()+2776] [SIGSEGV]

ORA-07445: exception encountered: core dump [kkqctdrvJPPD()+2776] [SIGSEGV] [ADDR:0x0] [PC:0x1BC3E18] [Address not mapped to object] []

SELECT operation cannot be performed on custom views in my case, resulting in above error.  Version affected 11.1.0.7. The view was making use of pushed join predicates.

This ora-7445 is due to the explicitly hint push_predicate in the query because of which optimizer not able to calculate cost correctly.

Possible Workaround

Set any of the following parameters at session level:

“_push_join_union_view” = false

or,

“_optimizer_push_pred_cost_based” = false

or,

“_optimizer_cost_based_transformation” = off

I tried the second one as that helped me.

Please also see Bug 7497640