I cannot login as SYSDBA
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: I cannot login as SYSDBA

  1. #1
    Join Date
    Mar 2007
    Posts
    5

    I cannot login as SYSDBA

    Hi all.
    I'm running Oracle 8i for Windows NT (8.0.5) on Windows Server 2000. Somewhere I read that I need to be in ora_dba group on Windows NT platform in order to login as sysdba to database. But I cannot find this group. When I try to login as sysdba as system/manager, login fails with ORA-01031: insufficient privileges. I need to execute startup and shutdown commands from SQL*Plus.
    Code:
    C:\>sqlplus /nolog
    
    SQL*Plus: Release 8.0.5.0.0 - Production on Mon Mar 26 8:46:56 2007
    
    (c) Copyright 1998 Oracle Corporation. All rights reserved.
    
    SQL> connect USER_X/PASSWORD
    Connected.
    
    SQL> select * from user_role_privs;
    
    USERNAME	GRANTED_ROLE	ADM DEF OS_
    --------------- --------------- --- --- ---
    USER_X		CONNECT		NO  YES NO
    USER_X		DBA		NO  YES NO
    USER_X		RESOURCE	NO  YES NO
    
    SQL> connect USER_X/PASSWORD as sysdba
    ERROR:
    ORA-01031: insufficient privileges
    
    Warning: You are no longer connected to ORACLE.
    
    SQL> connect sys/change_on_install as sysdba;
    ERROR:
    ORA-01031: insufficient privileges
    
    Warning: You are no longer connected to ORACLE.
    
    SQL> connect sys/change_on_install
    Connected.
    
    SQL>
    Someone on Oracle forums (http://forums.oracle.com/forums/thread.jspa?messageID=1754301) told me:
    This type of errors comes only when u have forgotten uar password for sys.
    So create a new password file ora%SID% and give some new password to this file and then connect as sysdba using that password only.
    It will works...


    Code:
    SQL> select * from v$pwfile_users;
    ERROR:
    ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]
    
    no rows selected
    
    SQL>
    I found that password file really doesn't exist so I created it.
    Code:
    C:\>orapwd file=PWDORCL.ORA password=password
    But after restarting server (I cannot shutdown database as non-SYSDBA) that ORA-00600 remained. And I don't know how it could help in order to login as SYSDBA.
    Very very thx for help.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    call support

  3. #3
    Join Date
    Mar 2007
    Posts
    5
    Quote Originally Posted by davey23uk
    call support
    I haven't Oracle support :[

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    oh dear, bad luck

  5. #5
    Join Date
    Mar 2007
    Posts
    5
    Please can you at least consider the core of the problem and think about it ? I'm not Oracle DBA. I'm in my new job exposed to administer Oracle Database server and I haven't much time to learn it so fast. Some things I cannot do without SYSDBA privilegies...
    Thx

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what happens when you use svrmgrl

    svrmgr
    connect internal

  7. #7
    Join Date
    Mar 2007
    Posts
    5
    Code:
    C:\>SVRMGR30.EXE
    
    Oracle Server Manager Release 3.0.5.0.0 - Production
    
    (c) Copyright 1997, Oracle Corporation.  All Rights Reserved.
    
    Oracle8 Release 8.0.5.0.0 - Production
    PL/SQL Release 8.0.5.0.0 - Production
    
    SVRMGR> connect internal
    Password:
    Connected.
    SVRMGR>
    Sorry, I don't know what does this tool. I promise I will learn it...

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    once connected via svrmgrl you can go ahead, change SYS password, shutdown database, etc.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Mar 2007
    Posts
    5
    OK.
    I will find out what is this tool for. Today I cannot remain in work too long. So tomorow I will inform you how it worked out.
    Thanks very much...

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    was sqlplus "/ as sysdba" even valid for 8.0? no idea, dont think it was was.

    anyway server manager is the way to go, you can do everything with that

    you could also try sqlplus internal

Posting Permissions

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



Click Here to Expand Forum to Full Width