Personal tools
You are here: Home → Computing → Software → Databases
 

Databases

Databases at RZG

There are several Oracle-databases available for different purposes. Currently they undergo a major reconfiguration. Please contact the helpdesk for assistance.

There are four Oracle databases, three in Garching and one in Greifswald. The connect parameters are described below:

General Database for IPP Garching

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

Database for Comptel (MPE)

  HOST = pythia1.rzg.mpg.de
  PORT = 1521
  SERVICE_NAME = comptelX.rzg.mpg.de
  Names = comptel
  Version = 10.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 = baltic2.ipp-hgw.mpg.de
  PORT = 1521
  SERVICE_NAME = w7x
  Names = plm, w7x, w7as
  Version = 11.1.0.7

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 = pythia1.rzg.mpg.de)
               )
            )
         (CONNECT_DATA =
           (SERVICE_NAME = oradb1.rzg.mpg.de)
        )
      )

Oracle Documentation (Oracle-Doc-Server)

Database Documentation (all directly from the Oracle-Doc-Server)

 

Document Actions