Home » RDBMS Server » Server Administration » Query regarding 11g DBA (Oracle 11g release 11.2.0, Windows 7)
Query regarding 11g DBA [message #612360] Wed, 16 April 2014 09:43 Go to next message
Messages: 1
Registered: April 2014
Location: Bangalore
Junior Member

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.
Re: Query regarding 11g DBA [message #612362 is a reply to message #612360] Wed, 16 April 2014 09:54 Go to previous messageGo to next message
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.
Re: Query regarding 11g DBA [message #612363 is a reply to message #612360] Wed, 16 April 2014 10:01 Go to previous message
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.

Previous Topic: Oracle 11 install using response file
Goto Forum:

Current Time: Sun Oct 01 01:32:42 CDT 2023