Solved

Not able to access DB from SQL Developer

Posted on 2015-02-09
7
219 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

Suggested Solutions

Title # Comments Views Activity
sql for Oracle views 8 49
case statement in where clause 5 42
Maintaining Oracle Managed Accounts 2 30
Performance issue with case statement in oracle 11G 7 48
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now