Oracle Database/ERP/Cloud/RAC/Misc Solutions

  ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace While dropping any Tablespace, you might get the errror  ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace This is due to the fact that the tablespace contains the indexes or Materialized views You may use the following queries to find out which materialized views and/or which indeces of materialized view container tables are on the tablespace you intend to drop. Once these objects are found you can move the tables, rebuild indeces in other tablespace.  select s.sowner MV_OWNER, s.tname MV_NAME, p.name TABLESPACE   from sys.obj$ o, sys.tab$ t, sys.user$ u, sys.snap$ s , sys.ts$ p   where t.ts#=p.ts# and p.name='<tablespace_name>'   and t.obj#=o.obj# and o.owner#=u.user# and u.name=s.sowner and o.name=s.tname   order by 1,2; select o.owner, o.object_name index_name, o.object_type, sq.mv_owner,sq.mv_name,sq.tablespace   from dba_objects o, ...

  ORA-20000: Unable to set values for index <INDEX_NAME> does not exist or insufficient privileges while importing schema from 12c to 19c Importing statistics failed for 1 object(s);  While importing Schema objects from 12c Oracle Database to 19c Oracle Database, we face the above issue CAUSE  This problem is fixed by unpublished BUG 27761685. SOLUTION To avoid the issue use the workaround: - Add include=index while executing expdp   and - Add include=statistics while executing impdp expdp USER_A/USER_A directory=test_dir dumpfile=exp_data.dmp include=statistics,index tables=btree_tbl reuse_dumpfiles=y impdp USER_B/USER_B directory=test_dir dumpfile=exp_data.dmp remap_schema=user_a:user_b include=statistics Reference: ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)

 This blog will list the errors faced during Installation of Enterprise Manager 12c Cloud Control 1. :Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk' INFO: End output from spawned process. INFO: ---------------------------------- INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2021-05-14_12-14-33-AM.log' for details. Exception Severity: 1 INFO: POPUP WARNING:Error in invoking target 'install' of makefile '/u01/app/oracle/oms12cr3/oms/sqlplus/lib/ins_sqlplus.mk'. See '/u01/app/oraInventory/logs/installActions2021-05-14_12-14-33-AM.log' for details. INFO: /usr/bin/ld: cannot find crt1.o: No such file or directory /usr/bin/ld: cannot find crti.o: No such file or directory /usr...

Problem Faced below error while Installing 12.2 on Linux 8. Unable to execute cr9idata.pl Executing cr9idata.pl Executing: perl /u01/oracle/DEV/12.1.0/nls/data/old/cr9idata.pl Unable to execute cr9idata.pl RW-50010: Error: - script has returned an error:   2 RW-50004: Error code received when running external process.  Check log file for details. Running Database Install Driver for DEV instance Solution: I have installed the following rpms: Install the following rpm  [root@dev02 DEV_dev2]# yum list perl-File-CheckTree* Available Packages perl-File-CheckTree.noarch                                                                         4.42-303.el8                                        ...

  Latest CPU Patching on the 19c Grid home fails with below errors: OPATCHAUTO-68061: The orchestration engine failed. OPATCHAUTO-68061: The orchestration engine failed with return code 1 OPATCHAUTO-68061: Check the log for more details. OPatchAuto failed. Also it mentions to solve the issue and do opathauto resume.  Solution: Verify the patches have been applied on both the nodes: cd /u01/app/19.3.0/grid/bin  [root@DC2-GTDB-V-01 bin]# ./kfod op=patches --------------- List of Patches =============== 29340594 32218454 32218663 32222571 32240590 [root@DC2-GTDB-V-01 bin]# [root@DC2-GTDB-V-02 bin]# ./kfod op=patches --------------- List of Patches =============== 29340594 32218454 32218663 32222571 32240590 [root@DC2-GTDB-V-02 bin]#  The perform the following steps  as root cd $GI_HOME/bin clscfg -localpatch clscfg -patch After this restart the CRS and verify if its started properly.

  TNS-12518: TNS:listener could not hand off client connection While Connecting to oracle RAC database using sqlplus gives the following errors: TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact  TNS-12560: TNS:protocol adapter error   TNS-00517: Lost contact    Linux Error: 32: Broken pipe Solution: Check the permissions on the oracle executable in the RDBMS Home cd $ORACLE_HOME/bin ls -ltr oracle It should have 6751 permission chmod 6751 oracle

 How to Change Private IP in RAC Cluster (19c) on OEL 8 In this post, we will see how to change the Private IP of a 2-Node Oracle.  The purpose of this note is to describe how to change or update the private network (cluster_interconnect) information in Oracle Clusterware. ./oifcfg getif ens192  10.92.27.0  global  public ens224  192.168.221.0  global  cluster_interconnect,asm ens161  192.168.27.8  global  cluster_interconnect,asm [root@DC2-GTDB-V-01 bin]#  To set any interface ./oifcfg setif -global ens161/192.168.27.0:cluster_interconnect,asm To Delete any interface ./oifcfg delif -global ens224/192.168.221.0 Ref: How to Modify Private Network Information in Oracle Clusterware (Doc ID 283684.1)

  Java Error while launching Rapidwiz  ./buildStage.sh: line 142: /u01/software/ebs/1220/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java: No such file or directory eror unzipping shiphome ... Rapidwiz is expecting a 32-bit version of the JDK, and the error occurs because the only version available is 64-bit. The issue is discussed in the following unpublished defect: Bug 24386615 – STARTCD SHOULD BE UPDATED TO USE 64 BIT VERSION OF THE JDK/JRE . Solution: Copy a 64 bit version of the JDK from any 12c Oracle Home or download it from internet.  1.  Backup the existing JDK located in  startCD/Disk1/rapidwiz/jre/Linux_x64/ mv 1.6.0 1.6.0_old mkdir 1.6.0 2.  Copy the contents of jre directory unded the 1.6.0 directory  3.  Retest  Rapidwiz  and confirm the error is resolved.

   Rolling Forward a Physical Standby Database using RMAN Incremental Backup There is a huge gap around 5k between the archive logs of Standby Database and Primary Database.  Instead of waiting for the Redo Apply to sync the archive logs, we follow the below steps to sync the Standby database.  1. Cancel the Managed Recovery ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 2. Find the SCN of the Standby Database SELECT CURRENT_SCN FROM V$DATABASE; 11878709541860 select min(checkpoint_change#) from v$datafile_header; 11878709541861 We have to use the lower of the two scn values.  11878709541860 3. Connect to Primary and Identify the datafile needed for backup SELECT FILE#, NAME FROM V$DATAFILE WHERE CREATION_CHANGE# > 11878709541860; 322 +DATA/PRODNEW/DATAFILE/data.593.1063685263 323 +DATA/PRODNEW/DATAFILE/data.594.1063879113 324 +DATA/PRODNEW/DATAFILE/data.595.1063879183 325 +DATA/PRODNEW/DATAFILE/data.596.1063879207 326 +DATA/PRODNEW/DATAFIL...

 INSTALLING SOLARIS 11.4 ON VIRTUAL BOX In this blog, we will go through steps for Installing Solaris 11.4 on Virtual Box.  1. Download the Solaris ISO Installer from below link http://www.oracle.com/technetwork/server-storage/solaris11/downloads/index.html 2. Create a new VM and use the ISO, which was downloaded as source.  3. You will get the following screens  Choose default and press Enter Choose default and press Enter Choose 1 and press Enter press F2 - Continue Press F2 Press F2 Press F2- Continue Press F2 Press F2 Choose Asia or Time zone as per your Region Choose your Location and press F2 Press F2 Press F2 Choose Date and Time and press F2 Review the Summary Screen and press F2 .....................................................