Solved

Not able to access DB from SQL Developer

Posted on 2015-02-09
7
226 Views
Last Modified: 2015-02-10
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:

Error on SQL Developer
0
Comment
Question by:Swadhin Ray
  • 5
  • 2
7 Comments
 
LVL 16

Author Comment

by:Swadhin Ray
ID: 40598131
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

0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40598159
please post the content of the ORACLE_HOME path, and the tns connection files (tnsnames.ora ...)
0
 
LVL 16

Author Comment

by:Swadhin Ray
ID: 40600838
I've requested that this question be deleted for the following reason:

Solved this problem
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 16

Author Comment

by:Swadhin Ray
ID: 40598160
The IP address was not added on the HOST file.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40598161
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" ...
0
 
LVL 16

Author Comment

by:Swadhin Ray
ID: 40598385
Error - Solved
After adding the IP on the host file , now I am able to connect using SQL developer.
0
 
LVL 16

Author Closing Comment

by:Swadhin Ray
ID: 40600839
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question