Posts

Showing posts from April, 2014

renice oracle

bash-2.05# renice -n -19 -u oracle bash-2.05# renice -n -19 -p 5022 renice -10 -u oracle

nls_date_format showing only DD-MON-RR

On a particular server , select sysdate from dual was showing only DD-MON-RR not full time stamp . when i checked the nls_date_format , it was set as :- nls_date_format                      string      DD-MON-RR HH.MI.SS AM The issue was with parameter file in which the following parameters were set :- *.fixed_date='2014-05-02' and *.nls_date_format='DD-MON-RR HH.MI.SS AM' then , I commented the *.fixed_date='2014-05-02' and reset the nls_date_format and bounce the DB.

sqlplus: error cannot restore segment prot after reloc: Permission denied

Problem : sqlplus: error while loading shared libraries: /opt/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied The server is Suse Linux . Solution:- [root@localhost ~]# chmod -R 777  /opt/oracle [root@localhost ~]# chown -R oracle:oinstall /opt/oracle [root@localhost ~]# chcon -t textrel_shlib_t '/opt/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1'