-
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!
-
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!
-
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.
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|