Tuesday, April 5, 2011

Unable To Alter User Xxint To Change Password App-Fnd-02704

Unable To Alter User Xxint To Change Password App-Fnd-02704

Follow the metalink Note ID : [ID 753872.1]

FNDCPASS Failing When Using Underscore, Comma, Dollar Sign


Why is FNDCPASS Failing When Using Underscore, Comma, Dollar Sign, and Parentheses as Passwords?
 
Follow the metalink Note ID [ID 553807.1]

How to Generate AUDIT and NOAUDIT Statements

SCRIPT: Generate AUDIT and NOAUDIT Statements for Current Audit Settings

Please follow the metalink Note ID [ID 287436.1]

Friday, April 1, 2011

ld.so.1: rman: fatal: relocation error

unable to connect to RMAN with the following error

ld.so.1: rman: fatal: relocation error: file /opt/app/oracle/product/10.2.0/db_2/bin/rman: symbol kgslctx_: referenced symbol not found
Killed


Reason: LD_LIBRARY_PATH not set 
Solution:

Set the library  path in the .profile for the changes to become permanent.

export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

and then execute the rman command

NODE:TEST:/ora/admin>rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Apr 1 09:42:12 2011

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

connected to target database:TEST (DBID=3415316409)

RMAN> exit

Recovery Manager complete.

DBV-00600: Fatal Error - [21] [2] [0] [0]

While I was performing a test restore of one of the datafiles, encountered the  following error when  checking the integrity of the file.
NODE:TEST:/ora/admin/testrestore>dbv  file=TEST_get_file_test.f

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:47:34 2011

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

DBV-00600: Fatal Error - [21] [2] [0] [0]

I have searched metalink for 10.2.0.5  nothing turned  up there is a solution for the same Bug if it appears in 11.1.0.6  - [ID 731546.1]

But I have found the below solution for 10.2.0.5 and it worked.

Solution: 
Provide the full path of  the file even though you are in the same location doesnt matter  you mention the blocksize or not but good to mention

NODE:TEST:/ora/admin/testrestore>dbv file=/ora/admin/testrestore/TEST_get_file_test.f blocksize=8192

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:59:16 2011

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

DBVERIFY - Verification starting : FILE = /ora/admin/testrestore/TEST_get_file_test.f


DBVERIFY - Verification complete

Total Pages Examined         : 64000
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 14
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 63986
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 249167 (0.249167)

.