Oracle delete archive log

Oracle delete archive log

RMAN>DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-1’;
RMAN>DELETE ARCHIVELOG ALL BACKED UP 2 TIMES to disk;
RMAN>DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 3790;



OR

Delete all after backup

RMAN> backup archivelog all delete input;

Oracle startup error ORA-03113: end-of-file on communication channel

Oracle startup error ORA-03113: end-of-file on communication channel

Solution 1:

SQLplus connect as sysdba;

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;

SQL> ALTER DATABASE OPEN RESETLOGS;

Solution 2:

SQLplus connect as sysdba;

sql > startup nomount;

sql> alter database mount;

sql> alter database clear unarchived logfile group 1;

sql> alter database clear unarchived logfile group 2;

sql> alter database clear unarchived logfile group 3;

try #4 until you dont have any more group

sql> shutdown immediate;

sql> startup;

PLSQL Decode function

DECODE( expression , search , result [, search , result]... [, default] )

Example

The DECODE function can be used in Oracle/PLSQL.

You could use the DECODE function in a SQL statement as follows:

SELECT supplier_name,
DECODE(supplier_id, 10000, 'IBM',
                    10001, 'Microsoft',
                    10002, 'Hewlett Packard',
                    'Gateway') result
FROM suppliers;

The above DECODE statement is equivalent to the following IF-THEN-ELSE statement:

IF supplier_id = 10000 THEN
   result := 'IBM';

ELSIF supplier_id = 10001 THEN
   result := 'Microsoft';

ELSIF supplier_id = 10002 THEN
   result := 'Hewlett Packard';

ELSE
   result := 'Gateway';

END IF;

Ellucian Banner : Input text into 2 text boxes continuously when typing extra characters

Ellucian Banner : Input text into 2 text boxes continuously when typing extra characters

Ex

Struct

<Item AllowSearch="true" CanvasName="FABINVH_HEADER" Id="FABINVH_VEND_INV_CODE" MaxLength="15" Type="TextItem"/>


XVC

<textbox autoskip="true" block="FABINVH" case="upper" datatype="String" height="23px" keyactions="NEXT_ITEM" label="fabinvh.fabinvhVendInvCode.prompt" maxlength="15" member="FABINVH_VEND_INV_CODE" name="fabinvhVendInvCode" validation="server" width="120px" style="ui-hidelabel">


FORM

@ActionTrigger(action="HOLD_LAST_ITEM_LOC")
public void Fyainve_HoldLastItemLoc()
{

// DECLARE
//  hold_last_text_item VARCHAR2(30);
// BEGIN
// DECLARE
//  hold_last_text_item VARCHAR2(30);
// BEGIN
getFormModel().getFormHeader().setHoldLastTextItem(toStr(getCursorItem()));


CONTROLLER

@ActionTrigger(action="POST-TEXT-ITEM", item="FABINVH_VEND_INV_CODE", function=KeyFunction.ITEM_OUT)
public void fabinvhVendInvCode_itemOut()
{
    System.out.println(" fabinvhVendInvCode_itemOut");

    executeAction("HOLD_LAST_ITEM_LOC");
}



@ActionTrigger(action="KEY-NEXT-ITEM", item="FABINVH_VEND_INV_CODE", function=KeyFunction.NEXT_ITEM)
public void fabinvhVendInvCode_keyNexItem()
{
System.out.println(" fabinvhVendInvCode_keyNextItem ");
nextItem();
//    GO_FIELD( 'FABINVH_ACH_OVERRIDE_IND' ) ;
getTask().getGoqrpls().gCheckFailure();
}

Banner 9 Eclipse - Unable to Open Task Outline

Eclipse - Unable to Open Task Outline in Banner 9


Close Eclipse
navigate to the Eclipse workspace directory in the file system c:\admin_page\dev90workspace
Drill into the following path under that folder: .metadata\.plugins\morphis.foundations.plugin.core\
Delete the tasksRegistry.xml file (or rename it).
Then restart Eclipse and wait for it to finish rebuilding the task registry.
Note: you may have to run Maven update

Ellucian
explanation:

The tasksRegistry is created and maintained by the Morphis plugins. We've been seeing strange problems like you described that are caused by bad data in the tasks registry, but thus far haven't been able to track down the root cause other than that letting Eclipse rebuild it often helps. There is nothing you did wrong per se that would cause this. At this point we don't know if there is something invalid in the Banner code or with how the Morphis plugins work that causes this to happen but are actively working with Morphis to try and narrow it down.

Banner 9: Fix for Missing IN or OUT parameter

Ellucian Banner 9: Fix for Missing IN or OUT parameter

Find Queries in controller to make sure no missing addParametter

Notes param will start with :
ex   pidm= :id

Banner 9: After, Before event for extended function of controller in extension

Banner 9: After, Before event for extended function of controller in extension page