Oracle 12c RDBMS Silent Installation on HP Server

Oracle 12c RDBMS Silent Installation on HP Server Silent _ installations: nohup /u01/software/database/runInstaller -ignoreSysPrereqs -ignorePrereq -waitforcompletion -showProgress -silent -responseFile /u01/software/db_install.rsp > 12c_db_install_on_hp_new1 Starting Oracle Universal Installer… Checking Temp space: must

Oracle Database creation in silent method

Oracle Database creation in silent method $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbNameORCL1-sid ORCL1-SysPassword abc123-SystemPassword abc123-emConfiguration NONE -redoLogFileSize 50 -recoveryAreaDestination /u02/ORCL1/recovery -datafileDestination /u02/ORCL1/oradata -storageType FS -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -totalMemory 4096

Script to setup RMAN active duplicate

Script to setup RMAN active duplicate #In Production running from primary DB server ORCLPROD ==> Prod Database nameORCLNP ==> Nonprod database name mkdir -p /tmp/DUPcd /tmp/DUP vi rman-Active-Duplicate.sh ############################################# Start

After Oracle DB upgrade to 19c on AIX , not able to connect to database from putty session

Issue : After Oracle DB upgrade to 19c on AIX , not able to connect to database from putty session Error: Getting below error            

How to find Oracle DB size along with hostname,db name,instance name, version ,created date

Oracle DB size with hostname,db name,instance name, version ,created date. The size of the database is the space the files physically consume on disk. You can find this with below

Step by Step doc for relinking Oracle homes

Step by Step doc for relinking Oracle homes If we have ASM on the server ,first we need to relink ORACLE_HOME and then Grid infra (GI) (ASM) home RDBMS Relink