| make oracle available for other clients [message #139227] |
Mon, 26 September 2005 22:28  |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
Hi all, i have an oracle 9i on a solaris 10 machine. I do not know how to make oracle available for other clients and also other users on the same machine. I put the ORACLE_SID and PATH in the .profile of the users but it says permission denied. Can anyone help me out in doing this.
Thanks a lot .....
|
|
|
|
| Re: make oracle available for other clients [message #139294 is a reply to message #139227] |
Tue, 27 September 2005 04:56  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Never done that but I am trying ,
Its fine that you changed the .profile settings of other users i.e. ORACLE_HOME, ORACLE_SID etc. But did you change the group of other users as of oracle user.
I think that is also needed because one should belong to the same group to use the executables.
Try this out and you might get a solution.
regards,
tarun
|
|
|
|
| Re: make oracle available for other clients [message #139303 is a reply to message #139294] |
Tue, 27 September 2005 05:42 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Rock
>>i have an oracle 9i on a solaris 10 machine. I do not know how to make oracle available for other clients and also other users on the same machine.
Well as per your question .....that what i understand....
If your database is on solaris o/s one machine(i.e server) and you want to connect your database from client machine then you have to configure client machine TNSnames.ora file (i.e client side configuration to connect to database) client can be on any operating system. but there will be tnsname.ora at client machine.
Regard
Always Friend sunilkumar.
|
|
|
|
| Re: make oracle available for other clients [message #139598 is a reply to message #139227] |
Wed, 28 September 2005 14:54 |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
Thanks for your replies guys, i am sorry i wasnt clear. At first my requirement was to connect to the server from a client but now i dont have to that but just the users who are in the machine should use oracle. For that i changed the .profile of the test user. It also belongs to the oracle dba group. The .profile file is as follows
ORACLE_BASE=/export/home/oracleuser
export ORACLE_BASE
DBA=$ORACLE_BASE/admin
export DBA
ORACLE_HOME=$ORACLE_BASE
export ORACLE_HOME
SQL=$ORACLE_HOME/sqlplus
export SQL
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
ORACLE_SID=aero
export ORACLE_SID
ORACLE_TERM=xterm
export ORACLE_TERM
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_NLS33
LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
export LD_LIBRARY_PATH_64
PATH=/usr/bin:/usr/ucb:/etc:.
PATH=$PATH:$ORACLE_HOME/bin
export PATH
umask 022
oracle works fine for the oracleuser in which i installed and configured oracle but for a test user when i type the sqlplus command it gives a command not found error at the console.
Could you please help me out with this one.
Thanks for your replies again guys ......
|
|
|
|
| Re: make oracle available for other clients [message #139674 is a reply to message #139598] |
Thu, 29 September 2005 02:26 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
First connect to the database by sysdba throung SQL*Plus
then at SQL prompt
SQL>Grant sysdba to test;
i think you have to grant this right to test;
If required you have to grant connect and resources to test so that test user can connect to the database and work with the resources.
I hope your work should be done by my information
Regards
Always friend sunilkumar.
|
|
|
|
| Re: make oracle available for other clients [message #139695 is a reply to message #139674] |
Thu, 29 September 2005 04:03 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
@sunil
If you are granting some user sysdba, then you dont need to specifically grant connect & resource to user.
@rock
You need to add $oracle_home/bin in your path.
Also, are you using OS authentication? If no, then in tnsnames.ora specify the service identifier & use same in connect string. eg conn a/b@<sid>
--Girish
|
|
|
|
| Re: make oracle available for other clients [message #139698 is a reply to message #139695] |
Thu, 29 September 2005 04:14 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hi to all,
Girish :
After a long time , probably enjoyed leaves.
| Quote: |
You need to add $oracle_home/bin in your path.
|
i think its already added
| Quote: |
PATH=/usr/bin:/usr/ucb:/etc:.
PATH=$PATH:$ORACLE_HOME/bin
|
and i am confused , you and sunil are talking about grant sysdba, connect, resource but as i am understanding it , its quite different
| Quote: |
rockwell: oracle works fine for the oracleuser in which i installed and configured oracle but for a test user when i type the sqlplus command it gives a command not found error at the console.
|
Mean to say an OS user is not able to use Oracle or i should say not able to use sqlplus.exe , might be due to insufficient privileges . ( all correct me if wrong )
The problem of connecting to Oracle is a later issue , initially other OS users are not able to access sqlplus.exe.
thanks & regards,
tarun
|
|
|
|
| Re: make oracle available for other clients [message #139700 is a reply to message #139698] |
Thu, 29 September 2005 04:21 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi Tarun
The first reply
@sunil
If you are granting some user sysdba, then you dont need to specifically grant connect & resource to user.
was for Sunil's comment.
For second reply:
Rock said...oracle works fine for the oracleuser in which i installed and configured oracle but for a test user when i type the sqlplus command it gives a command not found error at the console.
For user "test" the path should be having $oracle_home/bin entry, otherwise it'll face this issue.
--Girish
|
|
|
|
| Re: make oracle available for other clients [message #139845 is a reply to message #139598] |
Thu, 29 September 2005 16:22 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
rockwell,
Please forgive my ignorance.
I am lost between the posts.
You still have problem?
Post the exact error message.
And DO-NOT-ADD the other OS user (test) to dba group ( dba/oinstall groups are dedicated for DBA's.)
Not for regular users.
ELSE
with a little knowledge, the regular user test, can bring down your database and do any harm.
In this session,
mahesh is a regular user in dba group.
You can see that, the user can startup/shutdown the database.
If you can live with these consequences, you can add a regular user to dba group.
#############
#first i login as mahesh from oracle
#then set my profile.
#just checking..whether i am in dba group
#with dba group privilege, i can login as sysdba and do whatever i want.
#like
#startup/shutdown ....
##############
oracle@hemlock#su - mahesh
Password:
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001
> bash
bash-2.03$ . .profile
bash: cd: scr/ora: No such file or directory
mahesh@hemlock#touch a
mahesh@hemlock#ls -lrt
total 0
-rw-r--r-- 1 mahesh dba 0 Sep 29 16:57 a
mahesh@hemlock#sqlplus '/as sysdba'
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Sep 29 17:08:01 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> shutdown abort;
ORACLE instance shut down.
|
|
|
|
| Re: make oracle available for other clients [message #140819 is a reply to message #139227] |
Wed, 05 October 2005 14:25 |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
Hey all, thanks for your replies guys, i solved the problem by setting the oracle environment by adding the line . /usr/local/bin/oraenv in the .profile file of the user and oracle is working for the users. I guess what i did was right, i dont know if it has any security issues.
One other thing i am facing now is(its not a issue but just want to know how to remove it) when i open a new console for a user it asks me ORACLE_SID=[sigma]? at the command prompt though i set the ORACLE_SID to sigma in .profile file. I guess its asking me to set the ORACLE_SID if its not sigma (I may be wrong too). Can any one help me in this.
Thanks a lot for your replies you all ....
rock
|
|
|
|
|
|
| Re: make oracle available for other clients [message #141128 is a reply to message #139227] |
Fri, 07 October 2005 01:42 |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
If the value is set in the .profile file it shows the correct value in the bracket and then asks for anew value if any. The following line looks similar to it
#ORACLE_SID=[sigma]?
sigma is the value set for oracle_sid in the .profile file, but i dont know why is it prompting at the console again.
|
|
|
|
| Re: make oracle available for other clients [message #141130 is a reply to message #141128] |
Fri, 07 October 2005 02:08 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| rockwell wrote on Fri, 07 October 2005 12:12 |
#ORACLE_SID=[sigma]?
|
In *Unix environment "#" is used for commenting a line so whenever one login as the above user , this line is treated as a comment and not read by Unix.
and one more thing , i dont think that there is a need to enclose sigma in [] .
regards,
tarun
[Updated on: Fri, 07 October 2005 02:23] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
