MENU

Information Access

UMKC Information Services Information Access

Connection Information


Server: KC-ISIA-ORA1.kc.umkc.edu
Port: 1521
SID: KCDW2
Version: 11.2.0.3
TNSNAMES:
    KCDW2 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = KC-ISIA-ORA1.kc.umkc.edu)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = kcdw2.world)
        )
      )


Server: KC-ISIA-ORA2.kc.umkc.edu
Port: 1521
SID: KCDW3
Version: 11.2.0.3
TNSNAMES:
    KCDW3 =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = KC-ISIA-ORA2.KC.UMKC.EDU)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = KCDW3.WORLD)
        )
      )


Server: KC-CSRV-ORA3.kc.umkc.edu
Port: 1521
SID: ROOTDB
Version: 11.2.0.3
TNSNAMES:
    ROOTDB =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = kc-csrv-ora3.kc.umkc.edu)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = rootdb.world)
        )
      )


Server: KC-CSRV-ORA4.kc.umkc.edu
Port: 1521
SID: KCORA2
Version: 11.2.0.3
TNSNAMES:
    KCORA2 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = KC-CSRV-ORA4.kc.umkc.edu)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = KCORA2)
        )
      )


Server: KC-CSRV-IRAPORA.kc.umkc.edu
Port: 1521
SID: IRAPDW
Version: 11.2.0.3
TNSNAMES:
    IRAPDW =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = KC-ISIA-IRAPORA.KC.UMKC.EDU)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = IRAPDW.WORLD)
        )
      )


Server: KC-CSRV-IRAPODV.kc.umkc.edu
Port: 1521
SID: IRADDW
Version: 11.2.0.3
TNSNAMES:
    IRADDW =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = KC-ISIA-IRAPODV.KC.UMKC.EDU)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = IRADDW.WORLD)
        )
      )




Resource


Oracle FAQ

What is an Oracle database?
    Oracle Corporation is the software provider of the Oracle Relational Database Management System (RDMBS). It is a very robust and solid option for storing and accessing data. Here at UMKC we have many RDBMS solutions including Microsoft SQL Server, Oracle MySQL, and FileMaker available
We have determined that our department has a need for an Oracle database. Who do I contact for that?
    Please reach out to the IS department or submit a Technology Support Center request and specify as much detail as possible about your project and also why you need a database. We have several Oracle database servers which can certainly satisfy the needs of your department and/or project(s).
We received an email about our new Oracle database which has a "Schema" listed. What is a "Schema"?
    An Oracle schema is both the user who you will use (along with the password provided) to log into the Oracle database as well as the name of the container in which the database objects (tables, indexes, views, procedures, etc.) will be stored.
We need help creating the database tables and/or bringing data into our Oracle schema. How do we get help with that?
    You can reach out to your IS contact who has been working on the project with you, or submit a request to the Technology Support Center and they will put you in contact with someone on our team who can help.