Re: Connect to Oracle 11g using PL-SQL developer and SQL PLus

From: joel garry <>
Date: Mon, 14 Oct 2013 09:35:19 -0700 (PDT)
Message-ID: <>

On Monday, October 14, 2013 6:52:42 AM UTC-7, Amir Diwan wrote:
> Upon trying the username and password on SQL PLUS it gives, an error
> ORA-12560: TNS Adapter error

OK, there are several possible problems in your previous post and this one. I don't know what the defaults are for personal edition and sql*developer, so I'll tell you what I would look for.

First, does sqlplus work for you? As the owner of the Oracle software, get to a command line and try this:

sqlplus / as sysdba

It should log you in as sys user and give a sql prompt. At the prompt, enter:

select username, account_status from dba_users;

It should give a list of usernames and whether the account is locked. If the names SCOTT or HR are in there, we can proceed with unlocking and/or attaching with sql*developer, if not, you need to google for how to add demo accounts - there is perhaps a script you need to run.

Show us the output of those commands with cut and paste.

Also, you can google for tutorials, but I think they generally assume the demo accounts are ready to go.


-- is bogus.
Received on Mon Oct 14 2013 - 18:35:19 CEST

Original text of this message