Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12560: TNS: protocol adapter error - 12c on windows 7

Sam90Jan 8 2016 — edited Mar 1 2016

Hi all,

I have tried everything to solve this issue but i couldn't

I added loopback adapter and assigned a static ip 10.10.10.10

I started all the oracle services

I added the oracle paths manually

2.PNG

yet I couldn't solve the issue

I'm using mac and installed virtualbox windows 7 and then installed the database 12c

when i configure the database i get this error

1.PNG

I have Path has : C:\app\Sameh\product\12.1.0\dbhome_1\bin

I added ORACLE_HOME : C:\app\Sameh\product\12.1.0\dbhome_1

TNS_ADMIN : C:\app\Sameh\product\12.1.0\dbhome_1\NETWORK\ADMIN

Listener

# listener.ora Network Configuration File: C:\app\Sameh\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID\_DESC =

  (SID\_NAME = CLRExtProc)

  (ORACLE\_HOME = C:\\app\\Sameh\\product\\12.1.0\\dbhome\_1)

  (PROGRAM = extproc)

  (ENVS = "EXTPROC\_DLLS=ONLY:C:\\app\\Sameh\\product\\12.1.0\\dbhome\_1\\bin\\oraclr12.dll")

)

(SID\_DESC =

  (SID\_NAME = CLRExtProc)

  (ORACLE\_HOME = C:\\app\\Sameh\\product\\12.1.0\\dbhome\_1)

  (PROGRAM = extproc)

  (ENVS = "EXTPROC\_DLLS=ONLY:C:\\app\\Sameh\\product\\12.1.0\\dbhome\_1\\bin\\oraclr12.dll")

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1521))

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

-----------------------

tnsnames

# tnsnames.ora Network Configuration File: C:\app\Sameh\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS\_LIST =

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT\_DATA =

  (SID = CLRExtProc)

  (PRESENTATION = RO)

)

)

What else i'm missing, any configuration for the virtualbox?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2016
Added on Jan 8 2016
51 comments
15,474 views