Xref: alice comp.databases.oracle.server:33545 Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!newsfeed.cwix.com!206.63.63.70!nwnews.wa.com!brokaw.wa.com!not-for-mail From: Dan Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Enterprise Manager Questions? Date: Wed, 11 Nov 1998 11:13:19 -0800 Organization: EXE Lines: 24 Message-ID: <3649E1CF.24ECD5EF@exesolutions.com> References: <363F8415.7EDD2BC5@agentsystems.com> Reply-To: dmorgan@exesolutions.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.06 [en] (WinNT; I) To: development@agentsystems.com > 1) If I have one main database for my application, do I need a > repository database? Enterprise Manager will build it on start-up. You do not need to worry about this. > 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. Check the LISTENER.ORA file and make sure that you have an entry for each database. Then bounce the listener. > 3) What is the quickest way to set up an ODBC connection to this database? Unless your front-end tool demands it (for example VB) I would avoid it. ODBC is insecure, slow, buggy, and . . . well ugly. If you must use ODBC try setting it up on your server rather than on the clients. Daniel A. Morgan