Forum Stats

  • 3,768,258 Users
  • 2,252,769 Discussions
  • 7,874,506 Comments

Discussions

DBCA fails with TNS-12560: TNS:protocol adapter error on Windows 10 Home

Remco Blaakmeer
Remco Blaakmeer Member Posts: 4
edited May 3, 2016 7:47PM in Database Installation

I'm trying to install Oracle Database 12c on Windows 10 Home. When the installer runs the Database Configuration Assistant, it fails with TNS-12560: TNS:protocol adapter error.

I found a file sqlnet.log that starts with this:

Sat Apr 30 20:51:59 2016

Create Relation ADR_CONTROL

Create Relation ADR_INVALIDATION

Create Relation INC_METER_IMPT_DEF

Create Relation INC_METER_PK_IMPTS

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\oracle12c\product\12.1.0\dbhome_1\bin\sqlplus.exe)(HOST=DESKTOP-VUF3EMH)(USER=remco))))

  VERSION INFORMATION:

  TNS for 64-bit Windows: Version 12.1.0.2.0 - Production

  Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.1.0.2.0 - Production

  Time: 30-APR-2016 20:52:02

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12560

   

TNS-12560: TNS:protocol adapter error

    ns secondary err code: 0

    nt main err code: 530

   

TNS-00530: Protocol adapter error

    nt secondary err code: 233

    nt OS err code: 0

Sat Apr 30 20:59:09 2016

***********************************************************************

What could cause this error?

Tagged:

Answers

  • himmy
    himmy Member Posts: 322 Red Ribbon
    edited May 1, 2016 3:50PM
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\oracle12c\product\12.1.0\dbhome_1\bin\sqlplus.exe)(HOST=DESKTOP-VUF3EMH)(USER=remco))))
    

    I couldn't be so sure about this but in the above description i don't see port variable defined, something like (PORT=1521) ( 1521 being the default)

    At what point did the dbca failed , can you check the installation logs in ORACLE_BASE\cfgtoollogs directory

  • Srini Chavali-Oracle
    Srini Chavali-Oracle Member Posts: 29,596 Blue Diamond
    edited May 3, 2016 7:47PM
    I'm trying to install Oracle Database 12c on Windows 10 Home
    
    

    Oracle database software is not certified for Windows Home edition - so expect issues - see the official Install Guide for a list of supported Windows versions/editions.

This discussion has been closed.