From: "EB" Newsgroups: comp.databases.oracle.server References: <3B1E2D4F.485660B2@mindspring.com> Subject: Re: help connecting to database Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Wed, 06 Jun 2001 19:31:47 GMT NNTP-Posting-Host: 12.9.200.149 X-Complaints-To: abuse@earthlink.net X-Trace: newsread2.prod.itd.earthlink.net 991855907 12.9.200.149 (Wed, 06 Jun 2001 12:31:47 PDT) NNTP-Posting-Date: Wed, 06 Jun 2001 12:31:47 PDT Organization: EarthLink Inc. -- http://www.EarthLink.net X-Received-Date: Wed, 06 Jun 2001 12:29:50 PDT (newsmaster1.prod.itd.earthlink.net) You should be able to login as system/manager or sys/change_on_install. 1) Check to make sure your TNS listener is running: ps -ef |grep tns 2) If it's not running, try to start it login as oracle lsnrctl start 3) If it still does not start, check your tnsnames.ora file, which should be located in $ORACLE_HOME/network/admin "Peter Choe" wrote in message news:3B1E2D4F.485660B2@mindspring.com... > i was able to install Oracle 8i on a freebsd machine. at least i think > it installed correctly. > > but when i tried to use sqlplus to try to connect using scott/tiger i > get an error saying ORACLE is not available. > > how do i make it available? or what id can i use? i run it as oracle > user, the same user that i installed oracle with. > > peter choe