Re: Oracle8i on SOLARIS 8 login question

Just to claify, you don't set your sid in the tnsnames.ora. That file is only used if you are using Net8. You would do that if you need to connect from some machine other than the one where the database is installed.

sqlplus system/manager_at_dbname.

if you just want to connect from the same machine as the database you can do so with the following.

export ORACLE_SID=SIDNAME

sqlplus system/manager

--
rfazio_at_home.com
http://24.8.218.197/
"Jim Bromhal" <jbromh1_at_gl.umbc.edu> wrote in message
news:Pine.SGI.4.10A.B3.10004021939160.10972840-100000_at_umbc8.umbc.edu...


> It looks like you have yet to set up your TNSNAMES.ORA file.  That's where

> the SID is set.

>

> jim

>

> On Sun, 2 Apr 2000, Don Woodward wrote:

>

> > Need help - just installed Oracle8i on SOLARIS 8 and can't get logged

 into


> > SQLPLUS...

> >

> > During install, it told me the default password was "change_on_install".

 Any


> > ideas?

> >

> >

 ============================================================================


> > ============

> > # sqlplus

> >

> > SQL*Plus: Release 8.1.5.0.0 - Production on Sun Apr 2 17:39:33 2000

> >

> > (c) Copyright 1999 Oracle Corporation.  All rights reserved.

> >

> > Enter user-name: system

> > Enter password:

> > ERROR:

> > ORA-07200: slsid: oracle_sid not set.

> >

> >

> > Enter user-name:

> >

> >

 ============================================================================


> > ==============

> >

> > Don Woodward

> > dbwoodw_at_abraxis.com

> > www.sunsunsun.net

> >

> >

> >

> >

> >

> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----

> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!

> > -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

> >

> >

>

> Jim Bromhal

> bromhal_at_world-net.net

> www.world-net.net/home/bromhal

>

>