Wednesday, 30 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.


Wednesday, 9 April 2014

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'