Re: For Daniel Morgan

LouisD wrote:

> <snipped>
>
>
> So what I really need advise on is how do I set up the puers so that the
> computers on the network conect to the on edbase where the
> tables/entities/attributes are located.
>
> You have helped me before for which a thousand thanks.
>
> Thanks

On the client machine, go to the \net80\admin directory and insert an entry into tnsnames.ora that points to the server. It will just be the following for 8i.

<database_alias> =

   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SID = <sid_name>)
     )

The database_alias can be anything you want The host is the name or IP address of the server The sid name is the instance name you are connect to

BTW: We do not have any lab at UW for students to use with Oracle. All students have their own copy of the database, etc. on their own machines which provides them with not only far more flexibility but far more experience. They get to install, configure, destroy, and have full SYS privileges to explore at a level impossible with a shared server.

[Quoted] I hope the above helps.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)