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

Thanks very much.
Your suggestions look worthwhile, will try them later today I hope.

Some additional information that might be useful to others with same problem:

I installed the same way (typical, defaults for everything) from the same CD Pack, same CD, Personal Oracle 8i, 8.1.6, on a Windows 2000 client machine at work, and can and do log on to SQLplus just as you suggest, no problem. That machine is also, of course, on a network. I am handling the coursework that way. Still would love to get it running on my machine at home for convenience.

I've got to assume that there is something that was found in the installation under Windows 98SE (and on a machine set up for internet access via the cable modem, though how a NIC card or TCP/IP would differ from a NIC card and a TCP/IP network under Windows 2000 Server at work, I don't know) which is causing the conflict.

I'm adding to the thread in the hopes that the additional information will generate more responses. I've posted the question to Oracle's installation support, after noting that a similar problem is described that is apparently specific to connecting with Developer 6 to a database for 8i Personal, specifically under Windows 98. There are other issues, sort of an FAQ, related to installation posted there for problems that don't seem related.

In case it is helpful to anyone else with a similar problem, here is that URL:
http://www.oracle.com/support/oracleinstall/

(I thought I'd checked the site carefully, but had seen the installation support listed under the "must be paid for" Meta-something support and had assumed that buyers of the trial CD packs were pretty much just stuck without support. Glad I was wrong. Now will see what sort of response I get.)

In article <961832689.15960.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> 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.
>
>

--
When confused, or in doubt,
Run in circles, Scream and Shout.


Sent via Deja.com http://www.deja.com/
Before you buy.