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

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.

jg

-- 
_at_home.com is bogus.
http://gigaom.com/2013/10/14/oracles-hardware-business-may-be-worse-than-we-thought/