Re: Personal Oracle 8i, 8.1.6 - ORA-12560 TNS:protocol adapter error

I'm having the same problem with a new installation of Oracle8i Enterprise Edition, Release 8.1.5 for NT.

Been searching the web, newsgroups and everything else I can think of all week. Nothing seems to work. Compared my configuration files with those below and they are identical, but I still can't use SQL*Plus or the import utility.

Any one else have ANY other tips? This is SO FRUSTRATING!

Thanks,
John Schneider

Sybrand Bakker wrote:

> Here are the listener.ora and tnsnames.ora of a 8.1.5 *standard* install
> (sid is called ORCL).
> Replace the xxxx by your machine name, and it should work.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
> File:c:\Oracle\Ora81\network\admin\listener.ora
> # Generated by Oracle Net8 Assistant
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = 13382)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = c:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
> )
> # C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration
> File:c:\Oracle\Ora81\network\admin\tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> <charleshahn_at_my-deja.com> wrote in message
> news:8j1ifo$9bf$1_at_nnrp1.deja.com...
> > As a raw beginner with Oracle this is very frustrating. I've
> > reinstalled Personal 8i (8.1.6) several times, trying to not install
> > Net8 at all (it gets installed anyway), then telling it I'll configure
> > net connections later but not configuring any -- hoping to have only my
> > local machine available -- but no matter what I do when I click on
> > SQLPlus and start it up, I get the
> > ORA-12560 TNS:protocol adapter error
> > that prevents me from logging onto and working with my local database
> > under SQLPlus.
> >
> > I searched for that error here in Deja, and found several references,
> > but not really an answer (that I understand, anyway).
> >
> > Anyone got time to help me, and it looks like others, deal with this?
> >
> > Thanks,
> > Charlie Hahn
> >
> >
> > --
> > When confused, or in doubt,
> > Run in circles, Scream and Shout.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

--
John Schneider
JohnSchneider_at_bigfoot.com