New Content Alert!!

Hello Viewers , watch out for new contents coming real soon !!

RAC Installation Step by Step

Hi All,

Please find the below link for RAC installation document for reference.

Know when to rebuild indexes

Summary

An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer.

You can create indexes on one or more columns of a table to speed SQL statement execution on that table. If you do not have an index on the column, then a full table scan occurs.

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

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;

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]$

how to check OATM enabled or not?

how to check OATM enabled or not?

SQL> show user
USER is “APPS”

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]$

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

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