Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    64

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

    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 ...
    Attached Thumbnails Attached Thumbnails 11g.jpg  

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by Littlefoot View Post
    Are you sure username you are about to use is SYSDBA? I, somehow, doubt so.
    I agree.
    As far as I know, SYSDBA is a role not a user

  4. #4
    Join Date
    Jan 2010
    Posts
    64

    its working fine ... thank you much !!

    its working fine ... thank you much LittleFoot !!
    Last edited by subhotech; 09-10-10 at 18:40. Reason: typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •