Error while opening another instance using the "New Tab" feature in the same IE8 session

Issue while using the NEW TAB in IE8 to open the R12 instance, when another 11i instance is already open in the same browser session.[ID 1322928.1]

Getting the following error:
   Unable to authenticate session.



To implement the solution, perform the following in the second instance:

1. Update SESSION_COOKIE_NAME to a different value than the other instance (it can be set to the same value as the instance name):

update ICX_PARAMETERS
set SESSION_COOKIE_NAME = 'DEV';

commit;

2. Bounce the instance (apps and db).

3. Retest the issue.

Example for creating dblink in Oracle.

You should change all things that bolded:

create public database link TEST
connect to username identified by password
 using
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=IP or hostname)(Port=1521)))(CONNECT_DATA=(SID=TEST)))'

If you would like to drop link, you can use follow:

drop public database link TEST

Create User in Oracle Database

For user creating you should create default TABLESPACE for this user or use current one.

You can create it follow:


1) First step you create tablespace for this.
create tablespace TEST1
datafile '/d01/oracle/oradata/test01.dbf'
size 100m;

2) Now you can create user:

CREATE USER test1 IDENTIFIED BY password

       DEFAULT TABLESPACE test1  

       TEMPORARY TABLESPACE temp

       QUOTA UNLIMITED ON test1;

3) After this you can give him permissions:

GRANT CREATE session, CREATE table, CREATE view, CREATE resource, 

      TO test1;

Adding Responsibility to an Application User for Oracle E-Business Suite Application

Step 1: Login with 'sysadmin' user into Oracle E-Business Suite


Step 2: Go to Security->User->Define.

Step 3:
In open window press F11 for search user.

Step 4: Write name of user and press CTRL + F11.

Step 5: In this step you should press on one of responsibilities and press NEW menu button. 

Step 6: The windows will be change view for one like this. Please press on ... (red marked) 

Step 7: Write needed responsibility name and press find.

Step 8: After you find needed responsibility and add it, press save.

Step 9: Press Switch Responsibility button.

Step 10:  Now you can change your responsibility to new one. 

GOOD LUCK....

How to find large directories in Linux

Use this simple command to find large directories. To find directories over 1GB

[root@localhost]# du -h / | grep ^[0-9.]*G

or

[root@localhost]#find / -type d -size +1G

How to compile Oracle Apps Forms 11i/R12

1. Login in Forms Server as APPLUSER and run .evn to set environment.

2. cd  $AU_TOP/forms/US

3. If you on 11i version use following command:
    f60gen module=XXX.fmb userid=apps/apps output_file=XXX.fmb

4. If you on R12 version use following command:
    frmcmp_batch.sh module="XXX.fmb" userid=APPS/APPS output_file="XXX.fmb" module_type=form
   OR
    frmcmp module="XXX.fmb" userid=APPS/APPS output_file="XXX.fmx" module_type=form

Oracle DB&APPL Prerequisite RPM's RedHat5

RedHat5:

OS packages:
------------
compat-libstdc++-egcs-1.1.2-1
compat-libstdc++-33-3.2.3-6
compat-libstdc++-296-2.96-138
compat-libcwait-2.1-1
compat-oracle-el5-1.0-5
openmotif21-2.1.30-11.EL5
binutils-2.15
The following packages must be installed from the OEL 5 or RHEL 5 distribution media:

libXp-1.0.0-8.1.el5
compat-libgcc-296-2.96-138
compat-libstdc++-33-3.2.3-61
compat-db-4.2.52-5.1

How to check "Actual" & "Needed" Undo size

SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]",
       (TO_NUMBER(e.value) * TO_NUMBER(f.value) *
       g.undo_block_per_sec) / (1024*1024)
      "NEEDED UNDO SIZE [MByte]"
  FROM (
       SELECT SUM(a.bytes) undo_size
         FROM v$datafile a,
              v$tablespace b,
              dba_tablespaces c
        WHERE c.contents = 'UNDO'
          AND c.status = 'ONLINE'
          AND b.name = c.tablespace_name
          AND a.ts# = b.ts#
       ) d,
      v$parameter e,
       v$parameter f,
       (
       SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
         undo_block_per_sec
         FROM v$undostat
       ) g
 WHERE e.name = 'undo_retention'
  AND f.name = 'db_block_size'

How to copy MS SQL 2008 database to another Server

1. Start Microsoft SQL Server Management Studio

2. Right click on DB what you'd like to copy.

3. Click NEXT in next window.

4. Choice source Server. (Remember to select Windows or SQL Server Authentication)

5. Choice Destination Server

6. You can choice two different ways of DB copy.

I   - Use the detach and attach method.

II  - Use the SQL Management Object Method.

My recommendation to use "detach and attach method" this is faster method.

7. Choice Destination Database name.

  There is two options:

   *Stop the transfer if a database or file with the same name exists at the destination.

     (if you copy DB to new server you can select this option)

   

   *Drop any database on destination server with the same name,

     then continue with database transfer, overwriting exist database files.

     (if you copy DB and you want to overwrite exist DB, select this option.) 

8. Select Server Objects

    Please check if all DB users selected. 

    

9. Select database files (*.mdf, *.log) provide full path for files.

10. In next window press "Next"

11. Database copy Scheduling.

12. The next screen shows the summary information before the database copy.

      Click on "Finish" button and wait until the copy finish.

Good Luck.

How to connect external USB disk to Linux server:

Before connect USB Disk

 1.Open /var/log/messages file

     tail -f /var/log/messages

 2.Connect disk.

 3.Find new device name (example /dev/sda ) in messages file.

After you know name of the disk (example /dev/sda)

   1. fdisk -l (list partitions)

   2. d - delete partition

   3. n - add new partition

   4. p - primary

Make file system

   1. mkfs -t ext3 /dev/sda
   2. vi /etc/fstab
   3. add mount point to /etc/fstab (example /dev/sda       /d01         ext3    defaults        1 1)
   4. save /etc/fstab
   5. mount -a

How to clear Apache cache in Oracle Application R12

How to clear Apache cache in Oracle Application R12

1. Login to Linux with "appluser" account and load environments.
2. Shutdown Apache server by running $INST_TOP/admin/scripts/adapcctl.sh stop
3. cd $OA_HTML/cabo/styles/cache
4. remove all files from this directory. (rm -rf *)
5. cd $OA_HTML/cabo/images/cache
6. remove all files from this directory. (rm -rf *)
7. Start Apache server by running $INST_TOP/admin/scripts/adapcctl.sh start