ERROR: ORA-17627: ORA-01041: internal error. hostdef extension doesn’t exist ORA-19849: error while reading backup piece from service PROD ORA-03113: end-of-file on communication channel ORA-19558: error de-allocating device ORA-19557: device error,…
Read MoreError: Autoconfig could not process the following files: Directory: $ORA_CONFIG_HOME/10.1.3/Apache/Apache/bin .apachectl BINCPY .apachectl BINCPY AutoConfig is exiting with status 2 Solution: Change owner for apachectl in below mentioned locations, cd…
Read MoreAs root user in Target Node: Step 1 : /usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt Make a note of recent Seq in our case it is 124980 . Step 2 : /usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt Get the control file name using above command. In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00” As Oracle user in Target Node: Step 3 : Step 4 : Create a pfile with db_name=PROD. Step 5 : Start the database in nomount. SQL> startup nomount pfile=’initPROD.ora’; Step 6 : Connect Rman and execute below command RMAN > set DBID=193295451; run{ allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’; send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘; restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’; } #### Control file taken from step 2. Step 7 : SQL> alter database mount; Step 8: RMAN> list backup; Take recent LOW SCN number. 181267677438…
Read MoreHow to activate Periodic Alert Scheduler in Oracle EBS Application Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility We need to Login the Oracle EBS Application…
Read MoreERROR: FORM session is not opening after the clone SOLUTION: Go to FORMS node if it is multi node. cd $ORACLE_HOME/lib32 ls -lrt ldflags unlink ldflags ln -s /devweb/oracle/TEST/apps/tech_st/10.1.2/lib32/ldflags ldflags…
Read MoreERROR: RC-50204: Error: – Web Listener Port in use: Port Value = 8009 CAUSE: When cloning we have faced this error. This is due to some other process is using…
Read MoreMonitoring Progress of a SQL Execution Plan / sql query is really hanged or not How to check the progress of a query is making from within the execution plan…
Read MoreError: Re-link fails on target “client_sharedlib”. Re-link fails on target “client_sharedlib”. Re-link fails on target “ldapmoddn”. Re-link fails on target “ldapmodifymt”. Re-link fails on target “ldapaddmt”. Re-link fails on target…
Read MoreERROR: ORA-19909: datafile 1 belongs to an orphan incarnation When I tried to Flashback on in standby database then suddenly below message found in alert log and standby database not…
Read MoreProblem Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User Cause: It is an oracle bug Solution 1.Apply the Patch -22549247 2.It will give you a newer file…
Read More