Oracle Databases

Oracle Databases at MPCDF

There are several Oracle-databases available for different purposes. Please contact the helpdesk for assistance.

There are currently 3 Oracle databases, two in Garching and one in Greifswald. The connect parameters are described below:

General Database for IPP Garching

  HOST = pythia.rzg.mpg.de
  PORT = 1521
  SERVICE_NAME = oradb1.rzg.mpg.de
  Names = ipp, aug, libris
  Version = 11.2.0.4

Database for PLM (Garching)

  HOST = zteusv1.ipp.mpg.de
  PORT = 1521
  SERVICE_NAME = plmaug.ipp.mpg.de
  Names = plmaug
  Version = 9.2.0

General Database for IPP Greifswald

  HOST = sv-it-plmdb-1.ipp-hgw.mpg.de
  PORT = 1521
  SERVICE_NAME = w7x.ipp.mpg.de
  Names = plm, w7x, w7as
  Version = 11.2.0.4

Note that for UNIX-systems accessing the database-software via afs, the configuration will be initialized properly when calling orainit <name>. If you have you have a local installation, you need to setup your tnsnames.ora file properly with the paramters above correctly entered. An example below is the definition for accessing the general IPP database under the name ipp

ipp =
     (DESCRIPTION =
        (ADDRESS_LIST =
           (ADDRESS =
              (COMMUNITY = rzg.mpg.de)
                 (PROTOCOL = TCP)
                 (PORT = 1521)
                 (HOST = pythia.rzg.mpg.de)
               )
            )
         (CONNECT_DATA =
           (SERVICE_NAME = oradb1.rzg.mpg.de)
        )
      )

Document Actions