logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 31 / 1
DesiJat
anyone know how to disable the firewall within Oracle Ent. Linux ?
from command line preferrably
found it... /etc/selinux/config
mator
DesiJat, selinux is not a firewall
DesiJat
yes, sorry
i meant to say selinux/firewall
i wanted to disable both
DiscordianUK
not good practice
SilSila
how can i know the orginal characterset of my database? when i check my v$nls_parameters its showing WE8PC850. its storing all the arabic characters from the client and i am able to view the arabic characters only from the client.if i see it from the server its junk.
so how can i know, the characterset of my data?
Trengo
SilSila your "server" doesnt support that encoding perhaps?
SilSila
Trengo:how can i know which encoding is my server using?
TheBonsai
nls_database_parameters
SilSila
TheBonsai: this is same as v$nls_parameters.....now can i know the original characters of my data which is in the table? database characterset is WE8PC850...
         

TheBonsai
if database character set is WE8PC850 then your data is stored in this character set.
SilSila
TheBonsai: ok...what is the best way to change database character set of WE8PC850 to AR8MSWIN1256? I did like this...installed 10gR2 in RHEL 4.8 created the same database as my old one. exported the userschema of my old one with set nls_lang=AR8MSWIN1256...after that i imported to the new db..after importing to 10g with new characterset its showing as junk.
TheBonsai
did the exp/imp log tell something about character set conversion?
is AR8MSWIN1256 able to contain characters from WE8PC850 at all? if not, you have data loss (of course)
SilSila
disconnected...
TheBonsai:did u give any reply during my disconnection?
TheBonsai
<TheBonsai> did the exp/imp log tell something about character set conversion?
<TheBonsai> is AR8MSWIN1256 able to contain characters from WE8PC850 at all? if not, you have data l
oss (of course)
SilSila
Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set...server uses WE8PC850 character set (possible charset conversion)
TheBonsai
is AR8MSWIN1256 able to contain characters from WE8PC850 at all?
SilSila
when the characterset was WE8PC850 the arabic are displaying correctly in windows xp client. when i run/query from windows xp with AR8MSWIN1256 then its showing as junk
« prev next »