Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbe help please

Re: newbe help please

From: Mark McHugh <mchugh.mark.ma_at_bhp.com.au>
Date: 27 Aug 1998 05:50:19 GMT
Message-ID: <01bdd17d$ea5ca820$5c471286@fpdwol-pc4325.itwol.bhp.com.au>


If you are trying to connect with the enterprise manager, what I said below about sqlplus client also applies, however you can also get the error if your PC is running out of memory.

Mark McHugh <mchugh.mark.ma_at_bhp.com.au> wrote in article <01bdd15e$59eedfc0$5c471286_at_fpdwol-pc4325.itwol.bhp.com.au>...
> me also too. Are you logging on to SQLplus using the PC client program or
> directly on your server ?
>
> If on my pc client sqlplus program, the error you described:
>
> ERROR: ORA-03121: no interface driver connected - function not performed
>
> comes up when I don't put in the host string - ie, when the log on
dialogue
> box comes up, I have to type in a username, password and a host string.
In
> my case that is either DIDD is DIDS, the two database instances on our
> Oracle server. If Oracle client has been installed properly on your PC,
> these should have been defined in a file called tnsnames.ora on your PC.
On
> mine it looks like this :
>
> dids.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcpcom.world)
> (PROTOCOL = TCP)
> (Host = scwudids.scpdwol.bhp.com.au)
> (Port = 1525)
> )
> )
> (CONNECT_DATA =
> (SID = dids)
> (GLOBAL_NAME = dids.world)
> )
> )
>
> didd.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcpcom.world)
> (PROTOCOL = TCP)
> (Host = scwudids.scpdwol.bhp.com.au)
> (Port = 1525)
> )
> )
> (CONNECT_DATA =
> (SID = didd)
> (GLOBAL_NAME = didd.world)
> )
> )
>
> If you are logging on to sqlplus when you are logged on directly to the
> server, you have to type something like
>
> sqlplus userid/passwd_at_instance
>
> where in my case, instance is didd or dids. Alternatively you can leave
out
> the @instance part if the instance name is defined in an environment
> variable. I have it set in my .profile (UNIX) by export ORACLE_SID=didd
>
> hope this helps,
> Mark.
>
> fred <schmerd_at_primenet.com> wrote in article
> <01bdce4e$2e3a8540$c817a5ce_at_jim>...
> > me too. Try "scott" as your user name and "tiger" as your password then
> > click connect.
> > Maybe you don't have an account on the database? Or perhaps the
database
> > path isn't specified?
> > Anyone out there know?
> >
> > Chicago Bear Fan <bearfan_at_mindspring.com> wrote in article
> > <35dec135.144451975_at_news.mindspring.com>...
> > >
> > > I am attempting to learn oracle database development, and I need some
> > > basic help.
> > >
> > > When I attempt to logon to the database in sql*plus, I get the error
> > > ORA03121 " no interface driver connected" .
> > >
> > > How do I correct this problem...
> > >
> > > Thank you.
> > >
> > >
> > >
> >
>
Received on Thu Aug 27 1998 - 00:50:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US