Oracle DB restart in linux

-

 1. reboot

2. [root@dcwdb ~]# su - oracle

3. [oracle@dcwdb ~]$ lsnrctl start

4. [root@dcwdb ~]# su - oracle

5. [oracle@dcwdb ~]$ sqlplus / as sysdba

Comments

Post a Comment

Popular posts from this blog

Oracle Lock table

-
 SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name   FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID select * from V$Locked_Object select    c.owner,    c.object_name,    c.object_type,    b.sid,    b.serial#,    b.status,    b.osuser,    b.machine from    v$locked_object a ,    v$session b,    dba_objects c where    b.sid = a.session_id and    a.object_id = c.object_id;
Read more

Query to find onhand quantity Oracle Apps

-
  SELECT   ON_HAND.SUBINVENTORY_CODE,ITEM.SEGMENT1 ITEM_CODE, ITEM.DESCRIPTION ITEM_DESCRIPTION,          SUM (ON_HAND.ON_HAND) ON_HAND     FROM MTL_SYSTEM_ITEMS_B ITEM, MTL_ONHAND_TOTAL_MWB_V ON_HAND    WHERE ITEM.ORGANIZATION_ID = 3762  --ORG   AND ITEM.INVENTORY_ITEM_ID = ON_HAND.INVENTORY_ITEM_ID      AND ON_HAND.SUBINVENTORY_CODE IN ('PI6.FG','PI7.FG')  --SUB INVENTORY    --  AND ITEM.SEGMENT1 = '886631' ---ITEM GROUP BY ON_HAND.SUBINVENTORY_CODE,ITEM.SEGMENT1, ITEM.DESCRIPTION ORDER BY ON_HAND.SUBINVENTORY_CODE;             ------------second    SELECT   ON_HAND.ORGANIZATION_CODE,ON_HAND.SUBINVENTORY_CODE, ITEM.DESCRIPTION ITEM_DESCRIPTION,ITEM.SEGMENT1 ITEM_CODE,          SUM (ON_HAND.ON_HAND) ON_HAND     FROM MTL_SYSTEM_ITEMS_B ITEM, MTL_ONHAND_TOTAL_MWB_V ON_HAND    WHERE ITEM...
Read more

Delete formula line

-
 select * FROM FM_MATL_DTL WHERE line_no=3 and RELEASE_TYPE='1'  and trunc(LAST_UPDATE_DATE)=trunc(sysdate) SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='940589') AND RELEASE_TYPE='1' delete from FM_MATL_DTL WHERE FORMULALINE_ID='784760' and FORMULA_ID='65818' AND RELEASE_TYPE='1';
Read more