11gR1 Data Guard: Logs apply on standby is stoped due to currept or incomplete log

Check the logs apply status
Login to standby database (Open read only if not already opened)

SQL> select max(al.sequence#) "Last Seq Recieved", max(lh.sequence#) "Last Seq Applied" from v$archived_log al, v$log_history lh;

Last Seq Recieved	Last Seq Applied
6424	6400

Check the alert_<SID>.log and note that the apply process is stuck while trying to apply log seq. 6441.

Copy log seq. 6441 from primary database to standby and manually try to register the log.

SQL> alter database register physical logfile '<fullpath/filename>';

OR

SQL> alter database register or replace physical logfile '<fullpath/filename>';

If this does not resolve the issue then do the following:

SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
SQL> alter database recover automatic standby database;

Check the alert_<SID>.log and note that the logs apply has been started.
Wait for the recovery to finish and then cancel.

SQL> shutdown immediate
SQL> startup
SQL> alter database recover managed standby database using current logfile disconnect from session;

R12 Web ADI: Make it work with MS Office 2010

In Excel 2010

Go to File > Options. Following screen will open

Select Trust center

Click on Trust center settings

Select ActiveX Settings and make sure setting match following screen

Then click on Macro Settings and make sure settings match as following

Click on Protected View and make sure setting match as following

Click on External Contents and make sure setting match as following

Press Ok. Then again Press OK.

Now in Internet explorer

Go to Tools > Internet Options

Click on Security

Select Internet and then on Custom Level

Scroll Down to Download portion and match settings with following

Then Scroll down to miscellaneous section and match setting with following

Then Scroll Down to Scripting section and match setting with following

Press OK. Then again press OK.

ORA-02303: cannot drop or replace a type with type or table dependents

Try to modify a type and CREATE OR REPLACE TYPE gives the error:

ORA-02303: cannot drop or replace a type with type or table dependents

If you need to modify a type you need to drop all the dependent (child) objects first or use FORCE option (Not recommended)

Dependent objects may be found using:

BEGIN
 DBMS_UTILITY.get_dependency (  type => 'TYPE',
                                                         schema => 'APPS',
                                                            name => 'COST_OBJ_TYPE1');
END; 

Check how many archive logs have been recieved and applied by standby database

Login to standby database (Open read only if not already opned)

SQL> select max(al.sequence#) "Last Seq Recieved", max(lh.sequence#) "Last Seq Applied" from v$archived_log al, v$log_history lh;

Last Seq Recieved	Last Seq Applied
6424	6424

 

Delete N number of lines from a file on Linux

$ sed -i 'starting_line_no, end_line_no d' file_name

$ sed -i '1,5d' test.txt

The above command will delete first 5 lines from 'test.txt' file.

APP-FND-204 Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request XXXXXX. TM-SVC LOCK HANDLE FAILED

This is happening because of large number of receiving processes being spawned at the same time.

Navigation:

• System Administrator (or comparable) Responsibility > Concurrent > Manager > Define
• Query for Manager='Receiving Transaction Manager'
• Click Work Shifts button and review value in Processes field (Increase the number of process)
• Go to: Concurrent -> Manager -> Administer
• Restart and Activate the Receiving Transaction Manager
• Refresh to check to make sure the target and actual processes = desired number of processes
• Retest the issue

If steps above still does not work, please perform the ADRELINK utility on the executable
as follows:

At UNIX prompt:
cd $PO_TOP/bin
adrelink.sh force=y ranlib=y "po RCVOLTM"
This relinks the executable for the Receiving Transaction Manager which is RCVOLTM. Now shut down and restart the Receiving Transaction Manager, you may have to click on RESTART, then
REFRESH and then click on ACTIVATE.