Startup & Shutdown process in Oracle Apps in R12.

 Startup  & Shutdown process in  Oracle Apps in R12.   STARTUP PROCESS  1.Start Database Tier Services –Start Database Listener $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start <listener_name> –Start Database $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start or alternatively you can use lsnrctl start/stop <listener_name > sqlplus “/as sysdba” SQL> startup Then 2.Start Application/Middle Tier Services… Read More

BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY (Article -18).

BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY. Please Refer the previous article. BACKUP AND RECOVERY IN MySQL (Article -17). Using mysqldump utility we can take the backup of only data(ignoring structure ) Check the databases list.

To take the backup of only data… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -05

DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -04

DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More