Thread: Error on creating connection from ServiceCenter 6.2 to Oracle 9.2

Hello,

I installed ServiceCenter 6.2 Server and am currently trying to create a connection from the SC 6.2 P4 database to Oracle in order to shadow the P4 and use the Oracle database as operational database. These are the changes i have made:

- edited the login credentials in the sc.ini file
- created an Oracle in OraHome ODBC connection to connect to a newly created Oracle database that will be used to load the shadow tables in
- in the sc.cfg file disabled all lines except for "scenter -listener" so theres only 1 process running once im in SC

When i open the Service Center Console and start the server, it tells the service is not running. when i open the sc.log file i see the following error message. Anyone knows a solution to this or documentation that explains how to connect to Oracle using ServiceCenter 6.2? Really appreciated!


ERROR:

640 02/25/2008 15:56:43 RTE I Not using string pool
640 02/25/2008 15:56:43 RTE I ServiceCenter licensed on system (127.16.0.13)
640 02/25/2008 15:56:43 RTE I ServiceCenter console application
640 02/25/2008 15:56:43 RTE I Using "malloc" memory manager
640 02/25/2008 15:56:43 RTE I Not using string pool
2884 02/25/2008 15:56:44 RTE I Not using string pool
2884 02/25/2008 15:56:44 RTE I Not using string pool
2884 02/25/2008 15:56:44 RTE I scservic: start service event received for service ServiceCenter1
2884 02/25/2008 15:56:44 RTE I scservic: starting process scenter -listener
576 02/25/2008 15:56:44 RTE I Using "utalloc" memory manager
576 02/25/2008 15:56:44 RTE I Not using string pool
576 02/25/2008 15:56:44 RTE I Initializing listener(12670)
576 02/25/2008 15:56:44 RTE I Registration complete, waiting for connection
576 02/25/2008 15:56:44 RTE I Process scenter 6.2.0.0 (0346) System: 12670 (0x61e13c00) on PC running Windows Server 2003 (5.2 Build 3790) from ServiceCenter1 (127.16.0.13)
576 02/25/2008 15:56:44 RTE I Creating resources for system '12670' with key 0x61e13c00
576 02/25/2008 15:56:44 RTE I Shared memory size set to 200000000
576 02/25/2008 15:56:44 RTE D iinfo is initialized: 03020358
576 02/25/2008 15:56:44 RTE I ServiceCenter licensed on system (127.16.0.13)
576 02/25/2008 15:56:44 RTE I Allocating SQL Server statics
576 02/25/2008 15:56:44 RTE Connection established to database ORASC62
576 02/25/2008 15:56:44 RTE Connected to Data source 'ORASC62' SQL server 'ORASC62 ' version: 9.2.10 Using database '' as user 'system'
576 02/25/2008 15:56:44 RTE Neither dblanguage nor language parameter are specified.
576 02/25/2008 15:56:44 RTE An empty select list is passed in sqlopen()
576 02/25/2008 15:56:44 RTE Error: SQL State: HY000-922 Message: [Oracle][ODBC][Ora]ORA-00922: Missing or invalid option.
576 02/25/2008 15:56:44 RTE E SQL State: HY000-922 Message: [Oracle][ODBC][Ora]ORA-00922: Missing or invalid option.
576 02/25/2008 15:56:44 RTE sqlExec error statement= SET DATEFORMAT YMD
576 02/25/2008 15:56:44 RTE E sqlExec error statement= SET DATEFORMAT YMD
576 02/25/2008 15:56:44 RTE Error: SQL State: HY000-922 Message: [Oracle][ODBC][Ora]ORA-00922: Missing or invalid option.
576 02/25/2008 15:56:44 RTE E SQL State: HY000-922 Message: [Oracle][ODBC][Ora]ORA-00922: Missing or invalid option.
576 02/25/2008 15:56:44 RTE sqlExec error statement= SET ANSI_WARNINGS OFF
576 02/25/2008 15:56:44 RTE E sqlExec error statement= SET ANSI_WARNINGS OFF
576 02/25/2008 15:56:44 RTE Error: SQL State: 42S02-942 Message: [Oracle][ODBC][Ora]ORA-00942: Table or view does not exist.
2884 02/25/2008 15:56:45 RTE I scservic: initialization complete
576 02/25/2008 15:56:45 RTE I [Address ] Symbol(Parm1,Parm2,Parm3,Parm4) +Offset Source module
576 02/25/2008 15:56:46 RTE I [604986D4] stappendEx(0x12F0B0,0x11F388,0xB52FD0,0x77E620E0) +0x44 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-string.c-1038
576 02/25/2008 15:56:46 RTE I [60681566] sql_errmsg(0x1400160,0x1,0xFFFFFFFF,0x14E19F0) +0x316 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SQMSSQL.ODBC.DLL-sqsqlcli.cpp-470
576 02/25/2008 15:56:46 RTE I [60686F10] sqlSelect(0x1400160,0xB65800,0x0,0xB69200) +0x2F0 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SQMSSQL.ODBC.DLL-sqsqlcli.cpp-1365
576 02/25/2008 15:56:46 RTE I [6047516A] sqGetNoCommit(0x13C70B0,0x0,0x0,0xB52FD0) +0x43A C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-sqmisc.cpp-2731
576 02/25/2008 15:56:46 RTE I [604638BE] sqGet(0x13C70B0,0xB654A0,0x13C70B0,0xB69200) +0x25E C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-sq.cpp-1528
576 02/25/2008 15:56:46 RTE I [604658C5] sqFetch(0xB654A0,0xB654A0,0x0,0x0) +0xF5 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-sq.cpp-1182
576 02/25/2008 15:56:46 RTE I [60465F57] sqOpenCursor(0xB654A0,0x0,0xFFFDFFFF,0x13C70B0) +0x107 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-sq.cpp-1890
576 02/25/2008 15:56:46 RTE I [60350BFA] _checkQueryCache(0x13C70B0,0xB52FD0,0x0,0x0) +0x8A C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-8909
576 02/25/2008 15:56:46 RTE I [603520ED] dbOpenCursor(0x13C70B0,0x12F5EC,0x0,0x0) +0x4AD C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-3431
576 02/25/2008 15:56:46 RTE I [60352E45] dbDBDget(0x12F640,0x13,0xB52FD0,0x60586C90) +0xF5 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-1766
576 02/25/2008 15:56:46 RTE I [603534EE] dbGetSchema(0x13C74B0,0x60586C90,0x13C74F4,0x0) +0x58E C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-762
576 02/25/2008 15:56:46 RTE I [603537ED] _initRelationCommon(0x60586C90,0x605B6340,0xB65500 ,0x0) +0x22D C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-2698
576 02/25/2008 15:56:46 RTE I [603540C1] dbInitRelation(0x60586C90,0x605B6340,0xB65500,0xB5 2FD0) +0x61 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-2615
576 02/25/2008 15:56:46 RTE I [604023B9] pdbsInitRelation(0x12F7B8,0x60586C90,0x605B6340,0x 0) +0x39 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-pdbs.cpp-443
576 02/25/2008 15:56:46 RTE I [603F9B72] pdbInitRelation(0xB65500,0x60586C90,0x605B6340,0x0 ) +0x252 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-pdb.cpp-1297
576 02/25/2008 15:56:46 RTE I [6040073D] pdbfileSelectSortRel(0x12F804,0x60586C90,0x60586C9 C,0x12F82C) +0xCD C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-pdbfile.cpp-222
576 02/25/2008 15:56:46 RTE I [60400C46] pdbfileSelect(0x60586C90,0x60586C9C,0x12F82C,0x1) +0x26 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-pdbfile.cpp-129
576 02/25/2008 15:56:46 RTE I [604B3294] tzstart(0x0,0x1,0x1,0x6039522F) +0x134 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-tzstart.c-207
576 02/25/2008 15:56:46 RTE I [60354B74] dbstart(0xB69040,0xB69040,0x0,0x0) +0x14 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-dbi.cpp-5061
576 02/25/2008 15:56:46 RTE I [6039522F] inhookEx(0x0,0x12F89C,0x7FFF,0xB69040) +0xADF C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-in.cpp-456
576 02/25/2008 15:56:46 RTE I [6049D4D2] systartEx(0x0,0x7FFF,0x604581BE,0x0) +0x92 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-systart.cpp-143
576 02/25/2008 15:56:46 RTE I [6049D64F] systart(0x0,0x2,0x414C20,0x7C38B548) +0xF C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-systart.cpp-127
576 02/25/2008 15:56:46 RTE I [604581BE] _listenerStartup(0x12F914,0x40221D,0x7C342955,0x12 FF60) +0x6E C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-scxpress.cpp-266
576 02/25/2008 15:56:46 RTE I [6049B66B] syman(0x2,0x414C20,0x0,0x0) +0x29B C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\SCENTER.dll-syman.cpp-222
576 02/25/2008 15:56:46 RTE I [00401378] main(0x2,0x414C20,0x412988,0x403000) +0x378 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\scenter.exe-cppmain.cpp-103
576 02/25/2008 15:56:46 RTE I [0040164F] mainCRTStartup(0x0,0x0,0x7FFDF000,0x0) +0x143 C:\Program Files\Peregrine Systems\ServiceCenter 6.2\Server\RUN\scenter.exe-crtexe.c-398
576 02/25/2008 15:56:46 RTE I [77E6F23B] ProcessIdToSessionId(0x40150C,0x0,0x78746341,0x20) +0x209 C:\WINDOWS\system32\kernel32.dll
576 02/25/2008 15:56:46 RTE I ===> Signal 11: User=n/a, Application=n/a, Panel=n/a
576 02/25/2008 15:56:46 RTE I RAD thread id 0, last option key 0
576 02/25/2008 15:56:46 RTE D In _termAbort()
576 02/25/2008 15:56:46 RTE I Process termination cleanup complete for pid(576)

thanks for your quick reply tommy

where do i have to specify the Oracle database name?

tommy,

these are the lines that i have in the sc.ini file

sqldb:ORASC62
sqllogin:username/password

ORASC62 is the TNS service name. I double checked this in the ODBC connection i made.

ok, well if theres someone with the solution please let me know!

SC does *not* use ODBC. It uses Oracle native libraries. Do you have the Oracle client correctly installed on the SC server? Can you connect to that TNS name with sqlplus?

connect username/password@ORASC62 - ORASC62 is the name of the newly created Oracle 9 database and yes i can connect to the database using SQLPLUS.

The client? Do you mean the Enterprise Manager Console? If so then yes it is installed.

i created a new user and created a two new tablespaces, one temporary and one permanent. assigned them to the new user, but it still aint working

tommy, is the oracle client a seperate installer? cause i cant find it on the oracle cd's


also when i remove the oracle home ODBC connection to the oracle database, the following error is shown in the log. Doesnt ServiceCenter always use ODBC? Also for Oracle?


3352 02/26/2008 10:37:57 RTE I Allocating SQL Server statics
3352 02/26/2008 10:37:57 RTE Going to sleep for 15 seconds and try again to connect
3064 02/26/2008 10:37:58 RTE I scservic: initialization complete
3352 02/26/2008 10:38:12 RTE Going to sleep for 15 seconds and try again to connect
3352 02/26/2008 10:38:27 RTE Going to sleep for 15 seconds and try again to connect
3352 02/26/2008 10:38:42 RTE Failure connecting to SQL database ORASC62
3352 02/26/2008 10:38:42 RTE Error: SQL State: IM002-0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
3352 02/26/2008 10:38:42 RTE E SQL State: IM002-0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
3352 02/26/2008 10:38:42 RTE sqlExec error statement= SQL CONNECT
3352 02/26/2008 10:38:42 RTE E sqlExec error statement= SQL CONNECT
3352 02/26/2008 10:38:42 RTE E tzstart: unable to open the "info" file
3352 02/26/2008 10:38:42 RTE E unable to open file
3352 02/26/2008 10:38:42 RTE E _loadDbdefCache: Failed to open file 'joindefs', records will not be stord in cache
3352 02/26/2008 10:38:42 RTE E _loadDbdefCache: Failed to open file 'erddef', records will not be stord in cache
3352 02/26/2008 10:38:42 RTE E _loadDbdefCache: Failed to open file 'sctypecheck', records will not be stord in cache
3352 02/26/2008 10:38:42 RTE E _loadDbdefCache: Failed to open file 'scmandant', records will not be stord in cache
3352 02/26/2008 10:38:42 RTE E _loadDbdefCache: Failed to open file 'scaccess', records will not be stord in cache
3352 02/26/2008 10:38:42 RTE E dbstart: some mandanten definition files are not accessible, terminating.
3352 02/26/2008 10:38:42 RTE E Failure opening 'code' file, terminating.
3352 02/26/2008 10:38:42 RTE E ServiceCenter is unable to start
3352 02/26/2008 10:38:42 RTE E Failed to initialize one or all of the core files( code, format and link)
3352 02/26/2008 10:38:42 RTE I ---------------------- Cache Statistics ----------------------


3352 02/26/2008 10:38:42 RTE I Slot use: 0%; Average Slot Depth: 1; Maximum Slot Depth: 1

3352 02/26/2008 10:38:42 RTE I Shutdown of ServiceCenter environment has completed
3352 02/26/2008 10:38:42 RTE E Failed to initialize or attach to shared memory environment. Return code -1
3352 02/26/2008 10:38:42 RTE E expressterm returned -1
3352 02/26/2008 10:38:42 RTE I Process termination in progress
3352 02/26/2008 10:38:42 RTE E getMyProcessInfo does not have a userp->myProcessStats()!
3352 02/26/2008 10:38:42 RTE E Error 487 in call VirtualFree - Attempt to access invalid address.
3352 02/26/2008 10:38:42 RTE I Process termination cleanup complete for pid(3352)

where can i find the oracle native library to create a connection?

nop, working on this by myself

You can download the Oracle client from Oracle's website. I'm going through this process right in my test environment and the client installed with no problems on our server (RedHat ES 4). If you continue to have problems post back.

EDIT
Don't forget to update the ServiceCenter/ServiceManager user account with PATH information it needs to find the Oracle lib directory

wow, thats a long time back. anyway i solved the problem a long time back. if i remember correct, the problem was that the P4 was already shadowed to sql. if you use a clean install of SC 6.2, the above steps should be enough to get it working.

Glad to hear it worked out for you. I know some of the posts may be old on here but if the answers are posted it will help anybody searching. Cheers