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!
Printable View
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!
It can only be run as internal or sysdba.
RegardsCode:$ 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
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.
There is a space after the /. otherwise it won't work.
Code:connect / as sysdba
Just tried this
connect / as sysdba
The same result.:confused:
What's the exact problem?
Thanks!
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
:cool:
It worked finally!:)
Thank you guys!