make oracle db case insensitive (502 Views)
Reply
Frequent Advisor
darshana_ss
Posts: 85
Registered: ‎02-07-2012
Message 1 of 1 (502 Views)

make oracle db case insensitive

Hi,

 

I am using HPSM 9.31 on Oracle 11g. I am done with basic installation of HPSM Server, Web Tier, KM Search Engine, Crystal Report.

 

But now client wants to make HPSM case insensitive.

 

I have changed DB with

alter system set NLS_SORT='BINARY_CI' scope=spfile;


alter system set NLS_COMP='LINGUISTIC' scope=spfile;

 

Then I restarted DB and HPSM Server both. It is showing properly in sm.log that my both parameters NLS_SORT and NLS_COMP has been set properly to BINARY_CI and LINGUISTIC.

 

But I am getting following errors and I am not able to connect to SM server using client:

2648(  2604) 12/27/2012 16:54:40  RTE I Oracle server settings for language, territory and character set: AMERICAN_AMERICA.WE8MSWIN1252 (AL16UTF16)
  2648(  2604) 12/27/2012 16:54:40  RTE I OCI Client settings for language, territory and character set: AMERICAN_AMERICA.AL32UTF8 (UTF16)
  2648(  2604) 12/27/2012 16:54:40  RTE I Oracle instance setting for NLS_SORT is set to BINARY_CI
  2648(  2604) 12/27/2012 16:54:40  RTE I Oracle instance setting for NLS_COMP is set to LINGUISTIC
  2648(  2604) 12/27/2012 16:54:40  RTE I Oracle session is set up in CASE INSENSITIVE mode
  2648(  2604) 12/27/2012 16:54:41  RTE I Detected that table 'DBDICTM1' is case insensitive, changed flag in dbdict record for file 'dbdict'
  2648(  2604) 12/27/2012 16:54:41  RTE I Dbdict of file (dbdict --> dbdict) was updated by user (null)
  2648(  2604) 12/27/2012 16:54:42  RTE I [Address ] Symbol(Parm1,Parm2,Parm3,Parm4) +Offset                                          Source module
  2648(  2604) 12/27/2012 16:54:42  RTE I  1: [61E1E611] rcrd1(0x26A9CC8,0x26AB4F8,0x17C960,0x1A13F4B0) +0x31                             E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-rcche.cpp-754
  2648(  2604) 12/27/2012 16:54:42  RTE I  2: [61E1F56B] rckeynxt(0x26C6DC0,0x26AB508,0x26C6DC0,0x26C6E58) +0x10B                         E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-rckeynxt.cpp-712
  2648(  2604) 12/27/2012 16:54:42  RTE I  3: [61E768B8] sqPrimaryKey(0x26C6DC0,0x17C9C8,0x26A25F0,0x26C6DC0) +0x28                       E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-sqmisc.cpp-4146
  2648(  2604) 12/27/2012 16:54:42  RTE I  4: [61E64D06] sqFind(0x1A0EB3E0,0x17CA08,0x26C6E1C,0x26C6DC0) +0xD6                            E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-sq.cpp-1994
  2648(  2604) 12/27/2012 16:54:42  RTE I  5: [61DA7AEF] dbGetSchema(0x0,0x62005DB0,0x26C6E04,0x26A25F0) +0x2DF                           E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-699
  2648(  2604) 12/27/2012 16:54:42  RTE I  6: [61DAE09A] _initRelationCommon(0x62005DB0,0x6200614C,0x26AB4C0,0x0) +0x17A                  E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-2658
  2648(  2604) 12/27/2012 16:54:42  RTE I  7: [61DB0859] dbInitRelation(0x62005DB0,0x6200638C,0x26AB4C0,0x26AB4C0) +0x69                  E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-2585
  2648(  2604) 12/27/2012 16:54:42  RTE I  8: [61E11BC6] pdbInitRelation(0x26AB4C0,0x62005DB0,0x6200638C,0x26A25F0) +0x26                 E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-pdb.cpp-589
  2648(  2604) 12/27/2012 16:54:42  RTE I  9: [61DA9591] _openOneGlobalFile(0x0,0x1,0x26A25F0,0x0) +0x31                                  E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-4890
  2648(  2604) 12/27/2012 16:54:42  RTE I 10: [61DAC5E0] _globalFileInit(0x1,0x26C68D8,0x1,0x61DE124A) +0xB0                              E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-4974
  2648(  2604) 12/27/2012 16:54:42  RTE I 11: [61DB434A] dbstart(0x61DE2839,0x26A25F0,0x356EE8,0x17CBE4) +0x5A                            E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-dbi.cpp-5081
  2648(  2604) 12/27/2012 16:54:42  RTE I 12: [61DE124A] _agdbhook(0x26A25F0,0x356EE8,0x17CBE4,0x0) +0xA                                  E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-in.cpp-620
  2648(  2604) 12/27/2012 16:54:42  RTE I 13: [61DE2839] inhook(0x7FFF,0x356EE8,0x1,0x74F07408) +0x749                                    E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-in.cpp-437
  2648(  2604) 12/27/2012 16:54:42  RTE I 14: [61E88D27] _symanStart(0x1,0x356EE8,0x1,0x74F07408) +0x447                                  E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-syman.cpp-393
  2648(  2604) 12/27/2012 16:54:42  RTE I 15: [61E88ED9] syman(0x1,0x356EE8,0x4033FC,0x1) +0x89                                           E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\SM.dll-syman.cpp-183
  2648(  2604) 12/27/2012 16:54:42  RTE I 16: [0040135E] main(0x1,0x356EE8,0x351A20,0x39692CE1) +0x34E                                    E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\sm.exe-cppmain.cpp-235
  2648(  2604) 12/27/2012 16:54:42  RTE I 17: [00401553] __tmainCRTStartup(0xFFFDE000,0x17FFD4,0x7703D24D,0xFFFDE000) +0x10F              E:\Program Files (x86)\HP\Service Manager 9.30\Server\RUN\sm.exe-crtexe.c-582
  2648(  2604) 12/27/2012 16:54:42  RTE I 18: [7570ECCB] BaseThreadInitThunk(0xFFFDE000,0x770B35F5,0x0,0x0) +0xE                          C:\Windows\syswow64\kernel32.dll-
  2648(  2604) 12/27/2012 16:54:42  RTE I 19: [7703D24D] RtlCreateUserProcess(0x4016FA,0xFFFDE000,0xFFFFFFFF,0x7705D68C) +0x8C            C:\Windows\SysWOW64\ntdll.dll-
  2648(  2604) 12/27/2012 16:54:42  RTE I 20: [7703D45F] RtlCreateProcessParameters(0x4016FA,0xFFFDE000,0x0,0x78746341) +0x4E             C:\Windows\SysWOW64\ntdll.dll-
  2648(  2604) 12/27/2012 16:54:42  RTE I !!! Core Generation is disabled.  Ignoring Generate Core Dump Request.
  2648(  2604) 12/27/2012 16:54:42  RTE E Exception caught in syman(): Win32 Exception: 0xC0000005 (instruction 0x61E1E611 while reading address 0x00000048)
  2648(  2604) 12/27/2012 16:54:42  RTE I -Memory : S(396256) O(210844) MAX(803772) - MALLOC's Total(6026)
  2648(  2604) 12/27/2012 16:54:42  RTE I ===> Signal 11: User=n/a, Application=Unknown, Panel=Unknown
  2648(  2604) 12/27/2012 16:54:42  RTE I  RAD thread id 0, last option key 0

 

Kindly help.  I do not want to empty db tables.

 

 

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.