Re: Dbms_application_info

On Sun, 08 Dec 2002 14:40:21 +0000, meekes_26 <member_at_dbforums.com> wrote:

>
>Hi
>
>Im a new user of oracle. We have this oracle 9i database and
>everytime i connect to it using an sqlplus version 3.3.4.0.0 I always
>get this message.
>=========================
>
>SQL*Plus: Release 3.3.4.0.0 - Production on Sun Dec 08 22:38:25 2002
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>
>Connected to:
>Oracle8i Release 8.1.7.2.0 - Production
>JServer Release 8.1.7.2.0 - Production
>
>SQL> conn ecrmdev/ecrmdev_at_ucrmdev
>Error accessing package DBMS_APPLICATION_INFO
>ERROR:
>ORA-06550: line 1, column 40:
>PLS-00553: character set name is not recognized
>ORA-06550: line 0, column 0:
>PL/SQL: Compilation unit analysis terminated
>
>
>Connected.
>SQL>
>==================
>
>What should i do to resolve this error message when ever i log in. Or is
>this really a version mismatch?
>
>Thanks

The above doesn't make sense.
You say you have a 9i database. Yet the database shows up as 8.1.7.2.0 You are also using an Oracle 7.3 client to connect to this database, proven by your sql*plus version.
In short, this is a Mixed Evironment of Several versions of Software, also known as a MESS. Don't know how you managed to get this together, but I would consider opening the window, looking whether there is no one on the footpath and throwing the system out a viable option.

Apart from that it might be an incorrect value for the NLS_LANG registry variable, but I think you should sort out the version mess first.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Dec 08 2002 - 15:31:53 CST