How Unix user can Access Oracle

[Sharma]

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.

[nirasha]

Have you granted this user connect and create session privileges?

Nirasha

[santoshym]

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

[nirasha]

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

[pipo]

to finish the thread, if the OS user is in the dba group, he can conenct internal without password

[Sharma]

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.

[rcaballe]

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

[marist89]

I think the easiest way to setup your environment is to source the oraenv (or coraenv) file in $OH/bin

[Sharma]

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

[santoshym]

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