On the new rebuild database servers - after installing oracle crs/asm 11.2.0.1 and oracle rdbms binary for 10.2.0.1, 10.2.0.2 and 11.2.0.1 + apply 11g rdbms patches.

We got this error when trying to open the database under 10g environment variable

ALTER DATABASE   MOUNT

Sat Jun 11 12:09:03 2011

ORA-00202: control file: '+SID_DBF_DG/SID/controlfile/current.355.714385251'

ORA-17503: ksfdopn:2 Failed to open file +SID_DBF_DG/SID/controlfile/current.355.714385251

ORA-15001: diskgroup "SID_DBF_DG" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Manager

Cause

The reason here is that the cluster configuration in 11gR2 is dynamic. This dynamic configuration is incompatible with older database releases, which require a fixed configuration.

Solution

To run older databases on 11gR2 ASM and Clusterware you need to create a persistent configuration for the nodes on which these databases are meant to run. This is called pinning a node.


Metalink Note :949073.1 

Error while compiling reports in Custom Top | Oracle EBS version 12.1.3

 $ rwconverter.sh userid=apps/apps_password source=$XXCUSTOM_TOP/reports/US/XXCCUSTOM.RDF stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes

Report Builder: Release 10.1.2.3.0 - Production on Tue Jul 19 20:05:49 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter Username: apps
Enter Password:
Enter Username: apps
Enter Password:
REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0309: Unable to connect to the specified database after three attempts. Access denied.


Solution :
Do Not Compile EBS R12 Reports Using rwconverter.sh or Reports Builder from IDS 10gR2 (Doc ID 786794.1)
Using the OracleAS 10.1.2 Forms and Reports Builders with Oracle Applications Release 12 (Doc ID 444248.1)

Steps :

$ unset DE_DISABLE_PLS_512
$ unset EVENT_10932


comment out the following in reports.sh

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG