Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle Sqldeveloper connect to local database

Posted on 2013-11-20
2
879 Views
Last Modified: 2013-11-27
I downloaded SqlDeveloper from this url:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
I chose Windows 64-bit. My PC is Windows 7 64-bit.

I can connect to remote databases as expected using the SqlDeveloper IDE. But I cannot connect to the local database residing on the same PC on which I am running the SqlDeveloper.

On sqlplus:
c:\sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 21 00:24:31 2013

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

SQL> connect usr1/usr1
connected.
SQL> select name from v$database;

NAME
---------
ORCL

Could you please help troubleshoot? Thanks a lot. error
0
Comment
Question by:toooki
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39665662
From a command prompt make sure ORCL is being listened for:
lsnrctl status

If you don't see ORCL, try manually registering it.  From a sqlplus prompt: alter system register;

Then check the listener again.
0
 

Author Comment

by:toooki
ID: 39682151
Just checked, started lsnrctl and it now works.  Thanks a lot.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

828 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