asked on

Not able to access DB from SQL Developer

Hello Experts,

I have installed Oracle 12c on my local system . From command prompt I am able to login to my oracle DB :

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\sloba>sqlplus

SQL*Plus: Release 12.1.0.1.0 Production on Mon Feb 9 17:32:27 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions

SQL>

Open in new window

But when accessing the same DB from SQL Developer I am getting the below Error:

Swadhin Ray

ASKER

Checked the log undere "C:\app\oracle\product\12.1.0\dbhome_1\log\sloba-pc\client" :

Oracle Database 12c Clusterware Release 12.1.0.1.0 - Production Copyright 1996, 2013 Oracle. All rights reserved.
2015-02-09 15:46:50.212: [  OCRMSG][196]prom_waitconnect: CONN NOT ESTABLISHED (0,29,1,2)
2015-02-09 15:46:50.212: [  OCRMSG][196]GIPC error [29] msg [gipcretConnectionRefused]
2015-02-09 15:46:50.430: [  OCRMSG][196]prom_connect: error while waiting for connection complete [24]
2015-02-09 15:46:50.540: [ default][196]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2
2015-02-09 15:46:52.743: [  OCRMSG][196]prom_waitconnect: CONN NOT ESTABLISHED (0,29,1,2)
2015-02-09 15:46:52.743: [  OCRMSG][196]GIPC error [29] msg [gipcretConnectionRefused]
2015-02-09 15:46:52.743: [  OCRMSG][196]prom_connect: error while waiting for connection complete [24]
2015-02-09 15:46:52.743: [ default][196]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2
2015-02-09 15:46:53.774: [ default][196]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2

Open in new window

Listner.ora file has the below details:

# listener.ora Network Configuration File: C:\app\oracle\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\oracle\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.15)(PORT = 1521))
    )
  )

Open in new window

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Swadhin Ray

ASKER

I've requested that this question be deleted for the following reason:

Solved this problem

Swadhin Ray

ASKER

The IP address was not added on the HOST file.

Guy Hengel [angelIII / a3]

the corresponding login in sqlplus would be
sys@ORCL as sysdba

I presume that will return the same error as in sql developer

is the listener started (sqlplus is not using the listener for local connections "as sysdb" ...

Swadhin Ray

ASKER

After adding the IP on the host file , now I am able to connect using SQL developer.

Swadhin Ray

ASKER

thanks