Forum: Oracle

In my work we have a SC 4.1.1 working with P4 file, previously we've got a shadow with a oracle 8.1.7 working, but for problems with server the...

Hi! We're using Oracle db server as RDBMS for ServiceCenter and we would like to know which are the minimal roles and privileges exactly...

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...

Oracle 9 SC server 6.2.4.2 SC Client 6.2.4.0 In P4 everything works fine. Then I convert all the files to Oracle on the customers database....

Are there any special considerations if using Oracle on Unix vs windows ? I have problem with a system that works fine on a windows oracle server...

HI all, small question here for anyone who is using SC6.x or SC7.x with Oracle database. Is the search faster with Oracle db than P4 db? If...

Beware of this demon-posessed sc.ini parameter! When this parameter is switched on, terrible things happen. Data is not displayed, and...

Hi all: when I use service center 6.2 convert p4 to oracle 10.2.0,there has some error . some table which has IR key ,for example cm3r will...

Hi, i am in a process of converting p4 db type to oracle 10g, when the conversion process is running i recieve an error in the log file that...

We are currently mapped out to Oracle 9 and are preparing to move ServiceCenter to a new server. For testing, we have made a copy of our production...

Hello, I noticed something concerning about the number of connections taken in Oracle. It seems that every SC process and every user connection in...

Hi, We are working on a project involving 2 major parts: ServiceCenter 6.1.1 (for the service desk) and another solution for inventory,...

Hello, I created an Oracle SQL script that deletes closed incidents and related data from eg. clocks, activity,etc. older then 2 years. This works...

We upgraded a test system from Oracle 8 to Oracle 9 I changed the binaries to the oraoci9 equivalents and tried to start the SC again. The SC...

We are disastified with the functionnality found inside of the get service product espacially the change process implementation. Are organisation...

I dont see any sqlmapping records for any version of Oracle after 8x. Does anyone know where to get these? Any lessons learned for pushing to Oracle...

Hello All, I need some help with Shadowing to Oracle. I have the ticket files (incidents, problem, Probsummary etc.) shadowed to Oracle. All...

Hello Guys ! I'am back for some new problems ! I am moving my P4 database (SC4.0.9) to Oracle 8.1.7. All tablespaces are well...

Anyone Shadowing Files ? Any help would be greatly appreciated. When shadowing files to Oracle from p4, how much space is needed on the Oracle...

Question ?? Shadowing from P4 to Oracle, is there a parameter to set the case sensitivity in Oracle to case in-sensitivity ? Our Sc P4 files are...

If you have shadowed your database (p4) to Oracle I would like to know the pros and cons of the shadowing your database to a sequel database like...

We have recently gone "live" with ServiceCenter 4.1. We have completely pushed out to Oracle. Now we are working on our first maintenance project. ...

We have made a copy of the oracle side of our production system so we can fine tune the tablespaces and whatever else a DBA does. The DBA is now...

Hello, I'm sorry because may be I aks an studip question, but I'm just new in this SC world. We are going to put SC with Oracle RDMBS. I can...

Hello everybody ! I have a single question about the mapping between P4 (Sc 4.1.1) and Oracle 8. I have the fields comments of my request wich...