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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/24
Message-ID: <961832689.15960.1.pluto.d4ee154e@news.demon.nl>#1/1

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.

Received on Sat Jun 24 2000 - 00:00:00 CDT