ld.so.1: sqlplus: fatal: relocation error: file ……/lib/libnnz10.so: symbol nltrc_entry: referenced symbol not found
Posted: February 29, 2012 Filed under: ORACLE | Tags: /lib/libnnz10.so, /lib/libnnz10.so: symbol nltrc_entry, /lib/libnnz10.so: symbol nltrc_entry: referenced symbol not found, error, fatal, HOW TO, ld.so, ld.so.1, ld.so.1: sqlplus, ld.so.1: sqlplus: fatal, ld.so.1: sqlplus: fatal: relocation error, lib, libnnz10, libnnz10.so, nltrc_entry, ORA, oracle, referenced symbol not found, relocation error, sqlplus, sqlplus: fatal, sqlplus: fatal: relocation error, symbol nltrc_entry Leave a comment »Hi,
Probably you did not set your env. variables at all or correctly.
so, set these in your ~/.profile / ~/.bash_profile:
export ORACLE_BASE=/oracle/product/11.2.0
export ORACLE_HOME=$ORACLE_BASE/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=MUSDB
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin
try and pray 
ORA-01839 : DATE NOT VALID FOR MONTH SPECIFIED
Posted: February 29, 2012 Filed under: ORACLE 2 Comments »
Hi,
When adding interval to sysdate be careful.
sysdate type is date and you add timestamp. For example when you run this on 29.02.2012,
select trunc(sysdate) + interval '3' year from dual;
you will see:
ora-01839 : date not valid for month specified
solution:
–add months
select add_months(trunc(sysdate),36) from dual;
try and pray
HOW TO REMOVE APEX FROM DATABASE
Posted: February 23, 2012 Filed under: ORACLE Leave a comment »
Hi,
You can remove apex using apex remove script on oracle databases.
like this:
SQL> @?/apex/apxremov
Do not forget to utlrp:
SQL> @?/rdbms/admin/utlrp
try and pray
INF – ORA-19575: expected …….. blocks in file ………….., found ……..
Posted: February 1, 2012 Filed under: ORACLE Leave a comment »
Hi,
Probably one or more arc. files are backup up but con not be deleted.
When you lsof file, you may not see anything.
1)
Backup arc file:
$ cp file1.arc file1.arc.old
2)
remove arc file as a superuser:
# rm file1.arc
3)
RMAN> crosscheck archivelog all;
4)
* run archive backup.
try and pray
