OraFAQ Forum: Server Administration » Query regarding 11g DBA

Home » RDBMS Server » Server Administration » Query regarding 11g DBA (Oracle 11g release 11.2.0, Windows 7)

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

Query regarding 11g DBA [message #612360]

Wed, 16 April 2014 09:43

manojswarnakar@gmail.com
Messages: 1
Registered: April 2014
Location: Bangalore

Junior Member

Hi,

I created a user 'scott' and assigned 'sysdba' persmission. When i try to logon with user 'scott' as 'sysdba' and try to access V$ and dba_ views, i am unable to do so. Please suggest.

Report message to a moderator

Re: Query regarding 11g DBA [message #612362 is a reply to message #612360]

Wed, 16 April 2014 09:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

>I created a user 'scott' and assigned 'sysdba' persmission.
do NOT tell us what you did.
SHOW us using COPY & PASTE what you did & how Oracle responded.

Report message to a moderator

Re: Query regarding 11g DBA [message #612363 is a reply to message #612360]

Wed, 16 April 2014 10:01

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

"unable to do so" is not an actionable error message.

If you are "unable" to do something, your attempt should have resulted in an error code and message text. Knowing that error code AND message text is key to unraveling your mystery. Equally important is knowing the exact statement that produced the error.

Unfortunately, you chose not to share that information.

Report message to a moderator

Previous Topic:	Oracle 11 install using response file
Next Topic:	ORACLE_HOME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 17:35:02 CDT 2025