• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

configuring an Oracle 9i Database Server

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
janbaztaimoori
Just Arrived
Just Arrived


Joined: 04 Nov 2006
Posts: 0
Location: Pakistan

Offline

PostPosted: Thu Mar 08, 2007 11:56 am    Post subject: configuring an Oracle 9i Database Server Reply with quote

I have small domain network with 25 computers.
Server Computer has Windows Server 2003 Installed on it.
I have installed Oracle 9i Server on this server and also on the client machines.
I want to configure the Server so that my clients can connect to it. What is the easiest way to do that.
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
Groovicus
Trusted SF Member
Trusted SF Member


Joined: 19 May 2004
Posts: 9
Location: Centerville, South Dakota

Offline

PostPosted: Thu Mar 08, 2007 3:22 pm    Post subject: Reply with quote

IS there some application that the clients have that uses the database, or do you just want them to have raw access to it?
Back to top
View user's profile Send private message Visit poster's website
janbaztaimoori
Just Arrived
Just Arrived


Joined: 04 Nov 2006
Posts: 0
Location: Pakistan

Offline

PostPosted: Fri Mar 09, 2007 7:28 am    Post subject: a little more explaination Reply with quote

Please don't mind dear but would u like to tell me what are those applications that uses database. Embarassed

And the answer to your question is that no there are no applications. I just want them to access the default example database that is installed with the installation of Oracle 9i using SQL*Plus or SQL Worksheet.
Actually i am preparing for OCP on self Study basis coz i don't have any teacher available here. And this is my 1st experiance in Oracle products.
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
Groovicus
Trusted SF Member
Trusted SF Member


Joined: 19 May 2004
Posts: 9
Location: Centerville, South Dakota

Offline

PostPosted: Sat Mar 10, 2007 7:07 pm    Post subject: Reply with quote

There could be any number of applications that would access a database. Forums such as this use a database, biomedical research, accounting, medical field.

Anyway, in a nutshell, your users must have access rights to the database, or some portion of the database. I don't know how to configure SQL*Plus (I can't imagine that someone would really use this). At least with the SQL Worksheet, there does not appear to be any sort of network capabilities.

When I want clients to be able to access my database remotely, I either do it through a web-application, and all of the access is done server side, or I do it with an application that includes a database connector of some kind. For instance, Java applications use connectj for connecting to MySql. Oracle probably has their own proprietary connector.

In your scenario, there needs to exist some application or script that knows how to connect to the database.

Sorry I can not be more specific, but I am extrapolating from my experience which may or may not be applicable.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!
View a sample newsletter.

Become a WindowsNetworking.com member!

Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter