Steps to install Oracle 19c in CentOS 7.6 RPM mode

Steps to install Oracle 19c in CentOS 7.6 RPM mode Download the required installation package: 1.1 preinstall http://yum.Oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 1.2 Oracle rpm installation package https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html It is recommended to download at home or see the VPN proxy download speed in the company. Installation. yum localinstall -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Install after installation is complete yum localinstall -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm […]

Read more
oracle databases server

oracle databases server create database TEST MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO01.LOG’ SIZE 50M BLOCKSIZE 512, GROUP 2 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO02.LOG’ SIZE 50M BLOCKSIZE 512 DATAFILE’C:\oraclexe\app\oracle\oradata\TEST\SYSTEM.DBF’ size 100m autoextend on sysaux datafile ‘C:\oraclexe\app\oracle\oradata\TEST\SYSAUX.DBF’ size 100m autoextend on undo tablespace undotbs1 datafile ‘C:\oraclexe\app\oracle\oradata\TEST\UNDOTBS1.DBF’ size 100m autoextend on CHARACTER SET AL32UTF8 […]

Read more
oracle xe backup

ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH export PATH BKUP_DEST=/home/mohan/backups find $BKUP_DEST -name ‘backup*.dmp’ -mtime +10 -exec rm {} \; cd /home/mohan/backups && /u01/app/oracle/product/11.2.0/xe/bin/exp schema/password FILE=backup_`date +’%Y%m%d-%H%M’`.dmp STATISTICS=NONE startup nomount pfile=/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora / create database maxinstances 1 maxloghistory 2 maxlogfiles 16 maxlogmembers 2 maxdatafiles 30 datafile ‘/u01/app/oracle/oradata/XE/system.dbf’ size 200M reuse autoextend on next […]

Read more
 Create additional database in Oracle Express edition 

 Create additional database in Oracle Express edition  *In my windows i have installed oracle11g express edition i want to create new database for my testing purpose but the express edition doesnot support DBCA utiltiy let us we can discuss How to Create additional database in Oracle Express edition or How to create manual database in […]

Read more
How to list all database names in Oracle

1) To view database select * from v$database; 2) To view instance select * from v$instance; 3) To view all users select * from all_users; 4) To view table and columns for a particular user select tc.table_name Table_name ,tc.column_id Column_id ,lower(tc.column_name) Column_name ,lower(tc.data_type) Data_type ,nvl(tc.data_precision,tc.data_length) Length ,lower(tc.data_scale) Data_scale ,tc.nullable nullable FROM all_tab_columns tc ,all_tables t […]

Read more
EXP-00002: error in writing to export file

EXP-00002: error in writing to export file While exporting table or schema using exp/imp utility you may come across below error. Most of the time this error occurs due to insufficient space available on disk.so confirm space is available where you are taking taking export dump and re-run export. [oracle@DEV admin]$ exp test/test@DEV tables=t1,t2,t3,t4 file=exp_tables.dmp log=exp_tables.log Export: Release 9.2.0.8.0 – […]

Read more
oracle rman backup

How to sync standby database which is lagging behind from primary database Primary Database cluster: cluster1.rmohan.com Standby Database cluster: cluster2.rmohan.com Primary Database: prim Standby database: stand Database version:11.2.0.1.0 Reason:- 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to […]

Read more
How to sync standby database which is lagging behind from primary database

How to sync standby database which is lagging behind from primary database Primary Database cluster: cluster1.rmohan.com Standby Database cluster: cluster2.rmohan.com Primary Database: prim Standby database: stand Database version:11.2.0.1.0 Reason:- 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to […]

Read more
oracle backup

#!/bin/bash #oracle_backup.sh version1.0 chmod 700 #00 00 * * * /usr/local/scripts/oracle_backup.sh #chmod 700 /usr/local/scripts/oracle_backup.sh #You must first import the environment variables in the Oracle user’s bash_profile file #Must be used to define the DBA account first dpdata1 path and authorized directory to read and write, modify the dpdata1 group export ORACLE_BASE=/usr/local/u01/oracle export ORACLE_HOME=/usr/local/u01/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=oracle11 […]

Read more

Hit Counter provided by dental implants orange county