APEX INSTALLATION(5.1) in ORACLE12c In this blog we are going install the apex 5.1. Here, i have a database with 12c. So here i explained about this install steps at database directly. If we have a database then, follow below steps.…
Read MoreJAVA_PROPERTIES configuraion in SetDomainEnv.sh:- login to particular server Go to Domain/bin Take backup of SetDomainEnv.sh vi SetDomainEnv.sh Edit SetDomainEnv.sh and replace the JAVA_PROPERTIES url as per requested save and…
Read MoreSteps to install WLS by using GUI MODE:- Check the prerequisites like disk space, file permissions and compatibility 2. Execute Weblogic setup executable file 3. By default it will install…
Read MoreINTRODUCTION Migration of a windows database 12.1.0.1 to linux database of version 19.0.0, below are the steps to perform the migration. INSTALLED A DATABASE IN WINDOWS AND CHECKED THE…
Read MoreFollow the steps to Restore A Loss Of Controlfile Using Autobackup: Step:1 connect to RMAN and view the default parameters using SHOW ALL. Step:2 see the location of control…
Read MoreSteps in Backuping database using Recovery Catalog: What is a Recovery Catalog? RMAN metadata can be stored in either of the two places, Controlfile Recovery catalog Hence recovery catalog is…
Read MoreSteps for applying the patch: Step:1 Check current version of OpatchTool Step:2 Upgrade the Opatch utility Step:3 Take the backup of ORACLE_HOME Step:4 Shutdown the Database and Listener Step:5 Apply…
Read MoreMATERIALISED VIEWS: Materialized views are schema objects that can be used to summarize, precompute, replicate and distribute data. In mview, the query result is cached as a concrete table that may…
Read MoreSteps to perform Active Cloning : Target database – RAHUL Clone database – DOYEN 1)create the particular directories for clone database for storing datafiles,controlfiles,log files. mkdir DOYEN then create separate…
Read MoreRecover a tablespace using RMAN: Step:1 create a tablespace Rahul. Step:2 view the tablespaces present in the database using Select tablespace_name from dba_tablespaces; Step:3 Backup the tablespace and backup the…
Read More