DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: archive log list

  1. #1
    Join Date
    Feb 2003
    Posts
    5

    Thumbs up archive log list

    I try to use "archive log list". But always get "ORA-01031: insufficient privileges" error message. regardless I'm using "system" and "sys" user login.
    What's the problem I have? Any suggestions thanks in advance!

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It can only be run as internal or sysdba.

    Code:
    $ sqlplus system/manager
    
    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 12 09:03:26 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning option
    JServer Release 9.2.0.1.0 - Production
    
    SQL> archive log list
    ORA-01031: insufficient privileges
    SQL> connect / as sysdba
    Connected.
    SQL> archive log list
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            /data1/oradata/archive/
    Oldest online log sequence     3211
    Next log sequence to archive   3213
    Current log sequence           3213
    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Feb 2003
    Posts
    5
    I try to follow your steps. But it still has problem see below. Any suggestion. Thanks!!
    -----------------------------------------------
    C:\>sqlplus system/manager

    SQL*Plus: Release 8.1.6.0.0 - Production on Wed Feb 12 09:18:03 2

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    SQL> archive log list
    ORA-01031: insufficient privileges
    SQL> connect /as sysdba
    ERROR:
    ORA-01031: insufficient privileges


    Warning: You are no longer connected to ORACLE.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    There is a space after the /. otherwise it won't work.

    Code:
    connect /  as sysdba

  5. #5
    Join Date
    Feb 2003
    Posts
    5
    Just tried this
    connect / as sysdba

    The same result.
    What's the exact problem?
    Thanks!

  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    'connect / as sysdba' will only work if you are in the os-related DBA-group too: under Unix it's 'dbs' under Win2k it's 'ORA_DBA'

    If you are not in the dba-group then you have to connect this way

    'connect sys/passwd as sysdba'

    Orca


  7. #7
    Join Date
    Feb 2003
    Posts
    5
    It worked finally!
    Thank you guys!

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