Error when displaying standard report OEM query

[Matthias Wirtz]

jeff31 wrote:
When I execute a standard report, on some query I have this following error.

Your error code is ORA-00972:

ORA-00972 identifier is too long

Cause: The name of a schema object exceeds 30 characters. Schema objects are
tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
Action: Shorten the name to 30 characters or less.

wstring sqlStmt="/* OracleOEM */ select a.name "Nom de la BdD", e.global_name "Nom global", b.banner "Version de la BdD", c.host_name "Nom de l'hte", c.instance_name "Nom de l'instance", c.startup_time "Heure de dmarrage de l'instance", decode(c.logins,'RESTRICTED','YES','NO') "Mode restreint", a.log_mode "Mode ARCHIVELOG", decode(a.open_mode,'READ ONLY','YES','NO') "Mode Lecture seule" from v$database a, v$version b, v$instance c, global_name e WHERE b.banner LIKE '%Oracle%';

In your statement for example the column alias "Heure de
dmarrage de l'instance" has more than 30 characters.

PS: Don't know to what you are referring with "OEM report" and what db
version & os you are using.
--
Matthias Wirtz - Norfolk, USA

[jeff31]

I have errors when displaying standard report OEM query

When I execute a standard report, on some query I have this following
error.

My Internet Explorer is in french.

Could You help me please.

Thanks.

Message at execution report :
Informations sur l'instance et la base de données
Echec du traitement de l'élément d'état n° 2 : exception
VdbSQLException{wstring reason="ORA-00972: identifier is too
long\n";long oracleError=972;long errorCode=3;wstring sqlStmt="/*
OracleOEM */ select a.name \"Nom de la BdD\", e.global_name \"Nom
global\", b.banner \"Version de la BdD\", c.host_name \"Nom de
l\'h\364te\", c.instance_name \"Nom de l\'instance\" ,c.startup_time
\"Heure de d\351marrage de l\'instance\",
decode(c.logins,\'RESTRICTED\',\'YES\',\'NO\') \"Mode
restreint\",a.log_mode \"Mode ARCHIVELOG\" , decode(a.open_mode,\'READ
ONLY\',\'YES\',\'NO\') \"Mode Lecture seule\" from v$database a,
v$version b, v$instance c,global_name e WHERE b.banner LIKE
\'%Oracle%\'";}