This content has been marked as final. Show 14 replies
Thanks for your reply.
I have changed the file permissions of +- 5 files in the lib directory, every time that I changed the permission of 1 file, I got an error for another one.
Now I am getting the following error
[pemarten@orclserv ~]$ sqlplus pemarten/mypasswordAccording to oerr there are still lib files with wrong permissions...
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
What I would like to know is :
1) Are the file permissions changed in 10.2 (only DBA's can use sqlplus on the database server) ? If not I probably did something wrong and I will do a reinstall
2) Can anyone who has version 10.2 installed post an ls -l of his $ORACLE_HOME directory please, so I can compare the file permissions ?
The first time - when sqlplus not found - is a path problem. If you can execute a file, the "which" command will tell you if that file is in your path. If the file is in your path, is it executable? As "oracle" (the owner of the sqlplus file), set the permissions to 755. Then do ls -la sqlplus and note the "-rwxr-xr-x" in the first column. The last "x" means "others" have execute permission.
Try this out - remove $ORACLE_HOME/bin from your path statement and then try invoking sqlplus. Then try invoking it via $ORACLE_HOME/bin/sqlplus and note difference. Add $ORACLE_HOME/bin back to your path statement (environment variable - and don't forget to source the profile file each time).
it is bug 4516865
go to metalink and download and apply patch
Message was edited by:
Thank you so much. I am trying to install 10g at my home, reinstalled at least 5, 6 times, thinking it was a problem with my installation steps and finally I searched internet and found this.
Can we download the patches for free (for home usage)?
Right now as I do not have the ability to download the patch (I tried, but it seems require a subscription), I have used the following command and able to work from accounts other than 'oracle', as you suggested.
chmod -R a+rX $ORACLE_HOME
good morning everybody,
i installed oracle 10gr2 on rhel4 and everything worked fine after the installation.
after rebooting my machine i got the message : bash: sqlplus: command not found.
i tried chmod -R a+rX /usr/oracle/product/10.2.0/db_1 ($ORACLE_HOME) but in vain , i had the same message again, i haven't got a metalink account (i live in morocco & i couldn't join them by phone)
Please, please can anyone help me for setting permissions or downloading the patch.