Posted: Thu Mar 08, 2007 11:56 am Post subject: configuring an Oracle 9i Database Server
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.
Posted: Fri Mar 09, 2007 7:28 am Post subject: a little more explaination
Please don't mind dear but would u like to tell me what are those applications that uses database.
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.
Joined: 19 May 2004 Posts: 9 Location: Centerville, South Dakota
Posted: Sat Mar 10, 2007 7:07 pm Post subject:
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.
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