Unable to clone RAC to non-RAC database ora-01003 no statement parsed

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: Unable to clone RAC to non-RAC database ora-01003 no statement parsed

Clone the database gave the below error:

It errors ora-01003 error.

Solution:

Set

_no_recovery_through_resetlogs=TRUE

References:

Note 409045.1 - How To Clone From Rac To Non-Rac In Oracle Applications 11i. .
Note 334899.1 - RMAN Duplicate from RAC backup fails ORA-38856

Get Oracle Certifications for all Exams
Free Online Exams.com

ldap_bind: Invalid credentials,Orion Launcher Could not get OID connection javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

When login to SSO page we get unexpected error

Error:

OID HOST:
OID PORT: 389
SSO SERVER DN: orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=
OracleContext
OID USE SSL: N
SSO SERVER PASSWORD: Tl5cvq1x

ldapbind -h hostname -p 389 -D
orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=OracleContext
-w Tl5cvq1x
ldap_bind: Invalid credentials

ssoServer.logs

[ERROR] Orion Launcher Check the OID server, hostname:389 availability
Wed May 20 16:15:24 GMT+04:00 2009 [ERROR] Orion Launcher Could not get OID connection
javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]

Explanation:

Incorrect configuration between SSO and OID server.

Solution:

Define correct password at OID level for orclApplicationCommonName=ORASSO_SSOSERVER

1.       Open oidadmin tool and login as orcladmin user.

2. Navigate to:

From "Entry Management" Click "cn=OracleContext"
Then "cn=Products"
Then "cn=sso"
Do click on orclApplicationCommonName=ORASSO_SSOSERVER

Look in the right frame attribute userpassword it appears hide. So retype
password Tl5cvq1x and do click on “Apply” button.

3. Restart components on infra:

opmnctl stopall
opmnctl startall

4. Test ldapbind in command prompt:

/u01/vatdev/m2poc_oid/bin/ldapbind -h hostname -p 389 -D
orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=OracleContext
-w Tl5cvq1x

5. If that work then try to authentication using SSO and DAS:

http://hostname:7778/pls/orasso
http://hostname:7778/oiddas

References:

Note 315534.1 - How to Verify that SSO can Communicate with OID

Get Oracle Certifications for all Exams
Free Online Exams.com

How patches are applied when you have shared appltop?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How patches are applied when you have shared appltop?

When you have you apps environment on two nodes with a shared appltop

Database --- Two node RAC Instance.
Application --- Two node with shared APPL_TOP.

Explanation:

You need to apply the patch on admin node on shared APPL_TOP and run the auto-config on other node only. 

    

Get Oracle Certifications for all Exams
Free Online Exams.com

FAILED: file fwk_tbx_lookup_types_tl.xdf on worker 1 while applying RUP 6

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

After merging the pre_req  ,RUP6 and post-req patches together and apply the new merged patch,  

We got the below Error while applying RUP6.
we are running this patch using adctrl distributed=y.

FAILED: file fwk_tbx_lookup_types_tl.xdf on worker 1.
FAILED: file fwk_tbx_lookup_codes_b.xdf on worker 2.

Note DOC ID 5347952 did not help

Solution:

merge the pre-req patches alone and apply it then apply the RUP6 patch and then apply the post-req patches

apply the pre-req patches alone first and then apply the RUP6 patch and check whether issue got resolved or not

if it does not work, do the below:


1. Run scripts manually:

adjava -Xmx512M -nojit oracle.apps.fnd.odf2.FndXdfCmp ak ak apps apps_pwd
thin
"(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=<i.e. us.oracle.com>)(PORT=<db_por
t#>)
(CONNECT_DATA=(SERVICE_NAME=<i.e oracle.com)(INSTANCE_NAME=<SID_NAME>)))"
table
<full path to $FND_TOP/patch/115/fwk_tbx_lookup_types_tl.xdf
<full path to $FND_TOP/patch/115/xdf_xsl

adjava -Xmx512M -nojit oracle.apps.fnd.odf2.FndXdfCmp ak ak apps apps_pwd
thin
"(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=<i.e. us.oracle.com>)(PORT=
<db_port#>)
(CONNECT_DATA=(SERVICE_NAME=<i.e oracle.com)(INSTANCE_NAME=<SID_NAME>)))"
table
<full path to $FND_TOP/patch/115/fwk_tbx_lookup_codes_b.xdf
<full path to $FND_TOP/patch/115/xdf_xsl

2. Run adctrl and skip failed workers;

3. Continue adaptch;

Replace the entries by the ones from your environment.

    

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-01578: ORACLE data block corrupted on a Dictionary Table

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: ORA-01578: ORACLE data block corrupted  

We got the corruption on “trigger$” table in system tablespace,

 dbv found one block got corrupted.
 database got crashed and unable to start.
trigger$ table got corrupted,we used _system_enabled_trigger=false

 We can use hidden parameter _system_enabled_trigger=False and restarted the database.

Alert log file:

Mon Apr 27 15:06:01 2009
Errors in file /bdump/sid_ora_19549.trc:
ORA-12012: error on auto execute of job 7382
ORA-01578: ORACLE data block corrupted (file # 3, block # 91063)
ORA-01110: data file 3: '/system03.dbf'
Mon Apr 27 15:07:02 2009
MMON: terminating instance due to error 472
Instance terminated by MMON, pid = 7586

Solution:

When a dictionary table is corrupted the only valid option is restoring and recovering from a backup besides there is no way to recreate the dictionary

Can’t use DBMS_REPAIR against dictionary tables

Information at dictionary level cannot be ignored. It could cause other issues. Using DBMS_REPAIR against dictionary tables causes logical dictionary corruption

    

Get Oracle Certifications for all Exams
Free Online Exams.com

RC-20200 Fatal: Could Not Find Unzip

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


While installing Oracle apps R12, the below error occur:


...
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
...

Solution

To resolve this error, ensure that the version of the "unzip" utility is equal or greater than "5.5.2" and less than version "6.0" (but not equal to "6.0").


    

Get Oracle Certifications for all Exams
Free Online Exams.com

Rapidwiz is failing with error 'Unable to validate apps user/group

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

When attempting to perform a Multi - Node Install of the E-Bsuiness Suite Release 12.1.1 , the Rapidwizard is failing for the DB-Tier with error :

...
Unable to validate apps user/group applmgr/dba Provide a valid apps user/group for the installation
...

Explanation:


Rapidwiz is validating the Username of the APPS-Tier on the DB-Tier Server, although the APPS-Tier Server resides on a different node. The APPLMGR User is created with a valid Username and belonging to the correct group on the APPS-Tier Server.

Example :
Server 1 = DB-Tier Node : username oracle group dba
Server 2 = APPS-Tier Node : username applmgr group dba

Solution:

Solution

To get this failure fixed, please implement following Workaround :

1.) Create a new User with the name 'applmgr' on DB node.

2.) Add the new User 'applmgr' to the group 'dba'.

3.) Start the Rapidwizard for the Multi-Node-Installation again.

Get Oracle Certifications for all Exams
Free Online Exams.com