06 October 2017

REP-0004: Warning: Unable to open user preference file

All Concurrent request completed with below Error.

Error:

REP-0004: Warning: Unable to open user preference file.
REP-0069: Internal error
REP-57054: In-process job terminated:Finished successfully but output is voided

Solution :

I have Checked all necessary permission and access are given already.

Copy of the file prefs.ora in the directory  $ORACLE_HOME/tools/admin to $HOME

$ cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/

Reference : 12: Request Logs Contain the Message "REP-0004: Warning: Unable to open user preference file" (Doc ID 1120529.1)

03 October 2017

ld: 0711-851 SEVERE ERROR: Output file: librw.so The file is in use and cannot be overwritten


Relink report executables failed with below error on AIX 6.1 X64
Error:

$ cd $ORACLE_HOME/reports/lib32
$ make -f ins_reports.mk install
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.a  > librwuso.exp
        rm -f rwsutil.o rwspid.o ;  /bin/ar x /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.a  rwsutil.o rwspid.o ;  (LD_OPTIONS="-zmultidefs";  ld -o /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.so -bM:SRE -bnoentry -bnolibpath  -bE:librwuso.exp rwsutil.o rwspid.o  -lm -lc -lm  -ldl /web03/oratest/apps/tech_st/10.1.2/lib32/libclntsh.a -lpthreads  -L/usr/lpp/X11/lib/R6 -L/usr/lpp/X11/lib/R6/Motif2.1 -lXm -lXt -lX11 -lm `cat /web03/oratest/apps/tech_st/10.1.2/lib32/sysliblist` /web03/oratest/apps/tech_st/10.1.2/lib32/libclntst10.a )
        rm -f zrhitem.o zrhcursor.o;  /bin/ar x /web03/oratest/apps/tech_st/10.1.2/lib32//librw.a zrhitem.o zrhcursor.o
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32/libmmcm.a > temp1.exp
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32/librw.a > temp2.exp
        cat temp1.exp temp2.exp > temp.exp
        sort -u temp.exp > librw.exp
        rm temp1.exp temp2.exp temp.exp
ld: 0711-851 SEVERE ERROR: Output file: /web03/oratest/apps/tech_st/10.1.2/lib32//librw.so
        The file is in use and cannot be overwritten.
make: 1254-004 The error code from the last command is 12.

Stop.
$
Solution:
$ su - root
root's Password:
/etc/profile[61]: q:  not found.
# /usr/sbin/slibclean
# exit
$ cd $ORACLE_HOME/reports/lib32
$ make -f ins_reports.mk install
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.a  > librwuso.exp
        rm -f rwsutil.o rwspid.o ;  /bin/ar x /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.a  rwsutil.o rwspid.o ;  (LD_OPTIONS="-zmultidefs";  ld -o /web03/oratest/apps/tech_st/10.1.2/lib32//librwu.so -bM:SRE -bnoentry -bnolibpath  -bE:librwuso.exp rwsutil.o rwspid.o  -lm -lc -lm  -ldl /web03/oratest/apps/tech_st/10.1.2/lib32/libclntsh.a -lpthreads  -L/usr/lpp/X11/lib/R6 -L/usr/lpp/X11/lib/R6/Motif2.1 -lXm -lXt -lX11 -lm `cat /web03/oratest/apps/tech_st/10.1.2/lib32/sysliblist` /web03/oratest/apps/tech_st/10.1.2/lib32/libclntst10.a )
        rm -f zrhitem.o zrhcursor.o;  /bin/ar x /web03/oratest/apps/tech_st/10.1.2/lib32//librw.a zrhitem.o zrhcursor.o
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32/libmmcm.a > temp1.exp
        /web03/oratest/apps/tech_st/10.1.2/bin/mkexp.sh /web03/oratest/apps/tech_st/10.1.2/lib32/librw.a > temp2.exp
        cat temp1.exp temp2.exp > temp.exp
        sort -u temp.exp > librw.exp
        rm temp1.exp temp2.exp temp.exp
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .memmove
ld: 0711-224 WARNING: Duplicate symbol: .lxsVldStr
ld: 0711-224 WARNING: Duplicate symbol: .kgesec4
ld: 0711-224 WARNING: Duplicate symbol: .kgesec3
ld: 0711-224 WARNING: Duplicate symbol: .kgesec2
ld: 0711-224 WARNING: Duplicate symbol: .kgesec1
ld: 0711-224 WARNING: Duplicate symbol: .kghalp
ld: 0711-224 WARNING: Duplicate symbol: .kglgob
ld: 0711-224 WARNING: Duplicate symbol: .kghgrw
ld: 0711-224 WARNING: Duplicate symbol: .kghalf
ld: 0711-224 WARNING: Duplicate symbol: .kghfrf
ld: 0711-224 WARNING: Duplicate symbol: .kghalo
ld: 0711-224 WARNING: Duplicate symbol: .kgesec0
ld: 0711-224 WARNING: Duplicate symbol: .kglgdn
ld: 0711-224 WARNING: Duplicate symbol: .kglhfr
ld: 0711-224 WARNING: Duplicate symbol: .kglhin
ld: 0711-224 WARNING: Duplicate symbol: .kglini
ld: 0711-224 WARNING: Duplicate symbol: .kglfls
ld: 0711-224 WARNING: Duplicate symbol: .kgldmc
ld: 0711-224 WARNING: Duplicate symbol: .kgldmp
ld: 0711-224 WARNING: Duplicate symbol: .kglaud

Reference : What are the steps needed to Clean up the Libraries during Relinking of Reports on AIX? (Doc ID 834577.1)