Solved

Oracle Sqldeveloper connect to local database

Posted on 2013-11-20
2
867 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 76

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Read about achieving the basic levels of HRIS security in the workplace.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

895 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

13 Experts available now in Live!

Get 1:1 Help Now