Home » Other » General » Unusual Error ( Garbage Chars Everyware) (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production)
Unusual Error ( Garbage Chars Everyware) [message #464999] Mon, 12 July 2010 01:45 Go to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
OS :Linux 2.6.18-164.15.1.el5 #1 SMP x86_64 x86_64 x86_64 GNU/Linux

DB : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Hello All,

I am facing some unusual error

Quote:

Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
å"å"å" ècõ÷ècõ÷KeüC¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤àZíÿøZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZ ÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_ ÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿY öÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤ øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZ ÿøZíÿ_íÿYíöÀ¸¤¬ècõ÷ècõ÷KeüCC¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿ YíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤àZíÿøZíÿøZíÿ_íÿYíöÀ¸¤¬øZíÿøZíÿ_íÿYíöÀ¸¤àZíÿøZíÿøZíÿ _íÿYíöÀ¸¤¬SQL > SQL> SQL> Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
hZíÿhZíÿhZíÿècõ÷ècõ÷KeüC¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤`ZíÿxZíÿxZíÿ^íÿYíöÀ¸¤¬ xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^ íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸ ¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZ ÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíö À¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬ècõ ÷ècõ÷Ke¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬ xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤`ZíÿxZíÿxZ ÿ^íÿYíöÀ¸¤¬xZíÿxZíÿ^íÿYíöÀ¸¤`ZíÿxZíÿxZíÿ^íÿYíöÀ¸¤¬Source



I am not sure what is this I am running a proc from shell which is doing its job properly.

[Updated on: Mon, 12 July 2010 02:27] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465005 is a reply to message #464999] Mon, 12 July 2010 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your ORACLE_HOME parameter.
Check your NLS* parameters.

ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause:  This is the generic error number for the OCI
          environment (client-side) internal errors.  This indicates
          that the OCI environment has encountered an exceptional
          condition.
 *Action: Report as a bug - the first argument is the internal error number.


Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465010 is a reply to message #464999] Mon, 12 July 2010 02:53 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
SQL> show parameter NLS    

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_calendar                         string
nls_comp                             string
nls_currency                         string
nls_date_format                      string
nls_date_language                    string
nls_dual_currency                    string
nls_iso_currency                     string
nls_language                         string      AMERICAN
nls_length_semantics                 string      BYTE
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string
nls_territory                        string      AMERICA
nls_time_format                      string
nls_time_tz_format                   string
nls_timestamp_format                 string
nls_timestamp_tz_format              string

1/ everything is fine till this movement,
2/ As soon as I go for "set serverout on " , Sqlplus is popping up with following Error.

SQL> set serverout on 
Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
å"å"å"èCø÷èCø÷KeüC¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤Pæÿhæÿhæÿÿ9ðöÀ¸¤¬hæ
ÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ
¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿ
ÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬h
æÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðö
À¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬èCø÷èCø÷KeüCC¬hæÿhæ
ÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤¬hæÿhæÿÿ9ðöÀ¸¤Pæÿhæÿhæÿÿ9ðöÀ¸
¤¬hæÿhæÿÿ9ðöÀ¸¤Pæÿhæÿhæÿÿ9ðöÀ¸¤¬SQL> 



and again after "Select * from Tab"

519 rows selected.

Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
øæÿøæÿøæÿèCø÷èCø÷KeüCææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ðæææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ
9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸
¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸æÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ
9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸
¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤¬èCø
÷èCø÷KeüCCææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9
ðöÀ¸¤ðæææÿ,æÿ9ðöÀ¸¤ææÿ,æÿ9ðöÀ¸¤ðæææÿ,æÿ9ðöÀ¸¤¬SQL> 


[Updated on: Mon, 12 July 2010 04:14] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465011 is a reply to message #465010] Mon, 12 July 2010 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant NLS environment parameters at OS level.

Also apply:
*Action: Report as a bug - the first argument is the internal error number.


Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465012 is a reply to message #464999] Mon, 12 July 2010 03:15 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Quote:

I meant NLS environment parameters at OS level.

Also apply:
Quote:


*Action: Report as a bug - the first argument is the internal error number.


Regards
Michel


1/ Ok I will

2/ but when I see the SQL prompt with garbage char ( see Image )
./fa/7999/0/
3/ Same output I copy and paste in Quick reply of ORAFAQ I see following..
4/ I am running SQL plus on Linux Terminal.


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               string



Is related to char set of Terminal ?
  • Attachment: Ora.gif
    (Size: 3.27KB, Downloaded 1605 times)
Re: Unusual Error ( Garbage Chars Everyware) [message #465015 is a reply to message #465012] Mon, 12 July 2010 03:21 Go to previous messageGo to next message
Littlefoot
Messages: 19890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is probably not the case, but this:Quote:

OCI-21500: Message 21500 not found; No message file for product

reminds me of an issue I had the other day - there was nothing in ORACLE_HOME\server\sqlplus\mesg directory. What about your system? Is there anything there?
Re: Unusual Error ( Garbage Chars Everyware) [message #465016 is a reply to message #465015] Mon, 12 July 2010 03:24 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Let me check and get back !!!
Re: Unusual Error ( Garbage Chars Everyware) [message #465026 is a reply to message #465016] Mon, 12 July 2010 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You still didn't post your NLS parameters at OS level.
env | sort


Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465027 is a reply to message #464999] Mon, 12 July 2010 04:34 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
OS parameters !!
bash-3.2$ env |sort
_AST_FEATURES=UNIVERSE - ucb
_=/bin/env
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/xxxxxx
HOSTNAME=xxxxxxx
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=xxxxxx
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;
33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;
32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;
32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;
31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;
31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;
35:*.tif=01;35:
MAIL=/var/spool/mail/xxxxxx
PATH=/usr/kerberos/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
PWD=/home/xxxxxx
SHELL=/bin/ksh
SHLVL=1
SSH2_CLIENT=xx.xx.xxx.xxx 3250 xxx.xxx.xxx.xxx 22
SSH2_TTY=/dev/pts/3
SSH_RHOST=xxxxxx.xxxx.xxxx.xxxx
SSH_SESSION_ID=27
SSH_TTY=/dev/pts/3
TERM=vt100
USER=xxxxxx



"xxxxxx" Masked data username.. Ip etc..

[Updated on: Mon, 12 July 2010 06:18] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465028 is a reply to message #465027] Mon, 12 July 2010 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I see no ORACLE_HOME!

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465029 is a reply to message #465028] Mon, 12 July 2010 04:41 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
I have exported the
1/ ORACLE_HOME
Which I can see in Env |sort as full path of oracle dir
still the same ...

SQL> set serverout on 
Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
å"å"å"è3ó÷è3ó÷KeüC¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤0PðÿHPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)
ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ)ëöÀ¸¤¬HPðÿHPðÿlTðÿ

[Updated on: Mon, 12 July 2010 06:19] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465036 is a reply to message #465029] Mon, 12 July 2010 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post new "env| sort".

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465039 is a reply to message #464999] Mon, 12 July 2010 05:57 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
bash-3.2$ env |sort
_AST_FEATURES=UNIVERSE - ucb
_=/bin/env
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/xxxxxx
HOSTNAME=xxxxxxx
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/opt/common/current/oracle/lib:
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=xxxxxx
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;
33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;
32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;
31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;
31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;
35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;
35:*.tif=01;35:
MAIL=/var/spool/mail/xxxxxx
ORACLE_HOME=/opt/Common/current/oracle
PATH=/opt/Common/current/oracle/bin;/usr/kerberos/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
PWD=/home/xxxxxx
SHELL=/bin/ksh
SHLVL=1
SSH2_CLIENT=xx.xx.xxx.xxx 3250 xxx.xxx.xxx.xxx 22
SSH2_TTY=/dev/pts/3
SSH_RHOST=xxxxxx.xxxx.xxxx.xxxx
SSH_SESSION_ID=27
SSH_TTY=/dev/pts/3
TERM=vt100
USER=xxxxxx



Only difference is
1/ ORACLE_HOME
2/ LD_LIBRARY_PATH

[Updated on: Mon, 12 July 2010 06:19] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465043 is a reply to message #465039] Mon, 12 July 2010 06:03 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only? They are mandatory! Now try to set NLS_LANG or at least NLS_LANGUAGE.

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465046 is a reply to message #464999] Mon, 12 July 2010 06:13 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Done.
SQL> ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' 
  2  ;

Session altered.

Elapsed: 00:00:00.03
SQL>  set serverout on
Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
å"å"å"è³ù÷è³ù÷KeüC|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤ð{ú|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,ú
ÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú
|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñö
À¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,
úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤¬
è³ù÷è³ù÷KeüCC|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñ
öÀ¸¤ð{ú|ú|úÿ,úÿ©ñöÀ¸¤|ú|úÿ,úÿ©ñöÀ¸¤ð{ú|ú|úÿ,úÿ©ñöÀ¸¤¬SQL> 

[Updated on: Mon, 12 July 2010 06:20] by Moderator

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465047 is a reply to message #465046] Mon, 12 July 2010 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not at session level, at OS level.

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465048 is a reply to message #465047] Mon, 12 July 2010 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forgot to mention, set it as environment variable (so EXPORT), before you have to exit sqlplus and restart it after setting the variable.
Do you need the syntax?

And keep your lines in 80 characters width with code tags: split the lines.

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465052 is a reply to message #464999] Mon, 12 July 2010 06:35 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
bash-3.2$ export NLS_LANGUAGE="AMERICAN"
bash-3.2$ echo $NLS_LANGUAGE
AMERICAN


SQL> set serverout on 
Errors in file :
OCI-21500: Message 21500 not found; No message file for product=RDBMS, facility=OCI; arguments: [kope2uattr:charpass] [0xC1] [] []
å"å"å"èô÷èô÷KeüCE´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤ðD´E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤¬èô÷èô÷KeüCCE´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤ðD´E´E´ÿ,I´ÿùëöÀ¸¤E´E´ÿ,I´ÿùëöÀ¸¤ðD´E´E´ÿ,I´ÿùëöÀ¸¤¬SQL> 

Re: Unusual Error ( Garbage Chars Everyware) [message #465068 is a reply to message #465052] Mon, 12 July 2010 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So rest the wrong installation or Oracle bug.
Try to reinstall or contact Oracle.

Regards
Michel
Re: Unusual Error ( Garbage Chars Everyware) [message #465070 is a reply to message #465068] Mon, 12 July 2010 07:55 Go to previous messageGo to next message
Littlefoot
Messages: 19890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious - what about those message files I mentioned?
Re: Unusual Error ( Garbage Chars Everyware) [message #465072 is a reply to message #465052] Mon, 12 July 2010 08:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Oracle Client Or Server Install?
Are you logged in as Oracle user or other user?
Most probably, you might not have correct execute permissions on
$ORACLE_HOME/nls/mesg/*.

[Updated on: Mon, 12 July 2010 12:13]

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465080 is a reply to message #465070] Mon, 12 July 2010 09:12 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Littlefoot wrote on Mon, 12 July 2010 07:55
Just being curious - what about those message files I mentioned?


Sorry for delay . Yes there are files in said dir

-rwxr-xr-x 1 xxxxxx xxxxxx 4096 Jul 10 07:49 cpyus.msb
-rwxr-xr-x 1 xxxxxx xxxxxx 4369 Jul 10 07:49 cpyus.msg
-rwxr-xr-x 1 xxxxxx xxxxxx 11776 Jul 10 07:49 sp1us.msb
-rwxr-xr-x 1 xxxxxx xxxxxx 17957 Jul 10 07:49 sp1us.msg
-rwxr-xr-x 1 xxxxxx xxxxxx 33792 Jul 10 07:49 sp2us.msb
-rwxr-xr-x 1 xxxxxx xxxxxx 134081 Jul 10 07:49 sp2us.msg


Re: Unusual Error ( Garbage Chars Everyware) [message #465082 is a reply to message #465080] Mon, 12 July 2010 09:31 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
are these actually in /opt/Common/...?
Are you sure you named the directory with a leading capital C? (it is rather uncommon to do so)
Re: Unusual Error ( Garbage Chars Everyware) [message #465085 is a reply to message #465082] Mon, 12 July 2010 10:01 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For SQL*Plus messages are in $ORACLE_HOME/sqlplus/mesg, SQL and PL/SQL messages are in $ORACLE_HOME/rdbms/mesg. Check them.

Regards
Michel
icon14.gif  Re: Unusual Error ( Garbage Chars Everyware) [message #465100 is a reply to message #464999] Mon, 12 July 2010 11:01 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
I have solved the problem :

$ORLACE_HOME/$ORLACE_HOME/nls Dir was missing. , when we give command "set serverout on " it access the OCI interface.

Solution I have copied nls/* in oracle home and its working fine now.

Thanks for your help

Note :- if you dont use serverout on , it will not give you any error messages ( set set all output messages off including verfiy off etc )

[Updated on: Mon, 12 July 2010 11:01]

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465107 is a reply to message #465100] Mon, 12 July 2010 12:09 Go to previous messageGo to next message
Littlefoot
Messages: 19890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Gee, that's again some bogus information. I'm pretty sure it is not ORLACE. Or is it?
Re: Unusual Error ( Garbage Chars Everyware) [message #465109 is a reply to message #465107] Mon, 12 July 2010 12:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Littlefoot wrote on Mon, 12 July 2010 19:09
Gee, that's again some bogus information. I'm pretty sure it is not ORLACE. Or is it?

Nor is it very likely that it was an $ORACLE_HOME/$ORACLE_HOME/nls directory...
Re: Unusual Error ( Garbage Chars Everyware) [message #465132 is a reply to message #465080] Mon, 12 July 2010 17:22 Go to previous messageGo to next message
mikerault
Messages: 21
Registered: June 2010
Location: Alpharetta, Ga
Junior Member
Are you sure the ORACLE_HOME is set to the correct value?
Re: Unusual Error ( Garbage Chars Everyware) [message #465133 is a reply to message #465107] Mon, 12 July 2010 20:40 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Littlefoot wrote on Mon, 12 July 2010 12:09
Gee, that's again some bogus information. I'm pretty sure it is not ORLACE. Or is it?


Its not Bogus LittleFoot.

Steps To Reproduce. ( On Linux)

1/ Rename $ORACLE_HOME/nsl to $ORACLE_HOME/nls_1
2/ log into server
3/ set Serverout on
4/ you should get the error.

Please Try Smile

[Updated on: Mon, 12 July 2010 20:43]

Report message to a moderator

Re: Unusual Error ( Garbage Chars Everyware) [message #465151 is a reply to message #465133] Tue, 13 July 2010 00:06 Go to previous messageGo to next message
Littlefoot
Messages: 19890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, rahulvb
$ORLACE_HOME/$ORLACE_HOME/
is bogus.
Re: Unusual Error ( Garbage Chars Everyware) [message #465157 is a reply to message #464999] Tue, 13 July 2010 00:53 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Embarassed Ok My bad there but ,
Littlefoot Please Allow me to Call it "Typo"
Previous Topic: DBMS_OUTPUT
Next Topic: CPU Patch
Goto Forum:
  


Current Time: Sat Dec 20 18:25:04 CST 2014

Total time taken to generate the page: 0.13217 seconds