Oracle Database

Install Oracle Database 19c (NON CDB) in Oracle Linux7.9

-- This Script will Install Oracle Database 19c (NON CDB) in Oracle Linux 7.9 -- VM Config : -- -----------    Core  : 4    Ram   : 16 GB    Space : 512 GB    DB    : orcl Server Time Zone : ------------------ ------------------ sudo timedatectl set-…

HOW TO CONNECT ORACLE 6i FORMS TO ORACLE 12c / 19c

HOW TO CONNECT ORACLE 6i FORMS TO ORACLE 12c / 19c Pre-requisites Disable Case-Sensitive Passwords Developer 6i cannot handle case-sensitive logins introduced in 11g+. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; (Now passwords are treated as u…

How to Install Oracle Database 19c in Oracle Linux 7.9

How to Install Oracle Database 19c in Oracle Linux 7.9 vi /etc/hosts 192.168.100.9  ol7-19.localdomain  ol7-19 vi /etc/hostname ol7-19.localdomain yum install -y oracle-database-preinstall-19c yum update -y passwd oracle vi /etc/selinux/config SELINU…

How to Install Oracle Database 12C in Centos 7 Linux

1 - Step 1 : Install Centos 7 : Give ISO location in CD-Rom Location and Boot. RAM 4 GB Partition : 60 GB. 01 - Boot Partition    :  1,000 MB. 02 - /  Root Partition : 35,000 MB. 03 - Swap              :  8,000 MB. 04 - Data              :  The Rest o…

Oracle Database : Flashback

ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Default database initialization parameters: - UNDO_MANAGEMENT='AUTO - UNDO_TABLESPACE='UNDOTBS1' - UNDO_RETENTION=900 Collect undo block info w…

Backup, Drop and Restore Database step by step.

set oracle_sid=ORCL SET ORACLE_UNQNAME=ORCL Go to RMAN sqlplus /nolog conn / as sysdba ---- Get the Oracle DBID select DBID from v$database; 1033682200 ----- Giving folder permissions. # chown -R oracle:oinstall /data/backup # chmod -R 775 /data/backu…

Oracle Database-Oracle Data Migration from 11g to 10g

C:\oracle\product\10.2.0\db_1\bin\exp.exe hr/hr@orcl file=C:\Users\Administrator\Desktop\bk\hr10g.dmp full=n C:\oraclexe\app\oracle\product\11.2.0\server\bin\exp.exe hr/hr@xe file=C:\Users\Administrator\Desktop\bk\hr11g.dmp full=n STATISTICS= -…

DML in Access DB by Oracle RDBMS (Oracle 10g in Windows 2003)

VIEW DATA FROM MICROSOFT ACCESS 2003 AT ORACLE 10G RELEASE 1 (WIN 2003) : STEP 1: CREATE A MICROSOFT ACCESS TABLE : my_access_tab STEP 2: CREATE AN ODBC LOCAL SYSTEM DSN AND SELECT ACCESS *.MDB FILE PREVIOUSLY CREATED AND GIVE USER NAME AND PASSWORD I…

How to make Oracle Database Archivelog

follow the below steps: step1 :shutdown immediate step2: edit the pfile with the following log_archive_start=true log_archive_dest_1=’location=d:\archive_loc’ step3:startup mount step4:alter database archivelog step5: alter database ope…

Load More
That is All