| access oracle database on a server [message #145921] |
Mon, 07 November 2005 13:20  |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
Hello all, i have a small question about how to access database remotely, I will explain my system. I am a assistant database administrator in a school. I have a server X where the user information is stored(user login), i was given a diferent machine for installing and configuring oracle and i set it up. Now the problem is users have a different user names and passwords in both the servers. Now to use oracle in a web application the users cant access oracle as they have the java libraries on X and also the user information.
Now if i install oracle client on X server does it allow the users to access oracle server Y.
I think my post is a bit confusing, could anyone please help me out.
Thanks in advance.
|
|
|
|
| Re: access oracle database on a server [message #145979 is a reply to message #145921] |
Mon, 07 November 2005 23:26  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
From the description you gave, it looks that both Server X and Y have ORACLE installed on it ( if i am getting right) .
And if this is correct then you dont need to install Oracle Client on Server X but just need to configure
-- Listener on Server Y.
-- Net Service on Server X.
Read the Documentation related to SQL *net .
regards,
tarun
|
|
|
|
|
|
| Re: access oracle database on a server [message #145986 is a reply to message #145982] |
Tue, 08 November 2005 01:14 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Installing Oracle Client on Server X should do the job.
After installing client , configure
-- Listener on Server Y.
-- Net Service on Server X.
and then use this net service to access Oracle Database on Server Y.
|
|
|
|
|
|
| Re: access oracle database on a server [message #145990 is a reply to message #145986] |
Tue, 08 November 2005 01:34 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Install oralce client on server X & then in tnsnames.ora file on server x make the following entries:
<Identifier you want> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <IP of Server Y>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <SID on Server Y>)
)
)
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
