Solved

Oracle Sqldeveloper connect to local database

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

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
clob to char in oracle 3 39
Documenting Data flow 4 39
free version of MSSQL for over 10GB DB 19 60
Include a logo in email body using Oracle utl_mail 11 30
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Creating and Managing Databases with phpMyAdmin in cPanel.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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…

773 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