oracle 11g sql * plus login error :: ORA-01017

subhotech · #1 (**permalink**) 09-10-10, 17:03

HI,

earlier i was trying to install oracle 10g wch had problem hence tried
oracle 11g which wassuccesfull.

but i was not able to login to sql* plus ..itisthrowing error.

I am using the password which i have given during installation ... is there way to change the password .. I have tnsnames.ora and tnsnames.ora which looks ok.
Also checked the following command :-
D:\app\Subho\product\11.1.0\db_1\NETWORK\ADMIN>tns ping orcl

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 11-SEP-2010 02:20:57

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
D:\app\Subho\product\11.1.0\db_1\network\admin\sql net.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Subho-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (30 msec)

D:\app\Subho\product\11.1.0\db_1\NETWORK\ADMIN>pin g SUBHO-PC

Pinging Subho-PC [fe80::846:b4d:8c89:b087%10] from fe80::846:b4d:8c89:b087%10 with 32 bytes of data:
Reply from fe80::846:b4d:8c89:b087%10: time<1ms
Reply from fe80::846:b4d:8c89:b087%10: time<1ms
Reply from fe80::846:b4d:8c89:b087%10: time<1ms
Reply from fe80::846:b4d:8c89:b087%10: time<1ms

Ping statistics for fe80::846:b4d:8c89:b087%10:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

D:\app\Subho\product\11.1.0\db_1\NETWORK\ADMIN>

PLease Advice ...

Littlefoot · #2 (**permalink**) 09-10-10, 17:17

Are you sure username you are about to use is SYSDBA? I, somehow, doubt so.

SYS or SYSTEM seem to be a better choice; while connecting as SYS, there is a need for SYSDBA, though:

Code:

C:\temp>sqlplus sys/pwd

SQL*Plus: Release 10.2.0.1.0 - Production on Pet Ruj 10 23:16:03 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

C:\temp>sqlplus sys/pwd as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Pet Ruj 10 23:17:11 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>

Anyway: you'd rather check documentation; it is all described in there.