Re: sqlplus: fresh installation: can't connect

Neil Zanella wrote:

> Hello all,
>
> It has been a while since I installed Oracle Database from scratch.
> I remember that with older versions you could simply login with
> username scott and pasword tiger. I have just installed Oracle
> and cannot connect. Should I create a user called johndoe and
> connect as johndoe? How should I accomplish this?
>
> Thanks,
>
> Neil
>
> $ sqlplus
>
> SQL*Plus: Release 10.1.0.3.0 - Production on Sat Dec 25 17:32:30 2004
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> Enter user-name: scott
> Enter password:
> ERROR:
> ORA-12162: TNS:net service name is incorrectly specified
>
>
> Enter user-name:
> ERROR:
> ORA-12162: TNS:net service name is incorrectly specified
>
>
> Enter user-name:
> ERROR:
> ORA-12162: TNS:net service name is incorrectly specified
>
>
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
> $

conn / as sysdba
alter user scott account unlock;
alter user scott identified by tiger;

There is value in reading documentation: Just a suggestion.

But from the error message I'd say that isn't the problem:Yet. Carefully read the error message. Note it is asking about the service name which you didn't specify. Time to open TNSNAMES.ORA and discover what it is.

Then: conn scott/tiger@<service_name>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)