Oracle «

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (40)
Ansibile (19)
Apache (135)
Asterisk (2)
cassandra (2)
Centos (230)
- ftp (5)
- IPTABLES (15)
- SFTP (1)
- swap (3)
Centos RHEL 7 (270)
centos8 (3)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (31)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
health (2)
horoscope (23)
Hyper-V (10)
IIS (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (9)
Ldap (5)
Linux (189)
Linux Commands (166)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (24)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (36)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (35)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
TIPS on Linux (28)
tomcat (62)
Ubuntu (1)
Uncategorized (30)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

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 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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Forgot SYS password in oracle 11g

su – oracle

sqlplus /nolog connect / as sysdba

show user

Once connected, you can change the SYS password to something you know: ALTER USER sys IDENTIFIED BY new_password;

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 […]

Recent Posts

Pages

Categories

Archives

Recent Comments