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
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.
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
BlackSwan
Messages: 22542
Registered: January 2009
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
EdStevens
Messages: 230
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
Next Topic: ORACLE_HOME
Goto Forum:
  


Current Time: Thu Jul 31 02:38:32 CDT 2014

Total time taken to generate the page: 0.06504 seconds