Re: Enterprise Manager Questions?

Evan,

First thing is, you have to use SQL*Net with OEM to connect to other databases
You can not use ODBC.

Secondly, you have to configure
the SQL*Net (or Net80) in your client
system to access other databases
on the Network. This can be done
by using SQL*Net Easy Config utility

For this, you need a database alias
(a nome to recognize the remote
database), Protocol name
(such as TCP/IP), hostname or IP address and the port number on which the
remote listener is listening

With these details, you can configure
SQL*Net

HTH Good luck,

Madhu Cherukuri

development_at_agentsystems.com wrote:

> I have installed the Oracle 8 Enterprise Edition version 8.0.4.0.0 and
> have started learning the database administration.
>
> I ultimately need a database on the server that is accessible by a
> number
> of computers that are located on the network. I plan to connect to the
> database
> using ODBC.
>
> Now, I have a few questions.
>
> 1) If I have one main database for my application, do I need a
> repository
> database? The manual states that a repository database must be located
> on a separate computer and I would prefer to simply keep everything that
> is
> database related on the same server.
>
> 2) I created a new database called "EVAN". When I attempt to connec to
> this
> database I continually recieve ORA-12154... TNS could not resolve
> service name.
> I see that the database has been started. I get the same message with
> tye ORCL
> database.
>
> 3) What is the quickest way to set up an ODBC connection to this
> database?
>
> Thanks for any help,
> Evan
Received on Tue Nov 03 1998 - 17:10:14 CST