ERROR: You do not have SELECT privileges on sys.V_$PARAMETER view. This process cannot proceed.
Hello,
I am using ORACLE 10g Standard Edition and I am trying to configure the Oracle Designer for which a repository must be installed. The following is the procedure I am following:
- START >
- PROGRAMS >
- ORACLE
- DEVELOPER SUITE –DevSuite1 >
- DESIGNER >
- REPOSITORY ADMINISTRATION UTILITY
I am connecting to the database from which the repository will be formed. So I enter the following
Enter the following
Username:
SYSMAN
Password:
password
Connect String:
orcl
When I login to the Repository Administration Utility,
I click "Install" and I follow by clicking all the affirmatives. (see attachment)
So this is what I do after:
1. I Open up command prompt
2. ENTER:
sqlplus sys/change_on_install@orcl as sysdba
And I receive the following:
SQL*Plus: Release 10.1.0.4.2 - Production on Sat Nov 7 14:04:41 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
-----------------------------
SO I then enter the username:
Enter user-name[/i]:
SYSMAN Enter password: ********
and this is the outcome:
Connected to:
Oracle Database 10g release 10.2.0.1.0 - Production
SQL>
I then enter:
GRANT SELECT ON sys.V_$parameter to SYSMAN;
and I receive this:
GRANT SELECT ON sys.V_$parameter to SYSMAN;
*
ERROR at line 1:
ORA-10301: Insufficient Privileges
Can anyone tell me what I am doing wrong, please?
(I'm not experienced in using Oracle)
Thanks in advance!!!
