X-Received: by 10.182.95.68 with SMTP id di4mr12629790obb.4.1381768521251; Mon, 14 Oct 2013 09:35:21 -0700 (PDT) X-Received: by 10.50.98.4 with SMTP id ee4mr368514igb.5.1381768521185; Mon, 14 Oct 2013 09:35:21 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!209.85.216.87.MISMATCH!o2no4584563qas.0!news-out.google.com!9ni40084qaf.0!nntp.google.com!i2no12127236qav.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 14 Oct 2013 09:35:19 -0700 (PDT) In-Reply-To: <1bea74a8-55d3-4597-8ff3-daea9b0f6059@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv NNTP-Posting-Host: 64.58.150.28 References: <39485f3f-5f68-4f79-b4ee-770e6b6cbcab@googlegroups.com> <1bea74a8-55d3-4597-8ff3-daea9b0f6059@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: Connect to Oracle 11g using PL-SQL developer and SQL PLus From: joel garry Injection-Date: Mon, 14 Oct 2013 16:35:21 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl 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 >=20 >=20 >=20 > 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, ent= er: select username, account_status from dba_users; It should give a list of usernames and whether the account is locked. If t= he names SCOTT or HR are in there, we can proceed with unlocking and/or att= aching with sql*developer, if not, you need to google for how to add demo a= ccounts - 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 d= emo accounts are ready to go. jg --=20 @home.com is bogus. http://gigaom.com/2013/10/14/oracles-hardware-business-may-be-worse-than-we= -thought/