Kbase P103377: How to debug error (328) (6483)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/03/2010 |
|
Status: Verified
GOAL:
How to debug error (328) (6483)
GOAL:
What to do when receiving error 6483
GOAL:
Please also verify you have SELECT privileges on the needed system tables and the proper version of ORACLE was selected when the schema holder was created (328) (6483)
GOAL:
Please also verify you have SELECT privileges on the needed system tables and the proper version of ORACLE (7 or 8) was selected when the schema holder was created (328) (6483)
FACT(s) (Environment):
All Supported Operating Systems
Oracle DataServer
FIX:
As stated within the message
Please also verify you have SELECT privileges on the needed system tables
and the proper version of ORACLE (7 or 8) was selected when the schema
holder was created (328) (6483)
there are two possible reasons for error 6483.
Even if error the message suggest version "7" or "8", you will need to enter "9" when using Oracle 9 or Oracle 10.
If you have entered the correct number for the Oracle version, then there is a privilege problem within Oracle.
To know what statement failed due to insufficient privileges, then do:
1. Leave the currently session
2. Delete or rename the file "dataserv.lg"
3. Start a new session and connect to Oracle with the additional startup parameter: -Dsrv qt_debug,EXTENDED
4. Leave the session after having hit error 6483
5. Find within "dataserv.lg" the last SELECT statement which failed
6. Try running the same SELECT from within SQL*Plus
This should fail and prove that you need additional Oracle privileges.