OraFAQ Forum: Server Administration » archive log list doesn't work as sysdba

Home » RDBMS Server » Server Administration » archive log list doesn't work as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

archive log list doesn't work as sysdba [message #55566]

Fri, 31 January 2003 13:18

Somesh Dhawas
Messages: 9
Registered: January 2003

Junior Member

when I do archive log list as sysdba, it gives an error
1031:INsufficient privileges. PLus it doesn't lte me shutdown the database. Can you help ?
Thanks
-Somesh

Report message to a moderator

Re: archive log list doesn't work as sysdba [message #55567 is a reply to message #55566]

Fri, 31 January 2003 13:29

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first make sure the user is granted with sysdba role.
is shutdown norma/immediate/abort is not shuttin the down the dB?
pls post the exact message

SQL> connect sys/sys as sysdba
Connected.
SQL>  archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            C:OracleOra91RDBMS
Oldest online log sequence     20
Current log sequence           22
SQL>

Report message to a moderator

Re: archive log list doesn't work as sysdba [message #55570 is a reply to message #55566]

Fri, 31 January 2003 15:28

Somesh Dhawas
Messages: 9
Registered: January 2003

Junior Member

Mahesh,

Thanks for getting back to me. I tried connect sys/sys as sysdba this is what it does.

SQL> connect sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

When I type archive log list as sysdba it says
ORA-1031:Insufficient privileges.

Tried the follwoing as system.

SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> grant sysdba to sysdba;
grant sysdba to sysdba
*
ERROR at line 1:
ORA-01031: insufficient privileges

My environment is Windows-NT. DO I need to consult the sys administrator to see if I have ora_dba privileges.

Please help
Thanks
-Somesh

Report message to a moderator

Re: archive log list doesn't work as sysdba [message #55572 is a reply to message #55566]

Fri, 31 January 2003 17:45

Somesh Dhawas
Messages: 9
Registered: January 2003

Junior Member

Mahesh,

I could connect as

connect sys/sys as sysdba and now I can do
archive log list and start and stop the database.

The real question is once the database is stopped and if you exit/come out of the sys user you have no way of getting back in the database because you can't connect as internal as of 9i or svrmgrl.

I can conect as sysdba but somehow my sysdba user doesn't do any acivities like start or stop the database and even archive log list. This is where I'm confused.

The Oracle(sqlplus) version I use is 9.0.1.0.1
Can you tell me more.

Thanks
-Somesh

Report message to a moderator

Previous Topic:	DBA Question
Next Topic:	Flat File v. Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:50:28 CDT 2024