We help IT Professionals succeed at work.

Oracle Enterprise Manager login - VTABD-1000

m0nk3yza
m0nk3yza asked
on
1,125 Views
Last Modified: 2013-11-11
Hi Guys,
I've just installed Oracle 11.1 on Solaris 10 (SPARC).
I'm able to log in as SYSDBA.
I've also created a user "orausr"
I'm able to log into the DB with orausr (from the cmd line), but get some errors (see code).

Also, when trying to log in via "Oracle Enterprise Manager Console Standalone" with this user, I get an error:

"VTADB-1000 : Theis application requires more database priviliges thatn you have currently granted to you..."

What should I do to grant this user more privileges and also resolve the command line errors?

Thank you.
Enter user-name: orausr
Enter password:
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
 
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
 
Error accessing package DBMS_APPLICATION_INFO
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Open in new window

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
You have to use user SYS to log Oracle Enterprise Manager.
Only this user has the needed privileges to access all views
used by OEM.

Trying to bypass this rule will cause you many troubles.

Author

Commented:
Hi schwertner:,

I've restarted the DB from the cmd line, just to be sure.

I've also changed SYS' password.

Then logged in with SYS, but it still complains about privileges:

"ORA-01031 : insufficient privileges"

From the cmd line, I'm able to log in with SYS, using:  sqlplus "SYS as sysdba"
(using the new password)

Thank you.
CERTIFIED EXPERT
Top Expert 2008
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Spot on! Thank you very much.
CERTIFIED EXPERT
Top Expert 2008

Commented:
Thank you!
Good luck!