HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

make oracle db case insensitive

Highlighted
Frequent Advisor

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.