Oracle 12c Ddatabase migration from ASM to NON-ASM

Comments

Post a Comment

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== +     On Primary             + ==================  SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 ACTIVE          2       ...
Read more

Oracle 19c : Manually Install Oracle Database Software and setup listener for Single Instance

Image
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Oracle 19c : Manually Install Oracle Database Software, setup listener and Create an empty Container Database for Single Instance +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Assumption: You already created all the required OS users (example: oracle), group (oinstall) directories (example: $ORACLE_BASE, $ORACLE_HOME) Step 1: Download Oracle Software from edelivery Step 2: Unzip Software to the Oracle_HOME directory unzip V981623-01.zip -d /u01/app/oracle/product/19.2.0/db100 Step 3: Create a response file by copying  the response file from the response file directory oracle@racdb01.localdomain:/u01/app/oracle/product/19.2.0/db100/install/response $ cp db_install.rsp /home/oracle/19cEE_SoftOnly.rsp Step4:  modify response file in a text editor with necessary changes  Step5:  start the installer in silent with response file  $ cd /u01/app/oracle/pro...
Read more

Modifying the network configuration on Exadata x5-2

Modifying the network configuration on Exadata x5-2 Run the /opt/oracle.cellos/ipconf utility which is an interactive tool that will allow you to modify any and all of the network settings, including NTP or DNS.   Check Script: [root@exasc02-adm ~]# vi check_cellconf.sh IPCONF_RAW_OUTPUT=$(/opt/oracle.cellos/ipconf -verify -semantic -at-runtime -check-consistency -verbose 2>/dev/nu ll); IPCONF_RESULT=$(echo "$IPCONF_RAW_OUTPUT" | egrep "Consistency check PASSED" | wc -l); IPCONF_SUMMARY=$(echo "$IPCONF_RAW_OUTPUT" | tail -1); if [ $IPCONF_RESULT = "1" ]   then     echo -e "SUCCESS: $IPCONF_SUMMARY"   else     echo -e "FAILURE: $IPCONF_SUMMARY\n"     echo -e "`echo -e "$IPCONF_RAW_OUTPUT" | grep FAILED`" fi; Run Script:  sh -x check_cellconf.sh ---- ILOM second NTP server time.cmcom.net must have valid syntax in /opt/oracle.cellos/cell.conf   : PASSED I...
Read more