Open Source Database

         How to create and maintain users and roles, assign privileges mysql 8.0. mysql.user: User accounts, global privileges, and other non-privilege columns mysql.db: Database-level privileges mysql.tables_priv: Table-level privileges mysql.columns_priv: Column-level privileges mysql.procs_priv: Stored procedure and function privileges mysql.proxies_priv: Proxy-user privileg mysql> select DISTINCT User FROM mysql.user; +------------------+ | User             | +------------------+ | pankaj           | | rpl_user         | | mysql.infoschema | | mysql.session    | | mysql.sys        | | root             | +------------------+ 6 rows in set (0.00 sec) mysql> SELECT VALIDATE_PASSWORD_STRENGTH('weak'); +------------------------------------+ | VALIDATE_PASSWORD_STRENGTH('weak') | ...

               HOW TO CONFIGURE MYSQL 8.0 MASTER SLAVE REPLICATIN RHEL 8. Step 1: Configure the Master Server The first configuration change to make is setting Server ID for the master database: A complete simple configuration looks like below: +++++++++++++++++++++++++++++++++++++++++++++++++++ [root@master ~]# vi /etc/my.cnf [mysqld] pid-file = /var/run/mysqld/mysqld.pid datadir = /var/lib/mysql log-error = /var/log/mysql/error.log server-id = 1 log-bin = /var/log/mysql/mysql-bin.log tmpdir = /tmp binlog_format = ROW max_binlog_size = 500M sync_binlog = 1 expire-logs-days = 7 slow_query_log save and Restart mysql service for changes to take effect: [root@master ~]# systemctl restart mysqld.service Step 2: Create Replication user on Master database server We now need to create a database user to be used by slaves when connecting. Login to MySQL database as root user and create the user: [root@master ~]# mysql -u ...

step.1.go to the cat /etc/oratab and edit it. vi /etc/oratab pankaj:/u01/app/oracle/product/11.2.0/dbhome_1:N step.2.login to oracle user [oracle@servera ~]$ . oraenv ORACLE_SID = [orcl] ? pankaj The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle note:-. oraenv command hit for oratab and pankaj is name of the database. step.3.copy pfile cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs [oracle@servera dbs]$ cp initorcl.ora initpankaj.ora step.4.edit pfile current pfile orcl.__db_cache_size=289406976 orcl.__java_pool_size=4194304 orcl.__large_pool_size=4194304 orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment orcl.__pga_aggregate_target=310378496 orcl.__sga_target=457179136 orcl.__shared_io_pool_size=0 orcl.__shared_pool_size=150994944 orcl.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/orcl/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.con...

  How To Configure Local YUM Server In RHEL 7 Step.1.create a directory #mkdir -p /var/ftp/pub/ Step.2.copy iso image  #cp -rvf * /run/media/root/RHEL7/ /var/ftp/pub/ step.3.Go To Repo directory. #cd /etc/yum.repo.d/ Create a blank file .repo extension #touch server.repo Edit file and write it #vi server.repo Press i to write someting  [server] Name=localyumserver baseurl=file:///var/ftp/pub/ gpgcheck=09 Press ESC and :(colun) and wq to save and exit. Note:- name=you can write any name. Baseurl=local find file gpcheck =0 (0 indicate the rpm is disable and 1 it indicate the rpm is disable) Step.4.clean yum sever #yum clean all Step.5.check it. #yum repolist all Display approx 4100 file. Thank you.

how to install oracle 11g in Rhel7 linux GUI step.1.Create a directory and copy file. # mkdir /u01/ #linux.x64_11gR2_database_1of7.zip #linux.x64_11gR2_database_2of7.zip step.2.unzip the oracle 11g software. #unzip linux.x64_11gR2_database_1of7.zip  #unzip linux.x64_11gR2_database_2of7.zip  Now you have a single Database folder which is have runInstaller file. Step.3.Edit Hosts File In the Hosts file you have to fully specify your hostname and your machine IP address. #vi /etc/hosts For Example. <ip address >  <full name of machine >   <short name of your machine> After update this file press Esc then shif+: then wq  then Enter. Start configuration to install Oracle 11g R2 Step 4. Edit /etc/sysctl.conf file and add below parameter in end of this file. #vi /etc/sysctl.conf  fs.aio-max-nr = 1048576  fs.file-max = 6815744  kernel.shmall = 2097152  kernel.shmmax = 536870...