| Upgrade 9.2 failure [message #123352] |
Sun, 12 June 2005 09:36 |
tspoon
Messages: 1
Registered: June 2005
Location: France
|
Junior Member |
|
|
Hi,
I upgraded an 8.1.7 db to 9.2 using dbua (ugghhh), however after a few teething problems with dba_registry and tablespaces the database appears to be up and running. I can login and view data, via sqlplus. Not a problem.
However when I try to logon to OEM using system, I either get a
warning about a role 'SELECT_CATALOG_ROLE' or insufficient privs.
When I investigate this, there are adequate privs for the system account and the select_catalog_role has been granted. Is there a priv I am missing?
The init.ora parameter for 'remote_login_passwordfile=NONE'.
So in a nutshell, I can login to the database via sqlplus, but not OEM. No invalid objects or dba_registry invalid schemas etc... All post upgrade scripts executed
This is on a UNIX/Solaris server
Thanks in advance for your help
select * from dba_role_privs where grantee = 'SYSTEM';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SYSTEM DBA YES YES
SYSTEM CONNECT YES YES
SYSTEM RESOURCE YES YES
SYSTEM EXP_FULL_DATABASE YES YES
SYSTEM IMP_FULL_DATABASE YES YES
SYSTEM SELECT_CATALOG_ROLE YES YES
SYSTEM EXECUTE_CATALOG_ROLE YES YES
SYSTEM AQ_ADMINISTRATOR_ROLE YES YES
SQL-sys@ELS> select status, comp_name from dba_registry;
STATUS COMP_NAME
----------- -----------------------------------
VALID Oracle9i Catalog Views
VALID Oracle9i Packages and Types
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
