TNS-12555: TNS:permission denied
488643Oct 21 2006 — edited Oct 21 2006I recently re-installed ORACLE-XE using the increased swap size method below:
dd if=/dev/zero of=/swapfile1 bs=1M count=600
mkswap /swapfile
swapon /swapfile
it works perfectly until I log out and log back in.
Then http://127.0.01:8080/apex gives a connection refused error. It turns out oracle's startdb.sh is dev/null'ing the error message which was:
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
All my files in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin are:
-r-xr-xr-x 1 oracle dba 68948 2006-02-20 06:31 lsnrctl
protected so I've tried using chmod and chgrp and chown but no success!! I did one time get it to work by logging in as oracle. Then apex worked but my (java) application complained that there wasn't enough swap space.
As I said earlier, when I installed oracle xe everything worked fine. tnsnames.ora & listener.ora are fine so that's not the cause. My problem is I know a lot about oracle but I'm fairly new to linux. I'm using SUSE 10.
Can anyone help.
By the way, how can I see if my swap size change survived a reboot?