Red hat linux database

Red hat linux database

Could you be so kind to share your experience with mentioned
patch set 9.2.0.5 and other patches required for successful
AIO implementation on RHEL AS 3 regarding release 9.2.0.4
performance improvement.

Very truly yours
Anonymous

1.3 , votez ( ? ), 17:26, 28/07/2004 [ответить] [﹢﹢﹢] [ · · · ] + / –
А у меня не работает инсталлятор, по-моему из-за x.org (xhost & export DISPLAY сделаны):

Exception in thread «main» java.lang.InternalError: Can’t connect to X11 window server using ‘127.0.0.1:0.0’ as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment. (X11GraphicsEnvironment.java:59)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:58)
at java.awt.Window. (Window.java:188)
at java.awt.Frame. (Frame.java:315)
at java.awt.Frame. (Frame.java:262)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:593)

  • 2.4 , Adekamet ( ? ), 19:34, 28/07/2004 [^] [^^] [^^^] [ответить]
  • + / –
    а у меня запскается инсталятор, но не реагирует ни на какие кнопки окромя «О инсталяторе» и «удаление установленных продуктов» и не догнать из-за чего.
  • 3.12 , 1 ( ?? ), 14:32, 24/01/2005 [^] [^^] [^^^] [ответить]
  • + / –
    попробуй деактивировать NumLock.
  • 2.13, Ramallah ( ? ), 19:50, 23/02/2005 [^] [^^] [^^^] [ответить]
  • + / –
    >А у меня не работает инсталлятор, по-моему из-за x.org (xhost & export
    >DISPLAY сделаны):
    >
    >Exception in thread «main» java.lang.InternalError: Can’t connect to X11 window server using
    >’127.0.0.1:0.0′ as the value of the DISPLAY variable.
    > at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
    > at sun.awt.X11GraphicsEnvironment. (X11GraphicsEnvironment.java:59)
    > at java.lang.Class.forName0(Native Method)
    > at java.lang.Class.forName(Class.java:120)
    > at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:58)
    > at java.awt.Window. (Window.java:188)
    > at java.awt.Frame. (Frame.java:315)
    > at java.awt.Frame. (Frame.java:262)
    > at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:593)

    Открой командную строку заново.
    Така ошибка бывалевается вроде когда ты уже использовал su.
    У меня так было.

    2.14, Timoti ( ? ), 15:46, 10/11/2005 [^] [^^] [^^^] [ответить] + / –
    Так как же избавиться от ошибки, у меня точно такая же выползает
    Exception in thread «main» java.lang.InternalError: Can’t connect to X11 window server using ‘127.0.0.1:0.0’ as the value of the DISPLAY variable.
    at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
    at sun.awt.X11GraphicsEnvironment. (X11GraphicsEnvironment.java:59)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:120)
    at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:58)
    at java.awt.Window. (Window.java:188)
    at java.awt.Frame. (Frame.java:315)
    at java.awt.Frame. (Frame.java:262)
    at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:593)
    3.17, Хэс ( ?? ), 12:18, 29/11/2007 [^] [^^] [^^^] [ответить] + / –
    Была такая же ошибка пока вместо \runInstaller.sh не запустил \install\linux\runInstaller
    1.5 , Егор ( ?? ), 07:52, 18/08/2004 [ответить] [﹢﹢﹢] [ · · · ] + / –
    Не освещен вопрос с glibc
    есть там такая кочевряжина
    запускаещь ./runInstaller
    а он (подумав немного) выдает что то вроде
    libc++blablabla.so.2 not found (точно не помню).
    1.6 , Егор ( ?? ), 07:54, 18/08/2004 [ответить] [﹢﹢﹢] [ · · · ] + / –
    Пардон, обознался. Извините.
    1.8 , Fedor ( ?? ), 21:30, 18/09/2004 [ответить] [﹢﹢﹢] [ · · · ] + / –
    aio-stress выполняется без ошибок ввод/вывода, следовательно ядро поддерживает AIO

    Описание проблемы:
    Релинк бинарных файлов Oracle:

    Shutdown Oracle
    make -f ins_rdbms.mk async_on
    make -f ins_rdbms.mk ioracle
    Startup Oracle.

    Modify screen «SPFILE» of OEM console:
    disk_asynch_io=true
    filesystemio_options=asynch
    Click «Apply»

    Instance многократно рестартует процесс QMNO .
    Alter database mount не выполняется

    Следуем [1] , чтобы решить проблему

    Build libaio-oracle as root:

    Добавляем к /etc/ld.so.conf

    /lib
    /usr/lib
    /usr/local/lib

    Restart Linux.
    Выполняем контрольный тест : lio_test

    mv $ORACLE_HOME/rdbms/lib/skgaio.o $ORACLE_HOME/rdbms/lib/skgaio.orig
    cp /tmp/libaio-oracle-0.3.0/libaio-oracle.o $ORACLE_HOME/rdbms/lib/skgaio.o

    $make -f ins_rdbms.mk async_on
    $make -f ins_rdbms.mk ioracle

    Modify screen SPFILE of OEM concole
    disk_asynch_io=true
    filesystemio_options=asynch
    Click «Apply»

    Instance рестарт успешен
    Файл skgaio.o, участвующий в линковке бинарников Oracle :

    $make -f ins_rdbms.mk async_on
    $make -f ins_rdbms.mk ioracle

    теперь заменен на /tmp/libaio-oracle-0.3.0/libaio-oracle.o

    вбил все в скрипты, и без единой проблемы все пошло. Всего то там танцев — правка двух файлов (пришлось скриптик накатать), установка десятка RPM (в том числе пары насильно), и точное следование инструкциям. При том я абсолютно не спец по ораклу.

    А вот рядом индус уже второй день мучается, с творческим подходом — типа -opatch нужен а он не работает потому что были эксперименты с установкой oracle10, ну и так далее. В общем, чем меньше творчества, тем лучше.

    Кстати, Firewire пригодно для development, работает (хотя и виснет при сильной нагрузке).

    В общем, очень рекомендую ту статью. Хотя для установки на _не ES_ там, наверное, придется еще что то ручками делать.

    Источник

    Red Hat Customer Portal

    Log in to Your Red Hat Account

    Your Red Hat account gives you access to your profile, preferences, and services, depending on your status.

    If you are a new customer, register now for access to product evaluations and purchasing capabilities.

    Need access to an account?

    If your company has an existing Red Hat account, your organization administrator can grant you access.

    Red Hat Account

    Customer Portal

    For your security, if you’re on a public computer and have finished using your Red Hat services, please be sure to log out.

    Select Your Language

    Red Hat Training

    A Red Hat training course is available for Red Hat Enterprise Linux

    Chapter 17. Database Servers

    This chapter guides you through the installation and configuration of the MariaDB server, which is an open source fast and robust database server that is based on MySQL technology. The chapter also describes how to back up MariaDB data.

    17.1. MariaDB

    MariaDB is a relational database which converts data into structured information and provides an SQL interface for accessing data. It includes multiple storage engines and plug-ins, as well as geographic information system (GIS).

    Red Hat Enterprise Linux 7 contains MariaDB 5.5 as the default implementation of a server from the MySQL databases family. Later versions of the MariaDB database server are available as Software Collections for Red Hat Enterprise Linux 6 and Red Hat Enterprise Linux 7. For more information about the latest versions, see the Release Notes for Red Hat Software Collections .

    17.1.1. Installing the MariaDB server

    To install the MariaDB server, follow this procedure:

    Installing the MariaDB server

    Ensure that the mariadb and mariadb-server packages are installed on the required server:

    Start the mariadb service:

    Enable the mariadb service to start at boot:

    17.1.1.1. Improving MariaDB installation security

    You can improve security when installing the MariaDB server by running the mysql_secure_installation command:

    This command launches a fully interactive script, which prompts for each step in the process. The script enables to improve security in the following ways:

    • Setting a password for root accounts
    • Removing anonymous users
    • Disallowing remote (outside the local host) root logins
    • Removing test database

    17.1.2. Configuring the MariaDB server for networking

    To configure the MariaDB server for networking, use the [mysqld] section of the /etc/my.cnf.d/server.cnf file, where you can set the following configuration directives:

    Bind-address is the address on which the server will listen.

    Possible options are: a host name, an IPv4 address, or an IPv6 address.

    Possible values are:

    0 — to listen for all clients

    1 — to listen for local clients only

    The port on which MariaDB listens for TCP/IP connections.

    17.1.3. Backing up MariaDB data

    There are two main ways to back up data from a MariaDB database:

    • Logical backup
    • Physical backup

    17.1.3.1. Logical back up

    Logical backup consists of the SQL statements necessary to restore the data. This type of backup exports information and records in plain text files.

    The main advantage of logical backup over physical backup is portability and flexibility. The data can be restored on other hardware configurations, MariaDB versions or Database Management System (DBMS), which is not possible with physical backups.

    Logical backup can be performed only if the mariadb.service is running. Logical backup does not include log and configuration files.

    17.1.3.2. Physical back up

    Physical backup consists of copies of files and directories that store the content.

    Physical backup has the following advantages compared to logical backup:

    Источник

    Red Hat Customer Portal

    Log in to Your Red Hat Account

    Your Red Hat account gives you access to your profile, preferences, and services, depending on your status.

    If you are a new customer, register now for access to product evaluations and purchasing capabilities.

    Need access to an account?

    If your company has an existing Red Hat account, your organization administrator can grant you access.

    Red Hat Account

    Customer Portal

    For your security, if you’re on a public computer and have finished using your Red Hat services, please be sure to log out.

    Select Your Language

    The leading enterprise Linux operating system, certified on hundreds of clouds and with thousands of vendors.

    An enterprise-ready Kubernetes container platform with full-stack automated operations to manage hybrid cloud and multicloud deployments.

    A platform for implementing enterprise-wide automation, no matter where you are in your automation journey.

    All Red Hat products and documentation

    Categories

    Cloud Computing

    Red Hat Hybrid Cloud Console

    Applications on the Red Hat Hybrid Cloud Console are managed services, providing customers with prescriptive analytics and applications to manage Red Hat environments.

    Red Hat OpenShift Container Platform

    Built on Red Hat Enterprise Linux and Kubernetes, OpenShift Container Platform provides a secure and scalable multi-tenant operating system for today’s enterprise-class applications. It also provides integrated application runtimes and libraries.

    Red Hat OpenShift Dedicated

    Red Hat OpenShift Dedicated allows developers to quickly develop, build, deploy, and manage containerized services and applications in a cloud environment.

    Red Hat OpenShift Service on AWS

    Red Hat OpenShift Service on AWS (ROSA) delivers production-ready Kubernetes that many enterprises currently use on-premises today, enhancing the ability for customers to shift workloads to the cloud and making it even easer for customers to adopt containers and deploy their applications faster on AWS.

    Red Hat OpenShift Service Registry

    Red Hat OpenShift Service Registry is a cloud-based metadata repository for managing the standard event schemas and API definitions used in application development.

    Cost Management

    Cost management is an OpenShift Container Platform service that enables you to better understand and track costs for clouds and containers. It is based on the upstream project Koku.

    OpenShift Cluster Manager

    OpenShift Cluster Manager is a managed service where you can install, operate and upgrade your Red Hat OpenShift 4 clusters. OpenShift Cluster Manager provides the links and steps to install OpenShift Container Platform clusters and is responsible for managing both OpenShift Container Platform clusters after self-installation and OpenShift Dedicated clusters.

    Red Hat OpenShift API Management

    The Red Hat OpenShift API Management service adds full API lifecycle management capabilities to Red Hat OpenShift Dedicated.

    Red Hat OpenShift Streams for Apache Kafka

    Red Hat OpenShift Streams for Apache Kafka provides a developer-first, consistent experience that shields the user from administrative tasks, supports a consistent experience across clouds, and easily connects to other OpenShift workloads.

    Red Hat Quay

    Red Hat Quay is a secure, private container registry that builds, analyzes and distributes container images. It provides a high level of automation and customization. Red Hat Quay is also available as a hosted service called Quay.io.

    Red Hat OpenStack Platform

    Red Hat OpenStack Platform is a cloud computing platform that virtualizes resources from industry-standard hardware, organizes those resources into clouds, and manages them so users can access what they need—when they need it.

    Red Hat Advanced Cluster Management for Kubernetes

    Red Hat Advanced Cluster Management for Kubernetes controls clusters and applications from a single console, with built-in security policies.

    Red Hat CloudForms

    Red Hat CloudForms manages private clouds, virtual environments, and public clouds in a single tool.

    Red Hat OpenShift Online

    OpenShift Online is Red Hat’s public cloud application development and hosting platform that automates the provisioning, management, and scaling of applications so that you can focus on writing the code for your business, startup, or next big idea.

    Источник

    Читайте также:  Windows prepares to start
    Оцените статью