Printable View
I installed Oracle on Unix, When I logon as Oracle, I can use SQLPLUS and other tools and utilities.
I created another user on Unix, What should I do to enable this new user to acess Oracle. What setting I have to do in his .profile
I already have Database user created for this user.
Have you granted this user connect and create session privileges?
Nirasha
Hi
I hope you have given proper access for the oracle database user
The changes you have to make to ur .profile for the new unix user are the following
for example
export ORACLE_HOME=/oracle
export PATH=$PATH:/ORACLE_HOME/bin:
export LD_LIBARY_PATH=/ORACLE_HOME/lib
export ORACLE_SID=ORACLESID
Change the above accoring to ur environment
Or
the best thing is try to copy the .profile of Oracle user that is the unix user to the new user's home directory
Regards
Sorry I misread your thread, I did not realise it was an OS user. The user above is absolutely correct, the environment variables need to be the same.
Also you should check that the user is part of DBA/Oracle etc group on UNIX. Tjis ensures that not only does he know where the executables are but also has rights to run them.
Sorry about that.
Nirasha
to finish the thread, if the OS user is in the dba group, he can conenct internal without password
I set all the required environment variables in .profile of root, I logged in in Unix as root (OS USERNAME). When I invoke SQLPLUS, I get the following error,
Enter user-name: ems
Enter password:
ld.so.1: oracleion: fatal: libucb.so.1: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact
It works fine when I logon to Unix as Oracle (OS Username oracle).
Infact, I copied oracle user's .profile to root user's .profile even then I get this message.
Please help me in resolving this.
Check the variable $PATH, check the order of the PATH, if root has more then put them at last, I mean
root's PATH=/bin;/usr/bin;/usr/ucb/bin;/app/oracle/bin.....etc
oracle's PATH=/app/oracle/bin;/usr/bin;/bin;/local/bin
Then =>
root's PATH=/app/oracle/bin;/usr/bin;/bin;/local/bin;/usr/ucb/bin;...etc
I guess the problem is ucb path
I think the easiest way to setup your environment is to source the oraenv (or coraenv) file in $OH/bin
As I mentioned earlier, even If I copy the .profile of user "oracle" with right settings and for this user everything is working fine to root user's .profile the error following message comes,
Enter user-name: ems
Enter password:
ld.so.1: oracleion: fatal: libucb.so.1: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact
Hi
Just try this from root user
sqlplus username/password@oraclesid
replace username with ur db username
replace password with ur db password
replace oraclesid with ur sid
There are lot of issues like urs in metalink
Regards
Thank you Santosh and all for your cooperation. It worked using SQLNET.
Sharad
Thats the work around which works with no doubt... If you want it as Unix user connecting to Oracle with no SQLNET service name, you have to troubleshoot your environment profile as other members suggested.