-
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
Nirasha Jaganath
-
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
Santosh
-
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
Nirasha Jaganath
-
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
Jeff Hunter
-
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
Santosh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|