Updates from February, 2016 Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 11:32 on February 26, 2016 Permalink | Reply  

    How to enable archive log in RAC? 

    How to enable archive log in RAC?

    How to put the database in archive mode in rac?

    SQL> select name from v$database;

    NAME
    ———
    EBSTEST
    (More …)

     
  • Sachin Thapa 11:23 on February 26, 2016 Permalink | Reply  

    How to drop and recreate TEMP Tablespace in Oracle ? 

    How to drop and recreate TEMP Tablespace in Oracle ?
    1. Create Temporary Tablespace Temp2.

    CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE ‘/u01/dbdata/oradata/temp101.dbf’ SIZE 2000M, ‘/u01/dbdata/oradata/temp102.dbf’ SIZE 2000M’;

    2. Move Default temp tablespace to newly created one.

    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;
    (More …)

     
  • Sachin Thapa 10:40 on February 26, 2016 Permalink | Reply  

    How to compile jsp manually in R12? 

    How to compile jsp manually in R12?

    Bring down application service’s and make sure no processes are running.

    [applmgr@sachin scripts]$ ps -fu applmgr
    UID PID PPID C STIME TTY TIME CMD
    applmgr 26766 26765 0 17:33 pts/1 00:00:00 -bash
    applmgr 28635 26766 0 18:17 pts/1 00:00:00 ps -fu applmgr
    [applmgr@sachin scripts]$
    (More …)

     
  • Sachin Thapa 10:39 on February 26, 2016 Permalink | Reply  

    how to check OATM enabled or not? 

    how to check OATM enabled or not?

    SQL> show user
    USER is “APPS”

    (More …)

     
  • Sachin Thapa 10:31 on February 26, 2016 Permalink | Reply  

    How can we change the location of conc manager logfiles $APPLCSF/$APPLLOG? 

    How can we change the location of conc manager logfiles $APPLCSF/$APPLLOG?
    1)Make sure service should not be runing.

    [applmgr@sachin scripts]$ ps -fu applmgr
    UID PID PPID C STIME TTY TIME CMD
    applmgr 26816 26815 0 14:51 pts/1 00:00:01 -bash
    applmgr 27723 26816 0 15:35 pts/1 00:00:00 ps -fu applmgr
    [applmgr@sachin scripts]$
    (More …)

     
  • Sachin Thapa 10:23 on February 26, 2016 Permalink | Reply  

    How to bounce apache and clear cache in oracle apps 11i on sunsolaris operating system? 

    Go to scripts location.

    cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

    apptest@sachin $ adapcctl.sh stop ; m (More …)

     
  • Sachin Thapa 08:05 on February 7, 2016 Permalink | Reply  

    RAC related queries. 

    Hi All,

    I have been getting a lot of RAC related queries in my inbox, unfortunately i don’t access my blog inbox daily kindly shoot all your RAC related queries and requests for any contents..  @ ashkid0510@gmail.com.

    New Documents available:
    RAC installation step by step with screens..
    OCR and Voting Disk administration
    Adding and Deleting Nodes.
    Creating RAC Database Manually.
    RAC to non RAC and vice versa cloning

    Happy learning 🙂

    Cheers,
    Sachin

     
  • Sachin Thapa 08:01 on February 7, 2016 Permalink | Reply  

    Hi Viewers,

    Thanks for all your support 41K+ views and still counting..
    Happy learning 🙂

    Cheers,
    Sachin

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel