Create and Delete Oracle 19c database in Silent mode using DBCA

The example of rsp file you will find under Create and Delete commands!!

Create Database:

dbca -silent -createDatabase -responseFile /home/oracle/dbca_alex.rsp

Delete Database:

dbca -silent -deleteDatabase -sourceDB alex -sysDBAUserName sys -sysDBAPassword oracle

----------------------------------------------------------------

Detaching Oracle Homes from the Central Inventory

You can detach an Oracle home from the Central Inventory. When you pass this flag, it updates the oraclehomeproperties.xml present in the Oracle home. The syntax is as follows:

./runInstaller -silent -detachHome -invPtrLoc ./oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

You can use the -local flag to detach the Oracle home from the inventory of the local node. If you are using a shared Oracle home, use -cfs flag. This ensures that the local node information is not populated inside a shared Oracle home.

./runInstaller -silent -local -cfs -detachHome -invPtrLoc ./oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

./runInstaller -silent -detachHome -invPtrLoc ./oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

You can completely clean the Oracle home and remove the home directory by using the -removeallfiles flag. The syntax is as follows:

./runInstaller -silent -deinstall -removeallfiles -invPtrLoc ./oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

If you want to disable the warning message that appears when you use the -removeallfiles flag, use the -nowarningonremovefiles flag. The syntax is as follows:

./runInstaller -silent -deinstall -nowarningonremovefiles 

-invPtrLoc ./oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>"  ORACLE_HOME_NAME="<Oracle_Home_Name>"

How to debug silent installation?

./runInstaller -silent -force -debug -responsefile /ora/software/solaris_x64/response/agent_download.rsp

"Checking operation system version" error when installing Oracle Client on Windows 7

Problem:
When I tried to install Oracle 10g client on Windows 7 64-bit, I received the following error:



Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be  5.0, 5.1, 5.2 or 6.0 .    Actual 6.1
      Failed <<<<

Exiting Oracle Universal Installer, log for this session can be found at C:\User
s\ASLOBI~1\AppData\Local\Temp\OraInstall2010-05-10_11-09-12AM\installActions2010
-05-10_11-09-12AM.log

Please press Enter to exit...

Solution:
Go to MAIN_INSTALLATION_DIR\install directory and open openparam.ini file.
Add 6.1 value in [Certified Versions]\Windows section.

In addition, add the following section in the MAIN_INSTALLATION_DIR\stage\prereq\db\refhost.xml file:

Now the installer works.

How to upgrade Oracle8i Database to Oracle10g and move it from Unix to Linux

Introduction

Upgrade Database

Pre-Upgrade Tasks

Upgrade Tasks

Export Metadata

Execute the CONVERT tablespace command to change datafiles to Linux format.

 

Introduction

There are the steps we are going to do:

1.      Find a hot backup of production database ELAPROD (version 8.1.7) located on PEKO Unix server:
User: orapeko
Directory: /peko/backups/elaprod/hotbkup___2005

2.      Move it other Unix server – BIBBLE – where Oracle10g server is installed

3.      Startup ELAPROD database with a new name ELA10G.